######同一个dataframe文件写入pickle文件和写入csv效率对比
import numpy as np
import pandas as pd
import pickle
import time
###创建一个数据框,准备基础数据
file='C:/Users/Administrator/数据/5分钟/28#OIL9.txt'
data=pd.read_table(file,encoding="gbk",skiprows=2,sep=',')
data
data.columns=['date','time','open','hgih','low','close','vol','advol','fof']
del data['fof']
data.head()
df=data.copy()
df.head()
###写入pickle文件
f=open('dfl2','wb+')
%time pickle.dump(df,f)
f.close
###写入csv文件
f=open('dfl3.csv','w')
%time df.to_csv('df2.csv')
import numpy as np
import pandas as pd
import pickle
import time
###创建一个数据框,准备基础数据
file='C:/Users/Administrator/数据/5分钟/28#OIL9.txt'
data=pd.read_table(file,encoding="gbk",skiprows=2,sep=',')
data
data.columns=['date','time','open','hgih','low','close','vol','advol','fof']
del data['fof']
data.head()
df=data.copy()
df.head()
###写入pickle文件
f=open('dfl2','wb+')
%time pickle.dump(df,f)
f.close
###写入csv文件
f=open('dfl3.csv','w')
%time df.to_csv('df2.csv')
f.close
#################################################################
#################
似乎导入到csv文件失败了。。。。。。。。。。。。。。。。。