Unable to rename and remove pandas Index - Python

Question

I have a dataframe which is like as shown below

Though I know the column names are 'FR', 'ig' and 'te' with the help of below command.

dataFramesDict['Tri'].columns

What does name = 'level_1' mean here? Moreover, I also don't see subject_ID in the columns or index list. What is subject_ID here?

How do I get the output to be like as shown below

I tried the below code to rename 'level_1' to 'subject_ID' but it doesn't work

dataFramesDict['Tri'].index = dataFramesDict['Tri'].index.rename('subject_ID')

Please note that the data is just a sample data. I am only interested in changing the first column name and dropping that 'level_1'. Nothing to do with data

I am unable to create dataframe of this type through sample code. The above shown dataframe is a result of another complex code. So, I have provided a screenshot of dataframe

tawab_shakeel · Accepted Answer · 2019-07-29T08:19:58.023

3

Try this

df.columns.name= ''
df.reset_index(inplace=True)

edited Jul 29 '19 at 08:19

answered Jul 29 '19 at 08:14

tawab_shakeel

3,701
10
26

Thanks. It works. Instead of `title`, it is `df.columns.name = ' '` – The Great Jul 29 '19 at 08:18
Will update the answer soon. Currently it doesn't allow me to update – The Great Jul 29 '19 at 08:21
approve the answer if you found it helpful – tawab_shakeel Jul 29 '19 at 08:23
I meant marking your answer as solution. It didn't allow me to update earlier due to time limit. Thanks for your answer – The Great Jul 29 '19 at 08:24
Can you help me with this post? Can you help me with this post? https://stackoverflow.com/questions/57285680/dont-drop-all-nas-during-stack-operation-in-python – The Great Jul 31 '19 at 08:16

Unable to rename and remove pandas Index - Python

1 Answers1