How to i refer to columns and rows from my imported data?

8 次查看(过去 30 天)
I imported data from Exel into matlab. I didn't import the headings of each row however I noticed it automatically named the columns by their header in the workspace section. I have a 25 by 400 data set with a range of numerical and categorical information. The file is save as mortgagedata.xls. How do I refer to this in my script?
I tried: x=mortgagedata(:,[1:25]);
but it is saying it is says: Undefined function or variable 'mortgagedata'.
How do I get it to refer to them?
  1 个评论
Joshua
Joshua 2017-3-27
Generally when you import data into Matlab the data will show up in the workspace on the side of the Matlab window. See what it named the vectors or matrices that it imported and use those names. Alternatively, try something like this and refer to matrix A:
A=importdata('mortgagedata.xlsx');

请先登录,再进行评论。

回答(1 个)

KSSV
KSSV 2017-3-27
Use xlsread.
[num,txt,raw] = xlsread(' mortgagedata.xls') ;
All the text data, number data will be read. Read the documentation xlsread.

类别

Help CenterFile Exchange 中查找有关 Workspace Variables and MAT Files 的更多信息

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by