interpolate the duplicate values

Question

mahdi Babayi semiromi 2023-3-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1930360-interpolate-the-duplicate-values

评论： Rik 2023-4-5

Hi

Imagine I have vector of datetime values in increaing (not strictly increasing) order, such as follows:

'14-11-2022 05:18:14.000'

'14-11-2022 05:18:15.000'

'14-11-2022 05:18:16.000'

'14-11-2022 05:18:17.000'

I want to convert every slice of duplicate values into an evenly-spaced slice, so the above vector becomes:

'14-11-2022 05:18:14.000'

'14-11-2022 05:18:14.333'

'14-11-2022 05:18:14.666'

'14-11-2022 05:18:15.000'

'14-11-2022 05:18:15.500'

'14-11-2022 05:18:16.000'

'14-11-2022 05:18:17.000'

I know how to do it with loops, just wondering if there's a clever way to do it, probably using accumarray and histcounts.

thanks

3 个评论
显示 1更早的评论隐藏 1更早的评论

mahdi Babayi semiromi 2023-4-5

Hi

Yes each run of duplicate values will end at the next second.

thanks

Rik 2023-4-5

Well, what did you try? Have you looked into run length encoding?

请先登录，再进行评论。

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

Answer 1

Gayatri Rathod 2023-3-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1930360-interpolate-the-duplicate-values#answer_1204669

在 MATLAB Online 中打开

Hi mahdi,

you can use accumarray and histcounts to achieve this in MATLAB. Here's one way to do it:

1.Convert your date values to datetime format and create input vector of it (e.g., using datetime).

% Example input vector of datetime values 
inputVec = datetime(dates); 

2. Calculate the differences between adjacent serial dates using the diff function:

diffs = diff( inputVec);

3. Use histcounts to find the indices of the duplicate values:

[~, edges, bin] = histcounts(diffs); 
idx = find(bin > 1); 

4. use accumarray to add the appropriate fractions of a second to each group of duplicate values

% Syntax 
accumarray(ind,data,[],fun) % applies the function fun to each group in data specified by ind. 
                            % Specify fun using the @symbol. for eg. @sum. 

5.Convert the resulting values back to appropriate datetime format if needed.

The resulting vector should be the evenly spaced version of the input dates.

You can read more about the accumarray, histcounts, datetime, diff and find function from the following documentations: accumarray function, histcounts function, datetime function, diff function, find function.

Hope it helps!  

Regards,

Gayatri Rathod

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

interpolate the duplicate values

3 个评论
显示 1更早的评论隐藏 1更早的评论

回答（1 个）

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

interpolate the duplicate values

3 个评论 显示 1更早的评论隐藏 1更早的评论

回答（1 个）

0 个评论 显示 -2更早的评论隐藏 -2更早的评论

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

3 个评论
显示 1更早的评论隐藏 1更早的评论

0 个评论
显示 -2更早的评论隐藏 -2更早的评论