Maximum number of columns in DataFrame viewer?
Hello,
I am using PyCharm Community Ed 2017.3.3, and am having trouble viewing a dataframe I've imported from Excel spreadsheet.
The spreadsheet has ~12,000 rows and 127 columns. When I make the import in Spyder, I can open up the entire data frame in the viewer. When I click on "View as DataFrame" (as instructed here) in the variable viewer in PyCharm, I get a window that says "Nothing to Show"
I've figured out that if I use iloc in the bar at the bottom of the dataframe viewer window, I can view the first "n" rows. For example, if my dataframe is "df", I can see the first 10 rows (n=9) by entering df.iloc[:, 0:9]. I increased n until it hit 49, then no new columns started showing up.
It appears that the maximum number of columns the viewer will display is 50. Can anyone else confirm this? Are there any plans to change this? I regularly work with data frames that have more than 50 columns.
Thank you!
Please sign in to leave a comment.
Hello Mark,
It's a known issue https://youtrack.jetbrains.com/issue/PY-24896, please feel free to comment the issue to increase its priority and be notified about updates.
Thanks! I've submitted the comment.