Pandas
keyboard_arrow_down 655 guides
chevron_leftMiscellaneous Cookbook
Adjusting number of rows that are printedAppending DataFrame to an existing CSV fileChecking differences between two indexesChecking if a DataFrame is emptyChecking if a variable is a DataFrameChecking if index is sortedChecking if value exists in IndexChecking memory usage of DataFrameChecking whether a Pandas object is a view or a copyConcatenating a list of DataFramesConverting a DataFrame to a listConverting a DataFrame to a SeriesConverting DataFrame to a list of dictionariesConverting DataFrame to list of tuplesCounting the number of negative valuesCreating a DataFrame using cartesian product of two DataFramesDisplaying DataFrames side by sideDisplaying full non-truncated DataFrame valuesDrawing frequency histogram of DataFrame columnExporting Pandas DataFrame to PostgreSQL tableHighlighting a particular cell of a DataFrameHighlighting DataFrame cell based on valueHow to solve "ValueError: If using all scalar values, you must pass an index"Importing BigQuery table as Pandas DataFramePlotting two columns of DataFramePrinting DataFrame on a single linePrinting DataFrame without indexPrinting DataFrames in tabular formatRandomly splitting DataFrame into multiple DataFrames of equal sizeReducing DataFrame memory sizeSaving a DataFrame as a CSV fileSaving DataFrame as Excel fileSaving DataFrame as feather fileSetting all values to zeroShowing all dtypes without truncationSplitting DataFrame into multiple DataFrames based on valueSplitting DataFrame into smaller equal-sized DataFramesWriting DataFrame to SQLite
check_circle
Mark as learned thumb_up
0
thumb_down
0
chat_bubble_outline
0
Comment auto_stories Bi-column layout
settings
Adjusting number of rows that are printed in Pandas DataFrame
schedule Aug 12, 2023
Last updated local_offer
Tags Python●Pandas
tocTable of Contents
expand_more Master the mathematics behind data science with 100+ top-tier guides
Start your free 7-days trial now!
Start your free 7-days trial now!
Change settings temporarily to adjust number of rows
To temporarily adjust the maximum number of rows shown:
n = 100df = pd.DataFrame({"A":range(n), "B":range(n)}, index=range(n))
from IPython.display import displaynum_of_rows_to_show = 2with pd.option_context('display.max_rows', num_of_rows_to_show): display(df)
A B0 0 0... ... ...99 99 99
Here, we are temporarily changing the Pandas' settings using the with keyword. DataFrames that you print outside this with keyword will be printed according to the default settings.
Change settings for current session
To change the current session's settings so that 2 rows are shown:
pd.set_option('display.max_rows', 2)df
A B0 0 0... ... ...99 99 99
The setting changes are persistent and so if you print df later in the same session, only 2 rows will be shown.
Resetting back to default settings
To revert back to the default settings:
pd.reset_option('display.max_rows')
By default, Pandas will show up to 10 rows on screen - the top 5 rows and bottom 5 rows of the DataFrame.
Published by Isshin Inada
Edited by 0 others
Did you find this page useful?
thumb_up
thumb_down
Comment
Citation
Ask a question or leave a feedback...
thumb_up
0
thumb_down
0
chat_bubble_outline
0
settings
Enjoy our search
Hit / to insta-search docs and recipes!
