Read values in dataframe and store it in a vector

Question

I have a dataframe like this

  X  2001,2002,2003
 JAN   NA,1,2
 JUN   NA,2,3
 DEC   1,2,NA

I want an empty vector to store values and generate a time series What can I do

Intended output formated by month and year, omit NAs

 output=c(1,1,2,2,2,3)

How can I do?

If rows and columns were in desired order, you could try: as.vector(na.omit(unlist(df[-1]))) — Ben
– Ben, Commented Feb 23, 2020 at 3:30

m_ky · Accepted Answer · 2020-02-22 00:31:22Z

1

You might go that direction:

library(tidyverse)

dta <- tribble(
  ~X,    ~"2001", ~"2002", ~"2003",
  "JAN", NA,      1,       2,
  "JUN", NA,      2,       3,
  "DEC", 1,       2,       NA)

dta %>%
  pivot_longer(cols = '2001':'2003', 
               names_to = "year", 
               values_to = "val") %>%
  arrange(year) %>%
  filter(!is.na(val))

However, you need to assure that the months are sorted correctly.

answered Feb 22, 2020 at 0:31

m_ky

516 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Read values in dataframe and store it in a vector

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related