How to remove levels from a multi-indexed dataframe?

by 
df.reset_index(level=2, drop=True)
Out[29]: 
     A
1 1  8
  3  9

More Related Contents:

  1. How do I melt a pandas dataframe?
  2. Select rows in pandas MultiIndex DataFrame
  3. Construct pandas DataFrame from items in nested dictionary
  4. Converting a Pandas GroupBy output from Series to DataFrame
  5. How to split data into 3 sets (train, validation and test)?
  6. Nested dictionary to multiindex dataframe where dictionary keys are column labels
  7. selecting from multi-index pandas
  8. Requirements for converting Spark dataframe to Pandas/R dataframe
  9. How to flatten a hierarchical index in columns
  10. Pandas: add a column to a multiindex column dataframe
  11. Pandas, group by count and add count to original dataframe?
  12. Turn Pandas Multi-Index into column
  13. Adding a column thats result of difference in consecutive rows in pandas
  14. Python/Pandas: counting the number of missing/NaN in each row
  15. pandas dataframe group and sort by weekday
  16. Merge two data frames based on common column values in Pandas
  17. Filling in date gaps in MultiIndex Pandas Dataframe
  18. Splitting multiple columns into rows in pandas dataframe
  19. Sum columns by level in a pandas MultiIndex DataFrame
  20. Pandas- Select rows from DataFrame based on condition
  21. Why are Pandas and GeoPandas able to read a database table using a DBAPI (psycopg2) connection but have to rely on SQLAlchemy to write one?
  22. Scrape tables into dataframe with BeautifulSoup
  23. Multi Index Sorting in Pandas
  24. How to drop rows of Pandas DataFrame whose value in a certain column is NaN
  25. Remove duplicate rows from Pandas dataframe where only some columns have the same value
  26. How to switch columns rows in a pandas dataframe
  27. How to convert a dataframe to a dictionary
  28. Read CSV into a dataFrame with varying row lengths using Pandas
  29. Filling missing values using forward and backward fill in pandas dataframe (ffill and bfill)
  30. How to upload a CSV file in FastAPI and convert it into a Pandas Dataframe?

Leave a Comment