time align two files
조회 수: 3(최근 30일)
I have two CSV files that are not equal sizes. for one of the files,I want to obtain all values for when column two is only equal to one. I already did this, the code for this is:
P = N(N(:,2)==1,:);
Now that I have all the data associated with column 2 when it equals to 1, I want this file to line up with another file. So where ever the second column is = to 1, i want the second file to only show values that are at the same position.
my code for this is:
Val = find(isnan(P));
P(Val) = ;
M(Val) = ;
So there arent any nan values in the data set but this does what I want it to do. P is the values associated with column 2 when it = to 1 and M is the second file.
Guillaume 2020년 3월 11일
In your example, what you're asking is simply:
M(P(:, 2) ~= 1, :) =  %remove all rows of M for which the corresponding row of P is not 1.
How this translates to your real use case, I'm not too sure, particularly as you say that M and P haven't got the same number of rows.