Question

How to create a new column in pandas by using values from other columns?
We can perform column based mathematical operations on a pandas dataframe. Pandas columns containing numeric values can be operated upon by operators.

Code

import pandas as pd
a=[1,2,3]
b=[2,3,5]
d={"col1":a,"col2":b}
df=pd.DataFrame(d)
df["Sum"]=df["col1"]+df["col2"]
df["Difference"]=df["col1"]-df["col2"]
How to create a new column in pandas by using values from other columns?
We can perform column based mathematical operations on a pandas dataframe. Pandas columns containing numeric values can be operated upon by operators.

Answer 1

import pandas as pd

a=[1,2,3]

b=[2,3,5]

d={"col1":a,"col2":b}

df=pd.DataFrame(d)

print(df)

df["Sum"]=df["col1"]+df["col2"]

df["Difference"]=df["col1"]-df["col2"]

df["new_column"]=df["Sum"]*df["Difference"]

print(df)

Output: