How to decide interpolation technique?

1 view (last 30 days)
Hello, I plot the first column and fourth column of this txt file time series data and there are some empty data . how can I know what percentage of the empty data and interpolate the data?

Accepted Answer

Walter Roberson
Walter Roberson on 31 Jul 2022
You might want to choose a different aggregation method such as 'minutely'
format long g
filename = 'https://www.mathworks.com/matlabcentral/answers/uploaded_files/1083480/cbrn2020.txt';
data = readtable(filename);
data{1:5,1}
ans = 5×1
1.0e+00 * 2019.99863013699 2019.99863964992 2019.99864916286 2019.9986586758 2019.99866818874
tt = table2timetable(data, 'RowTimes', datetime(0,0,0) + years(data{:,1}));
ttt = retime(tt(:,4), 'daily', 'sum');
ttt(1:5,:)
ans = 5×1 timetable
Time Var4 ___________ ________________ 29-Nov-2019 504.559662800325 30-Nov-2019 771.212892908936 01-Dec-2019 772.532087984068 02-Dec-2019 773.057727623874 03-Dec-2019 763.898137033537
plot(ttt, 'Var4')
  7 Comments
Walter Roberson
Walter Roberson on 4 Aug 2022
You can always extract data, such as
ttt.Var4
You can do things like,
aggregations = {'hourly', 'daily', 'monthly'};
for K = 1 : length(aggrevations)
ttt = retime(tt(:,4), aggrevations{K}, 'sum');
plot(ttt.Properties.RowTimes, ttt.Var4, 'DisplayName', aggrevations{K});
hold on
end
hold off
legend show

Sign in to comment.

More Answers (0)

Products


Release

R2021b

Community Treasure Hunt

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

Start Hunting!