python - 如何从删除的表中恢复列(系列)？

Question

print(df)

    Names   Maths  Physics  Chemistry
0   Khaja    75       91    84
1   Srihari  81       89    71
2   Krishna  69       77    76
3   jain     87       69    68
4   shakir   79       70    74

df.drop(['Chemistry'],axis=1,inplace=True)

df

    Names   Maths   Physics
0   Khaja     75      91
1   Srihari   81      89
2   Krishna   69      77
3   jain      87      69
4   shakir    79      70

How to get back the dropped column from the table. I tried to get back the column with reset_drop() but it doesn't work.

The final outcome should look like this:

 print(df)

        Names   Maths  Physics  Chemistry
    0   Khaja    75       91    84
    1   Srihari  81       89    71
    2   Krishna  69       77    76
    3   jain     87       69    68
    4   shakir   79       70    74

Answer 1

使用pop用于提取列到 Series 和 join添加到 DataFrame 末尾:

a = df.pop('Chemistry')
print (a)
0    84
1    71
2    76
3    68
4    74
Name: Chemistry, dtype: int64

print (df)
     Names  Maths  Physics
0    Khaja     75       91
1  Srihari     81       89
2  Krishna     69       77
3     jain     87       69
4   shakir     79       70

df = df.join(a)
print (df)
     Names  Maths  Physics  Chemistry
0    Khaja     75       91         84
1  Srihari     81       89         71
2  Krishna     69       77         76
3     jain     87       69         68
4   shakir     79       70         74

如果列不是最后添加 reindex按原始列:

cols = df.columns
a = df.pop('Maths')
print (a)
0    75
1    81
2    69
3    87
4    79
Name: Maths, dtype: int64

print (df)
     Names  Physics  Chemistry
0    Khaja       91         84
1  Srihari       89         71
2  Krishna       77         76
3     jain       69         68
4   shakir       70         74

df = df.join(a).reindex(columns=cols)
print (df)
     Names  Maths  Physics  Chemistry
0    Khaja     75       91         84
1  Srihari     81       89         71
2  Krishna     69       77         76
3     jain     87       69         68
4   shakir     79       70         74