Import data tables in Python

Question

I am new to Python, coming from MATLAB. In MATLAB, I used to create a variable table (copy from excel to MATLAB) in MATLAB and save it as a .mat file and whenever I needed the data from the MATLAB, I used to import it using:

A = importdata('Filename.mat');

[Filename is 38x5 table, see the attached photo]

Is there a way I can do this in Python? I have to work with about 35 such tables and loading everytime from excel is not the best way.

Possible duplicate of [Read .mat files in Python](https://stackoverflow.com/questions/874461/read-mat-files-in-python) — Framester, Oct 01 '18 at 11:45

petezurich · Answer 1 · 2018-10-01T12:54:11.257

0

Use pandas:

import pandas as pd
dataframe = pd.read_csv("your_data.csv")
dataframe.head() # prints out first rows of your data

Or from Excel:

dataframe = pd.read_excel('your_excel_sheet.xlsx')

edited Oct 01 '18 at 12:54

answered Oct 01 '18 at 11:43

petezurich

9,280
9
43
57

As far as I am concerned the excel import is called with pd.Excelfile('your_excel_sheet.xlsx') ... https://www.datacamp.com/community/tutorials/python-excel-tutorial – Pablo Jeken Rico Oct 01 '18 at 11:54
Is there not an easy way like in MATLAB where I can just copy tables from excel to python and save it as a .py file – Pradeep Oct 01 '18 at 12:07

score 0 · Answer 2 · edited Oct 01 '18 at 12:53

0

In order to import excel tables into your python environment you have to install pandas. Check out the detailed guideline.

import pandas as pd
xl = pd.ExcelFile('myFile.xlsx')

I hope this helps.

edited Oct 01 '18 at 12:53

petezurich

9,280
9
43
57

answered Oct 01 '18 at 12:06

Pablo Jeken Rico

569
5
22

I am 99% sure that there is no simpler way in Python, but pls correct me if I am wrong – Pablo Jeken Rico Oct 01 '18 at 13:02

Import data tables in Python

2 Answers2