Matlab: read csv into array

Question

im new to matlab and coding. I have a csv file with data that goes like:

3 2 91 83 17

3 2 86 84 4

3 2 90 83 162

(there's a total of 7000 rows)

I need a way to read this into an array, can the array be something like A[I,J,K,L,M] with age=I for example? How would i go about doing this?

Say I created an array like [age, Doa, los, gender, dest]. Would there be a way to get data in the first coloum in age, data in the second coloum into DOA etc? — adam mcbrinn
– adam mcbrinn, Commented Oct 11, 2014 at 20:10

Kostya · Accepted Answer · 2014-10-12 10:37:47Z

1

M = csvread(filename);
age = M(:,1); Doa = M(:,2); los = M(:,3); gender = M(:,4); dest = M(:,5);

edited Oct 12, 2014 at 10:37

answered Oct 11, 2014 at 20:58

Kostya

1,5721 gold badge10 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

adam mcbrinn Over a year ago

Thank you for your answer it helped a lot. Im running into an error now though, i have my code as: M = csvread('peterdatnew.csv', 1,0); M(:,1) = dest; M(:,2) = gen; M(:,3) = age; M(:,4) = year; M(:,5) = dur; and i get the error: Undefined function or variable 'dest'. i tried dest = 0; gen = 0; but that literally set the value to 0. How should i go about resolving this?

Kostya Over a year ago

Sorry, was typing it too quickly, just swap lhs and rhs (see corrected answer)

Kostya Over a year ago

Great, you're welcome :). Would you mind accepting an answer to mark it closed, see here meta.stackexchange.com/questions/5234/…

Raj · Accepted Answer · 2015-12-09 22:22:25Z

0

dlmread(), csvread(), and xlsread() all work well.

Note that the first two (dlmread and csvread) are for numeric data only, and xlsread is limited by what excel can process (which in my experience is capped at somewhere around 1 million rows). xlsread can get you text and raw as well.

answered Dec 9, 2015 at 22:22

Raj

1381 silver badge11 bronze badges

Collectives™ on Stack Overflow

Matlab: read csv into array

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related