pandas进行分组统计

需要获取foursquare中每个用户每个签到地点的频次

可以用到pandas中groupby方法

data_ny.groupby(by=['userId','venueId']).size()

然后将userId ，venueId，频次写入csv中

userId = []
venueId = []
count = []
for i in data_gb:
    userId.append(i[0][0])
    venueId.append(i[0][1]) 
data_ub = pd.DataFrame()
data_ub['userId'] = userId
data_ub['venueId'] = venueId
data_ub['count'] = data_gb.size()
data_ub.to_csv('data/foursquare/data_ub.csv',index=None)