2019-05-24 pandas

#导入excel 
import pandas as pd

e_file = pd.ExcelFile('7月下旬入库表.xlsx')
data = e_file.parse('7月下旬入库表')
print(data)

# 数据透视
import pandas as pd
import numpy as np

e_file = pd.ExcelFile('7月下旬入库表.xlsx')
data = e_file.parse('7月下旬入库表')
# print(data)
pt1 = pd.pivot_table(data, index=['销售商'], columns=['来源省份'], values=['入库量（吨）'], aggfunc=np.sum, margins=True)

pt2 = pd.pivot_table(data, index=['销售商'], columns=['来源省份'], values=['入库量（吨）'], aggfunc=np.size, margins=True)
pd.set_option('display.max_columns', None)

print(pt1)
print(pt2)

#取一个数据
print(pt1.iat[0,0])
print(pt1.iat[1,0])