🔒 cant understand Groupby yet again :/

[lean cradle]

i want to prepare the df in a way i can create this plot. (without weight first) all variables have binary values only

[sage belfry]

@lean cradle

Python help channel opened

Remember to:

• Ask your Python question, not if you can ask or if there's an expert who can help.
• Show a code sample as text (rather than a screenshot) and the error message, if you've got one.
• Explain what you expect to happen and what actually happens.

:warning: Do not pip install anything that isn't related to your question, especially if asked to over DMs.

Closes after a period of inactivity, or when you send !close.

[lean cradle]

i tried this:

(df.groupby(['active', 'gluc', 'smoke'])['cardio'].count())

but this just subdivides stuff:

active  gluc  smoke
0       1     0        10744
              1          840
        2     0          996
              1           95
        3     0          992
              1           72
1       1     0        43508
              1         4387
        2     0         3653
              1          446
        3     0         3938
              1          329

i wanna get the counts of active fluc and smoke for its two values 0 and 1

and it works when i only enter one column in the groupby but it doesnt work for multible

[lean cradle]

theres e.g a totelö of 70k rows. i want sdmth like:

active 
0  30000
1  40000

smoke
0  25000
1  45000

[sage belfry]

@lean cradle

Python help channel closed

This help channel has been closed and it's no longer possible to send messages here. If your question wasn't answered, feel free to create a new post in #1035199133436354600. To maximize your chances of getting a response, check out this guide on asking good questions.