Fill in the missing time stamps in measurment data when the system is runnign but not when the system was OFF
Hello everyone,
I have 3 measurements in 3 excel sheets, each having two columns : Time stamp, State
The data is more or less continuously recorded (with different time resolution in 3 sheets) when the system was running and is discontinuous when the system was OFF.
What i want is for all the time stamps to match each other so that i can do my analysis.
I tried to import it in Matlab, and match the time stamps. I got some results by making the whole data continuous (i.e. filling in the missing time stamps). However this is not what i want as i would like to keep the discontinuity when the system was OFF so that the histogram data doesnt count unnecessary information.
I have attached a portion of the 3 excel sheets for example (In the raw data the discontinuity also happens for DAY as the system was turned OFF at night).
As one can see Data1.xlsx has the best time resolution and i would like if Data2 and Data3 could also match this time by filling in the missing points. However one can also see that there is a huge discontinuity between 12:53 and 14:01 which i would like to keep that way.
I kindly request someone to help me with this problem.Hello everyone,
I have 3 measurements in 3 excel sheets, each having two columns : Time stamp, State
The data is more or less continuously recorded (with different time resolution in 3 sheets) when the system was running and is discontinuous when the system was OFF.
What i want is for all the time stamps to match each other so that i can do my analysis.
I tried to import it in Matlab, and match the time stamps. I got some results by making the whole data continuous (i.e. filling in the missing time stamps). However this is not what i want as i would like to keep the discontinuity when the system was OFF so that the histogram data doesnt count unnecessary information.
I have attached a portion of the 3 excel sheets for example (In the raw data the discontinuity also happens for DAY as the system was turned OFF at night).
As one can see Data1.xlsx has the best time resolution and i would like if Data2 and Data3 could also match this time by filling in the missing points. However one can also see that there is a huge discontinuity between 12:53 and 14:01 which i would like to keep that way.
I kindly request someone to help me with this problem. Hello everyone,
I have 3 measurements in 3 excel sheets, each having two columns : Time stamp, State
The data is more or less continuously recorded (with different time resolution in 3 sheets) when the system was running and is discontinuous when the system was OFF.
What i want is for all the time stamps to match each other so that i can do my analysis.
I tried to import it in Matlab, and match the time stamps. I got some results by making the whole data continuous (i.e. filling in the missing time stamps). However this is not what i want as i would like to keep the discontinuity when the system was OFF so that the histogram data doesnt count unnecessary information.
I have attached a portion of the 3 excel sheets for example (In the raw data the discontinuity also happens for DAY as the system was turned OFF at night).
As one can see Data1.xlsx has the best time resolution and i would like if Data2 and Data3 could also match this time by filling in the missing points. However one can also see that there is a huge discontinuity between 12:53 and 14:01 which i would like to keep that way.
I kindly request someone to help me with this problem. time series MATLAB Answers — New Questions