1 主要内容
- DataFrame.groupby().sum()
- DataFrame.groupby().agg()
- pandas.concat([DataFrame1,DataFrame2])
- pandas.merge(DataFrame1,DataFrame2,parameters….)
- DataFrame1.join(DataFrame2,lsuffix=’列名 on DataFrame1’,rsuffix=’列名 on DataFrame2’)
- 帮助文档的获取
2 实例
- 构造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':[