How can read .csv file in matlab

Hi,

I have a .csv file which contains both string and numbers , the first raw contains columns name which is string and the rest of raw's contains integer value . my file look like

Id  age sex subject
12  21   1    3

I want to read it and store it as a cell array for counting the frequent itemsets . how can I do that . please help me.

Thank you.

[Renato Agurto]

Hi. Can you open your csv file with a text editor and see which separator is used for the values: ' ,' or ' ;' ?

Answer 1

[Yogesh Badhe]

If you have MATLAB R2014a or later version you have "Import data" tab on main window under Home tab. Just click on that, browse to your desired file and click import. Thats it.

[mulus]

Hello JPro,

I am using MATLAB 7.8.0 R2009a. I have frequent.m file , It contains a function function [frequentItemsets]= frequent(Transaction,Support) I want to read .csv file which contains transactions and store it as a cell array to count the occurrence frequency of each item.

thanks .

Answer 2

[Walter Roberson]

If you are using a new enough version of MATLAB (might require R2015b), then csvread() should work if you pass it parameters that tell it to skip the first line

Otherwise,

fid = fopen('YourFile.csv','rt');
datacell = textscan(fid, '%d%d%d%d', 'HeaderLines',1,'Delimiter',',','CollectData', 1);
fclose(fid);

now datacell{1} is your numeric matrix

[mulus]

It throws an error 'Invalid file identifier. Use fopen to generate a valid file identifier.'

Thanks

[Walter Roberson]

Replace YourFile.csv with the actual name of your file.

[Sajid Afaque]

what if i have variable numer of columns and rows