What’s the best way to sum all values in a Pandas dataframe? [duplicate]

by

Updated for Pandas 0.24+

df.to_numpy().sum()

Prior to Pandas 0.24+

df.values

Is the underlying numpy array

df.values.sum()

Is the numpy sum method and is faster

More Related Contents:

  1. Split (explode) pandas dataframe string entry to separate rows
  2. Convert pandas dataframe to NumPy array
  3. Binning a column with Python Pandas
  4. Performant cartesian product (CROSS JOIN) with pandas
  5. Pandas: sum DataFrame rows for given columns
  6. String concatenation of two pandas columns
  7. How to take column-slices of dataframe in pandas
  8. What does axis in pandas mean?
  9. Numpy “where” with multiple conditions
  10. How to map numeric data into categories / bins in Pandas dataframe
  11. Calculate average of every x rows in a table and create new table
  12. Find column name in pandas that matches an array
  13. Coalesce values from 2 columns into a single column in a pandas dataframe
  14. How can I map True/False to 1/0 in a Pandas DataFrame?
  15. How to check if a value is in the list in selection from pandas data frame?
  16. Pandas finding local max and min
  17. SQL-like window functions in PANDAS: Row Numbering in Python Pandas Dataframe
  18. Select multiple ranges of columns in Pandas DataFrame
  19. Pandas lookup from one of multiple columns, based on value
  20. ‘DataFrame’ object has no attribute ‘sort’
  21. python pandas flatten a dataframe to a list
  22. how do I calculate a rolling idxmax
  23. What is dtype(‘O’), in pandas?
  24. Why is np.where faster than pd.apply
  25. Get total of Pandas column
  26. Unpivot Pandas Data
  27. Get first and second highest values in pandas columns
  28. Store numpy.array in cells of a Pandas.DataFrame
  29. Python pandas: how to remove nan and -inf values
  30. Filtering pandas dataframe with multiple Boolean columns

Leave a Comment