How to decide interpolation technique?
13 views (last 30 days)
Show older comments
Anak Agung Adhi Dermawan
on 31 Jul 2022
Commented: Walter Roberson
on 4 Aug 2022
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?
0 Comments
Accepted Answer
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}
tt = table2timetable(data, 'RowTimes', datetime(0,0,0) + years(data{:,1}));
ttt = retime(tt(:,4), 'daily', 'sum');
ttt(1:5,:)
plot(ttt, 'Var4')
7 Comments
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
More Answers (0)
See Also
Categories
Find more on Interpolation of 2-D Selections in 3-D Grids 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!