python读取数据分析数据保存数据



import pandas as pd
import matplotlib.pyplot as plt
df = pd.read_csv('E:/biaohao_shuijiaobi_qiangdu - 2.csv',header=None,names=["SJQD","SJB","QIANGDU"])

#print df

grouped=df["SJQD"].groupby(df["QIANGDU"])

grouped

df1 = df.groupby(["SJQD","SJB"]).mean()
df1.to_excel('E:/biaohao_shuijiaobi_qiangdu - 33.xlsx',sheet_name='sheet1')

df.groupby(["SJQD","SJB"]).max().to_excel('E:/biaohao_shuijiaobi_qiangdu - 4.xlsx',sheet_name='sheet1')
df.groupby(["SJQD","SJB"]).min().to_excel('E:/biaohao_shuijiaobi_qiangdu - 5.xlsx',sheet_name='sheet1')
df.groupby(["SJQD","SJB"]).var().to_excel('E:/biaohao_shuijiaobi_qiangdu - 6.xlsx',sheet_name='sheet1')