R, get column names, reshaping

Asked Jun 08 '20 at 20:37

Active Jun 08 '20 at 20:37

Viewed 18 times

I'm trying to reshape wide DB to long. I want to get all column names and make them to the year column. How can I get all column names from 1961 to 2016

nsoil <- melt(soil, id.vars = c("CountryName", "Country.Code"),
              measure.vars = c(colnames("1961"......."2016")),
              variable.name = "years"
              value.name = "%AgroLands"
              )
nsoil

Thanks a lot!

asked Jun 08 '20 at 20:37

Mozzy_Tron

`1961:2016` perhaps? – markus Jun 08 '20 at 20:38
Can you please provide a minimally reproducible example of your data? It will help others to help you. https://stackoverflow.com/help/minimal-reproducible-example – Matt Jun 08 '20 at 20:41
Oh Jeez, that easy, thanks – Mozzy_Tron Jun 08 '20 at 20:44

R, get column names, reshaping

0 Answers0