Corresponding data arrangement problem

1 次查看（过去 30 天）
peter huang
peter huang 2023-2-13
回答： Lei Hou 2023-3-24
I have four time series data, each time data length is different and each data has different gaps I want to sort them out according to the comparison date, so I first create a complete time axis
How do I make the data correspond to the time it belongs to and put it into the corresponding column attach my file The effect I want to achieve is similar to the excel I attached Because I want to use bar to present its data, I need to put the corresponding data together

请先登录，再回答此问题。

回答（1 个）

Lei Hou
Lei Hou 2023-3-24
Hi Peter,
You can create timetables from your data and use synchronize to to merge them into one timetable.
>> load('plot_tidal_asymmetry_data_112_wl_2.mat')
>> tt_112 = timetable(plot_end_time_yr_112_wl_2',main_asymmetry_112_wl_2',main_asymmetry_112_wl_2_bar,plot_sum_tidal_asymmetry_triads_num_112_wl_2','VariableNames',{'main_asymmetry_112_wl_2' 'main_asymmetry_112_wl_2_bar' 'plot_sum_tidal_asymmetry_triads_num_112_wl_2'})
>> load('plot_tidal_asymmetry_data_1102_wl_2.mat')
>> tt_1102 = timetable(plot_end_time_yr_1102_wl_2',main_asymmetry_1102_wl_2',main_asymmetry_1102_wl_2_bar,plot_sum_tidal_asymmetry_triads_num_1102_wl_2','VariableNames',{'main_asymmetry_1102_wl_2' 'main_asymmetry_1102_wl_2_bar' 'plot_sum_tidal_asymmetry_triads_num_1102_wl_2'})
>> load('plot_tidal_asymmetry_data_1116_wl_2.mat')
>> tt_1116 = timetable(plot_end_time_yr_1116_wl_2',main_asymmetry_1116_wl_2',main_asymmetry_1116_wl_2_bar,plot_sum_tidal_asymmetry_triads_num_1116_wl_2','VariableNames',{'main_asymmetry_1116_wl_2' 'main_asymmetry_1116_wl_2_bar' 'plot_sum_tidal_asymmetry_triads_num_1116_wl_2'})
>> load('plot_tidal_asymmetry_data_1436_wl_2.mat')
>> tt_1436 = timetable(plot_end_time_yr_1436_wl_2',main_asymmetry_1436_wl_2',main_asymmetry_1436_wl_2_bar,plot_sum_tidal_asymmetry_triads_num_1436_wl_2','VariableNames',{'main_asymmetry_1436_wl_2' 'main_asymmetry_1436_wl_2_bar' 'plot_sum_tidal_asymmetry_triads_num_1436_wl_2'})
>> tt = synchronize(tt_112,tt_1102,tt_1116,tt_1436)
tt =
35×12 timetable
Time main_asymmetry_112_wl_2 main_asymmetry_112_wl_2_bar plot_sum_tidal_asymmetry_triads_num_112_wl_2 main_asymmetry_1102_wl_2 main_asymmetry_1102_wl_2_bar plot_sum_tidal_asymmetry_triads_num_1102_wl_2 main_asymmetry_1116_wl_2 main_asymmetry_1116_wl_2_bar plot_sum_tidal_asymmetry_triads_num_1116_wl_2 main_asymmetry_1436_wl_2 main_asymmetry_1436_wl_2_bar plot_sum_tidal_asymmetry_triads_num_1436_wl_2
___________ _______________________ _______________________________________ ____________________________________________ ________________________ _______________________________________ _____________________________________________ ________________________ _______________________________________ _____________________________________________ ________________________ _________________________________________ _____________________________________________
31-Dec-1951 NaN NaN NaN NaN NaN 0.26639 0.29424 -0.0148 -0.013051 0.33558 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31-Dec-1953 NaN NaN NaN NaN NaN -0.086358 -0.11334 0.017934 0.0090482 -0.13631 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31-Dec-1955 NaN NaN NaN NaN NaN 0.069314 0.049025 0.020282 6.7497e-06 0.041818 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31-Dec-1957 NaN NaN NaN NaN NaN 0.0511 0.018285 0.033564 -0.00074825 0.057067 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31-Dec-1959 NaN NaN NaN NaN NaN 0.019352 0.022804 -0.0027581 -0.00069359 0.036589 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31-Dec-1961 NaN NaN NaN NaN NaN -0.0057549 -0.042404 0.033073 0.0035765 -0.044242 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31-Dec-1963 NaN NaN NaN NaN NaN -0.027709 -0.05559 0.020879 0.007001 0.036814 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31-Dec-1965 NaN NaN NaN NaN NaN -0.022244 -0.029785 0.0044687 0.0030724 -0.040044 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31-Dec-1969 NaN NaN NaN NaN NaN -0.066137 -0.094939 0.028659 0.00014271 -0.010536 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31-Dec-1971 NaN NaN NaN NaN NaN -0.18947 -0.17038 -0.01004 -0.0090536 -0.18113 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
31-Dec-1973 NaN NaN NaN NaN NaN -0.11287 -0.085395 -0.028358 0.00088489 -0.1084 NaN NaN NaN NaN NaN 0.014166 0.019471 -0.013323 0.0080181 0.012136
: : : : : : : : : : : : :
31-Dec-2001 0.03207 0.026066 -0.010157 0.01616 0.031573 0.053213 0.039369 0.014563 -0.00071887 0.011054 -0.015739 0.024193 -0.01467 -0.025262 -0.015598 NaN NaN NaN NaN NaN
31-Dec-2003 -0.031383 -0.040934 -0.013026 0.022577 -0.031703 -0.031548 -0.049876 0.021014 -0.002686 -0.072253 0.053349 0.057457 -0.017285 0.013176 0.051255 -0.029609 -0.022554 -0.0024101 -0.0046445 -0.026542
31-Dec-2005 -0.078674 -0.04977 -0.00098186 -0.027922 -0.08015 0.069844 0.056118 0.019239 -0.0055136 -0.0052635 -0.010873 0.0021299 -0.012388 -0.00061527 -0.012206 -0.0093268 -0.020488 0.0091918 0.0019693 -0.0080205
31-Dec-2007 0.037756 0.080269 -0.014261 -0.028252 0.034638 0.14796 0.15528 -0.0030424 -0.0042786 0.11641 0.039896 0.04923 -0.020131 0.010797 0.045699 0.016412 0.019259 -0.012214 0.0093669 0.018587
31-Dec-2009 -0.099792 -0.061664 -0.0066194 -0.031508 -0.10754 -0.18414 -0.086861 -0.00619 -0.091086 -0.50633 0.032959 0.055016 -0.022079 2.2165e-05 0.029932 0.022498 0.018639 -0.00014331 0.0040028 0.020369
31-Dec-2011 -0.098349 -0.080599 0.0072445 -0.024994 -0.093391 -0.01947 -0.035081 0.01643 -0.00081847 0.0036598 0.037581 0.033193 -0.0072986 0.011686 0.033403 0.037826 0.018888 0.012879 0.0060595 0.034431
31-Dec-2013 0.10467 0.056995 0.011195 0.036477 0.12637 0.20943 0.22665 0.013524 -0.030742 0.13818 0.031478 0.051611 -0.007724 -0.012408 0.026956 0.00096473 -0.00059378 0.0066965 -0.005138 -0.00085702
31-Dec-2015 -0.020785 -0.056108 0.012345 0.022978 -0.023904 -0.0081235 0.028664 -0.011627 -0.02516 -0.109 -0.013326 -0.054366 0.024277 0.016763 -0.013452 0.0052183 -0.0051179 0.014128 -0.0037922 0.0036449
31-Dec-2017 -0.10966 -0.12825 0.012653 0.0059333 -0.09846 -0.085978 -0.09217 -0.014282 0.020474 -0.026212 0.076486 0.059032 0.011876 0.0055775 0.072806 0.010684 -0.0049836 0.012948 0.0027199 0.01146
31-Dec-2019 0.12805 0.071649 0.0054729 0.050927 0.13043 0.11875 0.20591 -0.0072936 -0.079868 -0.047419 0.035328 -0.012123 0.021073 0.026378 0.034132 0.0090387 0.002547 0.0035261 0.0029655 0.0044127
31-Dec-2021 -0.059676 0.0044596 0.0051614 -0.069297 -0.065802 0.031988 0.037986 -0.0050555 -0.00094273 0.014526 0.024494 0.03367 0.0070983 -0.016275 0.019657 0.028032 0.011231 0.012938 0.0038637 0.025186
Display all 35 rows.

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by