Help with csv data preparation

Question

FRANCISCO 2013-11-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/105730-help-with-csv-data-preparation

评论： Simon 2013-11-12

I applied the code:

if true
    % code

load file

fid = fopen('data.csv', 'r');

FC = textscan(fid, '%s', 'Delimiter', '\n');

fclose(fid);

FC = FC{1};

% extract data

for n = 1:length(FC)

Data{n, 1:3} = sscanf(FC{n}, '%s %d %f');

end

Still I have problems extracting values. Applying that CODES up before the "for" loop, matlab gives me cell:

'0000, 0,0 '

'0001, 1,0.2 '

'0010, 0,0 '

'0011, 0,0 '

'0100, 1,0.2 '

'0101, 0,0 '

'0110, 0,0 '

'0111, 0,0 '

'1000, 1,0.2 '

'1001, 0,0 '

'1010, 1,0.2 '

'1011, 0,0 ' and what I want is that I transform this into different columns as follows:

| 0 | 0 | 0 | 0 | 0 | 0 |

| 0 | 0 | 0 | 1 | 1 | 0.2 |

How could I do this?

4 个评论
显示 2更早的评论隐藏 2更早的评论

Walter Roberson 2013-11-11

Please show us a sample input line as known to excel, and tell us what datatype excel thinks the first column is.

FRANCISCO 2013-11-12

data.csv

My csv file is as follows, but also what I can generate without brackets [] of binary patterns:

Applying the above code, the imported data puts me in the first column in text format

I want every number in a column represent, for example:

[0000], 1,0.200

I represent:

| 0 | 0 | 0 | 0 | 1 | 0.20 |

Many thanks

请先登录，再进行评论。

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

Answer 1

Simon 2013-11-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/105730-help-with-csv-data-preparation#answer_114943

在 MATLAB Online 中打开

Hi!

In your cell array the second and third entry of every line are numeric values already. You may split the string in the first cell of every line like

[a, b, c, d] = strread(Data{1, 1}, '%1d%1d%1d%1d');

2 个评论
显示无隐藏无

FRANCISCO 2013-11-12

I run the code and it gives me error. I'm somewhat confused

Simon 2013-11-12

在 MATLAB Online 中打开

Hi!

What code did you run? What is your input (in my case Data{1, 1})? What is the error message?

It seems you have an error converting to your Data cell array. Try

fid = fopen('data.csv', 'r');
FC = textscan(fid, '%s', 'Delimiter', '\n');
fclose(fid);
FC = FC{1};
% remove ',', replace with ' '
FC = regexprep(FC, ',', ' ');
% extract data
for n = 1:length(FC)
Data{n, 1} = sscanf(FC{n}, '%s', 1);
Data{n, 2} = sscanf(FC{n}, '%*s %d');
Data{n, 3} = sscanf(FC{n}, '%*s %*d %f');
end