Rename Column¶

In [643]:

mydf.head(80)

Out[643]:

   comp dept grp     value1     value2
0    C2   D4  G1  50.265891  24.075876
1    C2   D3  G2  44.306847  19.393717
2    C2   D1  G2  56.247403  17.939938
3    C3   D1  G2  41.746750  18.240598
4    C1   D4  G2  50.915616  20.373281
..  ...  ...  ..        ...        ...
75   C3   D4  G2  56.144175  26.897399
76   C3   D2  G2  51.136115  14.648458
77   C2   D5  G2  49.063538  21.575246
78   C3   D2  G2  50.070189  19.389308
79   C1   D4  G1  53.550231  21.774371

[80 rows x 5 columns]

Assignment Method Use when column name does not contain special character

In [645]:

mydf >> rename( val1='value1', val2='value2' )

Out[645]:

    comp dept grp       val1       val2
0     C2   D4  G1  50.265891  24.075876
1     C2   D3  G2  44.306847  19.393717
2     C2   D1  G2  56.247403  17.939938
3     C3   D1  G2  41.746750  18.240598
4     C1   D4  G2  50.915616  20.373281
..   ...  ...  ..        ...        ...
195   C3   D3  G1  50.185141  15.609130
196   C2   D2  G1  54.906576  22.447863
197   C1   D2  G1  53.081448  19.785567
198   C3   D4  G2  44.667053  21.552565
199   C3   D3  G1  59.081494  15.113429

[200 rows x 5 columns]

Dictionary Method Use when column name contain special character

In [650]:

mydf >> rename( {'val.1' : 'value1',
                 'val.2' : 'value2' })

Out[650]:

    comp dept grp      val.1      val.2
0     C2   D4  G1  50.265891  24.075876
1     C2   D3  G2  44.306847  19.393717
2     C2   D1  G2  56.247403  17.939938
3     C3   D1  G2  41.746750  18.240598
4     C1   D4  G2  50.915616  20.373281
..   ...  ...  ..        ...        ...
195   C3   D3  G1  50.185141  15.609130
196   C2   D2  G1  54.906576  22.447863
197   C1   D2  G1  53.081448  19.785567
198   C3   D4  G2  44.667053  21.552565
199   C3   D3  G1  59.081494  15.113429

[200 rows x 5 columns]

Combined Method Combine both assignment and dictionary method

In [651]:

mydf >> rename( {'val.1' : 'value1',
                 'val.2' : 'value2'
              }, group = 'grp' )

Out[651]:

    comp dept group      val.1      val.2
0     C2   D4    G1  50.265891  24.075876
1     C2   D3    G2  44.306847  19.393717
2     C2   D1    G2  56.247403  17.939938
3     C3   D1    G2  41.746750  18.240598
4     C1   D4    G2  50.915616  20.373281
..   ...  ...   ...        ...        ...
195   C3   D3    G1  50.185141  15.609130
196   C2   D2    G1  54.906576  22.447863
197   C1   D2    G1  53.081448  19.785567
198   C3   D4    G2  44.667053  21.552565
199   C3   D3    G1  59.081494  15.113429

[200 rows x 5 columns]