如何使用python将.mat文件转换为csv？

Question

我先用了这个密码-

from scipy.io import loadmat 
data=loadmat(r"C:\Users\ansha\Downloads\HTS_C1_SN14_13.11.2019_02.mat")
print(data.keys())

然后我得到这个作为输出-

dict_keys(['__header__', '__version__', '__globals__', 'EyePts_', 'JoyPts_', 'TrlNo_', 'M1EyeX_', 'M1EyeY_', 'M1Pupil_', 'M1JoyX_', 'M1JoyY_', 'cond_', 'RwdCue_', 'MagCue_', 'MLTrialStart_', 'MLTrialEnd_', 'TrialStart_', 'FixToggleON_', 'FixON_', 'AcqFix_', 'HoldFix_', 'Correct_', 'RewardONJ1_', 'RewardOFFJ1_', 'Abort_', 'EndOfTrial_', 'ITION_', 'ITIOFF_', 'STargetON_', 'AcqSTarget_', 'HoldSTarget_', 'SmRwdON_', 'SmRwdOFF_', 'LickCamON_', 'RewardCueON_', 'HoldRwdCue_', 'MagnitudeCueON_', 'HoldMagCue_', 'TwoTargetsON_', 'AcqRTarget_', 'HoldRTarget_', 'AcqLTarget_', 'HoldLTarget_', 'RewardONJ2_', 'RewardOFFJ2_', 'RewardONJ3_', 'RewardOFFJ3_', 'RewardONJ4_', 'RewardOFFJ4_', 'YRcue_pos_', 'WRcue_pos_', 'LT_pos_', 'RT_pos_', 'RT_col_', 'LT_col_', 'RCueCol_', 'JoyPosn_', 'LeftT_', 'RtT_', 'ReactionTime_', 'ReactionTimeP_'])

我现在迷路了，我不知道如何将它转换成熊猫数据，并将其保存为csv。救命啊！

Answer 1

试着使用：

from scipy.io import loadmat 
import pandas as pd
data = loadmat(r"C:\Users\ansha\Downloads\HTS_C1_SN14_13.11.2019_02.mat")
data  = {k:v for k, v in data.items() if k[0] != '_'}
df = pd.DataFrame({k: pd.Series(v[0]) for k, v in data.items()})  
df.to_csv("example.csv")