Pandas dataframe columns collapsed in Spyder when printing

[UniKlixX]

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

Thank you for your assistance

EDIT: I noticed that in some cases this method doesn't quite work as intended (like you implied) 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

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