python - Count the number of males and females in a csv file

Question

Suppose I have this csv file named sample.csv:

CODE     AGE     SEX     CITY
----     ---     ---     ----
E101      25      M      New York
E102      42      F      New York
E103      31      M      Chicago
E104      67      F      Chicago

I wish to count the number of males and females in the data. For instance, for this one, the answer would be:

M : 2
F : 2

Where should I start and how should I code it?

Answer 1

You can do this:

import pandas as pd
df = pd.read_csv("sample.csv")

print(f"M : {len(df[df['SEX'] == 'M'])}")
print(f"F : {len(df[df['SEX'] == 'F'])}")