1.pandas数据统计操作,分组排序统计,去重,union合并
import pandas as pd
df = pd.DataFrame([{'A':2,'B':3},{'A':2,'B':3},{'A':5,'B':3},{'A':2,'B':9}])
df1 =df
df2 = df
df = pd.concat([df1,df2],ignore_index=True) ##合并 union
# '''
# A B
# 0 2 3
# 1 2 3
# 2 5 3
# 3 2 9
# 4 2 3
# 5 2 3
# 6 5 3
# 7 2 9
# '''
df.drop_duplicates(inplace=True) #去重
# '''
# A B
# 0 2 3
# 2 5 3
# 3 2 9
# '''
df.groupby(['A']).size().reset_index(name='counts') #分组操作 ['A'] 根据列分组 ['A','B']
# '''
# A counts
# 0 2 2
# 1 5 1
# '''
df['A'].tolist() ##[2, 5, 2] 将谋列转化为list