How I can read a CSV file with header?

15 次查看（过去 30 天）
Hildo
Hildo 2015-6-18
回答： Hildo 2016-11-25
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.

请先登录，再回答此问题。

采纳的回答

Hildo
Hildo 2016-11-25
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},',','.');

更多回答（1 个）

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

类别

在 Help Center 和 File Exchange 中查找有关 Large Files and Big Data 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by