python pandas 聚合与分组函数

1 主要内容

1. DataFrame.groupby().sum()
2. DataFrame.groupby().agg()
3. pandas.concat([DataFrame1,DataFrame2])
4. pandas.merge(DataFrame1,DataFrame2,parameters….)
5. DataFrame1.join(DataFrame2,lsuffix=’列名 on DataFrame1’,rsuffix=’列名 on DataFrame2’)
6. 帮助文档的获取

2 实例

1. 构造dataframe如下所示：

  food  food_id  number     price  user_id weather
0       soup        4       6  1.818250        3    cold
1       soup        8       6  1.834045        4     hot
2    iceream        8       7  3.042422        2    cold
3  chocolate        3       6  5.247564        4     hot
4    iceream        6       3  4.319450        4    cold
5    iceream        5       4  2.912291        1    cold
6    iceream        2       7  6.118529        2    cold
7       soup        8       4  1.394939        2     hot
8       soup        6       8  2.921446        2     hot
9  chocolate        2       1  3.663618        4     hot

实现程序如下所示：

import pandas as pd
from numpy import random
from numpy.random import rand
import numpy as np

random.seed(42)

df = pd.DataFrame({
  'user_id':random.randint(0,6,10),'food_id':random.randint(1,10,10),
'weather':['cold','hot','cold','hot','cold','cold','cold','hot','hot','hot'],
'food':[