I have multiple dataframes with two columns in common
events. I know this is pretty basic stuff but for some reason, I cannot seem to join them in a way that doesn't create new rows. I tried all variations of
join() but either new rows were added or data was omitted. Any help on where I am going wrong would be much appreciated.
wave_ps_coda <- read_delim(file = "https://gitlab.com/Bryanrt-geophys/ml-seismic-application/-/raw/master/R_wrangle_data/wave_ps_coda.csv", delim = ",", col_names = T) wave_data <- read_delim(file = 'https://gitlab.com/Bryanrt-geophys/ml-seismic-application/-/raw/master/R_wrangle_data/wave_data.csv', delim = ",", col_names = T) hypo_data <- read_delim(file = 'https://gitlab.com/Bryanrt-geophys/ml-seismic-application/-/raw/master/R_wrangle_data/hypo71_data.csv', delim = ",", col_names = T)
left_join(wave_ps_coda, hypo_data) right_join(wave_ps_coda, hypo_data) inner_join(wave_ps_coda, hypo_data) full_join(wave_ps_coda, hypo_data)
From there, I imagine I could
%>% ..._join(, wave_data) to bring in the third dataframe. Am I going in the right direction?