Pandas: Setting no. of max rows

by

Set display.max_rows:

pd.set_option('display.max_rows', 500)

For older versions of pandas (<=0.11.0) you need to change both display.height and display.max_rows.

pd.set_option('display.height', 500)
pd.set_option('display.max_rows', 500)

See also pd.describe_option('display').

You can set an option only temporarily for this one time like this:

from IPython.display import display
with pd.option_context('display.max_rows', 100, 'display.max_columns', 10):
    display(df) #need display to show the dataframe when using with in jupyter
    #some pandas stuff

You can also reset an option back to its default value like this:

pd.reset_option('display.max_rows')

And reset all of them back:

pd.reset_option('all')

More Related Contents:

  1. Format certain floating dataframe columns into percentage in pandas
  2. Pandas – Plotting a stacked Bar Chart
  3. How to read a .xlsx file using the pandas Library in iPython?
  4. Can you format pandas integers for display, like `pd.options.display.float_format` for floats?
  5. converting a text file to csv file with out index
  6. Extract the data and modify an existing excel with openpyxl
  7. How to drop rows of Pandas DataFrame whose value in a certain column is NaN
  8. Fast Haversine Approximation (Python/Pandas)
  9. How can I filter lines on load in Pandas read_csv function?
  10. Pandas Groupby Range of Values
  11. Pandas column access w/column names containing spaces
  12. How to get value counts for multiple columns at once in Pandas DataFrame?
  13. Convert to binary and keep leading zeros
  14. Add x and y labels to a pandas plot
  15. Plot different DataFrames in the same figure
  16. Formatting timedelta objects [duplicate]
  17. How to apply a function on every row on a dataframe?
  18. How to replace negative numbers in Pandas Data Frame by zero
  19. How to implement sql coalesce in pandas
  20. Subtract a year from a datetime column in pandas
  21. How to calculate correlation between all columns and remove highly correlated ones using pandas?
  22. Python Pandas merge samed name columns in a dataframe
  23. convert entire pandas dataframe to integers in pandas (0.17.0)
  24. TfidfVectorizer in scikit-learn : ValueError: np.nan is an invalid document
  25. In Python pandas, start row index from 1 instead of zero without creating additional column
  26. Pandas Correlation Groupby
  27. pandas, melt, unmelt preserve index
  28. Conditional row read of csv in pandas
  29. How to compute jaccard similarity from a pandas dataframe
  30. How to convert DataFrame.append() to pandas.concat()?

Leave a Comment