Pandas counting and summing specific conditions

by

You can first make a conditional selection, and sum up the results of the selection using the sum function.

>> df = pd.DataFrame({'a': [1, 2, 3]})
>> df[df.a > 1].sum()   
a    5
dtype: int64

Having more than one condition:

>> df[(df.a > 1) & (df.a < 3)].sum()
a    2
dtype: int64

If you want to do COUNTIF, just replace sum() with count()

More Related Contents:

  1. Pandas: sum DataFrame rows for given columns
  2. Pandas groupby nlargest sum
  3. Get total of Pandas column
  4. What’s the best way to sum all values in a Pandas dataframe? [duplicate]
  5. How to iterate over rows in a DataFrame in Pandas
  6. Selecting with complex criteria from pandas.DataFrame
  7. Combine two pandas Data Frames (join on a common column)
  8. Remove non-numeric rows in one column with pandas
  9. Plot Pandas DataFrame as Bar and Line on the same one chart
  10. Calculating difference between two rows in Python / Pandas
  11. Pandas: Looking up the list of sheets in an excel file
  12. Pandas: Subtracting two date columns and the result being an integer
  13. Convert timedelta64[ns] column to seconds in Python Pandas DataFrame
  14. Can pandas groupby aggregate into a list, rather than sum, mean, etc?
  15. AttributeError: ‘PandasExprVisitor’ object has no attribute ‘visit_Ellipsis’, using pandas eval
  16. Pandas reading csv as string type
  17. Python Pandas read_csv skip rows but keep header
  18. Python Pandas Replacing Header with Top Row
  19. Adding values for missing data combinations in Pandas
  20. python pandas – creating a column which keeps a running count of consecutive values
  21. Why is pandas.to_datetime slow for non standard time format such as ‘2014/12/31’
  22. What is the fastest and most efficient way to append rows to a DataFrame?
  23. How to plot different groups of data from a dataframe into a single figure
  24. pandas group by and find first non null value for all columns
  25. how to concat two data frames with different column names in pandas? – python
  26. Pandas – Interleave / Zip two DataFrames by row
  27. Python Pandas – Read csv file containing multiple tables
  28. How indexing works in Pandas?
  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