Pandas groupby and qcut

by 
import pandas as pd
df = pd.DataFrame({'A':'foo foo foo bar bar bar'.split(),
                   'B':[0.1, 0.5, 1.0]*2})

df['C'] = df.groupby(['A'])['B'].transform(
                     lambda x: pd.qcut(x, 3, labels=range(1,4)))
print(df)

yields

     A    B  C
0  foo  0.1  1
1  foo  0.5  2
2  foo  1.0  3
3  bar  0.1  1
4  bar  0.5  2
5  bar  1.0  3

More Related Contents:

  1. Get statistics for each group (such as count, mean, etc) using pandas GroupBy?
  2. How do I create a new column from the output of pandas groupby().sum()?
  3. How to groupby consecutive values in pandas DataFrame
  4. Pandas GroupBy.apply method duplicates first group
  5. pandas GroupBy columns with NaN (missing) values
  6. Count unique values per groups with Pandas [duplicate]
  7. Pandas ‘count(distinct)’ equivalent
  8. Pandas Groupby Range of Values
  9. Count unique values using pandas groupby
  10. pandas groupby, then sort within groups
  11. How to access pandas groupby dataframe by key
  12. Pandas GroupBy and select rows with the minimum value in a specific column
  13. group by in group by and average
  14. How to group a pandas dataframe by a defined time interval?
  15. Pandas: resample timeseries with groupby
  16. Make Pandas groupby act similarly to itertools groupby
  17. Python pandas – filter rows after groupby
  18. Python Pandas How to assign groupby operation results back to columns in parent dataframe?
  19. why does pandas rolling use single dimension ndarray
  20. pandas – find first occurrence
  21. python pandas groupby() result
  22. Group dataframe and get sum AND count?
  23. Pivot Tables or Group By for Pandas?
  24. Pivot Tables of Counts in Pandas DataFrame
  25. Pandas groupby with categories with redundant nan
  26. Pandas Correlation Groupby
  27. Add a sequence number to each element in a group using python
  28. Pandas: groupby forward fill with datetime index
  29. How to get number of groups in a groupby object in pandas?
  30. Why do I get a KeyError when using pandas apply?

Leave a Comment