Pandas groupby having condition on column

Asked Feb 03 '23 at 06:15

Active Feb 03 '23 at 06:15

Viewed 18 times

I have data like this :

    userID  activity   count
0   3       running         5
1   3       running         6
2   3       walking         0
3   3       walking         1
4   3       stopped         2

I want to group data conditionallly, by userID and wether activity is running(1) or not (0)

This will group by userID, of course, I'm a newbie in Pandas!:

numUsers = df.groupby(by=["userID"])["count"].sum()

asked Feb 03 '23 at 06:15

AVEbrahimi

17,993
23
107
210

`numUsers = df.groupby(by=["userID",df["activity"].eq('running').astype(int)])["count"].sum()` – jezrael Feb 03 '23 at 06:16
.eq is not working on UTF8, specially Arabic characters? – AVEbrahimi Feb 03 '23 at 06:34
It should working well, but you can try `numUsers = df.groupby(by=["userID",(df["activity"] == 'running').astype(int)])["count"].sum()` – jezrael Feb 03 '23 at 06:35

Pandas groupby having condition on column

0 Answers0