文章浏览阅读82次。import pandas as pdimport numpy as npimport matplotlib.pyplot as pltdata=pd.read_excel('/data/trd.xlsx',engine="openpyxl")print(data.columns) print(data.iloc[:5])dt=data.loc[data['股票代码']==600000,['交易日期','收盘价','交易量']]I1=dt['交易日期'......
文章浏览阅读118次。import numpy as npimport pandas as pdimport os#将数据进行转置,转置后行为用户编号、列为日期、值为用户每日用电量。data=pd.read_csv('data_etr.csv',parse_dates=['DATA_DATE'],encoding='gbk')data.head()#透视表data_new=pd.pivot_table(data=data......