Dataframe not showing in Pycharm

Question

I am using PyCharm 2016.2.1. When I try to view a Pandas dataframe through the newly added feature 'View as DataFrame' in the debugger, this works as expected for a small (e.g. 4x4) DataFrame.

However, when I try to view a DataFrame (generated by custom script) of ~10,000 rows x ~50 columns, I get the message: "Nothing to show".

When I run the same script (that generates the DataFrame) in Spyder, I can view it, so I am pretty sure it's not an error in my script.

Does anyone know if there is a maximum size to the DataFrames that can be viewed in PyCharm and if there is a way to change this?

It seems that the maximum size allowed is 1000 x 15, as in some cases it gets truncated to this size (when the number of rows is too large, but when there are too many columns pycharm just says 'nothing to show').

Still, I would like to know if there is a way to increase the maximum allowed rows and columns viewable through the DataFrame viewer.

Answer 1

The reason for your problem is that it was having a special character in a column's name.

If your column name is 'R&D' just change it to 'RnD' will it will fix the problem.

If you want to learn more about Pycharm then visit this Python Course designed by the industrial experts.