What is print (df.head(20).to_dict()) ?How to get average of field in dataframe

Asked Feb 25 '18 at 14:24

Active Feb 25 '18 at 16:04

Viewed 34 times

I have data frame as :

    Year      Sex  Count
0    yob1880   F    942
1    yob1880   M   1058
2    yob1881   F    938
3    yob1881   M    997
4    yob1882   F   1028
5    yob1882   M   1099
6    yob1883   F   1054
7    yob1883   M   1030
8    yob1884   F   1172

I need to find the average of Male and female in each yearas below:

Year Sex Count 0 yob1880 F 47.5 1 yob1880 M 52.5 and so on...

edited Feb 25 '18 at 16:04

asked Feb 25 '18 at 14:24

jagan nivas

1

Use `df = df.groupby(['Year', 'Sex'], as_index=False)['Count'].mean()`. Or do you need extract years from `yob1880` to integer also? – jezrael Feb 25 '18 at 14:27
What is expected output? – jezrael Feb 25 '18 at 14:27
I have added the result also in the question part.. – jagan nivas Feb 25 '18 at 15:16
OK, thanks, see dupe answer. this is what you need. – jezrael Feb 25 '18 at 15:17
I have tried your code, but igetting the same result i.e no change in my original dataframe – jagan nivas Feb 25 '18 at 15:19
What is `print (df.head(20).to_dict())` ? – jezrael Feb 25 '18 at 15:21
It will convert the dataframe to dictionary.... Do you mean this? – jagan nivas Feb 25 '18 at 15:29
Yes, and please add it to question. – jezrael Feb 25 '18 at 15:29
I think you can add output of `print (df.head(20).to_dict())` to question body, not to question title. – jezrael Feb 25 '18 at 16:05

What is print (df.head(20).to_dict()) ?How to get average of field in dataframe

0 Answers0