splitting data to two csv sheet
3 次查看(过去 30 天)
显示 更早的评论
Hi all, I have one csv file and I am planning to split it into two separate sheet based on a criteria. Th first column of my CSV has "name of the file" and all other columns have numbers. For each row, I want to check the last column and if it is more than 2300, separate the row and put it in one sheet of CSV, else put it in another sheet of CSV. I came up with this code
jj=1
cc=1
for j=1 : 463
if result(j,35)<2380
LF(jj,:)=result(j,:);
Lname{jj,1}=result1{j,1};
jj=jj+1;
else
HF(cc,:)=result(j,:);
Hname{cc,1}=result1{j,1};
cc=cc+1
end
end
sheet1=1;
sheet2=2;
xlswrite('seperated',Lname,sheet1,'A1')
xlswrite('seperated',LF,sheet1,'B1')
xlswrite('seperated',Hname,sheet2,'A1')
xlswrite('seperated',HF,sheet2,'B1')
It works, however, I am not sure when I want to write it in csv file, why I cannot not write the Lname which is a cell and include the related name can you please advise what I need to do to write it?
10 个评论
Guillaume
2018-6-11
t = readtable('result.csv');
c = table2cell(t);
r = cell2mat(c(:,36))>2300;
That's a lot of unnecessary conversions here
t = readtable('result.csv');
r = t{:, 36} > 2300;
would achieve the same faster. There is no point in converting the table to anything else. You can just split the table itself.
采纳的回答
Guillaume
2018-6-11
t = readtable('result - Copy.csv');
flag = t{:, 36} > 2300;
writetable(t(flag, :), 'datagreater.xls', 'WriteVariableNames', false);
writetable(t(~flag, :), 'datalower.xls', 'WriteVariableNames', false);
Should be all that is needed.
0 个评论
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!