Prepend a level to a pandas MultiIndex

by

A nice way to do this in one line using pandas.concat():

import pandas as pd

pd.concat([df], keys=['Foo'], names=['Firstlevel'])

An even shorter way:

pd.concat({'Foo': df}, names=['Firstlevel'])

This can be generalized to many data frames, see the docs.

More Related Contents:

  1. Filter pandas DataFrame by substring criteria
  2. Binning a column with Python Pandas
  3. Pandas GroupBy.apply method duplicates first group
  4. Pandas Dataframe line plot display date on xaxis
  5. Best way to join / merge by range in pandas
  6. How to plot and annotate a grouped bar chart
  7. Pandas Extract Number from String
  8. How to filter rows in pandas by regex
  9. Pandas groupby month and year
  10. Remove reverse duplicates from dataframe
  11. How to split text in a column into multiple rows
  12. Export a Pandas dataframe as a table image
  13. NLTK-based text processing with pandas
  14. Set values on the diagonal of pandas.DataFrame
  15. Pandas: Bar-Plot with two bars and two y-axis
  16. Assign pandas dataframe column dtypes
  17. HDF5 – concurrency, compression & I/O performance [closed]
  18. Python – Delete duplicates in a dataframe based on two columns combinations?
  19. Pandas error when using if-else to create new column: The truth value of a Series is ambiguous
  20. Scraping dynamic data selenium – Unable to locate element
  21. How to plot multiple bars grouped
  22. How to easily share a sample dataframe using df.to_dict()
  23. Given a pandas Series that represents frequencies of a value, how can I turn those frequencies into percentages?
  24. LabelEncoder: TypeError: ‘>’ not supported between instances of ‘float’ and ‘str’
  25. Run an OLS regression with Pandas Data Frame
  26. Relative Strength Index in python pandas
  27. Pandas bar plot with binned range
  28. plotting value_counts() in seaborn barplot
  29. how to specify the datetime format in read_csv
  30. Get total values_count from a dataframe with Python Pandas

Leave a Comment