|
按您说的我运行代码 提示 我
File "C:\Users\Administrator\Anaconda3\lib\site-packages\pandas\core\dtypes\concat.py", line 432, in _concat_datetime
to_concat], axis=axis)
MemoryError
代码如下:
import pandas as pd
df1=pd.read_excel('D:\\42.xlsx',sheet_name=[1,2,3,4,5,6,7,8,9],header=1,skiprows=0)
df=pd.concat([data for data in df1.values()],ignore_index=True)
df.index=pd.to_datetime(df.Time)
result=df.resample('10T').asfreq()
result=result.reset_index(drop=True)
result.to_excel('D:\\result.xlsx',index=None)
|
|