Based on Column 3 values how to get specific column 1 values?
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
raghavendra kandukuri
am 23 Okt. 2018
Kommentiert: jonas
am 24 Okt. 2018
I have 3 columns of data coming from excel, Please find attached txt file, for instance in the attached txt file when column C is '0', i would like to get the value of column A at that point and the two more values above it i.e 2301,2300,2244 in the attached file.
0 Kommentare
Akzeptierte Antwort
jonas
am 23 Okt. 2018
Bearbeitet: jonas
am 24 Okt. 2018
fid = fopen('sample.txt')
out = textscan(fid,'%f%f%f','headerlines',1);
fclose(fid)
A = cell2mat(out);
id0 = find(A(:,3) == 0);
idc = [id0,id0-1,id0-2];
idc = unique(idc)
idc(idc<1) = [];
A(idc, 1)
ans =
2244 2300 2301
works for multiple zeros as well
6 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!