I have a dataframe looks like this:
A B C
Date
data data data data
data data data data
how can I add header to make it looks like this:
All Data
Type A B C
Date
data data data data
data data data data
-
This might help: stackoverflow.com/questions/52479310/…Abhyuday Vaish– Abhyuday Vaish2021-08-20 04:40:06 +00:00Commented Aug 20, 2021 at 4:40
-
Did your query solved?Anurag Dabas– Anurag Dabas2021-08-21 16:44:43 +00:00Commented Aug 21, 2021 at 16:44
Add a comment
|
1 Answer
A simple way would be using concat():
df=pd.concat({'All Data':df},axis=1,names=[None,'Type'])
OR
use pd.MultiIndex.from_product():
df.columns=pd.MultiIndex.from_product([['All Data'],df.columns],names=[None,'Type'])
OR
use pd.MultiIndex.from_arrays()
df.columns=pd.MultiIndex.from_arrays([['All Data']*len(df.columns),df.columns],names=[None,'Type'])
output of df:
All Data
Type A B C
Date
data data data data
data data data data
Update: If you want to show the header in middle then use style.set_table_styles():
df=df.style.set_table_styles([dict(selector='th', props=[('text-align', 'center')])])
output of df:
All Data
Type A B C
Date
data data data data
data data data data
3 Comments
Vicki
Hello, thanks for your help! I tried these codes, but the header "All date" always displayed at the right instead of in the center. Is there a way to fix that?
Anurag Dabas
@Vicki it's display like that in jupyter or spyder but when you save to to excel it will appear in center
Anurag Dabas
@Vicki see this answer it will solve your problem of displaying header stackoverflow.com/a/61360291/14289892.....use
df=df.style.set_table_styles([dict(selector='th', props=[('text-align', 'center')])]).....and updated answer...kindly check :)