/Python/Count occurrences of one variable grouped by another python

Count occurrences of one variable grouped by another python

>>> data = pd.DataFrame({'user_id' : ['a1', 'a1', 'a1', 'a2','a2','a2','a3','a3','a3'], 'product_id' : ['p1','p1','p2','p1','p1','p1','p2','p2','p3']})
>>> count_series = data.groupby(['user_id', 'product_id']).size()
>>> count_series
user_id  product_id
a1       p1            2
         p2            1
a2       p1            3
a3       p2            2
         p3            1
dtype: int64
>>> new_df = count_series.to_frame(name = 'size').reset_index()
>>> new_df
  user_id product_id  size
0      a1         p1     2
1      a1         p2     1
2      a2         p1     3
3      a3         p2     2
4      a3         p3     1
>>> new_df['size']
0    2
1    1
2    3
3    2
4    1
Name: size, dtype: int64

Similar codes

2 votes139 views2 answers
How to get only first record in django
Python Django
0 vote101 views2 answers
NameError: name 'request' is not defined
Python
1 vote123 views1 answer
Python two while loops at same time
Python
0 vote109 views1 answer
How to download a project from pythonanywhere
Python
1 vote112 views1 answer
Numpy take out elements equal to zero
Python
0 vote123 views1 answer
Sorting-a-python-list-by-two-fields
Python
0 vote63 views1 answer
Neo4j python
Python
6 votes72 views1 answer
Unicodeencodeerror: 'charmap' codec can't encode characters in position 0-3: character maps to <undefined>
Python
0 vote103 views1 answer
Loading kivy lang
Python
0 vote112 views1 answer
Been deprecated, please pass in a Service object
Python