How one can Change Two Columns in Pandas (With Instance)

You’ll importance refer to customized serve as to switch the placement of 2 columns in a pandas DataFrame:

def swap_columns(df, col1, col2):
    col_list = listing(df.columns)
    x, y = col_list.index(col1), col_list.index(col2)
    col_list[y], col_list[x] = col_list[x], col_list[y]
    df = df[col_list]
    go back df

This serve as will switch the positions of columns col1 and col2 within the DataFrame.

Please see instance displays learn how to importance this serve as in apply.

Instance: Change Two Columns in Pandas

Think now we have refer to pandas DataFrame:

import pandas as pd

#manufacture DataFrame
df = pd.DataFrame({'workforce': ['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H'],
                   'issues': [18, 22, 19, 14, 14, 11, 20, 28],
                   'assists': [5, 7, 7, 9, 12, 9, 9, 4],
                   'rebounds': [11, 8, 10, 6, 6, 5, 9, 12]})

#view DataFrame
print(df)

  workforce  issues  assists  rebounds
0    A      18        5        11
1    B      22        7         8
2    C      19        7        10
3    D      14        9         6
4    E      14       12         6
5    F      11        9         5
6    G      20        9         9
7    H      28        4        12

We will outline a swap_columns() serve as to switch the positions of the “points” and “rebounds” columns:

#outline serve as to switch columns
def swap_columns(df, col1, col2):
    col_list = listing(df.columns)
    x, y = col_list.index(col1), col_list.index(col2)
    col_list[y], col_list[x] = col_list[x], col_list[y]
    df = df[col_list]
    go back df

#switch issues and rebounds columns
df = swap_columns(df, 'issues', 'rebounds'):

#view up to date DataFrame
print(df)

  workforce  rebounds  assists  issues
0    A        11        5      18
1    B         8        7      22
2    C        10        7      19
3    D         6        9      14
4    E         6       12      14
5    F         5        9      11
6    G         9        9      20
7    H        12        4      28

Understand that the “points” and “rebounds” columns were swapped week each and every alternative column has remained in the similar place.

Backup Assets

Please see tutorials give an explanation for learn how to carry out alternative habitual operations in pandas:

Pandas: How one can Rely Occurrences of Explicit Worth in Column
Pandas: Get Index of Rows Whose Column Fits Worth
Pandas: How one can Rely Lacking Values in DataFrame