How to loop over grouped Pandas dataframe?

by

df.groupby('l_customer_id_i').agg(lambda x: ','.join(x)) does already return a dataframe, so you cannot loop over the groups anymore.

In general:

  • df.groupby(...) returns a GroupBy object (a DataFrameGroupBy or SeriesGroupBy), and with this, you can iterate through the groups (as explained in the docs here). You can do something like:

    grouped = df.groupby('A')

for name, group in grouped:
    ...

  • When you apply a function on the groupby, in your example df.groupby(...).agg(...) (but this can also be transform, apply, mean, …), you combine the result of applying the function to the different groups together in one dataframe (the apply and combine step of the ‘split-apply-combine’ paradigm of groupby). So the result of this will always be again a DataFrame (or a Series depending on the applied function).

More Related Contents:

  1. Get statistics for each group (such as count, mean, etc) using pandas GroupBy?
  2. Aggregation in Pandas
  3. Groupby value counts on the dataframe pandas
  4. Converting a Pandas GroupBy output from Series to DataFrame
  5. Multiple aggregations of the same column using pandas GroupBy.agg()
  6. Is there a way in Pandas to use previous row value in dataframe.apply when previous value is also calculated in the apply?
  7. Pandas groupby mean – into a dataframe?
  8. Python Pandas max value in a group as a new column
  9. How to access pandas groupby dataframe by key
  10. Pandas Groupby and Sum Only One Column
  11. How to drop duplicates based on two or more subsets criteria in Pandas data-frame
  12. Python Pandas Group by date using datetime data
  13. Pandas get frequency of item occurrences in a column as percentage [duplicate]
  14. Pandas – dataframe groupby – how to get sum of multiple columns
  15. Group dataframe and get sum AND count?
  16. How to summarize on different groupby combinations?
  17. get first and last values in a groupby
  18. Pandas groupby and aggregation output should include all the original columns (including the ones not aggregated on)
  19. Get the row corresponding to the max in pandas GroupBy [duplicate]
  20. How to get number of groups in a groupby object in pandas?
  21. When is it appropriate to use df.value_counts() vs df.groupby(‘…’).count()?
  22. How to provide a reproducible copy of your DataFrame with to_clipboard()
  23. How to reversibly store and load a Pandas dataframe to/from disk
  24. Rename specific column(s) in pandas
  25. python pandas dataframe slicing by date conditions
  26. Convert list into a pandas dataframe
  27. Python: Removing Rows on Count condition
  28. Remove NaN/NULL columns in a Pandas dataframe?
  29. Group DataFrame in 5-minute intervals
  30. How to use str.contains() with multiple expressions in pandas dataframes

Leave a Comment