How to decide interpolation technique?

3 次查看（过去 30 天）

Anak Agung Adhi Dermawan 2022-7-31

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1771410-how-to-decide-interpolation-technique

评论： Walter Roberson 2022-8-4

cbrn2020.txt

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

Walter Roberson 2022-7-31

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1771410-how-to-decide-interpolation-technique#answer_1018510

在 MATLAB Online 中打开

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 个评论
显示 5更早的评论隐藏 5更早的评论

Anak Agung Adhi Dermawan 2022-8-3

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 2022-8-4

在 MATLAB Online 中打开

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