要按日期时间从原始文件中选择数据并将其插入csv文件吗
data = pd.read_csv(r'dataset.csv', low_memory=False, header = None, sep = ',')
s = pd.Series(data.loc['4/1/2019 7:57':'4/1/2019 12:27' , data.index[1,8,15,22,29,36,43]])
data = pd.DataFrame(s)
data.to_csv('summary.csv', index = False, header = None)
错误是“数组的索引太多”
<ipython-input-430-ca5724310254> in <module>
1 # Load the dataset using Pandas
2 data = pd.read_csv(r'Mill Operation U1.csv', low_memory=False, header = None, sep = ',')
----> 3 s = pd.Series(data.loc['4/1/2019 7:57':'4/1/2019 12:27' , data.index[1,8,15,22,29,36,43]])
4
5
~\Anaconda3\lib\site-packages\pandas\core\indexes\range.py in __getitem__(self, key)
588
589 # fall back to Int64Index
--> 590 return super_getitem(key)
591
592 def __floordiv__(self, other):
~\Anaconda3\lib\site-packages\pandas\core\indexes\base.py in __getitem__(self, key)
3967
3968 key = com.values_from_object(key)
-> 3969 result = getitem(key)
3970 if not is_scalar(result):
3971 return promote(result)
IndexError: too many indices for array
你知道吗
我相信你需要:
样本:
相关问题 更多 >
编程相关推荐