Python Pandas How to assign groupby operation results back to columns in parent dataframe?

by 
In [97]: df = pandas.DataFrame({'month': np.random.randint(0,11, 100), 'A': np.random.randn(100), 'B': np.random.randn(100)})

In [98]: df.join(df.groupby('month')['A'].sum(), on='month', rsuffix='_r')
Out[98]:
           A         B  month       A_r
0  -0.040710  0.182269      0 -0.331816
1  -0.004867  0.642243      1  2.448232
2  -0.162191  0.442338      4  2.045909
3  -0.979875  1.367018      5 -2.736399
4  -1.126198  0.338946      5 -2.736399
5  -0.992209 -1.343258      1  2.448232
6  -1.450310  0.021290      0 -0.331816
7  -0.675345 -1.359915      9  2.722156

More Related Contents:

  1. How do I Pandas group-by to get sum?
  2. Get statistics for each group (such as count, mean, etc) using pandas GroupBy?
  3. How to groupby consecutive values in pandas DataFrame
  4. Python: get a frequency count based on two columns (variables) in pandas dataframe some row appers
  5. Pandas dataframe get first row of each group
  6. Pandas groupby multiple fields then diff
  7. How to access pandas groupby dataframe by key
  8. How can I use cumsum within a group in Pandas?
  9. pandas – find first occurrence
  10. Add a sequential counter column on groups to a pandas dataframe
  11. Group dataframe and get sum AND count?
  12. Pandas groupby for zero values
  13. pandas divide row value by aggregated sum with a condition set by other cell
  14. Select row by max value in group in a pandas dataframe
  15. Pandas groupby with bin counts
  16. get first and last values in a groupby
  17. Pandas groupby and aggregation output should include all the original columns (including the ones not aggregated on)
  18. how to convert monthly data to quarterly in pandas
  19. Get the row corresponding to the max in pandas GroupBy [duplicate]
  20. Get frequency of item occurrences in a column as percentage [duplicate]
  21. How to get number of groups in a groupby object in pandas?
  22. How to split a dataframe string column into two columns?
  23. Comparing two dataframes and getting the differences [duplicate]
  24. Get the name of a pandas DataFrame
  25. What is the difference between join and merge in Pandas?
  26. Ambiguity in Pandas Dataframe / Numpy Array “axis” definition
  27. How to read a .xlsx file using the pandas Library in iPython?
  28. Pandas – dataframe groupby – how to get sum of multiple columns
  29. Convert month int to month name in Pandas
  30. Add a sequence number to each element in a group using python

Leave a Comment