How can you compare 2 values on excel and adding an excel formula in matlab?
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Hi guys, I'm going to compare values on excel but I'm trying to do it on MATLAB as there are so many values that needed to be compared. The values goes like this picture below:
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/164096/image.jpeg)
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/164098/image.jpeg)
i wanted to compare VarName1 (Awobetul.csv) with VarName7 (Awomanual.csv) I'm trying to use my own code but it doesn't work... it says:
if true
Q = importdata('Awobetul.csv');
W = importdata('Awomanual.csv');
counter = 0;
expandRange = 5;
saveHistory = 5;
lastHistory = zeros(5,4);
counterHistory = 0;
%saveResult = ['C:\Users\Kenny\Desktop\skripsi\pakebandingyangini\tikus\kencing.csv']; %char(folder1(1, listData)) hilang
%fid = fopen(saveResult, 'a');
%for n = 1:frameNum
for n = 1:size(Q.data, 1)
for m = 1:size(W.data, 7)
if Q.data(n, 1) == W.data(m, 7)
fprintf(fid, '%d, %f, %f, %f, %f, %d, %f, %f, %f, %f ', Q.data(n, 1), Q.data(n, 2), Q.data(n, 3), Q.data(n, 4), Q.data(n, 5), W.data(m, 1), W.data(m, 2), W.data(m, 3), W.data(m, 4), W.data(m, 5));
end
end
end
end
Attempt to reference field of non-structure array.
Error in bijikuda (line 15)
for m = 1:size(W.data, 7)
Here's my algorithm (what i wanted the program to show):
if VarName1(Awobetul.csv) is equal to VarName7 (Awomanual.csv)
then show VarName2 3 4 5(Awomanual.csv) and show Varname2 3 4 5(Awobetul.csv) next to it.
The values of the code will be written on a new .csv file
Thanks guys.
1 Kommentar
Weird Rando
am 12 Mai 2016
Bearbeitet: Weird Rando
am 12 Mai 2016
for m = 1:size(W.data, 7)
An array that is 7 dimension??? double check the dimension.
I think you wanted number of rows in the 7 column
for m = 1:length(W.data(:,7))
Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets 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!