Turn the first row into a column

Asked Jun 11 '21 at 14:18

Active Jun 12 '21 at 07:00

Viewed 22 times

I have a spreadsheet organized by years which looks like this DATA SET:

Now, I'm pretty sure that to make this data set 'tidy' i have to turn that Year row into a column. And have as a result the 3 columns, 1 with the model name, 1 with the year, and 1 with the units produced of that model in that year. I tried a few methods I know but couldn't solve it.

Can anyone suggest a method?

EDIT: I already substituted the NA with 0

edited Jun 12 '21 at 07:00

Sinval

1,315
1
16
25

asked Jun 11 '21 at 14:18

Brick

`library(tidyverse); df %>% gather(year, value, -1)` – missuse Jun 11 '21 at 14:19
Welcome. Please don't post images of your data - use ``dput()`` instead. Thanks. – user438383 Jun 11 '21 at 14:27
Ok, I will. Thank you very much for the help in the meantime! It worked perfectly – Brick Jun 11 '21 at 23:56

Turn the first row into a column

0 Answers0