I'm currently working with short term load forecasting project.
I got my whole set of data in two columns( 1st column as the date with hour,min,sec and 2nd column as the load demand).
Now I'm having a problem in manipulating this data according to my input selection.
I wish to present my data as in
[ L(d,t) ........
L(d,t-1) ......
L(d,t-2).......
L(d+1,t)....... ]
L(d,t) = load at current hour of today
L(d,t-1) =load at 1hour ago of today
L(d+1,t) = load at current hour of tomorrow (which is also my output to be predicted)
I need to write a code to make my two columns data into what i wish to present as mentioned above. can anyone help? urgent and much appreciated.
I got my whole set of data in two columns( 1st column as the date with hour,min,sec and 2nd column as the load demand).
Now I'm having a problem in manipulating this data according to my input selection.
I wish to present my data as in
[ L(d,t) ........
L(d,t-1) ......
L(d,t-2).......
L(d+1,t)....... ]
L(d,t) = load at current hour of today
L(d,t-1) =load at 1hour ago of today
L(d+1,t) = load at current hour of tomorrow (which is also my output to be predicted)
I need to write a code to make my two columns data into what i wish to present as mentioned above. can anyone help? urgent and much appreciated.