I am using matlab to prepare my dataset and I am facing an issue with linking the data between two of my tables.
So, I have two tables, "TC" and "TBC", which have different sizes and contain sequential recordings of certain values in certain timestamps. I want to create a third table "C" in which I will add rows of both "TC" and "TBC" given that they are meeting two conditions.
The two tables may not have the same amount of rows (TC has more measurements recorded) but they both have two columns:
1st column: time of the recording (hh:mm:ss converted in seconds) and
2nd column: recorded value in that timestamp
A row of TC and TBC is going to be added in table C when all the following conditions stand:
a. The time difference between TC and TBC is more than 9 sec but less than 14 sec
b. The recorded value of TC is the between the 30% - 60% of the recorded value of TBC.
When none of the conditions are met it means that the TBC table has two values (the current one and the next one) corresponding to one of value (the current one) of TC and they all need to get erased (all three of them, i,i+1 of TBC and i of TC).
Do that until you reach the last row of one of the tables.
I include all the necessary files. The mat files containing the 2 tables and the matlab code. The code is the incomplete join of the 2 tables which needs to be done.
Thank you in advance for your time. For more details and any questions contact me.
Décerné à :
I had done MS in Engineering. Also I had 8+ years of experience in the field of implementations using Matlab. I can easily do this task for you.
4 freelance ont fait une offre moyenne de 26 $ pour ce travail
I have read and fully understand your requirements .. Please open chat to discuss further.... +++++++++===================+++++++++++++========================+++++++++
I have considerable expertise (6 years) with MATLAB due to my background in engineering. I can do this in hours so time will not be an issue. Looking forward to hearing from you