comparing between two cell arrays
古いコメントを表示
we have two cell arrays that we would like to compare. the first of size 3x67 call it A and the second is of size 3x2 call it B. each row of the two cell arrays represent the data for the same day so we would like to compare the cells in the first row of A by the cell in the first row of B and so on. we are looking after the columnS "fof2" and "hmf2" from the cell in B, we will check the timimg in hours and minutes from the Date columns between this cell and the cells in A, and add to each cell in A the corresponding data for the columns "fof2" and "hmf2", it is not neccesary that we find exactly matching timings it is enough for them to be with in +-15mins range from each other. I am having an issue with the comparison between cell arrays, so if anyoe can help me in finding an effecient and easy way to do this, I attach the two cell array that I am working with.
Thanks in advance.
採用された回答
I am not certain what result you want.
Try this, and if it works, loop through the elements of ‘A’ and ‘B’ for all the necessary combinations. Note that in at least one for the ‘B’ table, ‘hmF2’ is actually 'hmF2 ' with an extra space that creates problems with the variable name referencing. If all the resulting timetables have the same variables in the same locations, numerical referencing will work.
LD = load(websave('A&B','https://www.mathworks.com/matlabcentral/answers/uploaded_files/1227457/A&B.mat'))
A = LD.A
B = LD.B
A12 = A{1,2}
A12 = A12(:,[8 1:7 9])
B12 = B{1,2}
TTA12 = table2timetable(A12)
TTB12 = table2timetable(B12)
TTAB12 = synchronize(TTA12,TTB12)
VN = TTAB12.Properties.VariableNames
VN{15}
TTAB12_Result = TTAB12(:,[10 15])
.
4 件のコメント
Salma fathi
2022 年 12 月 13 日
編集済み: Salma fathi
2022 年 12 月 13 日
Thank you very much for your reply. Yes this is exactly what I wanted, I did not now such function existed, it is realy so helpful. Another thing though,
in the above image (this is diffrent data from the one attached but serve the same goal), row 12 is from table A, and since there is no matching for it in B it will just have NaN values. so if insted we can customize the method to let row 12 have the values that we have in row 13 where it is the closest timing for it would be much better. Is there any method we can use to acheive this?
Thanks again.
My pleasure!
LD = load(websave('A&B','https://www.mathworks.com/matlabcentral/answers/uploaded_files/1227457/A&B.mat'))
A = LD.A
B = LD.B
A12 = A{1,2};
A12 = A12(:,[8 1:7 9]);
B12 = B{1,2};
TTA12 = table2timetable(A12);
TTB12 = table2timetable(B12);
TTAB12 = synchronize(TTA12,TTB12);
VN = TTAB12.Properties.VariableNames;
VN{15};
TTAB12_Result = TTAB12(:,[10 15])
TTAB12_Result = fillmissing(TTAB12_Result, 'nearest')
Here, I chose to fill with the 'nearest' value. Similar options are 'previous' and 'next'. (See the documentation I linked to for details.) Choose the method that works best in your application.
The code is unchanged from the previous version, with the addition of this assignment:
TTAB12_Result = fillmissing(TTAB12_Result, 'nearest')
Another option of course is:
TTAB12_Result = fillmissing(TTAB12(:,[10 15]), 'nearest')
It depends on whether you want to see the original result before calling fillmissing.
I am not certain what you want to do, so I stopped here. If this does what you want, it would be straightforward to create nested loops to synchronize each ‘A’ cell with each ‘B’ cell using this code, and save the resulting timetable to a new cell.
.
Salma fathi
2022 年 12 月 15 日
Star Strider
2022 年 12 月 15 日
As always, my pleasure!
その他の回答 (0 件)
カテゴリ
ヘルプ センター および File Exchange で Logical についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
