I need to write a code to import multiple csv files, changing delimiter and decimal standard...

37 次查看（过去 30 天）

Paulo Henrique Março 2021-10-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1573333-i-need-to-write-a-code-to-import-multiple-csv-files-changing-delimiter-and-decimal-standard

评论： Paulo Henrique Março 2021-10-28

Hi guys,

I need to import multiple .csv files. Nonetheless, all my tries are going wrong: the file delimiter (even though it is .CSV, the delimiter is the semicolon (;), and the decimal is the comma (,). Please, I need help. I was doing:

P = 'fullpath';

S = dir(fullfile(P,'*.csv'));

for k = 1:numel(S)

F = fullfile(P,S(k).name);

S(k).data = csvread(F);

end

But I have the message:

Error using dlmread (line 147)

Mismatch between file and format character vector.

Trouble reading 'Numeric' field from file (row number 1, field number 1) ==> (creator description)

Error in csvread (line 48)

m=dlmread(filename, ',', r, c);

Can someone help me, please? Many thanks in advance!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

Stephen23 2021-10-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1573333-i-need-to-write-a-code-to-import-multiple-csv-files-changing-delimiter-and-decimal-standard#answer_818318

Use READMATRIX and set the Delimiter and DecimalSeparator to values that suit your file.

5 个评论
显示 3更早的评论隐藏 3更早的评论

Stephen23 2021-10-28

在 MATLAB Online 中打开

Replace

readmatrix(F)

with

readmatrix(F, 'Delimiter',';', 'DecimalSeparator',',')

If you have any more difficulties, please upload your CSV file by clicking on the paperclip button.

Paulo Henrique Março 2021-10-28

Hi Stephen

Fantastic!

Now the problem is completely solved.

You saved my week!

Thank you a lot!

请先登录，再进行评论。

类别

MATLAB Programming

在 Help Center 和 File Exchange 中查找有关 Programming 的更多信息

产品

MATLAB

版本

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by