I want an output in a table as shown below:
JavaScript
x
4
1
GENDER SUM
2
Male 432
3
Female 521
4
Advertisement
Answer
Example inspired by this article
JavaScript
1
13
13
1
import pandas as pd
2
3
# create a sample dataframe
4
data = {
5
'A': ['E1', 'E2', 'E3', 'E4', 'E5'],
6
'B': ['Male', 'Female', 'Female', 'Male', 'Male'],
7
'C': [27, 24, 29, 24, 25],
8
'D': ['Accounting', 'Sales', 'Accounting', 'Coding', 'Sales']
9
}
10
df = pd.DataFrame(data)
11
12
print(df['Gender'].value_counts()) # This is what you will use
13
This prints
JavaScript
1
4
1
Male 3
2
Female 2
3
Name: Gender, dtype: int64
4
You can read more about value_counts()
here.