Add two different table in one common table based on conditions (Matlab).
$10-30 USD
Completed
Posted over 8 years ago
$10-30 USD
Paid on delivery
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.
I have read and fully understand your requirements ..
Please open chat to discuss further....
+++++++++===================+++++++++++++========================+++++++++
Hello There,
The project you propose can be handled very nice and easily by me. I will give a look at the tables and I will adjust the code according to your request. When done, I will get back to you to see if the code looks fine for you and we can discuss about it.
I hope to hear from you.
Regards,
T.
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