数据的合并与分组聚合

import pandas as pd
import numpy as np
df1=pd.DataFrame(np.ones(2,4),index=["A","B"],columns=list("abcd"))

合并

1.join
df1.join(df2)
df2.join(df1)

2.merge
df1.merge(df3,on=“a”)
how=“inner/outer/left/right”

分组聚合

df=pd.read_csv()
print(head(1))
print(info())
进行遍历，调用聚合方法
grouped=df.groupby()
for i,j in grouped

grouped[“Brand”].count( )

索引

df.index[‘x’,‘y’]
df.reindex(“xxxxxx”)
df.set_index(“a”,drop=FALSE)