Help with csv data preparation

2 次查看（过去 30 天）
FRANCISCO
FRANCISCO 2013-11-11
评论： 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
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更早的评论
Walter Roberson
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
FRANCISCO 2013-11-12
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

请先登录，再进行评论。

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

采纳的回答

Simon
Simon 2013-11-12
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
FRANCISCO 2013-11-12
I run the code and it gives me error. I'm somewhat confused
Simon
Simon 2013-11-12
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
Of course you will get an error if you have '[]' around your first entry in every row. You should have written that before! Remove them first.

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by