Pandas, groupby and count

by

You seem to want to group by several columns at once:

df.groupby(['revenue','session','user_id'])['user_id'].count()

should give you what you want

More Related Contents:

  1. How can I pivot a dataframe?
  2. How to group dataframe rows into list in pandas groupby
  3. Concatenate strings from several rows using Pandas groupby
  4. Groupby value counts on the dataframe pandas
  5. Split pandas dataframe based on groupby
  6. Pandas: filling missing values by mean in each group
  7. GroupBy pandas DataFrame and select most common value
  8. Converting a Pandas GroupBy output from Series to DataFrame
  9. pandas GroupBy columns with NaN (missing) values
  10. Count unique values per groups with Pandas [duplicate]
  11. Multiple aggregations of the same column using pandas GroupBy.agg()
  12. Pandas groupby cumulative sum
  13. Python Pandas max value in a group as a new column
  14. pandas dataframe groupby datetime month
  15. How to loop over grouped Pandas dataframe?
  16. How to move pandas data from index to column after multiple groupby
  17. Python – rolling functions for GroupBy object
  18. Pandas GroupBy and select rows with the minimum value in a specific column
  19. Use pandas.shift() within a group
  20. Pandas Groupby and Sum Only One Column
  21. Python Pandas Group by date using datetime data
  22. Python Pandas Conditional Sum with Groupby
  23. Identifying statistical outliers with pandas: groupby and reduce rows into different dataframe
  24. Pandas Groupby / List to Multiple Rows
  25. Sample each group after pandas groupby
  26. Pandas groupby with categories with redundant nan
  27. pandas groupby where you get the max of one column and the min of another column
  28. Bar graph from dataframe groupby
  29. pandas group by and assign a group id then ungroup
  30. What is the equivalent of SQL “GROUP BY HAVING” on Pandas?

Leave a Comment