time align two files
显示 更早的评论
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.
2 个评论
Guillaume
2020-3-11
"there arent any nan values in the data set but this does what I want it to do"
If there aren't any nan values then your code does nothing at all.
I'm not entirely sure what you mean by "line up". Can you clarify with an example?
However, just going by the title of your question if you want to match the times of two different files, then importing them as timetables and then synchronize the two. Possibly, this is done with just 3 lines of code.
采纳的回答
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.
11 个评论
isamh
2020-3-11
Guillaume
2020-3-11
You're going to have to give us a lot more than it didn't work
Using your example:
>> P = [3434, 1; 2342, 1; 2341, 1; 1232, 0; 3433, 0; 3534, 1; 3433, 0; 5464, 1];
>> M = [343, 5; 344, 7; 233, 9; 435, 1; 347, 5; 345, 7; 452, 9; 765, 2];
>> M(P(:, 2) ~= 1, :) = []
M =
343 5
344 7
233 9
345 7
765 2
Exactly the result you asked for.
It's hard to guess what you really want from the limited explanations you give.
isamh
2020-3-13
Guillaume
2020-3-13
I'm not entirely sure what you're stuck on. Import the csv files with one of the many import functions, readmatrix, readtable, dlmread, csvread, importdata, etc., then apply the code as appropriate. If that's not enough for you, then please attach an example of the text files.
A longer explanation of what you want to do and what the input files represent would also help.
isamh
2020-3-13
Guillaume
2020-3-13
Can you attach some example files?
Guillaume
2020-3-13
Comment by Ahmed Issa moved here:
at the moment no, dont have the files. but the code i created is:
Time_A = M(M(:,1) >= 30.1 & M(:,1) < = 1402);
When I do this, I only get this column. how can i do this and get all 4 columns?
is there a way to do this automatically without doing the time conversion?
isamh
2020-3-13
isamh
2020-3-18
Guillaume
2020-3-18
What do you mean by 'rows that are extra'?
Again, having a concrete example of what you actually want would help.
isamh
2020-3-18
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Data Import and Analysis 的更多信息
Translated by 
