MATLAB: How to manupulate each element of a colum from .csv file

arraycsv

I have a comma saperate .csv text file. I want to use each element of a single column one by one as input to my function. What I should do to achive that. I know c/c++ but Matlab is bit new to me. Please help

Best Answer

Try this

myData = csvread(fullFileName);
% Get one element into a new variable
element38 = myData(3, 8);
% Get the whole column 4
col4 = myData(:, 4);
% Assign element at row 5, column 2 to a new value of pi.
myData(5, 2) = pi;
% Pass each element of column 6 to a function myfun():
for k = 1 : size(myData, 1)
  thisElement = myData(k, 6);
  someResult(k) = myfun(thisElement);
end

Related Solutions

MATLAB: Import columns from a CSV by header name

The csvread function is capable of doing what you want to do.

MATLAB: Extract structure array value

You can hide the loop with arrayfun, but be aware that a good loop is always better than cellfun or arrayfun. You should ask yourself why you want to avoid loops.

MyData(1).User.Id = 5;
MyData(1).User.Name = 'XXX';
MyData(2).User.Id = 7;
MyData(2).User.Name = 'XXX';
MyData(3).User.Id = 8;
MyData(3).User.Name = 'XXX';
MyData(4).User.Id = 9;
MyData(4).User.Name = 'XXX';
MyData(5).User.Id = 75;
MyData(5).User.Name = 'XXX';
MyData(6).User.Id= 45;%correcting assumed typo

MyData(6).User.Name= 'XXX';%correcting assumed typo
arrayfun(@(s) s.User.Id,MyData)

It is also possible to avoid arrayfun:

tmp=[MyData.User];[tmp.Id]
%R2020a and later:
[horzcat(MyData.User).Id]

Best Answer

Related Solutions

MATLAB: Import columns from a CSV by header name

MATLAB: Extract structure array value

Related Question