getting a matrix from Excel data

156 ビュー (過去 30 日間)
Radoslav Vandzura
Radoslav Vandzura 2015 年 12 月 4 日
コメント済み: jgg 2015 年 12 月 9 日
Hello All. Could you advise me, how can i get a matrix from excel sheet to Matlab? Part of my excel sheet is attached here. Thank you for help...

回答 (1 件)

jgg
jgg 2015 年 12 月 4 日
There are a couple of ways.
  • The simplest way, if you're new to Matlab, is use the the file import tool. It's under the File menu > Import Data.
  • You can also call the import scripts from the command line. For instance https://www.mathworks.com/help/matlab/ref/xlsread.html is probably the command you're looking for. In your example, [numbers,text,all] = xlsread(filename,1,'A1:I3') would read in your information as three matrices, one holding the numbers, the other holding the non-numeric parts (and one of the original data).
  • The importdata command might also be useful: the documentation is here: http://www.mathworks.com/help/matlab/ref/importdata.html
I think in general, if you have mixed data that's both numeric and non-numeric, it's a good idea to try and use the tool first. Some of the other tools may not give you output in the format you expect, or can throw an error if they encounter unexpected data. It will also allow you to handle errors or missing data more naturally.
  2 件のコメント
jgg
jgg 2015 年 12 月 9 日
I think I am confused about what you are trying to do. The methods will put your data in a matrix. Some of them will be numeric, some will be string. These are both acceptable grouping variables (see http://www.mathworks.com/help/stats/grouping-variables.html).
If you need to convert the string variables to numerical categories, you can use the grp2idx command (<http://www.mathworks.com/help/stats/grp2idx.html>) then you can create dummy variables with dummyvar.
If this isn't what you're trying to do, you'll need to explain more clearly or give an example of what you'd like your data to look like.

サインインしてコメントする。

タグ

Community Treasure Hunt

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

Start Hunting!

Translated by