concise way of flattening multiindex columns

by

You can do a map join with columns 

out.columns = out.columns.map('_'.join)
out
Out[23]: 
     B_mean     B_std  C_median
A                              
1  0.204825  0.169408  0.926347
2  0.362184  0.404272  0.224119
3  0.533502  0.380614  0.218105

For some reason (when the column contain int) I like this way better

out.columns.map('{0[0]}_{0[1]}'.format) 
Out[27]: Index(['B_mean', 'B_std', 'C_median'], dtype="object")

More Related Contents:

  1. How can I pivot a dataframe?
  2. How do I melt a pandas dataframe?
  3. Split pandas dataframe based on groupby
  4. GroupBy pandas DataFrame and select most common value
  5. Converting a Pandas GroupBy output from Series to DataFrame
  6. pandas GroupBy columns with NaN (missing) values
  7. Multiple aggregations of the same column using pandas GroupBy.agg()
  8. Pandas groupby cumulative sum
  9. Python Pandas max value in a group as a new column
  10. pandas dataframe groupby datetime month
  11. How to move pandas data from index to column after multiple groupby
  12. Python – rolling functions for GroupBy object
  13. Requirements for converting Spark dataframe to Pandas/R dataframe
  14. Use pandas.shift() within a group
  15. pandas reading CSV data formatted with comma for thousands separator
  16. Pandas: add a column to a multiindex column dataframe
  17. Jupyter notebook display two pandas tables side by side
  18. Adding a column thats result of difference in consecutive rows in pandas
  19. collect() or toPandas() on a large DataFrame in pyspark/EMR
  20. Standard implementation of vectorize_sequences
  21. Sample each group after pandas groupby
  22. Pandas groupby with categories with redundant nan
  23. Suppress output of object when plotting in IPython
  24. pandas groupby where you get the max of one column and the min of another column
  25. Bar graph from dataframe groupby
  26. Convert a spark DataFrame to pandas DF
  27. pandas group by and assign a group id then ungroup
  28. Pandas & AWS Lambda
  29. Scrape tables into dataframe with BeautifulSoup
  30. Plot pandas dataframe containing NaNs

Leave a Comment