How to load data from one data frame to other in R?

Question

I have a mini data frame

| index| data | district | month | |:----:|:------:|:---------:|:----: | | 1 | data1 | District-1| month1| | 2 | data2 | District-2| month2| and so on

I want to load the data values from the data column to the data frame which has a structure like:-

| | month1 | month2| |:--------: |:------: | -----:| | District-1| data1 | NA | | District-2| NA | data2 | and so on

In short, the data1 from the mini data frame should go to its perfect cell in the big data frame where the district and months are matching. All the cells of big data frame are filled with null.

Answer 1

You don't have District-2 in your original data (though it appears in your desired data), but generally if you wanted this, try using tidyr::pivot_wider():

# Data with district 2 in it
df <- data.frame(index  = rep(1,4),
                 data = c("data1","data2","data3","data4"),
                 district = c("District-1", "District-1", "District-2", "District-2"),
                 month = rep(c("month1","month2"),2))

library(tidyr)
df %>% pivot_wider(names_from = "month", values_from = "data") %>% select(-index)

Output

#  district   month1 month2
#  <chr>      <chr>  <chr> 
#1 District-1 data1  data2 
#2 District-2 data3  data4