Rename the dataframe columns

Asked Jun 15 '20 at 10:55

Active Jun 15 '20 at 10:56

Viewed 30 times

import pandas as pd
lis=[{'0':'A','1':'B','2':'c','3':'d','4':'f','5':'g'},{'0':'A','1':'B','2':'c','3':'d','4':'f','5':'g'},{'0':'A','1':'B','2':'c','3':'d','4':'f','5':'g'}]
df=pd.DataFrame(lis)

df1

df=pd.DataFrame(lis,columns=list('ABCDFG'))

I want to rename the columns of dataframe but while renamaing getting below dataframe withall nan values

      A B   C   D   F   G
0   NaN NaN NaN NaN NaN NaN
1   NaN NaN NaN NaN NaN NaN
2   NaN NaN NaN NaN NaN NaN

edited Jun 15 '20 at 10:56

anky

74,114
11
41
70

asked Jun 15 '20 at 10:55

`df1.columns = df.iloc[0].str.upper()` ? or `df1 = pd.DataFrame(np.nan,columns=df.iloc[0].str.upper(),index=df.index)` depending on what you need – anky Jun 15 '20 at 10:57
`df.columns = list('ABCDFG')` – deadshot Jun 15 '20 at 11:00

Rename the dataframe columns

0 Answers0