Pandas Dummy Variables with Count

Asked Aug 27 '19 at 14:50

Active Aug 27 '19 at 14:50

Viewed 25 times

Instead of using get_dummies(), the ask over here is to have count . Eg: Consider T Shirt Sold at during each hour window.

df = pd.DataFrame({'Time':   [0,0,0,1,1,1,2,2,3,3,3,4,4,4],
                     'Sale': ['M','M','S','S','M','XL','S','M','M','S','S','M','XL','XL'],
               })

Output

Time,   S,M,XL
0,  1,2,0
1,  1,1,1

asked Aug 27 '19 at 14:50

user2458922

1,691
1
17
37

4

`pd.crosstab(df.Time,df.Sale)` ? – anky Aug 27 '19 at 14:52
2

I like the answer above using `crosstab`. You can also use `groupby` after passing your data through the `get_dummies`. `pd.get_dummies(df).groupby('Time').agg(np.sum)` – stahamtan Aug 27 '19 at 14:57
Both Worked.. Please mark them as Answer.. – user2458922 Aug 27 '19 at 14:59

Pandas Dummy Variables with Count

0 Answers0