Answers for "how to add the sum of multiple columns into another column in a dataframe"

how to add the sum of multiple columns into another column in a dataframe

print(df)
   Apples  Bananas  Grapes  Kiwis
0     2.0      3.0     NaN    1.0
1     1.0      3.0     7.0    NaN
2     NaN      NaN     2.0    3.0

df['Fruit Total']=df.iloc[:,-4:].sum(axis=1)

print(df)
   Apples  Bananas  Grapes  Kiwis  Fruit Total
0     2.0      3.0     NaN    1.0          6.0
1     1.0      3.0     7.0    NaN         11.0
2     NaN      NaN     2.0    3.0          5.0

Posted by: Guest on June-03-2020

Code answers related to "how to add the sum of multiple columns into another column in a dataframe"

Code answers related to "Python"

Python Answers by Framework

Browse Popular Code Answers by Language

Answers for "how to add the sum of multiple columns into another column in a dataframe"

Code answers related to "how to add the sum of multiple columns into another column in a dataframe"

Code answers related to "Python"

Python Answers by Framework

Browse Popular Code Answers by Language

Answers for "how to add the sum of multiple columns into another column in a dataframe"

Code answers related to "how to add the sum of multiple columns into another column in a dataframe"

Code answers related to "Python"

Python Answers by Framework

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us