0

Programming in R using Tidyverse I have 5 separate publicly available datafiles with the same information with one datafile for each of 5 different years. I want them joined in one file so I can do growth modeling. I trimmed each to have the exact same columns. My problem is that I cannot find a unique identifier to join them. When I tried inner_join, the column names came across correctly, but there were no observations. How do I join these files? Here is a link to the datafiles I am using. I have cleaned the column names to be lowercase with no spaces.

https://caaspp-elpac.cde.ca.gov/caaspp/researchfiles/sb_ca2019_all_19_csv_v4.zip

Progman
  • 16,827
  • 6
  • 33
  • 48
Donna
  • 1
  • 1
  • 2
    You can add a column "Year" to each data.frame with the year number, then use `bind_rows(df1,df2,df3,df4,df5)` to make an unique data.frame – Ric Oct 15 '22 at 23:41

0 Answers0