Count the number of occurrences from a column

Question

Be a DataFrame in pandas of this format:

I simply want to create a DataFrame like the following by counting the number of times each row is output in the previous DataFrame.

What have you tried so far? You've added the `group-by` tag, which is almost certainly what you're looking for ;) — gvee, Sep 15 '22 at 12:53
`groupby` here will be slower: use `df["ID"].value_counts(sort=0)` — user3483203, Sep 15 '22 at 13:10

score 1 · Accepted Answer · answered Sep 15 '22 at 12:53

1

Try this:

df.groupby('ID').count()

answered Sep 15 '22 at 12:53

gtomer

1 Answers1