how to normalize data?

Question

Jan Risn 2019-7-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/472107-how-to-normalize-data

编辑： Adam Danz 2019-7-19

sample1.mat

Hi all

I have a wrong program step. I don't know what is wrong with my program script.

I have data per 10 minutes which is divided into 7 columns, time and data.

09/10/2014 3:00 0

09/10/2014 3:10 0

09/10/2014 3:30 0.4

09/10/2014 3:50 0.4

09/10/2014 4:00 0.4

09/10/2014 4:10 0.4

09/10/2014 4:20 0.4

09/10/2014 4:30 0.4

10/10/2014 4:40 0.4

09/10/2014 4:50 0.4

09/10/2014 5:00 0.4

09/10/2014 5:10 0.4

09/10/2014 5:20 0.4

It can be seen that at 3:20 a.m. and the value of the data is empty, I want to get data per 10 minutes with empty data filled with 0 / nan.

I use matlab 2014b. there is no retime function so I have trouble ... I have asked before in this forum but have not received suggestions that are in accordance with this program. I attach the following data. I say thank you to anyone who has tried to help and advise ...

jan risn

4 个评论
显示 2更早的评论隐藏 2更早的评论

Adam Danz 2019-7-18

编辑：Adam Danz 2019-7-18

在 MATLAB Online 中打开

The attached data do not match the example you provided in your question. Are we tp assume the columns in your data are [year, month, day, hour, minute, fraction-of-minute]?

>> sample(1:5,:)
ans =
        2014           8          10           8          20           0           0
        2014           8          10           8          30           0           0
        2014           8          10           8          40           0           0
        2014           8          10           8          50           0           0
        2014           8          10           9           0           0           0

What's column 1? At the end of the matrix there are weird year numbes.

>> sample(end-6:end,:)
ans =
           37            6            5           22           50            0          0.4
           37            6            5           23            0            0          0.4
           37            6            5           23           10            0          0.4
           37            6            5           23           20            0          0.4
           37            6            5           23           30            0          0.4
           37            6            5           23           40            0          0.4
           37            6            5           23           50            0          0.4

Row #95 doesn't have a day value

>> sample(95,:)
ans =                                          %v
        2014           9          10           0           0           0           0

The data needs a bit more explanation and/or cleaning.

Jan Risn 2019-7-19

thank you, it looks like I've found a solution to my problem. thank you for contributing in justifying my program. im sorry i delete and edit my comment. thank you

Adam Danz 2019-7-19

编辑：Adam Danz 2019-7-19

Sometimes merely discussing the problems leads the questioner to their solution ;)

请先登录，再进行评论。

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

how to normalize data?

4 个评论
显示 2更早的评论隐藏 2更早的评论

回答（0 个）

社区

另请参阅

类别

标签

Community Treasure Hunt

how to normalize data?

4 个评论 显示 2更早的评论隐藏 2更早的评论

回答（0 个）

社区

另请参阅

类别

标签

Community Treasure Hunt

4 个评论
显示 2更早的评论隐藏 2更早的评论