In [1]:
import numpy as np
import scipy.io
import pandas as pd
import os
# Lade matlab struct
matPath = r"D:\C\Uni\Master\KSS\MV_Analyse\MatLab\Messmatrix_Beispiel_small.mat"
mat = scipy.io.loadmat(matPath)
savePath = os.path.join(os.getcwd(),os.path.basename(matPath)[:-4]+".csv")
In [2]:
# erhalte Zeilenbezeichnungen
columnsExt = mat["columnnames"].T
columns = []
for i in np.arange(len(columnsExt)):
columns.append(columnsExt[i][0][0])
In [3]:
# Lade Kennwerte und schreibe inkl Zeilenbezeichnungen in dataframe
data = mat["X"]
df = pd.DataFrame(data)
df.columns = columns
In [4]:
df.head()
Out[4]:
In [5]:
df.to_csv(savePath, index=False)
In [ ]: