Say I have this dataframe:
order_id | class
1 | furniture
2 | book
2 | furniture
2 | book
3 | auto
3 | auto
3 | electronics
3 | pet
and to get the most frequent class of each order:
df.groupby('order_id').agg({'order_id': lambda x: x.value_counts().index[0]})
Monday, December 31, 2018
Subscribe to:
Posts (Atom)
-
It took me a while to figure out how to insert a space in Mathtype equations. This is especially useful when you write an equation with mult...
-
Recently I read post from Dr. Doug Hull's blog: http://blogs.mathworks.com/videos/2009/10/23/basics-volume-visualization-19-defining-s... -
To get the slope of a pair of x and y, usually I first plot the curve and then add the trend line. Actually there are two functions i...