create new column counting gender year wise

Asked Mar 17 '21 at 19:41

Active Mar 17 '21 at 19:41

Viewed 11 times

I have a dataframe:

d={'year':['2011','2011','2011','2012','2012','2013','2013'],'sex':['M','F','M','M','F','F','M']}

df=pd.DataFrame(d)

I want to create new column for performing time series analysis, count of male and female each year. Output should be a dataframe like below:

I tried d1.groupby(['sex','year']).count(), but it did not do what i expected in output

edited Mar 17 '21 at 19:41

Quang Hoang

asked Mar 17 '21 at 19:41

Nishant

`pd.crosstab(df['Year'], df['sex'])`. – Quang Hoang Mar 17 '21 at 19:46
Use ```size()``` instead of ```count()``` – Ani Mar 17 '21 at 19:48
See this: https://stackoverflow.com/questions/17679089/pandas-dataframe-groupby-two-columns-and-get-counts – Ani Mar 17 '21 at 19:49

0 Answers0