Help with csv data preparation
显示 更早的评论
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 个评论
Azzi Abdelmalek
2013-11-11
To format your code, just skip 2 blank spaces on the left, don't skip lines
FRANCISCO
2013-11-11
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
采纳的回答
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
2013-11-12
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 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Text Data Preparation 的更多信息
产品
Translated by 
