Bottom Page

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
 Pandas dataframe columns collapsed in Spyder when printing
#1
Hello everyone!

I have this tiny problem when using Pandas inside the Spyder IDE. BTW I am still kind of new to Python and libraries so I hope you can forgive me for my beginner question.

So, what I want is to print a preview of a query I made with Google BigQuery (health data). For this, I used

print(df.head(5))
in my script.

However, what I get in the console view is a "collapsed" view of the data frame with columns replaced by dots in the console, like this:

Per stat:
  provider_city  ... average_medicare_payments
0      ABINGTON  ...                   3992.93
1         AKRON  ...                   4292.47
2        ALBANY  ...                   3834.18
3        ALBANY  ...                   5137.31
4     ALLENTOWN  ...                   3913.78
Note the dots replacing the columns. I have seen other examples of this, and in that case the columns were shown in the preview. So is there a way to enable a wider view of the data frame? I have searched on the internet but all the solutions I tried didn't work as intended Huh

What I did in my case was to use tkinter to print the entire sheet instead and look at the data. But since this is kind of irritating doing all the time when working with my data, I would love to hear your opinion on this matter.

Thanks very much in advance!
Quote
#2
This may or may not work for you.
pd.set_option("display.max_columns",200)
it will display up to 200 columns. However, it will do so by displaying them in groups, stacked on each other.
Quote
#3
(Nov-02-2019, 06:33 PM)jefsummers Wrote: This may or may not work for you.
pd.set_option("display.max_columns",200)
it will display up to 200 columns. However, it will do so by displaying them in groups, stacked on each other.

Thank you so much, this did the trick! This method surely will be most useful for me in my tasks Cool

Thank you for your assistance Big Grin

EDIT: I noticed that in some cases this method doesn't quite work as intended (like you implied) Tongue I was lucky with my first attempt and in that case my dataframe was presented nicely. However, my other dataframes look kind of messy with this setting. So I guess you are right, it is not a "general solution". But is surely is helpful to know about this method as it may actually be the right solution in some cases Tongue

For this project, I guess I will just stick with tkinter and view the full sheet Shy
Quote

Top Page

Possibly Related Threads...
Thread Author Replies Views Last Post
  manipulating a dataframe - pandas nsx200 1 58 Yesterday, 05:59 PM
Last Post: ThomasL
  pandas dataframe iloc mystery edvvardbrian 2 172 Oct-29-2019, 02:55 PM
Last Post: jefsummers
  How to add a few empty rows into a pandas dataframe python_newbie09 2 495 Sep-20-2019, 08:52 AM
Last Post: python_newbie09
  How modify the DataFrame columns SriRajesh 2 163 Sep-12-2019, 03:14 PM
Last Post: SriRajesh
  Double 'for' loop and writing in a new columns dataframe marco_ita 0 177 Sep-07-2019, 12:44 PM
Last Post: marco_ita
  Dropping a column from pandas dataframe marco_ita 6 690 Sep-07-2019, 08:36 AM
Last Post: marco_ita
  created a pandas series instead of pandas DataFrame ibaad1406 6 586 Sep-06-2019, 06:23 AM
Last Post: ibaad1406
  Applying operation to a pandas multi index dataframe subgroup Nuovoq 1 344 Sep-04-2019, 10:04 PM
Last Post: Nuovoq
  Substr on Pandas Dataframe Scott 1 383 Sep-02-2019, 02:49 AM
Last Post: scidam
  Pandas Dataframe to Google Big Query Ecniv 1 455 Aug-21-2019, 04:56 PM
Last Post: ThomasL

Forum Jump:


Users browsing this thread: 1 Guest(s)