/Python/Pandas set one column equal to another

Pandas set one column equal to another

In [300]:
df.loc[df['colA'] == 'a', 'colC'] = df['colB']
df['colC'] = df['colC'].fillna(0)
df

Out[300]:
   id colA  colB  colC
0   0    a    13    13
1   1    a    52    52
2   2    b    16     0
3   3    a    34    34
4   4    b   946     0

Source: stackoverflow.com

Similar codes

27 votes192 views4 answers
How to start an exe file in python
Python
1 vote199 views3 answers
Accessing data on django sessionstore
Python
2 votes225 views2 answers
Python selenium full screen
Python
2 votes207 views2 answers
Python how to sum two lists
Python
1 vote230 views1 answer
Log base 2 python
Python
3 votes215 views4 answers
Pair Plot Seaborn
Python
1 vote216 views1 answer
How to make jupyterlab see other directory
Python
1 vote214 views1 answer
Scrapy get inside attribute value
Python
0 vote196 views1 answer
Pandas dataframe scan column for values between numbers
Python
2 votes187 views1 answer
How to replace a word in csv file using python
Python