How can read .csv file in matlab
조회 수: 6 (최근 30일)
이전 댓글 표시
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.
댓글 수: 1
Renato Agurto
2015년 9월 21일
Hi. Can you open your csv file with a text editor and see which separator is used for the values: ' ,' or ' ;' ?
답변 (2개)
Yogesh Badhe
2015년 9월 21일
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.
Walter Roberson
2015년 9월 21일
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
댓글 수: 3
참고 항목
카테고리
Help Center 및 File Exchange에서 Text Files에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!