How do I change display options in pandas?

Have you ever wanted to change the way your DataFrame is displayed? Perhaps you needed to see more rows or columns, or modify the formatting of numbers? In this video, I'll demonstrate how to change the settings for five common display options in pandas.

SUBSCRIBE to learn data science with Python:

JOIN the "Data School Insiders" community and receive exclusive rewards:

== RESOURCES ==

== LET'S CONNECT! ==

[LonglongFeng]

the best and most detail-oriented tutorial I've seen on Youtube. thanks

[noel]

I have been hooked to your videos like a tv show ever since I watched the first one and I want to say that not only are these videos extremely useful and valuable but they are just as much entertaining as well.
btw I've been hearing about some other, though not free, really powerful data analysis tools such as Alteryx and Pathwise. would absolutely love to watch if you create videos on those.

[fernandai.b.]

Thanks for the video, it is clear and easy to understand 👍

[AbdallahAnalyst]

Thank you so much for this awesome playlist it is really helpful

[hephepiyey]

Hello there! Thank you for the explanation. So I was wondering if it's possible to set the column width to its max to show the numbers because I am seeing +06 in my column and I really wanted to show everything. Is that possible? Thank you!

[fadilyassin]

thank you for your videos very good explanations, can you please tell us how you show the grid in the Dataframe, your DataFrame looks like excel sheet please, thank you

[benogidan]

pd.set_option('display.float_format', '{:, .0f}'.format) will get the decimal points off

[sindhumohandas]

Truly helpful video.. thankyou so much😊..

[PocketInfinite]

Is it possible to have it display in a nice table in IDLE like how it does in Jupyter? Jinja just won't work for me...

[Gargi_]

While using the get_option on max_rows I also got 60 back but my pandas is displaying only 10 rows in its default view. What is the possible explanation? Could you pls help with that

[saikannan]

in my idle pandas the spaces between two columns is clumsy how can correct it can you please help me with it

[nelson]

Thank you for the excellent explanation.

[PavanKumar-wxnl]

How do i apply complete back ground color to entire pivot table with customized alignments inside text?

[BobBelford]

Why does the following only change precision on Fare and not Age, they both are Float64 objects? (I do not see where we specify the column, so would think this would affect all float data types)

# overwrite the 'precision' setting to display 2 digits after the decimal point of 'Fare'
pd.set_option('display.precision', 2)
train.head()

thanks for these great tutorials

[biganubhav]

How do you display the df in this nice table-like style within the jupyter notebook?

[shivamkakkar]

I want to know how your columns and rows are coming beautifully? As for me there are no lines when I run the CSV file in jupyter notebook

[sinabaghaei]

Thanks dear Kevin for explanation. My pandas File doesn't show set_option for numbers more than 10. it just shows None and less than 10. Can you please explain to me why is that? I use panda 1.1.3

[rajarshi_]

How do we select the first 4 digits of each values in a column which is consisting of 10 digit numbers..can you plz make a video on it.. It's been of great help from all your videos

[meghasyam]

Hi Kevin,

for somereason
pd.set_option('display.float_format', '{:, }'.format)
is not working for me nor throwing an error.
The format is not getting applied.

Can you help

[kleczekr]

Hello Kevin!
I am impressed by the quality of the material you provide on your channel.
I have a brief question when it comes to the number formatting, which you explained in the video. Would it be difficult to introduce commas in non-standard places, e.g. to indicate Indian lakhs and crores, so that, e.g., to write 1 lakh rupees as 1, 00, 000; and 1 crore rupees as 1, 00, 00, 000?
Thank you for the wonderful series!
Rafal