Home/ Questions/Q 1646
Next
In Process
Meet
  • 1
Pundit
Asked: 2023-07-04T07:46:16+00:00 In:

How can I change the values of a column in a pandas dataframe?

  • 1

I want to replace the first column of this table depending on the name given in the first column.

End       Col A     Col B    Col C

Col C       10         20           30

Col B       40        50           60

To replace like this:

End       Col A     Col B    Col C

30          10         20           30

50          40        50           60

What is the best way of changing this?

pandasprogramspython
Share
Leave an answer

Leave an answer

Browse

1 Answer

  1. Professional

    Try this code below:

    import pandas as pd
df = pd.DataFrame(
    {
        End: ['Col C', 'Col B'],
        'Col A': [10,40],
        'Col B': [20,50],
        'Col C': [30,60]
    }
)
df[‘End’] = df.apply(lambda x: x[x['End']], axis=1)
print(df)

    Output:

       End  Col A  Col B  Col C
0   30     10     20     30
1   50     40     50     60
    • 0