reshape

[Giovanni Di Prete]

Dear all,
the structure of my dataset is shown in the first attachment. the first variable is the date, the second variable is the time. Then, the remaining variables are several time series: each of them contains the output produced by a specific plant (each plant name is made of two parts: "type"_"plant"). Is there a way to reshape the dataset to make it as in the second attachment?

[Marcos Almeida]

Hello Giovanni,

I fear the best way to present you data is not by sharing images, but by inputting a few observations with the original scheme and the new one you wish to provide.

That said, I took a glimpse at the images you sent and I found it hard to spot the "id" variable. It's a crucial point. This being done, your task will become quite easier.

You may also want to take a look at - help reshape - and see interesting examples.

Hopefully it helps.

Best,

Marcos