Pandas number rows within group in increasing order

by

Use groupby/cumcount:

In [25]: df['C'] = df.groupby(['A','B']).cumcount()+1; df
Out[25]: 
   A  B  C
0  A  a  1
1  A  a  2
2  A  b  1
3  B  a  1
4  B  a  2
5  B  a  3

More Related Contents:

  1. Concatenate strings from several rows using Pandas groupby
  2. Pandas groupby with delimiter join
  3. Number rows within group in increasing order in a pandas dataframe
  4. Pandas rank by multiple columns
  5. How to group dataframe rows into list in pandas groupby
  6. Groupby value counts on the dataframe pandas
  7. Replace values in a pandas series via dictionary efficiently
  8. FutureWarning: elementwise comparison failed; returning scalar, but in the future will perform elementwise comparison
  9. Moving Average Pandas
  10. How to loop over grouped Pandas dataframe?
  11. How to deal with multi-level column names downloaded with yfinance
  12. How to use groupby to concatenate strings in python pandas?
  13. group by pandas dataframe and select latest in each group
  14. Pandas deleting row with df.drop doesn’t work
  15. How to melt 2 columns at the same time?
  16. Python Pandas Conditional Sum with Groupby
  17. Identifying statistical outliers with pandas: groupby and reduce rows into different dataframe
  18. Transform vs. aggregate in Pandas
  19. Sample each group after pandas groupby
  20. pandas.io.json.json_normalize with very nested json
  21. Updating a value in a pandas dataframe in an iterrows loop
  22. pandas groupby where you get the max of one column and the min of another column
  23. FutureWarning: The default value of regex will change from True to False in a future version
  24. Check if rows in one dataframe exist in another dataframe
  25. Pandas ParserError EOF character when reading multiple csv files to HDF5
  26. Python making combined bar and line plot with secondary y-axis
  27. Pandas groupby and aggregation output should include all the original columns (including the ones not aggregated on)
  28. How to convert string representation of dictionary in Pandas DataFrame to a new columns?
  29. Get the row corresponding to the max in pandas GroupBy [duplicate]
  30. When is it appropriate to use df.value_counts() vs df.groupby(‘…’).count()?

Leave a Comment