Pandas dataframe total row

by

Update June 2022

pd.append is now deprecated. You could use pd.concat instead but it’s probably easier to use df.loc['Total'] = df.sum(numeric_only=True), as Kevin Zhu commented. Or, better still, don’t modify the data frame in place and keep your data separate from your summary statistics!

Append a totals row with

df.append(df.sum(numeric_only=True), ignore_index=True)

The conversion is necessary only if you have a column of strings or objects.

It’s a bit of a fragile solution so I’d recommend sticking to operations on the dataframe, though. eg.

baz = 2*df['qux'].sum() + 3*df['bar'].sum()

More Related Contents:

  1. How to one-hot-encode from a pandas column containing a list?
  2. Rename Pandas DataFrame Index
  3. Pandas groupby cumulative sum
  4. Pandas DataFrame concat vs append
  5. Pandas counting and summing specific conditions
  6. Convert row to column header for Pandas DataFrame,
  7. Use AWS Glue Python with NumPy and Pandas Python Packages
  8. Select multiple ranges of columns in Pandas DataFrame
  9. Pandas read csv file with float values results in weird rounding and decimal digits
  10. pandas – filter dataframe by another dataframe by row elements
  11. How to set some xlim and ylim in Seaborn lmplot facetgrid
  12. Left justify string values in a pandas DataFrame
  13. Setting values on a copy of a slice from a DataFrame [duplicate]
  14. How can I replicate rows in Pandas?
  15. pandas – get most recent value of a particular column indexed by another column (get maximum value of a particular column indexed by another column)
  16. Pandas: SettingWithCopyWarning: [duplicate]
  17. Seaborn ValueError: zero-size array to reduction operation minimum which has no identity
  18. How to create a DataFrame of random integers with Pandas?
  19. summing two columns in a pandas dataframe
  20. add a row at top in pandas dataframe [duplicate]
  21. Find difference between two data frames
  22. Create new column based on values from other columns / apply a function of multiple columns, row-wise in Pandas
  23. Specifying date format when converting with pandas.to_datetime
  24. Bar graph from dataframe groupby
  25. What are the differences between feather and parquet?
  26. Grouped Bar graph Pandas
  27. KeyError when indexing Pandas dataframe
  28. pandas group by and assign a group id then ungroup
  29. How to efficiently assign unique ID to individuals with multiple entries based on name in very large df
  30. Add image annotations to bar plots

Leave a Comment