Pandas: Incrementally count occurrences in a column

by

You can use cumcount
to avoid a dummy column:

>>> df["Occ_Number"] = df.groupby("Name").cumcount()+1
>>> df
  Name  Occ_Number
0  abc           1
1  def           1
2  ghi           1
3  abc           2
4  abc           3
5  def           2
6  jkl           1
7  jkl           2

More Related Contents:

  1. How to split a dataframe string column into two columns?
  2. Annotate bars with values on Pandas bar plots
  3. Comparing two dataframes and getting the differences [duplicate]
  4. How to make separator in pandas read_csv more flexible wrt whitespace, for irregular separators?
  5. Why isn’t my Pandas ‘apply’ function referencing multiple columns working? [closed]
  6. Convert the string 2.90K to 2900 or 5.2M to 5200000 in pandas dataframe
  7. Conditionally fill column values based on another columns value in pandas
  8. pandas concat generates nan values
  9. Normalize columns of a dataframe
  10. Pandas Groupby and Sum Only One Column
  11. Quickest way to make a get_dummies type dataframe from a column with a multiple of strings
  12. Pandas Dataframe: Replacing NaN with row average
  13. How to read a .xlsx file using the pandas Library in iPython?
  14. “unstack” a pandas column containing lists into multiple rows [duplicate]
  15. Pandas Replace NaN with blank/empty string
  16. How to check whether a pandas DataFrame is empty?
  17. Python pandas Filtering out nan from a data selection of a column of strings
  18. How to append rows in a pandas dataframe in a for loop?
  19. ValueError: Length of values does not match length of index | Pandas DataFrame.unique()
  20. Copy pandas dataframe to excel using openpyxl
  21. How to drop unique rows in a pandas dataframe?
  22. How to reorder indexed rows based on a list in Pandas data frame
  23. Trying to merge 2 dataframes but get ValueError
  24. How can I count the number of consecutive TRUEs in a DataFrame?
  25. Truncate `TimeStamp` column to hour precision in pandas `DataFrame`
  26. Remove row with null value from pandas data frame
  27. Replace NaN with empty list in a pandas dataframe
  28. Get weekday/day-of-week for Datetime column of DataFrame
  29. Get max value from row of a dataframe in python [duplicate]
  30. When is it appropriate to use df.value_counts() vs df.groupby(‘…’).count()?

Leave a Comment