Transforming columns with multiple indexes/headers

Asked Oct 02 '18 at 15:40

Active Oct 02 '18 at 15:40

Viewed 49 times

I have a dataframe with two headers like this:

I want to transform it to have one header. Desired output:

I have followed some solutions on stack-overflow about multi-indexing and multi-headers, but I am not able to achieve the result I want. Can anybody help me solve this? Thanks in advance.

asked Oct 02 '18 at 15:40

Trisa Biswas

2

Use `df.columns = df.columns.map(''.join)`, check [dupe](https://stackoverflow.com/q/14507794/2901002) – jezrael Oct 02 '18 at 15:41
It is giving me this error: `can only join an iterable` – Trisa Biswas Oct 02 '18 at 15:47

Transforming columns with multiple indexes/headers

0 Answers0