国外科技感强的网站,wordpress文章版权,房地产信息网查询,自媒体平台账号我是Python中Pandas概念的新手.通常情节不是问题.但是,我现在面临的是包含索引的数据框.不知何故什么都没有了.我想要实现的目标#xff1a;为每个列[Plant1,Plant2,Plant3]创建一个特定柱[Trafo1]的子图.这是我的代码#xff1a;import numpy as npimport datetimeimport nu…我是Python中Pandas概念的新手.通常情节不是问题.但是,我现在面临的是包含索引的数据框.不知何故什么都没有了.我想要实现的目标为每个列[Plant1,Plant2,Plant3]创建一个特定柱[Trafo1]的子图.这是我的代码import numpy as npimport datetimeimport numpy as npimport matplotlibimport matplotlib.pyplot as pltimport pandas as pdimport os# Create the sample dataplant1 {Date : pd.date_range(1/1/2011, periods10, freqD),Plant : pd.Series([Plant1]*10),Output : pd.Series(abs(np.random.randn(10)))}plant2 {Date : pd.date_range(1/3/2011, periods10, freqD),Plant : pd.Series([Plant2]*10),Output : pd.Series(abs(np.random.randn(10)))}plant3 {Date : pd.date_range(1/5/2011, periods10, freqD),Plant : pd.Series([Plant3]*10),Output : pd.Series(abs(np.random.randn(10)))}trafo1 {Date : pd.date_range(1/5/2011, periods10, freqD),Plant : pd.Series([Trafo1]*10),Output : pd.Series(abs(np.random.randn(10)))}trafo2 {Date : pd.date_range(1/5/2011, periods10, freqD),Plant : pd.Series([Trafo2]*10),Output : pd.Series(abs(np.random.randn(10)))}df_plant_1 pd.DataFrame(plant1)df_plant_2 pd.DataFrame(plant2)df_plant_3 pd.DataFrame(plant3)df_trafo_1 pd.DataFrame(trafo1)df_trafo_2 pd.DataFrame(trafo2)sample pd.concat([df_plant_1,df_plant_2,df_plant_3,df_trafo_1,df_trafo_2])test pd.pivot_table(sample, indexDate, columnsPlant, valuesOutput)test test.fillna(methodpad)test test.fillna(methodbfill)# Draw the plotsmatplotlib.style.use(ggplot)cols len(test.columns) - 1fig, axes plt.subplots(nrowscols/2, ncols2, figsize(12, 4))for column in test.iloc[:,:-1]:test.plot(xtest[column], ytest[Trafo1], titlecolumn)plt.gca().set_aspect(equal, adjustablebox)plt.show()导致以下错误输出runfile(C:/..../untitled12.py, wdirC:/...)Traceback (most recent call last):File , line 1, in runfile(C:/Users/bjl/untitled12.py, wdirC:/Users/bjl)File C:\Anaconda2\lib\site-packages\spyderlib\widgets\externalshell\sitecustomize.py, line 699, in runfileexecfile(filename, namespace)File C:\Anaconda2\lib\site-packages\spyderlib\widgets\externalshell\sitecustomize.py, line 74, in execfileexec(compile(scripttext, filename, exec), glob, loc)File C:/Users/bjl/untitled12.py, line 52, in test.plot(xtest[column], ytest[Trafo1], titlecolumn)File C:\Anaconda2\lib\site-packages\pandas\tools\plotting.py, line 3671, in __call__sort_columnssort_columns, **kwds)File C:\Anaconda2\lib\site-packages\pandas\tools\plotting.py, line 2556, in plot_frame**kwds)File C:\Anaconda2\lib\site-packages\pandas\tools\plotting.py, line 2370, in _plotseries data[y].copy() # Dont modifyFile C:\Anaconda2\lib\site-packages\pandas\core\frame.py, line 1963, in __getitem__return self._getitem_array(key)File C:\Anaconda2\lib\site-packages\pandas\core\frame.py, line 2007, in _getitem_arrayindexer self.ix._convert_to_indexer(key, axis1)File C:\Anaconda2\lib\site-packages\pandas\core\indexing.py, line 1150, in _convert_to_indexerraise KeyError(%s not in index % objarr[mask])KeyError: [ 1.20311253 1.20311253 1.20311253 1.20311253 1.20311253 0.32765014\n 1.65686117 2.58118029 0.58903059 0.13907876 0.59270297 0.27072611\n 0.50167366 1.0310578 ] not in index我不明白索引的问题是什么.我无法在线找到任何帮助,因为所有示例都没有索引.我非常感谢你的帮助.这个错误对新手来说很神秘.
