How to merge multi index axis into single index axis Pandas

Question

I've a single data frame and after pivoting it I've got the dataframe in this format:

I want it to be a single header like Raw01, Raw02, Raw 03, Raw04, Raw05, calcd01, calcd02, calcd03 and so on. Also the index column can just b a.

I've searched for other questions but in that case they have two data frames and I only have one. So, how will I achieve it?

zipa · Accepted Answer · 2019-07-15 14:36:43Z

1

You can flatten your columns like this:

df.columns = [''.join(map(str, col)).strip() for col in df.columns.values]

answered Jul 15, 2019 at 14:36

zipa

28k6 gold badges45 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Chaudhry Talha Over a year ago

I got a warning

/anaconda3/lib/python3.6/site-packages/ipykernel_launcher.py:1: UserWarning: Pandas doesn't allow columns to be created via a new attribute name - see https://pandas.pydata.org/pandas-docs/stable/indexing.html#attribute-access   """Entry point for launching an IPython kernel.

and after that if I do df.head() it prints out the same multi index.

zipa Over a year ago

@ChaudhryTalha That's odd, df.columns should refer to columns not new column named columns. Did you paste the code correctly?

Chaudhry Talha Over a year ago

My bad... I'm with this dataset since morning and going crazy. It worked perfectly :D

zipa Over a year ago

@ChaudhryTalha No worries, glad to help :)

Collectives™ on Stack Overflow

How to merge multi index axis into single index axis Pandas

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related