Python读取mat文件并转换为dataframe格式数据
from scipy.io import loadmatimport pandas as pdfilename = r'D:\python_project_lzz\a1405.mat'data = loadmat(filename)dfdata = pd.DataFrame(data=data['data'][1:],columns=['date','time','open','high','lo
·
from scipy.io import loadmat
import pandas as pd
filename = r'D:\python_project_lzz\a1405.mat'
data = loadmat(filename)
dfdata = pd.DataFrame(data=data['data'][1:],columns=['date','time','open','high','low','close','volume','amount','position']).astype(str)
dfdata['date'] = dfdata['date'].map(lambda x: x.replace('[', '').replace(']', ''))
dfdata["time"] =dfdata['time'].map(lambda x: x.replace('[', '').replace(']', ''))
dfdata["open"] =dfdata['open'].map(lambda x: x.replace('[', '').replace(']', ''))
dfdata["high"] =dfdata['high'].map(lambda x: x.replace('[', '').replace(']', ''))
dfdata["low"] =dfdata['low'].map(lambda x: x.replace('[', '').replace(']', ''))
dfdata["close"]=dfdata['close'].map(lambda x: x.replace('[', '').replace(']', ''))
dfdata["volume"]=dfdata['volume'].map(lambda x: x.replace('[', '').replace(']', ''))
dfdata["amount"]=dfdata['amount'].map(lambda x: x.replace('[', '').replace(']', ''))
dfdata["position"]=dfdata['position'].map(lambda x: x.replace('[', '').replace(']', ''))
print(dfdata)
DAMO开发者矩阵,由阿里巴巴达摩院和中国互联网协会联合发起,致力于探讨最前沿的技术趋势与应用成果,搭建高质量的交流与分享平台,推动技术创新与产业应用链接,围绕“人工智能与新型计算”构建开放共享的开发者生态。
更多推荐

所有评论(0)