You are now following this question
- You will see updates in your followed content feed.
- You may receive emails, depending on your communication preferences.
How to fill missing time points from a txt file
43 views (last 30 days)
Show older comments
I have txt files that I am trying to read in and towards the end of the file it starts skipping time values and data points. I am trying to compare this txt file to another excel data set. I would like to create the missing time variables on the txt file and just fill them with NaN variables that way I can better match up the time. Should I use the fillmissing function? Any suggestion would be appreciated.
The excel file is also time shifted by about 3 seconds late so that is another problem I will have to face.
4 Comments
Umar
on 29 Jul 2024 at 22:30
Edited: Walter Roberson
on 30 Jul 2024 at 7:08
Hi @Austin,
To accomplish your task, begin by reading the text file using the readtable function to read the text file into a table format for easier manipulation.
data = readtable('cal.txt');
Identify missing time gaps by analyzing the time values in your text file to identify the missing time points. You can check for gaps in the time series and determine where the missing values occur. Then, create a time range by generating a complete time range that covers the entire duration of your data. This range will include all time points from the start to the end of your dataset.
start_time = min(data.Time);
end_time = max(data.Time);
complete_time_range = (start_time:end_time)';
Afterwards, fill missing time points with Nan by comparing the complete time range with the existing time values in your text file. Identify the missing time points and fill them with NaN values to align the time series.
missing_times = setdiff(complete_time_range, data.Time);
missing_data = table(missing_times, nan(size(missing_times)),
'VariableNames', {'Time', 'Data'});
data = [data; missing_data];
Then,sort the data based on the time values to ensure that the dataset is in chronological order.
data = sortrows(data, 'Time');
Finally, export the updated data with filled NaN values to a new text file or any desired format for further analysis.
writetable(data, 'updated_cal_file.txt');
Hope, this answers your question.
Austin Bollinger
on 30 Jul 2024 at 16:11
Thank you for the help! I tried the following code to gather all the missing time points with a 100hz sampling rate. Do you know how I might remove the trailing zeros in the txt file import? With the trailing zeros there is time points that are really not missing, but the code thinks it is based on the decimal value.
data = readtable('cal.txt');
data.LeftSeconds=round(data.LeftSeconds,2);
format short
start_time = min(data.LeftSeconds);
end_time = max(data.LeftSeconds);
complete_time_range = (start_time:0.01:end_time)';
missing_times = setdiff(complete_time_range, data.LeftSeconds);
missing_data = table(missing_times, nan(size(missing_times)),'VariableNames', {'Time', 'Data'});
T1r = movevars(data, 'LeftSeconds', 'Before',1);
T1r.LeftSeconds = duration(seconds(T1r.LeftSeconds));
TT1r = table2timetable(T1r);
missing_data.Time = duration(seconds(missing_data.Time));
TT2 = table2timetable(missing_data);
TTs = synchronize(TT1r, TT2);
Umar
on 30 Jul 2024 at 17:34
@Austin,
I hope the solution you were seeking has been answered by @Star Strider. If it still doesn’t meet your requirements, please ask us for clarification, we will be more happy to help you out.
Umar
on 30 Jul 2024 at 20:17
@Austin, please also vote for @Star Strider, as a doctor not only he saves human lives but also rescue people from making mistakes in their code. He is humble and knowledgeable just like rest of us. If by any chance if you run into any issues, please don’t hesitate to reach out to us for help.
Accepted Answer
Star Strider
on 29 Jul 2024 at 22:22
The tables may need to be manipulated a bit first. I put relevant times in the first column in ‘T1r’.
After that, converting them to timetable arrays and using synchronize works to create a single timetable with a single time (actually duration) variable. Yopu can convert it back to a table with the timetable2table function if you want to.
The synchronize function has options for filling missing values. I will let you explore those so that the result is what you want. For he time being, I just want to get it to work, and it does.
Try this —
T1 = readtable('cal.txt');
CheckSeconds = nnz((T1.LeftSeconds - T1.RightSeconds) ~= 0)
CheckSeconds = 0
T1r = movevars(T1, 'LeftSeconds', 'Before',1);
T1r.LeftSeconds = duration(seconds(T1r.LeftSeconds));
TT1r = table2timetable(T1r)
TT1r = 1554x70 timetable
LeftSeconds LeftFrameNumber LeftFrameNumberRaw LeftPupilX LeftPupilY LeftPupilWidth LeftPupilHeight LeftPupilAngle LeftIrisRadius LeftTorsion LeftUpperEyelid LeftLowerEyelid LeftDataQuality LeftCR1X LeftCR1Y LeftCR2X LeftCR2Y LeftCR3X LeftCR3Y LeftCR4X LeftCR4Y LeftCR5X LeftCR5Y RightFrameNumber RightFrameNumberRaw RightSeconds RightPupilX RightPupilY RightPupilWidth RightPupilHeight RightPupilAngle RightIrisRadius RightTorsion RightUpperEyelid RightLowerEyelid RightDataQuality RightCR1X RightCR1Y RightCR2X RightCR2Y RightCR3X RightCR3Y RightCR4X RightCR4Y RightCR5X RightCR5Y AccelerometerX AccelerometerY AccelerometerZ GyroX GyroY GyroZ MagnetometerX MagnetometerY MagnetometerZ Int0 Int1 Int2 Int3 Int4 Int5 Int6 Int7 Double0 Double1 Double2 Double3 Double4 Double5 Double6 Double7
___________ _______________ __________________ __________ __________ ______________ _______________ ______________ ______________ ___________ _______________ _______________ _______________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________________ ___________________ ____________ ___________ ___________ _______________ ________________ _______________ _______________ ____________ ________________ ________________ ________________ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ ______________ ______________ ______________ _____ _____ _____ _____________ _____________ _____________ ____ ____ ____ ____ ____ ____ ____ ____ _______ _______ _______ _______ _______ _______ _______ _______
0 sec 0 0 204.99 125.92 58.03 63.265 -43.59 99 0 432.47 851.93 79.385 169.49 115.84 279.53 134.16 0 0 0 0 0 0 0 0 0 195.3 132.99 56.223 59.353 26.129 109 -0.54 438.26 929.43 80.692 230.23 119.23 111.89 139 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.01 sec 1 1 204.99 125.93 58.126 63.175 -44.066 99 0 432.47 851.93 79.4 169.62 115.89 279.53 134.16 0 0 0 0 0 0 1 1 0.01 195.31 132.98 56.253 59.343 25.995 109 -0.56 438.26 929.43 81.046 230.23 119.23 111.92 139.06 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.02 sec 2 2 204.88 126.66 58.109 60.877 -43.862 99 -0.02 359.88 851.93 78.9 169.74 115.95 279.57 134.16 0 0 0 0 0 0 2 2 0.02 195.3 132.99 56.244 59.324 26.137 109 -0.54 438.26 929.43 81.184 230.36 119.26 111.96 139.16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.03 sec 3 3 204.49 126.56 58.476 61.196 -28.859 99 0.2 359.88 851.93 78.724 169.84 115.93 279.57 134.16 0 0 0 0 0 0 3 3 0.03 195.37 133.27 56.032 59.478 25.764 109 -0.54 438.26 929.43 81.553 230.34 119.34 111.96 139.34 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.04 sec 4 4 204.84 126.72 57.961 61.223 -40.685 99 0 357.53 851.93 79.485 169.93 115.89 279.63 134.11 0 0 0 0 0 0 4 4 0.04 195.37 133.25 55.967 59.709 27.929 109 -0.54 438.26 929.43 80.961 230.4 119.28 112 139.38 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.05 sec 5 5 205.03 126.79 57.57 61.205 -45.715 99 -0.06 357.53 851.93 79.816 169.93 115.89 279.67 134.13 0 0 0 0 0 0 5 5 0.05 194.88 132.66 56.057 61.564 37.115 109 -0.3 483.72 929.43 81.153 230.5 119.3 112.02 139.44 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.06 sec 6 6 204.94 126.59 58.1 61.045 -49.247 99 0 357.53 851.93 81.061 169.93 115.89 279.71 134.05 0 0 0 0 0 0 6 6 0.06 194.89 132.95 55.606 61.387 35.093 109 -0.24 492.08 929.43 81.661 230.51 119.4 112.02 139.44 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.07 sec 7 7 204.93 126.65 58.067 60.97 -48.215 99 0.02 357.53 851.93 80.369 169.93 115.89 279.83 134.15 0 0 0 0 0 0 7 7 0.07 195.47 133.38 56.139 59.55 28.418 109 -0.62 438.26 929.43 81.292 230.5 119.5 112.02 139.44 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.08 sec 8 8 204.78 126.59 58.372 60.948 -43.23 99 0.08 357.53 851.93 79.915 169.93 115.89 279.88 134.18 0 0 0 0 0 0 8 8 0.08 195.47 133.56 56.409 59.273 26.188 109 -0.56 438.26 846.28 80.038 230.48 119.7 112.02 139.56 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.09 sec 9 9 204.97 126.71 57.965 60.848 -46.259 99 0.02 359.88 851.93 80.146 169.93 115.89 279.9 134.08 0 0 0 0 0 0 9 9 0.09 195.5 133.64 56.489 59.272 31.647 109 -0.6 438.26 846.28 80.469 230.48 119.7 111.96 139.66 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.1 sec 10 10 204.94 126.64 58.129 60.874 -49.992 99 0.02 357.53 851.93 80.4 169.93 115.89 279.87 134 0 0 0 0 0 0 10 10 0.1 195.11 133.36 55.983 60.658 35.123 109 -0.34 481.53 844.83 80.761 230.52 119.81 111.95 139.6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.11 sec 11 11 204.94 126.63 58.122 60.884 -50.106 99 0 357.53 851.93 80.115 169.96 115.84 279.9 134.08 0 0 0 0 0 0 11 11 0.11 195.06 133.38 55.744 60.756 34.948 109 -0.26 492.08 846.28 81.561 230.52 119.81 112.04 139.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.12 sec 12 12 204.97 126.6 58.162 60.767 -50.134 99 0 357.53 851.93 80.284 169.93 115.89 279.9 134.08 0 0 0 0 0 0 12 12 0.12 195.49 133.63 56.524 59.203 31.602 109 -0.52 438.26 846.28 79.9 230.47 119.8 112.04 139.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.13 sec 13 13 204.92 126.58 58.038 60.846 -47.157 99 0.02 357.53 851.93 80.354 169.93 115.89 279.95 134.07 0 0 0 0 0 0 13 13 0.13 195.05 133.37 55.768 60.718 35.293 109 -0.24 492.08 929.43 80.846 230.52 119.81 112 139.62 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.14 sec 14 14 204.91 126.58 57.948 60.935 -46.763 99 0.04 357.53 851.93 79.639 169.93 115.89 279.92 133.98 0 0 0 0 0 0 14 14 0.14 194.97 133.62 55.376 60.245 34.676 109 -0.12 492.08 939.25 79.377 230.41 119.86 112 139.54 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.15 sec 15 15 204.92 126.43 57.881 61.186 -45.472 99 0.26 389.69 851.93 80.269 169.93 115.89 279.87 134 0 0 0 0 0 0 15 15 0.15 195.09 133.91 55.33 59.614 30.645 109 -0.22 492.08 929.43 80.507 230.41 119.86 111.98 139.6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
T2 = readtable('04_16_24_cal.csv', 'VariableNamingRule','preserve');
T2.Time_Index = duration(seconds(T2.Time_Index));
TT2 = table2timetable(T2)
TT2 = 1654x23 timetable
Time_Index Left_Eye_H (°) Right_Eye_H (°) Left_Eye_V (°) Chair_Velocity (°/s) Laser_X (°) Laser_Y (°) OKN_Velocity (°/s) Laser/Ref Left_Eye_T (°) Left_Eye_A Right_Eye_V (°) Right_Eye_T (°) Right_Eye_A Video_Frame_Number VOG_Timestamp Event Code Laser_Z Gyro_X (°/s) 0 Gyro_Y (°/s) 0 Gyro_Z (°/s) 0 Accel_X (g) 0 Accel_Y (g) 0 Accel_Z (g) 0
__________ ______________ _______________ ______________ ____________________ ___________ ___________ __________________ _________ ______________ __________ _______________ _______________ ___________ __________________ _____________ __________ _______ ______________ ______________ ______________ _____________ _____________ _____________
0.01 sec -2.13 -2.16 -2.1 0 0 0 0 0 NaN 2692 -2.44 NaN 2849 321 7.2388e+07 0 0 -0.754 1.393 4.088 0.006 -0.019 -0.962
0.02 sec -2.1 -2.15 -2.09 0 0 0 0 0 NaN 2691 -2.45 NaN 2845 322 7.2398e+07 0 0 -1.308 1.818 4.089 0.008 -0.02 -0.963
0.03 sec -2.12 -2.16 -2.09 0 0 0 0 0 NaN 2694 -2.45 NaN 2857 323 7.2408e+07 0 0 -1.665 2.001 3.741 0.008 -0.02 -0.955
0.04 sec -2.12 -2.14 -2.09 0 0 0 0 0 NaN 2700 -2.45 NaN 2852 324 7.2418e+07 320 0 -2.021 1.457 3.628 0.007 -0.024 -0.957
0.05 sec -2.12 -2.14 -2.11 0 0 0 0 0 NaN 2690 -2.46 NaN 2860 325 7.2428e+07 320 0 -2.402 1.554 4.07 0.01 -0.019 -0.959
0.06 sec -2.1 -2.13 -2.12 0 -2.8 0 0 0 NaN 2699 -2.47 NaN 2855 326 7.2438e+07 0 0 -2.745 1.1 3.478 0.015 -0.014 -0.958
0.07 sec -2.09 -2.13 -2.13 0 -2.8 0 0 0 NaN 2693 -2.48 NaN 2860 327 7.2448e+07 0 0 -2.796 1.096 3.166 0.014 -0.016 -0.961
0.08 sec -2.1 -2.12 -2.16 0 -2.8 0 0 0 NaN 2708 -2.48 NaN 2865 328 7.2458e+07 0 0 -2.971 0.543 3.119 0.011 -0.015 -0.964
0.09 sec -2.1 -2.11 -2.14 0 -2.8 0 0 0 NaN 2713 -2.47 NaN 2860 329 7.2468e+07 0 0 -3.101 0.557 3.366 0.008 -0.014 -0.971
0.1 sec -2.1 -2.09 -2.17 0 -2.8 0 0 0 NaN 2709 -2.47 NaN 2872 330 7.2478e+07 0 0 -3.22 0.507 3.291 0.008 -0.01 -0.963
0.11 sec -2.09 -2.1 -2.17 0 -2.8 0 0 0 NaN 2712 -2.46 NaN 2869 331 7.2488e+07 0 0 -2.985 0.655 3.512 0.009 -0.01 -0.966
0.12 sec -2.1 -2.09 -2.16 0 -2.8 0 0 0 NaN 2708 -2.45 NaN 2871 332 7.2498e+07 0 0 -2.987 0.704 3.583 0.01 -0.008 -0.974
0.13 sec -2.11 -2.09 -2.16 0 -2.8 0 0 0 NaN 2712 -2.44 NaN 2873 333 7.2508e+07 0 0 -2.79 0.736 3.099 0.01 -0.005 -0.963
0.14 sec -2.09 -2.08 -2.13 0 -2.8 0 0 0 NaN 2716 -2.45 NaN 2878 334 7.2518e+07 0 0 -2.548 0.728 3.166 0.011 -0.006 -0.97
0.15 sec -2.05 -2.08 -2.09 0 -2.8 0 0 0 NaN 2720 -2.44 NaN 2875 335 7.2528e+07 0 0 -2.299 0.895 2.956 0.011 -0.002 -0.968
0.16 sec -2.03 -2.08 -2.1 0 -2.8 0 0 0 NaN 2714 -2.44 NaN 2872 336 7.2538e+07 0 0 -2.171 0.668 2.855 0.01 -0.005 -0.975
TTs = synchronize(TT1r, TT2);
TTsSize = size(TTs)
TTsSize = 1x2
1722 93
<mw-icon class=""></mw-icon>
<mw-icon class=""></mw-icon>
disp(TTs)
LeftSeconds LeftFrameNumber LeftFrameNumberRaw LeftPupilX LeftPupilY LeftPupilWidth LeftPupilHeight LeftPupilAngle LeftIrisRadius LeftTorsion LeftUpperEyelid LeftLowerEyelid LeftDataQuality LeftCR1X LeftCR1Y LeftCR2X LeftCR2Y LeftCR3X LeftCR3Y LeftCR4X LeftCR4Y LeftCR5X LeftCR5Y RightFrameNumber RightFrameNumberRaw RightSeconds RightPupilX RightPupilY RightPupilWidth RightPupilHeight RightPupilAngle RightIrisRadius RightTorsion RightUpperEyelid RightLowerEyelid RightDataQuality RightCR1X RightCR1Y RightCR2X RightCR2Y RightCR3X RightCR3Y RightCR4X RightCR4Y RightCR5X RightCR5Y AccelerometerX AccelerometerY AccelerometerZ GyroX GyroY GyroZ MagnetometerX MagnetometerY MagnetometerZ Int0 Int1 Int2 Int3 Int4 Int5 Int6 Int7 Double0 Double1 Double2 Double3 Double4 Double5 Double6 Double7 Left_Eye_H (°) Right_Eye_H (°) Left_Eye_V (°) Chair_Velocity (°/s) Laser_X (°) Laser_Y (°) OKN_Velocity (°/s) Laser/Ref Left_Eye_T (°) Left_Eye_A Right_Eye_V (°) Right_Eye_T (°) Right_Eye_A Video_Frame_Number VOG_Timestamp Event Code Laser_Z Gyro_X (°/s) 0 Gyro_Y (°/s) 0 Gyro_Z (°/s) 0 Accel_X (g) 0 Accel_Y (g) 0 Accel_Z (g) 0
___________ _______________ __________________ __________ __________ ______________ _______________ ______________ ______________ ___________ _______________ _______________ _______________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________________ ___________________ ____________ ___________ ___________ _______________ ________________ _______________ _______________ ____________ ________________ ________________ ________________ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ ______________ ______________ ______________ _____ _____ _____ _____________ _____________ _____________ ____ ____ ____ ____ ____ ____ ____ ____ _______ _______ _______ _______ _______ _______ _______ _______ ______________ _______________ ______________ ____________________ ___________ ___________ __________________ _________ ______________ __________ _______________ _______________ ___________ __________________ _____________ __________ _______ ______________ ______________ ______________ _____________ _____________ _____________
0 sec 0 0 204.99 125.92 58.03 63.265 -43.59 99 0 432.47 851.93 79.385 169.49 115.84 279.53 134.16 0 0 0 0 0 0 0 0 0 195.3 132.99 56.223 59.353 26.129 109 -0.54 438.26 929.43 80.692 230.23 119.23 111.89 139 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0.01 sec 1 1 204.99 125.93 58.126 63.175 -44.066 99 0 432.47 851.93 79.4 169.62 115.89 279.53 134.16 0 0 0 0 0 0 1 1 0.01 195.31 132.98 56.253 59.343 25.995 109 -0.56 438.26 929.43 81.046 230.23 119.23 111.92 139.06 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -2.13 -2.16 -2.1 0 0 0 0 0 NaN 2692 -2.44 NaN 2849 321 7.2388e+07 0 0 -0.754 1.393 4.088 0.006 -0.019 -0.962
0.02 sec 2 2 204.88 126.66 58.109 60.877 -43.862 99 -0.02 359.88 851.93 78.9 169.74 115.95 279.57 134.16 0 0 0 0 0 0 2 2 0.02 195.3 132.99 56.244 59.324 26.137 109 -0.54 438.26 929.43 81.184 230.36 119.26 111.96 139.16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -2.1 -2.15 -2.09 0 0 0 0 0 NaN 2691 -2.45 NaN 2845 322 7.2398e+07 0 0 -1.308 1.818 4.089 0.008 -0.02 -0.963
0.03 sec 3 3 204.49 126.56 58.476 61.196 -28.859 99 0.2 359.88 851.93 78.724 169.84 115.93 279.57 134.16 0 0 0 0 0 0 3 3 0.03 195.37 133.27 56.032 59.478 25.764 109 -0.54 438.26 929.43 81.553 230.34 119.34 111.96 139.34 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -2.12 -2.16 -2.09 0 0 0 0 0 NaN 2694 -2.45 NaN 2857 323 7.2408e+07 0 0 -1.665 2.001 3.741 0.008 -0.02 -0.955
0.04 sec 4 4 204.84 126.72 57.961 61.223 -40.685 99 0 357.53 851.93 79.485 169.93 115.89 279.63 134.11 0 0 0 0 0 0 4 4 0.04 195.37 133.25 55.967 59.709 27.929 109 -0.54 438.26 929.43 80.961 230.4 119.28 112 139.38 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -2.12 -2.14 -2.09 0 0 0 0 0 NaN 2700 -2.45 NaN 2852 324 7.2418e+07 320 0 -2.021 1.457 3.628 0.007 -0.024 -0.957
0.05 sec 5 5 205.03 126.79 57.57 61.205 -45.715 99 -0.06 357.53 851.93 79.816 169.93 115.89 279.67 134.13 0 0 0 0 0 0 5 5 0.05 194.88 132.66 56.057 61.564 37.115 109 -0.3 483.72 929.43 81.153 230.5 119.3 112.02 139.44 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -2.12 -2.14 -2.11 0 0 0 0 0 NaN 2690 -2.46 NaN 2860 325 7.2428e+07 320 0 -2.402 1.554 4.07 0.01 -0.019 -0.959
0.06 sec 6 6 204.94 126.59 58.1 61.045 -49.247 99 0 357.53 851.93 81.061 169.93 115.89 279.71 134.05 0 0 0 0 0 0 6 6 0.06 194.89 132.95 55.606 61.387 35.093 109 -0.24 492.08 929.43 81.661 230.51 119.4 112.02 139.44 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -2.1 -2.13 -2.12 0 -2.8 0 0 0 NaN 2699 -2.47 NaN 2855 326 7.2438e+07 0 0 -2.745 1.1 3.478 0.015 -0.014 -0.958
0.07 sec 7 7 204.93 126.65 58.067 60.97 -48.215 99 0.02 357.53 851.93 80.369 169.93 115.89 279.83 134.15 0 0 0 0 0 0 7 7 0.07 195.47 133.38 56.139 59.55 28.418 109 -0.62 438.26 929.43 81.292 230.5 119.5 112.02 139.44 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -2.09 -2.13 -2.13 0 -2.8 0 0 0 NaN 2693 -2.48 NaN 2860 327 7.2448e+07 0 0 -2.796 1.096 3.166 0.014 -0.016 -0.961
0.08 sec 8 8 204.78 126.59 58.372 60.948 -43.23 99 0.08 357.53 851.93 79.915 169.93 115.89 279.88 134.18 0 0 0 0 0 0 8 8 0.08 195.47 133.56 56.409 59.273 26.188 109 -0.56 438.26 846.28 80.038 230.48 119.7 112.02 139.56 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -2.1 -2.12 -2.16 0 -2.8 0 0 0 NaN 2708 -2.48 NaN 2865 328 7.2458e+07 0 0 -2.971 0.543 3.119 0.011 -0.015 -0.964
0.09 sec 9 9 204.97 126.71 57.965 60.848 -46.259 99 0.02 359.88 851.93 80.146 169.93 115.89 279.9 134.08 0 0 0 0 0 0 9 9 0.09 195.5 133.64 56.489 59.272 31.647 109 -0.6 438.26 846.28 80.469 230.48 119.7 111.96 139.66 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -2.1 -2.11 -2.14 0 -2.8 0 0 0 NaN 2713 -2.47 NaN 2860 329 7.2468e+07 0 0 -3.101 0.557 3.366 0.008 -0.014 -0.971
0.1 sec 10 10 204.94 126.64 58.129 60.874 -49.992 99 0.02 357.53 851.93 80.4 169.93 115.89 279.87 134 0 0 0 0 0 0 10 10 0.1 195.11 133.36 55.983 60.658 35.123 109 -0.34 481.53 844.83 80.761 230.52 119.81 111.95 139.6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -2.1 -2.09 -2.17 0 -2.8 0 0 0 NaN 2709 -2.47 NaN 2872 330 7.2478e+07 0 0 -3.22 0.507 3.291 0.008 -0.01 -0.963
0.11 sec 11 11 204.94 126.63 58.122 60.884 -50.106 99 0 357.53 851.93 80.115 169.96 115.84 279.9 134.08 0 0 0 0 0 0 11 11 0.11 195.06 133.38 55.744 60.756 34.948 109 -0.26 492.08 846.28 81.561 230.52 119.81 112.04 139.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -2.09 -2.1 -2.17 0 -2.8 0 0 0 NaN 2712 -2.46 NaN 2869 331 7.2488e+07 0 0 -2.985 0.655 3.512 0.009 -0.01 -0.966
0.12 sec 12 12 204.97 126.6 58.162 60.767 -50.134 99 0 357.53 851.93 80.284 169.93 115.89 279.9 134.08 0 0 0 0 0 0 12 12 0.12 195.49 133.63 56.524 59.203 31.602 109 -0.52 438.26 846.28 79.9 230.47 119.8 112.04 139.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -2.1 -2.09 -2.16 0 -2.8 0 0 0 NaN 2708 -2.45 NaN 2871 332 7.2498e+07 0 0 -2.987 0.704 3.583 0.01 -0.008 -0.974
0.13 sec 13 13 204.92 126.58 58.038 60.846 -47.157 99 0.02 357.53 851.93 80.354 169.93 115.89 279.95 134.07 0 0 0 0 0 0 13 13 0.13 195.05 133.37 55.768 60.718 35.293 109 -0.24 492.08 929.43 80.846 230.52 119.81 112 139.62 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -2.11 -2.09 -2.16 0 -2.8 0 0 0 NaN 2712 -2.44 NaN 2873 333 7.2508e+07 0 0 -2.79 0.736 3.099 0.01 -0.005 -0.963
0.14 sec 14 14 204.91 126.58 57.948 60.935 -46.763 99 0.04 357.53 851.93 79.639 169.93 115.89 279.92 133.98 0 0 0 0 0 0 14 14 0.14 194.97 133.62 55.376 60.245 34.676 109 -0.12 492.08 939.25 79.377 230.41 119.86 112 139.54 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -2.09 -2.08 -2.13 0 -2.8 0 0 0 NaN 2716 -2.45 NaN 2878 334 7.2518e+07 0 0 -2.548 0.728 3.166 0.011 -0.006 -0.97
0.15 sec 15 15 204.92 126.43 57.881 61.186 -45.472 99 0.26 389.69 851.93 80.269 169.93 115.89 279.87 134 0 0 0 0 0 0 15 15 0.15 195.09 133.91 55.33 59.614 30.645 109 -0.22 492.08 929.43 80.507 230.41 119.86 111.98 139.6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -2.05 -2.08 -2.09 0 -2.8 0 0 0 NaN 2720 -2.44 NaN 2875 335 7.2528e+07 0 0 -2.299 0.895 2.956 0.011 -0.002 -0.968
0.16 sec 16 16 204.89 126.44 57.836 61.24 -44.658 99 0.28 389.69 851.93 80.246 169.93 115.89 279.77 133.98 0 0 0 0 0 0 16 16 0.16 195.09 133.91 55.349 59.573 30.586 109 -0.22 492.08 929.43 80.769 230.35 119.89 111.98 139.6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -2.03 -2.08 -2.1 0 -2.8 0 0 0 NaN 2714 -2.44 NaN 2872 336 7.2538e+07 0 0 -2.171 0.668 2.855 0.01 -0.005 -0.975
0.17 sec 17 17 204.68 126.44 58.132 60.612 -43.198 99 0.38 359.88 851.93 79.131 169.93 115.89 279.77 133.98 0 0 0 0 0 0 17 17 0.17 195.13 133.92 55.344 59.614 29.889 109 -0.24 492.08 929.43 80.792 230.35 119.89 112 139.54 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -2.03 -2.08 -2.07 0 -2.8 0 0 0 NaN 2713 -2.42 NaN 2890 337 7.2548e+07 0 0 -1.926 0.611 2.852 0.01 -0.007 -0.971
0.18 sec 18 18 204.65 126.48 58.12 60.7 -43.597 99 0.42 359.88 851.93 78.416 169.93 115.89 279.72 133.95 0 0 0 0 0 0 18 18 0.18 195.03 133.66 55.629 59.637 31.954 109 -0.22 492.08 856.11 81.469 230.31 119.81 111.98 139.6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -2.02 -2.09 -2.07 0 -2.8 0 0 0 NaN 2711 -2.4 NaN 2892 338 7.2558e+07 0 0 -1.441 0.737 2.889 0.005 -0.005 -0.978
0.19 sec 19 19 204.67 126.44 58.497 60.625 -39.098 99 0.4 356.4 851.93 78.677 169.73 115.69 279.73 133.85 0 0 0 0 0 0 19 19 0.19 194.96 133.82 54.999 59.63 29.735 109 -0.16 492.08 846.28 81.576 230.27 119.78 112 139.54 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -2 -2.1 -2.04 0 -2.8 0 0 0 NaN 2718 -2.39 NaN 2893 339 7.2568e+07 0 0 -1.437 0.628 2.807 0.005 -0.007 -0.977
0.2 sec 20 20 204.63 126.47 58.48 60.563 -41.087 99 0.42 359.88 851.93 78.001 169.73 115.69 279.73 133.85 0 0 0 0 0 0 20 20 0.2 194.7 133.67 55.023 60.125 30.793 109 -0.04 492.08 856.11 80.646 230.28 119.74 111.93 139.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -2.01 -2.09 -2.05 0 -2.8 0 0 0 NaN 2712 -2.38 NaN 2894 340 7.2578e+07 0 0 -0.947 0.585 2.751 0.004 -0.007 -0.972
0.21 sec 21 21 204.53 126.42 58.087 60.498 -37.102 99 0.52 359.88 851.93 77.793 169.69 115.72 279.73 133.85 0 0 0 0 0 0 21 21 0.21 194.73 133.79 54.987 60.223 30.69 109 -0.06 492.08 856.11 80.569 230.19 119.71 111.91 139.44 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.98 -2.07 -2.03 0 -2.8 0 0 0 NaN 2712 -2.39 NaN 2875 341 7.2588e+07 0 0 -0.707 0.828 2.804 0.007 -0.003 -0.984
0.22 sec 22 22 204.5 126.45 58.351 60.528 -43.537 99 0.52 356.4 851.93 77.585 169.61 115.59 279.73 133.85 0 0 0 0 0 0 22 22 0.22 194.72 133.78 54.983 60.226 30.85 109 -0.06 492.08 856.11 80.731 230.19 119.71 111.91 139.44 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.96 -2.06 -2.03 0 -2.8 0 0 0 NaN 2702 -2.39 NaN 2868 342 7.2598e+07 0 0 -0.646 0.293 3.015 0.005 -0.009 -0.971
0.23 sec 23 23 204.46 126.4 58.247 60.65 -42.626 99 0.56 356.4 851.93 78.516 169.62 115.69 279.73 133.85 0 0 0 0 0 0 23 23 0.23 194.89 133.69 55.657 59.002 29.642 109 -0.16 492.08 856.11 81.638 230.17 119.52 111.91 139.44 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.94 -2.05 -2.02 0 -2.8 0 0 0 NaN 2703 -2.37 NaN 2869 343 7.2608e+07 0 0 -0.343 0.487 2.999 0.007 -0.005 -0.966
0.24 sec 24 24 204.88 126.4 57.241 61.826 -47.562 99 0.32 359.88 851.93 80.238 169.61 115.59 279.73 133.85 0 0 0 0 0 0 24 24 0.24 194.99 133.81 55.63 58.66 29.291 109 -0.18 492.08 856.11 81.746 230.17 119.52 111.91 139.44 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.93 -2.03 -2.02 0 -2.8 0 0 0 NaN 2700 -2.38 NaN 2862 344 7.2618e+07 0 0 0.028 0.061 2.991 0.01 -0.006 -0.973
0.25 sec 25 25 204.81 126.3 57.354 61.846 -47.794 99 0.36 357.53 851.93 80.446 169.55 115.58 279.72 133.95 0 0 0 0 0 0 25 25 0.25 194.94 133.7 55.362 58.68 30.314 109 -0.18 492.08 929.43 81.553 230.18 119.42 111.91 139.44 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.91 -2.03 -2.02 0 -2.8 0 0 0 NaN 2692 -2.38 NaN 2868 345 7.2628e+07 0 0 0.298 -0.303 2.31 0.003 -0.007 -0.967
0.26 sec 26 26 204.62 126.58 57.628 60.813 -38.438 99 0.46 389.69 851.93 79.016 169.61 115.59 279.73 133.85 0 0 0 0 0 0 26 26 0.26 194.91 133.68 55.384 58.619 31.202 109 -0.18 492.08 939.25 81.553 230.2 119.32 111.87 139.48 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.9 -2.01 -2.04 0 -2.8 0 0 0 NaN 2685 -2.39 NaN 2857 346 7.2638e+07 0 0 0.234 -0.255 2.379 -0.002 -0.01 -0.963
0.27 sec 27 27 204.56 126.42 58.106 60.651 -40.325 99 0.48 357.53 851.93 78.924 169.61 115.59 279.73 133.85 0 0 0 0 0 0 27 27 0.27 194.54 133.56 54.877 59.535 30.487 109 0 492.08 846.28 80.923 230.2 119.32 111.87 139.48 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.89 -2 -2.04 0 -2.8 0 0 0 NaN 2682 -2.37 NaN 2856 347 7.2648e+07 0 0 0.1 0.2 2.585 -0.005 -0.012 -0.967
0.28 sec 28 28 204.6 126.48 57.907 60.671 -40.514 99 0.44 359.88 851.93 79.108 169.61 115.59 279.73 133.85 0 0 0 0 0 0 28 28 0.28 194.66 133.52 55.338 58.55 29.553 109 -0.1 492.08 846.28 81.007 230.2 119.32 111.49 139.45 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.89 -2 -2.05 0 -2.8 0 0 0 NaN 2678 -2.38 NaN 2850 348 7.2658e+07 0 0 0.16 0.594 2.475 -0.008 -0.01 -0.97
0.29 sec 29 29 204.71 126.1 57.809 61.017 -47.165 99 0.4 357.53 851.93 80.162 169.56 115.51 279.67 133.77 0 0 0 0 0 0 29 29 0.29 194.24 133.37 54.808 59.505 29.699 109 0.12 492.08 846.28 80.046 230.2 119.32 111.48 139.34 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.9 -1.99 -2.08 0 -2.8 0 0 0 NaN 2665 -2.38 NaN 2849 349 7.2668e+07 0 0 0.257 1.236 3.032 -0.008 -0.011 -0.969
0.3 sec 30 30 204.5 125.92 57.516 60.076 -47.112 99 0.16 354.05 851.93 80.277 169.34 115.3 279.5 133.67 0 0 0 0 0 0 30 30 0.3 194.88 133.27 55.363 57.677 14.674 109 -0.44 438.11 846.28 82.561 230.23 119.23 111.6 139.05 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.87 -1.96 -2.09 0 -2.8 0 0 0 NaN 2632 -2.38 NaN 2843 350 7.2678e+07 0 0 0.131 1.606 3.036 -0.001 -0.013 -0.969
0.31 sec 31 31 204.14 125.97 57.474 60.47 -32.236 99 0.4 352.05 851.93 78.862 169.34 115.3 279.5 133.67 0 0 0 0 0 0 31 31 0.31 194.8 132.67 55.355 58.351 28.908 109 -0.5 438.26 846.28 82.184 230.23 119.23 111.63 139.1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.87 -1.95 -2.09 0 -2.8 0 0 0 NaN 2627 -2.4 NaN 2830 351 7.2688e+07 0 0 0.131 1.141 3.197 -0.002 -0.012 -0.966
0.32 sec 32 32 204.57 125.96 57.197 59.807 -47.617 99 0.1 354.05 851.93 80.715 169.55 115.41 279.58 133.8 0 0 0 0 0 0 32 32 0.32 194.63 132.7 54.824 58.908 32.379 109 -0.36 492.08 846.28 82.584 230.23 119.23 111.6 139.05 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.87 -1.94 -2.11 0 -2.8 0 0 0 NaN 2624 -2.42 NaN 2827 352 7.2698e+07 0 0 0.313 1.072 3.252 -0.001 -0.013 -0.961
0.33 sec 33 33 204.59 126.07 57.088 59.736 -45.78 99 0.06 357.53 847.82 79.969 169.55 115.41 279.58 133.8 0 0 0 0 0 0 33 33 0.33 194.4 132.63 54.736 59.574 32.005 109 -0.22 492.08 837.2 82.53 230.23 119.23 111.6 139.05 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.84 -1.92 -2.12 0 -2.8 0 0 0 NaN 2630 -2.43 NaN 2823 353 7.2708e+07 0 0 0.008 0.997 3.291 -0.001 -0.011 -0.966
0.34 sec 34 34 204.63 126.1 57.033 59.561 -45.579 99 0.06 354.05 851.93 80.83 169.55 115.41 279.62 133.81 0 0 0 0 0 0 34 34 0.34 194.43 132.87 54.172 59.843 29.861 109 -0.2 492.08 846.28 82.038 230.23 119.23 111.6 139.05 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.82 -1.92 -2.1 0 -2.8 0 0 0 NaN 2634 -2.44 NaN 2827 354 7.2718e+07 0 0 -0.549 0.601 3.697 -0.007 -0.021 -0.958
0.35 sec 35 35 204.59 126.1 57.09 59.432 -46.307 99 0.08 354.05 851.93 80.677 169.62 115.44 279.62 133.81 0 0 0 0 0 0 35 35 0.35 195.21 133.26 54.655 57.592 17.409 109 -0.7 438.26 929.43 83.46 230.29 119.16 111.6 139.05 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.8 -1.91 -2.13 0 -2.8 0 0 0 NaN 2626 -2.44 NaN 2833 355 7.2728e+07 0 0 -0.556 0.556 3.936 -0.004 -0.014 -0.964
0.36 sec 36 36 204.69 126.1 56.947 59.455 -46.835 99 0.04 354.05 851.93 81.069 169.62 115.44 279.64 133.72 0 0 0 0 0 0 36 36 0.36 194.55 132.82 53.933 59.747 31.095 109 -0.28 492.08 929.43 82.376 230.29 119.16 111.63 139.1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.79 -1.9 -2.16 0 -2.8 0 0 0 NaN 2624 -2.45 NaN 2838 356 7.2738e+07 0 0 -0.618 0.818 3.86 -0.009 -0.017 -0.963
0.37 sec 37 37 204.76 126.15 56.669 59.623 -46.808 99 0 352.05 851.93 80.692 169.68 115.33 279.64 133.72 0 0 0 0 0 0 37 37 0.37 194.87 132.89 54.525 58.354 30.105 109 -0.5 438.26 929.43 81.892 230.29 119.16 111.53 138.97 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.77 -1.87 -2.18 0 -2.8 0 0 0 NaN 2619 -2.48 NaN 2830 357 7.2747e+07 0 0 -0.741 0.674 3.953 -0.002 -0.014 -0.967
0.38 sec 38 38 204.74 126.12 56.816 59.333 -46.264 99 0.02 352.05 851.93 80.938 169.68 115.33 279.69 133.68 0 0 0 0 0 0 38 38 0.38 195.05 132.99 55.048 57.702 26.778 109 -0.6 438.26 929.43 83.606 230.35 119.11 111.56 139.01 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.76 -1.87 -2.18 0 -2.8 0 0 0 NaN 2611 -2.49 NaN 2820 358 7.2757e+07 0 0 -1.001 0.903 4.361 -0.001 -0.015 -0.966
0.39 sec 39 39 204.85 125.76 56.754 60.044 -48.259 99 0.02 352.05 851.93 80.531 169.68 115.33 279.64 133.72 0 0 0 0 0 0 39 39 0.39 194.87 132.75 54.289 58.822 32.462 109 -0.52 438.26 929.43 81.676 230.35 119.11 111.56 138.91 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.77 -1.87 -2.19 0 -2.8 0 0 0 NaN 2604 -2.49 NaN 2818 359 7.2767e+07 0 0 -0.943 1.084 4.397 -0.005 -0.014 -0.971
0.4 sec 40 40 204.89 125.96 56.597 59.122 -44.504 99 -0.04 357.53 851.93 80.146 169.79 115.39 279.69 133.68 0 0 0 0 0 0 40 40 0.4 194.95 133.06 54.083 57.799 28.633 109 -0.52 492.08 929.43 82.291 230.35 119.11 111.59 138.96 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.77 -1.86 -2.19 0 -2.8 0 0 0 NaN 2571 -2.49 NaN 2831 360 7.2777e+07 0 0 -0.948 1.384 4.453 -0.003 -0.011 -0.965
0.41 sec 41 41 204.92 126.09 56.582 59.012 -45.548 99 -0.1 357.53 851.93 80.5 169.79 115.39 279.69 133.68 0 0 0 0 0 0 41 41 0.41 194.96 132.54 54.147 58.638 33.224 109 -0.62 438.26 929.43 82.276 230.38 119.2 111.57 138.8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.77 -1.84 -2.19 0 -2.8 0 0 0 NaN 2578 -2.51 NaN 2819 361 7.2787e+07 0 0 -1.132 1.239 4.544 -0.002 -0.017 -0.96
0.42 sec 42 42 204.71 125.98 56.633 58.851 -42.617 99 0.04 357.53 851.93 79.769 169.79 115.39 279.69 133.68 0 0 0 0 0 0 42 42 0.42 194.72 132.61 53.582 59.167 34.183 109 -0.42 492.08 929.43 81.123 230.38 119.2 111.61 138.84 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.78 -1.86 -2.19 0 -2.8 0 0 0 NaN 2558 -2.5 NaN 2831 362 7.2797e+07 0 0 -1.01 1.574 4.425 -0.003 -0.016 -0.964
0.43 sec 43 43 204.99 125.71 56.413 59.508 -53.695 99 -0.04 357.53 851.93 80.331 169.74 115.4 279.69 133.68 0 0 0 0 0 0 43 43 0.43 195.07 132.81 54.204 57.914 34.039 109 -0.66 438.26 929.43 83.306 230.35 119.11 111.61 138.77 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.78 -1.85 -2.25 0 -2.8 0 0 0 NaN 2549 -2.5 NaN 2823 363 7.2807e+07 0 0 -1.078 1.599 4.614 0.001 -0.019 -0.972
0.44 sec 44 44 204.94 125.86 56.078 58.97 -47.424 99 -0.04 354.05 846.74 79.792 169.84 115.38 279.64 133.72 0 0 0 0 0 0 44 44 0.44 194.97 132.74 53.713 57.931 29.975 109 -0.58 438.26 929.43 83.083 230.35 119.11 111.54 138.69 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.76 -1.85 -2.23 0 -2.8 0 0 0 NaN 2543 -2.49 NaN 2832 364 7.2817e+07 0 0 -0.825 1.456 4.408 0 -0.013 -0.97
0.45 sec 45 45 204.41 125.83 56.494 58.633 -29.182 99 0.38 357.53 851.93 79.546 169.8 115.39 279.69 133.68 0 0 0 0 0 0 45 45 0.45 194.7 132.61 53.054 57.978 32.117 109 -0.08 492.08 929.43 80.608 230.35 119.11 111.57 138.74 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.77 -1.86 -2.23 0 -2.8 0 0 0 NaN 2542 -2.49 NaN 2833 365 7.2827e+07 0 0 -0.893 1.613 4.559 0 -0.016 -0.967
0.46 sec 46 46 204.73 125.95 56.041 58.278 -38.276 99 0.16 357.53 851.93 79.985 169.79 115.39 279.69 133.68 0 0 0 0 0 0 46 46 0.46 194.69 132.61 53.02 58.055 32.222 109 -0.06 492.08 929.43 80.792 230.39 119.02 111.64 138.82 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.77 -1.86 -2.22 0 -2.8 0 0 0 NaN 2572 -2.5 NaN 2831 366 7.2837e+07 0 0 -0.718 1.499 4.853 0 -0.014 -0.972
0.47 sec 47 47 204.95 125.79 55.109 59.068 -45.443 99 0.06 357.53 851.93 80.723 169.84 115.38 279.69 133.68 0 0 0 0 0 0 47 47 0.47 195.24 132.6 53.88 57.158 27.805 109 -0.42 438.26 929.43 81.269 230.35 119.11 111.61 138.77 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.76 -1.86 -2.24 0 -2.8 0 0 0 NaN 2548 -2.49 NaN 2824 367 7.2847e+07 0 0 -0.789 1.43 5.211 -0.004 -0.014 -0.965
0.48 sec 48 48 204.81 125.86 55.724 58.534 -43.254 99 0.14 357.53 851.93 79.5 169.79 115.39 279.69 133.68 0 0 0 0 0 0 48 48 0.48 194.81 132.54 53.111 58.325 31.549 109 -0.14 492.08 929.43 80.215 230.35 119.11 111.58 138.72 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.78 -1.85 -2.24 0 -2.8 0 0 0 NaN 2547 -2.5 NaN 2823 368 7.2857e+07 0 0 -0.84 1.164 4.973 0 -0.013 -0.974
0.49 sec 49 49 204.41 125.8 55.699 58.192 -30.977 99 0.4 354.05 851.93 78.47 169.79 115.39 279.69 133.68 0 0 0 0 0 0 49 49 0.49 195 132.62 53.748 56.826 35.683 109 -0.24 492.08 929.43 80.231 230.26 119.07 111.58 138.72 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.76 -1.86 -2.23 0 -2.8 0 0 0 NaN 2537 -2.5 NaN 2810 369 7.2867e+07 0 0 -0.843 0.939 5.179 0 -0.014 -0.969
0.5 sec 50 50 204.42 125.53 55.544 57.999 -41.246 99 0.42 357.53 851.93 78.701 169.79 115.39 279.69 133.68 0 0 0 0 0 0 50 50 0.5 194.66 132.51 52.517 57.979 30.134 109 -0.06 492.08 929.43 80.023 230.26 119.07 111.52 138.64 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.75 -1.84 -2.23 0 -2.8 0 0 0 NaN 2535 -2.5 NaN 2805 370 7.2877e+07 0 0 -0.48 0.932 5.25 -0.002 -0.012 -0.967
0.51 sec 51 51 204.46 125.53 55.464 57.958 -41.013 99 0.38 357.53 851.93 79.077 169.79 115.29 279.69 133.68 0 0 0 0 0 0 51 51 0.51 195.25 132.74 53.183 56.34 22.613 109 -0.4 438.26 929.43 81.092 230.26 119.07 111.58 138.72 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.75 -1.84 -2.24 0 -2.8 0 0 0 NaN 2530 -2.5 NaN 2794 371 7.2887e+07 0 0 -0.484 0.97 5.381 0.004 -0.017 -0.964
0.52 sec 52 52 204.37 125.54 55.375 57.777 -41.898 99 0.44 357.53 851.93 78.454 169.75 115.31 279.69 133.68 0 0 0 0 0 0 52 52 0.52 194.75 132.85 52.56 57.045 28.447 109 -0.08 492.08 929.43 80.923 230.26 119.07 111.55 138.73 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.75 -1.84 -2.24 0 -2.8 0 0 0 NaN 2527 -2.49 NaN 2788 372 7.2897e+07 0 0 -0.668 0.825 5.473 0.008 -0.018 -0.969
0.53 sec 53 53 204.36 125.47 55.319 57.495 -38.952 99 0.48 357.53 846.74 78.823 169.79 115.29 279.69 133.68 0 0 0 0 0 0 53 53 0.53 195.45 132.89 53.063 55.499 18.658 109 -0.52 438.26 929.43 80.238 230.26 119.07 111.55 138.73 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.75 -1.84 -2.25 0 -2.8 0 0 0 NaN 2526 -2.49 NaN 2787 373 7.2907e+07 0 0 -0.794 0.932 5.552 0.006 -0.015 -0.97
0.54 sec 54 54 204.36 125.59 55.032 57.299 -43.081 99 0.48 357.53 851.93 79.185 169.79 115.29 279.69 133.68 0 0 0 0 0 0 54 54 0.54 195.01 132.95 52.629 56.493 31.091 109 -0.2 492.08 929.43 80.184 230.26 119.07 111.82 138.66 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.75 -1.85 -2.25 0 -2.8 0 0 0 NaN 2523 -2.51 NaN 2778 374 7.2917e+07 0 0 -0.722 0.869 5.232 0.006 -0.014 -0.962
0.55 sec 55 55 204.49 125.52 54.83 57.563 -46.195 99 0.38 357.53 851.93 79.385 169.79 115.29 279.78 133.7 0 0 0 0 0 0 55 55 0.55 194.75 132.71 52.346 56.977 32.883 109 -0.08 492.08 929.43 79.623 230.26 119.07 111.51 138.76 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.76 -1.85 -2.27 0 -2.8 0 0 0 NaN 2516 -2.52 NaN 2753 375 7.2927e+07 0 0 -0.779 0.629 5.185 0.008 -0.015 -0.959
0.56 sec 56 56 204.47 125.6 55.134 57.088 -40.277 99 0.4 357.53 851.93 78.762 169.75 115.21 279.73 133.7 0 0 0 0 0 0 56 56 0.56 194.88 132.65 52.863 56.277 34.899 109 -0.16 438.26 929.43 80.707 230.26 119.07 111.79 138.71 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.76 -1.87 -2.27 0 -2.8 0 0 0 NaN 2512 -2.51 NaN 2755 376 7.2937e+07 0 0 -0.96 0.769 5.082 0.008 -0.017 -0.961
0.57 sec 57 57 204.56 125.67 54.94 56.985 -42.434 99 0.36 357.53 851.93 78.77 169.79 115.29 279.73 133.7 0 0 0 0 0 0 57 57 0.57 194.9 132.95 52.254 55.892 31.725 109 -0.12 492.08 929.43 80.284 230.26 119.07 111.79 138.71 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.77 -1.87 -2.27 0 -2.8 0 0 0 NaN 2512 -2.52 NaN 2738 377 7.2947e+07 0 0 -0.832 0.816 4.846 0.011 -0.02 -0.963
0.58 sec 58 58 204.51 125.63 54.804 56.976 -42.955 99 0.4 357.53 851.93 79.385 169.9 115.29 279.78 133.7 0 0 0 0 0 0 58 58 0.58 195.04 132.63 52.65 55.737 34.942 109 -0.24 492.08 929.43 80.507 230.26 119.07 111.67 138.69 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.77 -1.88 -2.27 0 -2.8 0 0 0 NaN 2510 -2.53 NaN 2731 378 7.2957e+07 0 0 -0.949 0.908 4.674 0.006 -0.019 -0.961
0.59 sec 59 59 204.54 125.53 54.601 56.887 -42.653 99 0.38 357.53 851.93 78.516 169.97 115.32 279.78 133.7 0 0 0 0 0 0 59 59 0.59 194.95 132.9 52.305 55.514 35.214 109 -0.14 492.08 929.43 80.8 230.21 119.14 111.58 138.67 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.77 -1.88 -2.28 0 -2.8 0 0 0 NaN 2511 -2.53 NaN 2730 379 7.2967e+07 0 0 -0.997 1.128 4.155 0.01 -0.017 -0.964
0.6 sec 60 60 204.62 125.57 54.054 56.835 -38.005 99 0.32 387.35 846.74 78.508 170.02 115.32 279.85 133.54 0 0 0 0 0 0 60 60 0.6 195.27 132.78 52.297 54.867 23.08 109 -0.5 438.26 929.43 85.198 230.26 119.07 112.99 138.76 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.78 -1.9 -2.29 0 -2.8 0 0 0 NaN 2501 -2.54 NaN 2718 380 7.2977e+07 0 0 -1.12 0.984 4.249 0.002 -0.024 -0.966
0.61 sec 61 61 204.62 125.59 54.175 56.558 -34.564 99 0.3 357.53 846.74 78.201 170.02 115.32 279.9 133.48 0 0 0 0 0 0 61 61 0.61 195.26 132.83 52.386 54.814 20.672 109 -0.48 438.26 929.43 85.39 230.15 119.15 112.99 138.76 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.87 -2.07 -2.27 0 -2.8 0 0 0 NaN 2507 -2.51 NaN 2703 381 7.2987e+07 0 0 -1.172 1.111 3.899 0.006 -0.02 -0.965
0.62 sec 62 62 204.67 125.48 54.318 56.562 -40.786 99 0.28 357.53 846.74 78.047 170.02 115.32 279.92 133.61 0 0 0 0 0 0 62 62 0.62 195.08 132.59 52.593 55.047 27.682 109 -0.4 438.26 929.43 84.829 230.15 119.15 112.89 138.68 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.96 -2.08 -2.2 0 -2.8 0 0 0 NaN 2492 -2.51 NaN 2705 382 7.2997e+07 0 0 -0.976 0.93 3.56 0.007 -0.014 -0.964
0.63 sec 63 63 204.77 125.14 54.215 57.073 -49.374 99 0.28 357.53 851.93 76.655 169.98 115.24 279.92 133.61 0 0 0 0 0 0 63 63 0.63 194.88 132.84 51.662 55.298 29.477 109 -0.2 438.26 929.43 84.652 230.21 119.14 112.89 138.68 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.86 -2.06 -2.25 0 -2.8 0 0 0 NaN 2503 -2.53 NaN 2717 383 7.3007e+07 0 0 -1.281 1.26 3.427 0.005 -0.021 -0.962
0.64 sec 64 64 204.68 125.39 53.785 56.371 -33.333 99 0.3 357.53 846.74 77.878 169.98 115.24 279.92 133.61 0 0 0 0 0 0 64 64 0.64 194.82 132.79 52.154 54.885 31.966 109 -0.18 438.26 929.43 84.583 230.15 119.15 112.39 138.65 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.91 -2.04 -2.26 0 -2.8 0 0 0 NaN 2477 -2.55 NaN 2715 384 7.3017e+07 0 0 -1.348 1.285 3.616 0.007 -0.02 -0.97
0.65 sec 65 65 204.57 125.34 53.723 56.099 -37.195 99 0.42 357.53 846.74 77.47 170.02 115.32 279.95 133.52 0 0 0 0 0 0 65 65 0.65 194.91 132.57 52.549 54.84 33.369 109 -0.28 438.26 929.43 84.46 230.15 119.15 112.39 138.65 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.9 -2.06 -2.26 0 -2.8 0 0 0 NaN 2470 -2.55 NaN 2723 385 7.3027e+07 0 0 -1.337 1.221 3.294 0.003 -0.016 -0.968
0.66 sec 66 66 204.57 125.3 53.742 56.017 -36.821 99 0.42 357.53 846.74 77.332 169.98 115.24 279.95 133.52 0 0 0 0 0 0 66 66 0.66 194.85 132.47 52.4 54.948 31.864 109 -0.28 438.26 929.43 84.814 230.15 119.15 112.39 138.65 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.9 -2.05 -2.27 0 -2.8 0 0 0 NaN 2469 -2.53 NaN 2723 386 7.3037e+07 0 0 -1.459 1.22 3.29 0.004 -0.02 -0.966
0.67 sec 67 67 204.53 125.19 53.644 56.034 -41.213 99 0.46 357.53 846.74 76.886 169.98 115.24 279.95 133.52 0 0 0 0 0 0 67 67 0.67 194.85 132.29 52.069 55.051 32.701 109 -0.32 438.26 929.43 83.829 230.15 119.15 112.39 138.65 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.92 -2.04 -2.26 0 -2.8 0 0 0 NaN 2465 -2.54 NaN 2718 387 7.3047e+07 0 0 -1.469 1.021 3.687 0 -0.018 -0.96
0.68 sec 68 68 204.51 125.23 53.572 55.822 -37.008 99 0.46 357.53 847.82 77.778 169.98 115.24 279.95 133.52 0 0 0 0 0 0 68 68 0.68 194.84 132.29 51.529 55.216 31.873 109 -0.3 438.26 929.43 83.091 230.15 119.15 112.39 138.65 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.9 -2.03 -2.26 0 -2.8 0 0 0 NaN 2465 -2.55 NaN 2716 388 7.3057e+07 0 0 -1.282 1.117 3.524 -0.002 -0.02 -0.968
0.69 sec 69 69 204.58 125.22 53.278 55.832 -37.415 99 0.4 387.35 846.74 78.062 169.95 115.15 279.95 133.52 0 0 0 0 0 0 69 69 0.69 194.66 132.08 51.474 55.402 35.788 109 -0.24 438.26 929.43 82.568 230.15 119.15 112.39 138.65 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.89 -2.01 -2.26 0 -2.8 0 0 0 NaN 2460 -2.53 NaN 2719 389 7.3067e+07 0 0 -1.283 1.046 3.573 0.002 -0.017 -0.967
0.7 sec 70 70 204.58 124.89 53.132 56.295 -45.102 99 0.46 387.35 846.74 76.063 169.95 115.15 279.95 133.52 0 0 0 0 0 0 70 70 0.7 194.96 132.38 52.318 54.054 33.609 109 -0.38 438.26 929.43 84.206 230.12 119.09 113.95 139 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.89 -2 -2.26 0 -2.8 0 0 0 NaN 2460 -2.53 NaN 2721 390 7.3077e+07 0 0 -1.099 0.988 3.567 -0.006 -0.013 -0.969
0.71 sec 71 71 204.66 124.78 53.133 56.163 -43.621 99 0.46 387.35 846.74 75.709 169.95 115.15 279.95 133.52 0 0 0 0 0 0 71 71 0.71 194.78 132.23 51.814 54.725 35.408 109 -0.28 438.26 929.43 83.222 230.12 119.09 113.95 139 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.87 -1.99 -2.26 0 -2.8 0 0 0 NaN 2468 -2.54 NaN 2732 391 7.3087e+07 0 0 -1.1 0.846 3.665 -0.001 -0.014 -0.967
0.72 sec 72 72 204.5 124.86 53.214 55.61 -40.17 99 0.54 387.35 847.82 75.963 169.95 115.15 279.93 133.43 0 0 0 0 0 0 72 72 0.72 194.78 131.92 51.656 54.663 33.753 109 -0.38 438.26 929.43 82.93 230.16 118.93 113.95 139 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.84 -1.99 -2.27 0 -2.8 0 0 0 NaN 2468 -2.54 NaN 2724 392 7.3097e+07 0 0 -0.861 0.886 3.803 0.003 -0.016 -0.972
0.73 sec 73 73 204.66 124.75 53.004 55.75 -42.423 99 0.44 387.35 846.74 75.409 169.95 115.15 279.95 133.52 0 0 0 0 0 0 73 73 0.73 194.78 131.77 51.36 55.011 36.923 109 -0.4 438.26 929.43 82.422 230.16 118.93 113.92 138.64 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.84 -1.98 -2.27 0 -2.8 0 0 0 NaN 2474 -2.55 NaN 2720 393 7.3107e+07 0 0 -0.873 0.939 4.185 0 -0.017 -0.967
0.74 sec 74 74 204.53 124.83 52.967 55.45 -33.771 99 0.5 354.05 846.74 76.217 169.95 115.15 279.95 133.52 0 0 0 0 0 0 74 74 0.74 195.13 132.14 51.532 54.271 29.442 109 -0.56 438.26 929.43 83.822 230.16 118.93 113.92 138.64 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.83 -1.97 -2.25 0 -2.8 0 0 0 NaN 2458 -2.54 NaN 2715 394 7.3117e+07 0 0 -0.873 1.141 4.099 0.003 -0.014 -0.967
0.75 sec 75 75 204.7 124.56 53.188 55.549 -46.895 99 0.3 357.53 847.82 76.494 170 115 279.93 133.43 0 0 0 0 0 0 75 75 0.75 194.88 132.05 50.564 54.531 29.076 109 -0.28 438.26 837.2 82.968 230.16 118.93 113.92 138.64 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.84 -1.97 -2.26 0 -2.8 0 0 0 NaN 2453 -2.54 NaN 2691 395 7.3127e+07 0 0 -0.69 1.012 4.142 -0.003 -0.01 -0.966
0.76 sec 76 76 204.7 124.58 53.057 55.576 -41.566 99 0.3 387.35 847.82 76.524 170.07 115.02 279.93 133.43 0 0 0 0 0 0 76 76 0.76 194.88 132.05 50.564 54.531 29.076 109 -0.28 438.26 837.2 82.976 230.26 118.9 113.95 138.3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.82 -1.97 -2.24 0 -2.8 0 0 0 NaN 2445 -2.54 NaN 2684 396 7.3137e+07 0 0 -0.748 1.296 3.945 -0.001 -0.014 -0.962
0.77 sec 77 77 204.71 124.54 53.148 55.446 -44.668 99 0.28 357.53 847.82 76.317 170.07 115.02 279.93 133.43 0 0 0 0 0 0 77 77 0.77 194.89 132.05 50.459 54.675 29.416 109 -0.28 438.26 837.2 83.114 230.26 118.9 113.95 138.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.82 -1.96 -2.22 0 -2.8 0 0 0 NaN 2441 -2.55 NaN 2682 397 7.3147e+07 0 0 -0.878 1.178 4.23 -0.007 -0.017 -0.963
0.78 sec 78 78 204.73 124.53 53.11 55.307 -42.319 99 0.3 357.53 847.82 75.863 170.08 114.93 279.95 133.52 0 0 0 0 0 0 78 78 0.78 194.99 131.76 50.821 54.739 30.354 109 -0.42 438.26 837.2 82.13 230.26 118.9 113.97 138.16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.82 -1.97 -2.22 0 -2.8 0 0 0 NaN 2435 -2.55 NaN 2677 398 7.3157e+07 0 0 -0.82 1.156 4.352 0.004 -0.014 -0.96
0.79 sec 79 79 204.88 124.69 52.893 55.03 -39.064 99 0.16 357.53 847.82 76.801 170.07 115.02 279.95 133.52 0 0 0 0 0 0 79 79 0.79 195.23 131.98 50.769 54.112 25.39 109 -0.58 438.26 837.2 82.868 230.25 118.8 113.95 138.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.82 -1.96 -2.22 0 -2.8 0 0 0 NaN 2431 -2.54 NaN 2680 399 7.3167e+07 0 0 -1.011 1.169 4.597 0.001 -0.013 -0.965
0.8 sec 80 80 204.83 124.69 52.859 54.938 -38.531 99 0.16 357.53 847.82 76.909 170.07 115.02 280.03 133.41 0 0 0 0 0 0 80 80 0.8 195.14 132.1 50.518 54.024 29.884 109 -0.48 438.26 837.2 83.03 230.32 118.84 113.95 138.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1.79 -2.06 -2.23 0 -2.8 0 0 0 NaN 2416 -2.53 NaN 2668 400 7.3177e+07 0 0 -0.955 1.339 4.692 -0.003 -0.018 -0.964
0.81 sec 81 81 204.86 124.63 52.933 54.841 -39.523 99 0.14 354.05 846.74 76.863 170.11 114.89 280.03 133.41 0 0 0 0 0 0 81 81 0.81 195.42 132.12 51.162 53.333 21.218 109 -0.7 438.26 837.2 83.922 230.32 118.84 114.5 138.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -2.37 -3.28 -2.17 0 -2.8 0 0 0 NaN 2405 -2.45 NaN 2626 401 7.3187e+07 0 0 -1.066 1.273 4.367 -0.002 -0.017 -0.962
0.82 sec 82 82 204.93 124.63 53.075 54.87 -43.474 99 0.12 357.53 846.74 76.363 170.11 114.89 280.03 133.41 0 0 0 0 0 0 82 82 0.82 195.17 131.96 50.865 53.841 31.125 109 -0.54 438.26 837.2 83.56 230.32 118.84 114.5 138.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -3.83 -4.53 -1.91 0 -2.8 0 0 0 NaN 2409 -2.5 NaN 2618 402 7.3197e+07 0 0 -1.128 0.868 4.537 0 -0.018 -0.975
0.83 sec 83 83 205.13 124.58 52.484 55.514 -46.711 99 0.02 387.35 846.74 76.201 170.2 115.03 280.03 133.41 0 0 0 0 0 0 83 83 0.83 195.39 132.03 51.119 53.532 24.462 109 -0.68 438.26 837.2 84.567 230.42 118.74 114.5 138.5 0 ...
.
5 Comments
Austin Bollinger
on 31 Jul 2024 at 20:16
Hi @Star Strider, I am using the following code which is a combination of your code and Umar. Out of this txt file there should be time variables from 0 to 19.56. When I use setdiff it is finding variables that are in the set so the missing times is not actually correct to what actually is missing. Should I maybe round the variables if there is an issue with the exact time variable number?
data = readtable('cal.txt');
data.LeftSeconds=round(data.LeftSeconds,2);
format short
start_time = min(data.LeftSeconds);
end_time = max(data.LeftSeconds);
complete_time_range = (start_time:0.01:end_time)';
Timedata = data.LeftSeconds;
missing_times = setdiff(complete_time_range, Timedata);
missing_data = table(missing_times, nan(size(missing_times)),'VariableNames', {'Time', 'Data'});
T1r = movevars(data, 'LeftSeconds', 'Before',1);
T1r.LeftSeconds = duration(seconds(T1r.LeftSeconds));
TT1r = table2timetable(T1r);
missing_data.Time = duration(seconds(missing_data.Time));
TT2 = table2timetable(missing_data);
TTs = synchronize(TT1r, TT2);
Star Strider
on 31 Jul 2024 at 20:51
I am not certain that I understand the problem. My code synchronizes ‘cal.txt’ and ‘04_16_24_cal.csv’.
See if
data = readtable('cal.txt');
data.LeftSeconds=round(data.LeftSeconds,2);
format short
start_time = min(data.LeftSeconds);
end_time = max(data.LeftSeconds);
complete_time_range = (start_time:0.01:end_time)';
Timedata = data.LeftSeconds;
missing_times = setdiff(complete_time_range, Timedata);
missing_data = table(missing_times, nan(size(missing_times)),'VariableNames', {'Time', 'Data'});
T1r = movevars(data, 'LeftSeconds', 'Before',1);
T1r.LeftSeconds = duration(seconds(T1r.LeftSeconds));
TT1r = table2timetable(T1r);
missing_data.Time = duration(seconds(missing_data.Time));
TT2 = table2timetable(missing_data);
TTs = synchronize(TT1r, TT2)
TTs = 2501x71 timetable
LeftSeconds LeftFrameNumber LeftFrameNumberRaw LeftPupilX LeftPupilY LeftPupilWidth LeftPupilHeight LeftPupilAngle LeftIrisRadius LeftTorsion LeftUpperEyelid LeftLowerEyelid LeftDataQuality LeftCR1X LeftCR1Y LeftCR2X LeftCR2Y LeftCR3X LeftCR3Y LeftCR4X LeftCR4Y LeftCR5X LeftCR5Y RightFrameNumber RightFrameNumberRaw RightSeconds RightPupilX RightPupilY RightPupilWidth RightPupilHeight RightPupilAngle RightIrisRadius RightTorsion RightUpperEyelid RightLowerEyelid RightDataQuality RightCR1X RightCR1Y RightCR2X RightCR2Y RightCR3X RightCR3Y RightCR4X RightCR4Y RightCR5X RightCR5Y AccelerometerX AccelerometerY AccelerometerZ GyroX GyroY GyroZ MagnetometerX MagnetometerY MagnetometerZ Int0 Int1 Int2 Int3 Int4 Int5 Int6 Int7 Double0 Double1 Double2 Double3 Double4 Double5 Double6 Double7 Data
___________ _______________ __________________ __________ __________ ______________ _______________ ______________ ______________ ___________ _______________ _______________ _______________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________________ ___________________ ____________ ___________ ___________ _______________ ________________ _______________ _______________ ____________ ________________ ________________ ________________ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ ______________ ______________ ______________ _____ _____ _____ _____________ _____________ _____________ ____ ____ ____ ____ ____ ____ ____ ____ _______ _______ _______ _______ _______ _______ _______ _______ ____
0 sec 0 0 204.99 125.92 58.03 63.265 -43.59 99 0 432.47 851.93 79.385 169.49 115.84 279.53 134.16 0 0 0 0 0 0 0 0 0 195.3 132.99 56.223 59.353 26.129 109 -0.54 438.26 929.43 80.692 230.23 119.23 111.89 139 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NaN
0.01 sec 1 1 204.99 125.93 58.126 63.175 -44.066 99 0 432.47 851.93 79.4 169.62 115.89 279.53 134.16 0 0 0 0 0 0 1 1 0.01 195.31 132.98 56.253 59.343 25.995 109 -0.56 438.26 929.43 81.046 230.23 119.23 111.92 139.06 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NaN
0.02 sec 2 2 204.88 126.66 58.109 60.877 -43.862 99 -0.02 359.88 851.93 78.9 169.74 115.95 279.57 134.16 0 0 0 0 0 0 2 2 0.02 195.3 132.99 56.244 59.324 26.137 109 -0.54 438.26 929.43 81.184 230.36 119.26 111.96 139.16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NaN
0.03 sec 3 3 204.49 126.56 58.476 61.196 -28.859 99 0.2 359.88 851.93 78.724 169.84 115.93 279.57 134.16 0 0 0 0 0 0 3 3 0.03 195.37 133.27 56.032 59.478 25.764 109 -0.54 438.26 929.43 81.553 230.34 119.34 111.96 139.34 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NaN
0.04 sec 4 4 204.84 126.72 57.961 61.223 -40.685 99 0 357.53 851.93 79.485 169.93 115.89 279.63 134.11 0 0 0 0 0 0 4 4 0.04 195.37 133.25 55.967 59.709 27.929 109 -0.54 438.26 929.43 80.961 230.4 119.28 112 139.38 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NaN
0.05 sec 5 5 205.03 126.79 57.57 61.205 -45.715 99 -0.06 357.53 851.93 79.816 169.93 115.89 279.67 134.13 0 0 0 0 0 0 5 5 0.05 194.88 132.66 56.057 61.564 37.115 109 -0.3 483.72 929.43 81.153 230.5 119.3 112.02 139.44 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NaN
0.06 sec 6 6 204.94 126.59 58.1 61.045 -49.247 99 0 357.53 851.93 81.061 169.93 115.89 279.71 134.05 0 0 0 0 0 0 6 6 0.06 194.89 132.95 55.606 61.387 35.093 109 -0.24 492.08 929.43 81.661 230.51 119.4 112.02 139.44 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NaN
0.07 sec 7 7 204.93 126.65 58.067 60.97 -48.215 99 0.02 357.53 851.93 80.369 169.93 115.89 279.83 134.15 0 0 0 0 0 0 7 7 0.07 195.47 133.38 56.139 59.55 28.418 109 -0.62 438.26 929.43 81.292 230.5 119.5 112.02 139.44 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NaN
0.08 sec 8 8 204.78 126.59 58.372 60.948 -43.23 99 0.08 357.53 851.93 79.915 169.93 115.89 279.88 134.18 0 0 0 0 0 0 8 8 0.08 195.47 133.56 56.409 59.273 26.188 109 -0.56 438.26 846.28 80.038 230.48 119.7 112.02 139.56 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NaN
0.09 sec 9 9 204.97 126.71 57.965 60.848 -46.259 99 0.02 359.88 851.93 80.146 169.93 115.89 279.9 134.08 0 0 0 0 0 0 9 9 0.09 195.5 133.64 56.489 59.272 31.647 109 -0.6 438.26 846.28 80.469 230.48 119.7 111.96 139.66 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NaN
0.1 sec 10 10 204.94 126.64 58.129 60.874 -49.992 99 0.02 357.53 851.93 80.4 169.93 115.89 279.87 134 0 0 0 0 0 0 10 10 0.1 195.11 133.36 55.983 60.658 35.123 109 -0.34 481.53 844.83 80.761 230.52 119.81 111.95 139.6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NaN
0.11 sec 11 11 204.94 126.63 58.122 60.884 -50.106 99 0 357.53 851.93 80.115 169.96 115.84 279.9 134.08 0 0 0 0 0 0 11 11 0.11 195.06 133.38 55.744 60.756 34.948 109 -0.26 492.08 846.28 81.561 230.52 119.81 112.04 139.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NaN
0.12 sec 12 12 204.97 126.6 58.162 60.767 -50.134 99 0 357.53 851.93 80.284 169.93 115.89 279.9 134.08 0 0 0 0 0 0 12 12 0.12 195.49 133.63 56.524 59.203 31.602 109 -0.52 438.26 846.28 79.9 230.47 119.8 112.04 139.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NaN
0.13 sec 13 13 204.92 126.58 58.038 60.846 -47.157 99 0.02 357.53 851.93 80.354 169.93 115.89 279.95 134.07 0 0 0 0 0 0 13 13 0.13 195.05 133.37 55.768 60.718 35.293 109 -0.24 492.08 929.43 80.846 230.52 119.81 112 139.62 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NaN
0.14 sec 14 14 204.91 126.58 57.948 60.935 -46.763 99 0.04 357.53 851.93 79.639 169.93 115.89 279.92 133.98 0 0 0 0 0 0 14 14 0.14 194.97 133.62 55.376 60.245 34.676 109 -0.12 492.08 939.25 79.377 230.41 119.86 112 139.54 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NaN
0.15 sec 15 15 204.92 126.43 57.881 61.186 -45.472 99 0.26 389.69 851.93 80.269 169.93 115.89 279.87 134 0 0 0 0 0 0 15 15 0.15 195.09 133.91 55.33 59.614 30.645 109 -0.22 492.08 929.43 80.507 230.41 119.86 111.98 139.6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NaN
I initially used synchronize on your two tables, since I though that whas what you wanted to do. I am not certain that it will produce the result you want in this application.
TT1r = retime(TT1r, 'regular', 'linear', 'TimeStep',seconds(0.01))
producing —
data = readtable('cal.txt');
% data.LeftSeconds=round(data.LeftSeconds,2);
% format short
% start_time = min(data.LeftSeconds);
% end_time = max(data.LeftSeconds);
complete_time_range = (start_time:0.01:end_time)';
Timedata = data.LeftSeconds;
% missing_times = setdiff(complete_time_range, Timedata);
% missing_data = table(missing_times, nan(size(missing_times)),'VariableNames', {'Time', 'Data'});
T1r = movevars(data, 'LeftSeconds', 'Before',1);
T1r.LeftSeconds = duration(seconds(T1r.LeftSeconds));
TT1r = table2timetable(T1r)
TT1r = 1554x70 timetable
LeftSeconds LeftFrameNumber LeftFrameNumberRaw LeftPupilX LeftPupilY LeftPupilWidth LeftPupilHeight LeftPupilAngle LeftIrisRadius LeftTorsion LeftUpperEyelid LeftLowerEyelid LeftDataQuality LeftCR1X LeftCR1Y LeftCR2X LeftCR2Y LeftCR3X LeftCR3Y LeftCR4X LeftCR4Y LeftCR5X LeftCR5Y RightFrameNumber RightFrameNumberRaw RightSeconds RightPupilX RightPupilY RightPupilWidth RightPupilHeight RightPupilAngle RightIrisRadius RightTorsion RightUpperEyelid RightLowerEyelid RightDataQuality RightCR1X RightCR1Y RightCR2X RightCR2Y RightCR3X RightCR3Y RightCR4X RightCR4Y RightCR5X RightCR5Y AccelerometerX AccelerometerY AccelerometerZ GyroX GyroY GyroZ MagnetometerX MagnetometerY MagnetometerZ Int0 Int1 Int2 Int3 Int4 Int5 Int6 Int7 Double0 Double1 Double2 Double3 Double4 Double5 Double6 Double7
___________ _______________ __________________ __________ __________ ______________ _______________ ______________ ______________ ___________ _______________ _______________ _______________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________________ ___________________ ____________ ___________ ___________ _______________ ________________ _______________ _______________ ____________ ________________ ________________ ________________ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ ______________ ______________ ______________ _____ _____ _____ _____________ _____________ _____________ ____ ____ ____ ____ ____ ____ ____ ____ _______ _______ _______ _______ _______ _______ _______ _______
0 sec 0 0 204.99 125.92 58.03 63.265 -43.59 99 0 432.47 851.93 79.385 169.49 115.84 279.53 134.16 0 0 0 0 0 0 0 0 0 195.3 132.99 56.223 59.353 26.129 109 -0.54 438.26 929.43 80.692 230.23 119.23 111.89 139 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.01 sec 1 1 204.99 125.93 58.126 63.175 -44.066 99 0 432.47 851.93 79.4 169.62 115.89 279.53 134.16 0 0 0 0 0 0 1 1 0.01 195.31 132.98 56.253 59.343 25.995 109 -0.56 438.26 929.43 81.046 230.23 119.23 111.92 139.06 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.02 sec 2 2 204.88 126.66 58.109 60.877 -43.862 99 -0.02 359.88 851.93 78.9 169.74 115.95 279.57 134.16 0 0 0 0 0 0 2 2 0.02 195.3 132.99 56.244 59.324 26.137 109 -0.54 438.26 929.43 81.184 230.36 119.26 111.96 139.16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.03 sec 3 3 204.49 126.56 58.476 61.196 -28.859 99 0.2 359.88 851.93 78.724 169.84 115.93 279.57 134.16 0 0 0 0 0 0 3 3 0.03 195.37 133.27 56.032 59.478 25.764 109 -0.54 438.26 929.43 81.553 230.34 119.34 111.96 139.34 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.04 sec 4 4 204.84 126.72 57.961 61.223 -40.685 99 0 357.53 851.93 79.485 169.93 115.89 279.63 134.11 0 0 0 0 0 0 4 4 0.04 195.37 133.25 55.967 59.709 27.929 109 -0.54 438.26 929.43 80.961 230.4 119.28 112 139.38 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.05 sec 5 5 205.03 126.79 57.57 61.205 -45.715 99 -0.06 357.53 851.93 79.816 169.93 115.89 279.67 134.13 0 0 0 0 0 0 5 5 0.05 194.88 132.66 56.057 61.564 37.115 109 -0.3 483.72 929.43 81.153 230.5 119.3 112.02 139.44 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.06 sec 6 6 204.94 126.59 58.1 61.045 -49.247 99 0 357.53 851.93 81.061 169.93 115.89 279.71 134.05 0 0 0 0 0 0 6 6 0.06 194.89 132.95 55.606 61.387 35.093 109 -0.24 492.08 929.43 81.661 230.51 119.4 112.02 139.44 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.07 sec 7 7 204.93 126.65 58.067 60.97 -48.215 99 0.02 357.53 851.93 80.369 169.93 115.89 279.83 134.15 0 0 0 0 0 0 7 7 0.07 195.47 133.38 56.139 59.55 28.418 109 -0.62 438.26 929.43 81.292 230.5 119.5 112.02 139.44 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.08 sec 8 8 204.78 126.59 58.372 60.948 -43.23 99 0.08 357.53 851.93 79.915 169.93 115.89 279.88 134.18 0 0 0 0 0 0 8 8 0.08 195.47 133.56 56.409 59.273 26.188 109 -0.56 438.26 846.28 80.038 230.48 119.7 112.02 139.56 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.09 sec 9 9 204.97 126.71 57.965 60.848 -46.259 99 0.02 359.88 851.93 80.146 169.93 115.89 279.9 134.08 0 0 0 0 0 0 9 9 0.09 195.5 133.64 56.489 59.272 31.647 109 -0.6 438.26 846.28 80.469 230.48 119.7 111.96 139.66 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.1 sec 10 10 204.94 126.64 58.129 60.874 -49.992 99 0.02 357.53 851.93 80.4 169.93 115.89 279.87 134 0 0 0 0 0 0 10 10 0.1 195.11 133.36 55.983 60.658 35.123 109 -0.34 481.53 844.83 80.761 230.52 119.81 111.95 139.6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.11 sec 11 11 204.94 126.63 58.122 60.884 -50.106 99 0 357.53 851.93 80.115 169.96 115.84 279.9 134.08 0 0 0 0 0 0 11 11 0.11 195.06 133.38 55.744 60.756 34.948 109 -0.26 492.08 846.28 81.561 230.52 119.81 112.04 139.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.12 sec 12 12 204.97 126.6 58.162 60.767 -50.134 99 0 357.53 851.93 80.284 169.93 115.89 279.9 134.08 0 0 0 0 0 0 12 12 0.12 195.49 133.63 56.524 59.203 31.602 109 -0.52 438.26 846.28 79.9 230.47 119.8 112.04 139.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.13 sec 13 13 204.92 126.58 58.038 60.846 -47.157 99 0.02 357.53 851.93 80.354 169.93 115.89 279.95 134.07 0 0 0 0 0 0 13 13 0.13 195.05 133.37 55.768 60.718 35.293 109 -0.24 492.08 929.43 80.846 230.52 119.81 112 139.62 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.14 sec 14 14 204.91 126.58 57.948 60.935 -46.763 99 0.04 357.53 851.93 79.639 169.93 115.89 279.92 133.98 0 0 0 0 0 0 14 14 0.14 194.97 133.62 55.376 60.245 34.676 109 -0.12 492.08 939.25 79.377 230.41 119.86 112 139.54 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.15 sec 15 15 204.92 126.43 57.881 61.186 -45.472 99 0.26 389.69 851.93 80.269 169.93 115.89 279.87 134 0 0 0 0 0 0 15 15 0.15 195.09 133.91 55.33 59.614 30.645 109 -0.22 492.08 929.43 80.507 230.41 119.86 111.98 139.6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
% missing_data.Time = duration(seconds(missing_data.Time));
% TT2 = table2timetable(missing_data);
% TTs = synchronize(TT1r, TT2)
TT1rr = retime(TT1r, 'regular', 'linear', 'TimeStep',seconds(0.01))
TT1rr = 1957x70 timetable
LeftSeconds LeftFrameNumber LeftFrameNumberRaw LeftPupilX LeftPupilY LeftPupilWidth LeftPupilHeight LeftPupilAngle LeftIrisRadius LeftTorsion LeftUpperEyelid LeftLowerEyelid LeftDataQuality LeftCR1X LeftCR1Y LeftCR2X LeftCR2Y LeftCR3X LeftCR3Y LeftCR4X LeftCR4Y LeftCR5X LeftCR5Y RightFrameNumber RightFrameNumberRaw RightSeconds RightPupilX RightPupilY RightPupilWidth RightPupilHeight RightPupilAngle RightIrisRadius RightTorsion RightUpperEyelid RightLowerEyelid RightDataQuality RightCR1X RightCR1Y RightCR2X RightCR2Y RightCR3X RightCR3Y RightCR4X RightCR4Y RightCR5X RightCR5Y AccelerometerX AccelerometerY AccelerometerZ GyroX GyroY GyroZ MagnetometerX MagnetometerY MagnetometerZ Int0 Int1 Int2 Int3 Int4 Int5 Int6 Int7 Double0 Double1 Double2 Double3 Double4 Double5 Double6 Double7
___________ _______________ __________________ __________ __________ ______________ _______________ ______________ ______________ ___________ _______________ _______________ _______________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________________ ___________________ ____________ ___________ ___________ _______________ ________________ _______________ _______________ ____________ ________________ ________________ ________________ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ ______________ ______________ ______________ _____ _____ _____ _____________ _____________ _____________ ____ ____ ____ ____ ____ ____ ____ ____ _______ _______ _______ _______ _______ _______ _______ _______
0 sec 0 0 204.99 125.92 58.03 63.265 -43.59 99 0 432.47 851.93 79.385 169.49 115.84 279.53 134.16 0 0 0 0 0 0 0 0 0 195.3 132.99 56.223 59.353 26.129 109 -0.54 438.26 929.43 80.692 230.23 119.23 111.89 139 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.01 sec 1 1 204.99 125.93 58.126 63.175 -44.066 99 0 432.47 851.93 79.4 169.62 115.89 279.53 134.16 0 0 0 0 0 0 1 1 0.01 195.31 132.98 56.253 59.343 25.995 109 -0.56 438.26 929.43 81.046 230.23 119.23 111.92 139.06 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.02 sec 2 2 204.88 126.66 58.109 60.877 -43.862 99 -0.02 359.88 851.93 78.9 169.74 115.95 279.57 134.16 0 0 0 0 0 0 2 2 0.02 195.3 132.99 56.244 59.324 26.137 109 -0.54 438.26 929.43 81.184 230.36 119.26 111.96 139.16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.03 sec 3 3 204.49 126.56 58.476 61.196 -28.859 99 0.2 359.88 851.93 78.724 169.84 115.93 279.57 134.16 0 0 0 0 0 0 3 3 0.03 195.37 133.27 56.032 59.478 25.764 109 -0.54 438.26 929.43 81.553 230.34 119.34 111.96 139.34 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.04 sec 4 4 204.84 126.72 57.961 61.223 -40.685 99 0 357.53 851.93 79.485 169.93 115.89 279.63 134.11 0 0 0 0 0 0 4 4 0.04 195.37 133.25 55.967 59.709 27.929 109 -0.54 438.26 929.43 80.961 230.4 119.28 112 139.38 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.05 sec 5 5 205.03 126.79 57.57 61.205 -45.715 99 -0.06 357.53 851.93 79.816 169.93 115.89 279.67 134.13 0 0 0 0 0 0 5 5 0.05 194.88 132.66 56.057 61.564 37.115 109 -0.3 483.72 929.43 81.153 230.5 119.3 112.02 139.44 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.06 sec 6 6 204.94 126.59 58.1 61.045 -49.247 99 0 357.53 851.93 81.061 169.93 115.89 279.71 134.05 0 0 0 0 0 0 6 6 0.06 194.89 132.95 55.606 61.387 35.093 109 -0.24 492.08 929.43 81.661 230.51 119.4 112.02 139.44 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.07 sec 7 7 204.93 126.65 58.067 60.97 -48.215 99 0.02 357.53 851.93 80.369 169.93 115.89 279.83 134.15 0 0 0 0 0 0 7 7 0.07 195.47 133.38 56.139 59.55 28.418 109 -0.62 438.26 929.43 81.292 230.5 119.5 112.02 139.44 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.08 sec 8 8 204.78 126.59 58.372 60.948 -43.23 99 0.08 357.53 851.93 79.915 169.93 115.89 279.88 134.18 0 0 0 0 0 0 8 8 0.08 195.47 133.56 56.409 59.273 26.188 109 -0.56 438.26 846.28 80.038 230.48 119.7 112.02 139.56 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.09 sec 9 9 204.97 126.71 57.965 60.848 -46.259 99 0.02 359.88 851.93 80.146 169.93 115.89 279.9 134.08 0 0 0 0 0 0 9 9 0.09 195.5 133.64 56.489 59.272 31.647 109 -0.6 438.26 846.28 80.469 230.48 119.7 111.96 139.66 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.1 sec 10 10 204.94 126.64 58.129 60.874 -49.992 99 0.02 357.53 851.93 80.4 169.93 115.89 279.87 134 0 0 0 0 0 0 10 10 0.1 195.11 133.36 55.983 60.658 35.123 109 -0.34 481.53 844.83 80.761 230.52 119.81 111.95 139.6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.11 sec 11 11 204.94 126.63 58.122 60.884 -50.106 99 0 357.53 851.93 80.115 169.96 115.84 279.9 134.08 0 0 0 0 0 0 11 11 0.11 195.06 133.38 55.744 60.756 34.948 109 -0.26 492.08 846.28 81.561 230.52 119.81 112.04 139.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.12 sec 12 12 204.97 126.6 58.162 60.767 -50.134 99 0 357.53 851.93 80.284 169.93 115.89 279.9 134.08 0 0 0 0 0 0 12 12 0.12 195.49 133.63 56.524 59.203 31.602 109 -0.52 438.26 846.28 79.9 230.47 119.8 112.04 139.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.13 sec 13 13 204.92 126.58 58.038 60.846 -47.157 99 0.02 357.53 851.93 80.354 169.93 115.89 279.95 134.07 0 0 0 0 0 0 13 13 0.13 195.05 133.37 55.768 60.718 35.293 109 -0.24 492.08 929.43 80.846 230.52 119.81 112 139.62 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.14 sec 14 14 204.91 126.58 57.948 60.935 -46.763 99 0.04 357.53 851.93 79.639 169.93 115.89 279.92 133.98 0 0 0 0 0 0 14 14 0.14 194.97 133.62 55.376 60.245 34.676 109 -0.12 492.08 939.25 79.377 230.41 119.86 112 139.54 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.15 sec 15 15 204.92 126.43 57.881 61.186 -45.472 99 0.26 389.69 851.93 80.269 169.93 115.89 279.87 134 0 0 0 0 0 0 15 15 0.15 195.09 133.91 55.33 59.614 30.645 109 -0.22 492.08 929.43 80.507 230.41 119.86 111.98 139.6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
figure
plot(TT1r.LeftSeconds, TT1r.LeftPupilWidth)
grid
xlabel('LeftSeconds')
ylabel('LeftPupilWidth')
title('TT1r')
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1744206/image.png)
figure
plot(TT1rr.LeftSeconds, TT1rr.LeftPupilWidth)
grid
xlabel('LeftSeconds')
ylabel('LeftPupilWidth')
title('TT1rr')
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1744211/image.png)
The retime function has added 403 rows to ‘TT1rr’ that were not in ‘TT1r’ in the interpolation.
I am not certain what result you want, so we can continue to work on this until you have your desired result.
.
Austin Bollinger
on 31 Jul 2024 at 21:38
This is exactly what I am looking for with the retime function. Thank you for the support and I appreciate the assistance dearly!
Umar
on 31 Jul 2024 at 21:47
@Austin Bollinger,
You can create a logical index to identify missing times accurately. Here's example code snippet:
data = readtable('cal.txt');
data.LeftSeconds = round(data.LeftSeconds, 2);
start_time = min(data.LeftSeconds);
end_time = max(data.LeftSeconds);
complete_time_range = (start_time:0.01:end_time)';
Timedata = data.LeftSeconds;
% Find missing times using logical indexing
isMissing = ~ismember(complete_time_range, Timedata);
missing_times = complete_time_range(isMissing);
missing_data = table(missing_times, nan(size(missing_times)),
'VariableNames', {'Time', 'Data'});
T1r = movevars(data, 'LeftSeconds', 'Before', 1);
T1r.LeftSeconds = duration(seconds(T1r.LeftSeconds));
TT1r = table2timetable(T1r);
missing_data.Time = duration(seconds(missing_data.Time));
TT2 = table2timetable(missing_data);
TTs = synchronize(TT1r, TT2);
You can customize this code based on your preferences. Hope this helps.
More Answers (0)
See Also
Categories
Find more on Preprocessing Data in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!An Error Occurred
Unable to complete the action because of changes made to the page. Reload the page to see its updated state.
Select a Web Site
Choose a web site to get translated content where available and see local events and offers. Based on your location, we recommend that you select: .
You can also select a web site from the following list
How to Get Best Site Performance
Select the China site (in Chinese or English) for best site performance. Other MathWorks country sites are not optimized for visits from your location.
Americas
- América Latina (Español)
- Canada (English)
- United States (English)
Europe
- Belgium (English)
- Denmark (English)
- Deutschland (Deutsch)
- España (Español)
- Finland (English)
- France (Français)
- Ireland (English)
- Italia (Italiano)
- Luxembourg (English)
- Netherlands (English)
- Norway (English)
- Österreich (Deutsch)
- Portugal (English)
- Sweden (English)
- Switzerland
- United Kingdom (English)
Asia Pacific
- Australia (English)
- India (English)
- New Zealand (English)
- 中国
- 日本Japanese (日本語)
- 한국Korean (한국어)