Showing all index values when using multiIndexing in Pandas

by

You need set display.multi_sparse to False:

#if need temporary use option
with pd.option_context('display.multi_sparse', False):
    print (df)

                  0
Jim Betty          
20  N/A    0.201643
50  N/A    0.201643
20  10     0.201643
20  30     0.201643

If this display option is required throughout a notebook, the option can be set once and for all as follows:

# if permanent use
import pandas as pd
pd.options.display.multi_sparse = False

Documentation:

display.multi_sparse
True
“Sparsify” MultiIndex display (don’t display repeated elements in outer levels within groups)

More Related Contents:

  1. How to change column names from numbers to names [closed]
  2. How to provide a reproducible copy of your DataFrame with to_clipboard()
  3. Replace values in a pandas series via dictionary efficiently
  4. Find column whose name contains a specific string
  5. pandas: merge (join) two data frames on multiple columns
  6. Pandas Extract Number from String
  7. How to deal with multi-level column names downloaded with yfinance
  8. Pandas dataframe with multiindex column – merge levels
  9. Pandas deleting row with df.drop doesn’t work
  10. How to flatten a hierarchical index in columns
  11. Count number of words per row
  12. pandas or python equivalent of tidyr complete
  13. Resampling Within a Pandas MultiIndex
  14. Pandas: combining header rows of a multiIndex DataFrame
  15. pandas.io.json.json_normalize with very nested json
  16. Number rows within group in increasing order in a pandas dataframe
  17. Updating a value in a pandas dataframe in an iterrows loop
  18. pandas.read_csv from string or package data
  19. FutureWarning: The default value of regex will change from True to False in a future version
  20. Check if rows in one dataframe exist in another dataframe
  21. Pandas ParserError EOF character when reading multiple csv files to HDF5
  22. Python making combined bar and line plot with secondary y-axis
  23. Format a number with commas to separate thousands
  24. reading multiple files contained in a zip file with pandas
  25. How to compute jaccard similarity from a pandas dataframe
  26. Search and replace dots and commas in pandas dataframe
  27. How to convert string representation of dictionary in Pandas DataFrame to a new columns?
  28. Python Pandas – Lookup a variable column depending on another column’s value
  29. Multi Index Sorting in Pandas
  30. pandas scatter plotting datetime

Leave a Comment