Considering data from two files with conditions
显示 更早的评论
Hello,
I have two files with different sizes, in each file 4 columns are there
fisrt column is time
second column is tec in one file and roti in another file
third column is day of the year (1 to 365 days)
forth column is PRN number varies from 1 to 32
so in both the files only second column is the data that i want in a order. now i want data like for each prn (column4), in a day, if time is same in both file then take tec and roti, if not same then no need.
this is how i need the data
prn time doy tec roti
1 1 1 24 3.4
1 2 1 19 2.9
please help me..
thank you
7 个评论
Walter Roberson
2022-4-30
Use a timetable() object and use synchronize()
LISSA DUVVU
2022-4-30
Walter Roberson
2022-4-30
synchronize() became available in R2016b.
LISSA DUVVU
2022-4-30
dpb
2022-4-30
@Walter Roberson said "Use a timetable() object..." and the documenation illustrates that synchronize() operates on two timetables, not individual arrays.
Walter Roberson
2022-4-30
D = days(doy) + hours(time)
TT = timetable(prn, tec, roti, 'rowtimes', D)
it might have to be hours(time-1)
LISSA DUVVU
2022-5-2
回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Workspace Variables and MAT Files 的更多信息
2022-4-30
2022-5-2
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
