数据分析学习记录-----DAY6

31.牛客网每日正确与错误的答题次数：

import pandas as pd

df=pd.read_csv('nowcoder.csv')

df['year-month-day']=pd.to_datetime(df["date"]).dt.date

a=df.groupby(['result','year-month-day'])['year-month-day'].count()

print(a)

32.牛客网答题正误总数:

思路和上题一样

33.

34.牛客网不同毕业年份的大佬:

import pandas as pd

df=pd.read_csv('Nowcoder.csv')

print(df.groupby('Graduate_year')['Achievement_value'].apply(max))

35.不同等级用户语言使用情况:

与31思路一样

36.总人数超过5的等级

import pandas as pd

df=pd.read_csv('Nowcoder.csv')

a=df.groupby('Level')['Level'].apply(sum)

print(a[a>5])

37.统计运动会项目报名人数

import pandas as pd

item=pd.read_csv('items.csv')

signup=pd.read_csv('signup.csv')

df=pd.merge(item,signup,on='item_id')

a=df.groupby('item_name').count().item_id

print(a[a>0])