-1

Gender and city are two different columns. I want to search in such a way that how many males and Females from Gender column in particular city in Pandas

Learning
  • 1
  • 2

1 Answers1

1
df = pd.DataFrame({
    'city': ['NY', 'NY', 'NY', 'LA'],
    'gender': ['m', 'f', 'f', 'm']})

z = df.groupby(['city', 'gender']).size()
z

Output:

city  gender
LA    m         1
NY    f         2
      m         1

To check distribution in one city, e.g. NY:

z = df.groupby(['city', 'gender']).size()
z['NY']

Output:

gender
f    2
m    1
perl
  • 9,826
  • 1
  • 10
  • 22
  • for df["Gender"].value_counts(dropna=False) Male 389648 Female 84544 NaN 64673 Name: Gender, dtype: int64 In same if I want to find total males and Females for particular city. – Learning Mar 07 '19 at 13:45
  • If you have "City" column, run `df.groupby(['City', 'Gender']).size()` – perl Mar 07 '19 at 13:47
  • for df["Gender"].value_counts(dropna=False) Male 389648 Female 84544 NaN 64673 if I want to find total males and Fmale for particular city. ex: NY London Male:23 Male:74 Fmale:23 Fmale:47 – Learning Mar 07 '19 at 13:56
  • Updated my answer with an example – perl Mar 07 '19 at 13:59