Converting mat files to csv using python, scipy and pandas

mat_to_csv.py

import scipy.io
import pandas as pd

mat = scipy.io.loadmat('file.mat')
mat = {k:v for k, v in mat.items() if k[0] != '_'}
data = pd.DataFrame({k: pd.Series(v[0]) for k, v in mat.iteritems()})
data.to_csv("example.csv")

Yes iPhone’umdan gönderildi Jay Gupta ***@***.***> şunları yazdı (4 Oca 2023 22:45):  @jaygupta-2k commented on this gist.

…

________________________________ hello I have 980 mat files they contain ecg records. I want to convert them to a single csv. What code should I write in python? did anyone find a proper solution for this? — Reply to this email directly, view it on GitHub<https://gist.github.com/9001039bf54ba9d8aec3ad7f5d8bfd08#gistcomment-4424275> or unsubscribe<https://github.com/notifications/unsubscribe-auth/AKPHIN4C5GBBN3GCIYWXVR3WQXHONBFKMF2HI4TJMJ2XIZLTSKBKK5TBNR2WLJDHNFZXJJDOMFWWLK3UNBZGKYLEL52HS4DFQKSXMYLMOVS2I5DSOVS2I3TBNVS3W5DIOJSWCZC7OBQXE5DJMNUXAYLOORPWCY3UNF3GS5DZVRZXKYTKMVRXIX3UPFYGLK2HNFZXIQ3PNVWWK3TUUZ2G64DJMNZZDAVEOR4XAZNEM5UXG5FFOZQWY5LFVA2DKOJTGUYDONFHORZGSZ3HMVZKMY3SMVQXIZI>. You are receiving this email because you commented on the thread. Triage notifications on the go with GitHub Mobile for iOS<https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android<https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.

Can you help me out please?

…

On Thu, 5 Jan, 2023, 3:22 am Tuğba TAŞBAŞI, ***@***.***> wrote: ***@***.**** commented on this gist. ------------------------------ Yes iPhone’umdan gönderildi Jay Gupta ***@***.***> şunları yazdı (4 Oca 2023 22:45):  @jaygupta-2k commented on this gist. ________________________________ hello I have 980 mat files they contain ecg records. I want to convert them to a single csv. What code should I write in python? did anyone find a proper solution for this? — Reply to this email directly, view it on GitHub< https://gist.github.com/9001039bf54ba9d8aec3ad7f5d8bfd08#gistcomment-4424275> or unsubscribe< https://github.com/notifications/unsubscribe-auth/AKPHIN4C5GBBN3GCIYWXVR3WQXHONBFKMF2HI4TJMJ2XIZLTSKBKK5TBNR2WLJDHNFZXJJDOMFWWLK3UNBZGKYLEL52HS4DFQKSXMYLMOVS2I5DSOVS2I3TBNVS3W5DIOJSWCZC7OBQXE5DJMNUXAYLOORPWCY3UNF3GS5DZVRZXKYTKMVRXIX3UPFYGLK2HNFZXIQ3PNVWWK3TUUZ2G64DJMNZZDAVEOR4XAZNEM5UXG5FFOZQWY5LFVA2DKOJTGUYDONFHORZGSZ3HMVZKMY3SMVQXIZI >. You are receiving this email because you commented on the thread. Triage notifications on the go with GitHub Mobile for iOS< https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android< https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub >. — Reply to this email directly, view it on GitHub <https://gist.github.com/9001039bf54ba9d8aec3ad7f5d8bfd08#gistcomment-4424409> or unsubscribe <https://github.com/notifications/unsubscribe-auth/AOBCYIVDRD66WSAFIVT2Y7DWQXWLLBFKMF2HI4TJMJ2XIZLTSKBKK5TBNR2WLJDHNFZXJJDOMFWWLK3UNBZGKYLEL52HS4DFQKSXMYLMOVS2I5DSOVS2I3TBNVS3W5DIOJSWCZC7OBQXE5DJMNUXAYLOORPWCY3UNF3GS5DZVRZXKYTKMVRXIX3UPFYGLK2HNFZXIQ3PNVWWK3TUUZ2G64DJMNZZDAVEOR4XAZNEM5UXG5FFOZQWY5LFVA2DKOJTGUYDONFHORZGSZ3HMVZKMY3SMVQXIZI> . You are receiving this email because you were mentioned. Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub> .

hello I have 980 mat files they contain ecg records. I want to convert them to a single csv. What code should I write in python?

Hi, did you find a proper solution for this?

If yes, could you please post your solution here . thanks in advanced

import scipy.io
import pandas as pd

mat = scipy.io.loadmat('file.mat')
mat = {k:v for k, v in mat.items() if k[0] != '_'}
data = pd.DataFrame({k: pd.Series(v[0]) for k, v in mat.items()})
data.to_csv("example.csv")

This should work. use items() instead of iteritems()

Executing the above code causes the following error:
Traceback (most recent call last): File "mat2csv.py", line 6, in <module> data = pd.DataFrame({k: pd.Series(v[0]) for k, v in mat.iteritems()}) AttributeError: 'dict' object has no attribute 'iteritems'
Changed mat.iteritems() to mat.items() and then it works. (as Python 3 renamed iteritems to items)

thanks for your explanation, it is working now but this code return only single row of data what should i do to get entire data in format of dataframe , thanks in advanc.

import scipy.io
import pandas as pd

mat = scipy.io.loadmat('file.mat')
mat = {k:v for k, v in mat.items() if k[0] != '_'}
data = pd.DataFrame({k: pd.Series(v[0]) for k, v in mat.items()})
data.to_csv("example.csv")

This should work. use items() instead of iteritems()

Executing the above code causes the following error:
Traceback (most recent call last): File "mat2csv.py", line 6, in <module> data = pd.DataFrame({k: pd.Series(v[0]) for k, v in mat.iteritems()}) AttributeError: 'dict' object has no attribute 'iteritems'
Changed mat.iteritems() to mat.items() and then it works. (as Python 3 renamed iteritems to items)

That's what I said.