How to decide interpolation technique?

13 views (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
Anak Agung Adhi Dermawan
Anak Agung Adhi Dermawan on 3 Aug 2022
Sir, I can only plot the timetable data using stackedplot command, how can I plot the Var4 data with different aggregation and resample result with hold on command?
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)

Categories

Find more on Interpolation of 2-D Selections in 3-D Grids in Help Center and File Exchange

Products


Release

R2021b

Community Treasure Hunt

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

Start Hunting!