How I can read a CSV file with header?

9 views (last 30 days)
Hildo
Hildo on 18 Jun 2015
Answered: Hildo on 25 Nov 2016
How I can read one CSV file with header, semicolon to separate the column and coma to float point? One example is annex. I try use the importdata, csvread and dlmread.

Accepted Answer

Hildo
Hildo on 25 Nov 2016
The better way was use the textscan function with ";" delimiter and after replace the "," by "." before the conversion of string to number.
fileID = fopen(filename,'r');
startRow = 10;
dataArray = textscan(fileID,'%s%s%s',inf,'Delimiter',';',...
'HeaderLines', startRow-1,'ReturnOnError', false);
fclose(fileID);
dataArray{1,2} = strrep(dataArray{1,2},',','.');
dataArray{1,3} = strrep(dataArray{1,3},',','.');

More Answers (1)

Azzi Abdelmalek
Azzi Abdelmalek on 20 Jun 2015
[a,b,c]=xlsread('PV-20150616.csv')
out=b(8:end,:)

Categories

Find more on Large Files and Big Data in Help Center and File Exchange

Products

Community Treasure Hunt

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

Start Hunting!