CSV files sweep [Script]

Question

Antonio Jayena 2015-3-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/184913-csv-files-sweep-script

回答： Guillaume 2015-3-24

Hi everyone.

I have a script thats loads one CSV per time.

i=0;
cont=0;
s = csvread('scope_1_1.csv', 2, 0);
[fil,col]=size(s);
for i=1:fil
if ((s(i,2))< 0.5)&&(s(i+1,2)-(s(i,2))>2)
cont=cont+1; 
if (cont==25)
display(s(i, 1));
break
end
end
end

I have a lot of CSV files, with this estructure scope_1_1.csv , scope_2_1.csv ..... Its posible to optimize this code to execute this script for all the CSV with only one iteration?

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

请先登录，再进行评论。

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

Answer 1

Guillaume 2015-3-24

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/184913-csv-files-sweep-script#answer_172556

在 MATLAB Online 中打开

Your code will fail if i happens to reach fil, since s(i+1, 2) is then not valid.

You will need a loop to go over the different csv files, but you certainly don't need a loop for finding your row:

s = csvread('scope_1_1.csv', 2, 0);
thresholdindices = find(s(1:end-1, 2) < 0.5 & diff(s(:, 2)) > 2, 25);
if numel(thresholdindices) < 25
   error('there was less than 25 values that matched the threshold');
end
thresholdvalue = s(thresholdindices(end), 1);