[New post] Python code snippet – How to add the sum of multiple columns into another column in a dataframe?

Subash Chandran posted: "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 " New post on Poopcode Python code snippet – How to add the sum of multiple columns into another column in a dataframe? by Subash Chandran 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 Read more of this post Subash Chandran | October 16, 2021 at 8:25 am | Tags: Python code snippet - How to add the sum of multiple columns into another column in a dataframe? | Categories: Snippets | URL: https://wp.me/pb9kQA-3Oi Comment    See all comments Unsubscribe to no longer receive posts from Poopcode. Change your email settings at Manage Subscriptions. Trouble clicking? Copy and paste this URL into your browser: https://poopcode.com/python-code-snippet-how-to-add-the-sum-of-multiple-columns-into-another-column-in-a-dataframe/