Breaking News: Grepper is joining You.com. Read the official announcement!

How to swap two DataFrame columns?

Add Answer

Marawan Mamdouh answered on September 24, 2020 Popularity 7/10 Helpfulness 7/10

answer How to swap two DataFrame columns?

related swap two columns python

related rearange DataFrame swap columsn and rows

How to swap two DataFrame columns?

Comment

### I create `swapColumns` function

It swaps the position of the two columns in the DataFrame and then renames the columns to reflect the swap.

    def swapColumns(df, col1, col2):
        # Get the list of column names in the DataFrame
        cols = df.columns
        
        # Get the index of the two columns to swap
        col1_idx = cols.get_loc(col1)
        col2_idx = cols.get_loc(col2)
        
        # Swap the two columns using the index
        df[[cols[col1_idx], cols[col2_idx]]] = df[[cols[col2_idx], cols[col1_idx]]]
        
        # Rename the columns to reflect the swap
        df.rename(columns = {col1:col2, col2:col1}, inplace = True)


# To use the function, you can pass in the DataFrame df and the two column names col1 and col2 like this :

	swapColumns(df, 'longitude', 'median_house_value')

This will swap the position of the longitude and median_house_value columns in the DataFrame df.

Popularity 7/10 Helpfulness 7/10 Language whatever

Source: Grepper

Tags: dataframe python swap

Link to this answer
Share Copy Link

Contributed on Mar 21 2023

Marawan Mamdouh

0 Answers Avg Quality 2/10

Closely Related Answers

swap two columns python

Comment

# 2d array a[row][col] ,  swap the columns h and k
for i in range(row):
    a[i][k] , a[i][h] = a[i][h], a[i][k]

Popularity 8/10 Helpfulness 4/10 Language python

Source: Grepper

Tags: python swap

Link to this answer
Share Copy Link

Contributed on Nov 02 2021

BreadCode

0 Answers Avg Quality 2/10

rearange DataFrame swap columsn and rows

Comment

df_t = df.T
print(df_t)
#            0    1        2
# name   Alice  Bob  Charlie
# age       24   42       18
# state     NY   CA       CA
# point     64   92       70

Popularity 9/10 Helpfulness 1/10 Language python

Source: note.nkmk.me

Tags: dataframe data

Link to this answer
Share Copy Link

Contributed on Sep 24 2020

Anxious Anaconda

0 Answers Avg Quality 2/10

How to swap two DataFrame columns?

Contents

More Related Answers

How to swap two DataFrame columns?

Closely Related Answers

swap two columns python

rearange DataFrame swap columsn and rows

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.