Why won't my rows merge, even though my variables are identical?

1
votes

I have two very basic data sets, GVA and Comptroller, that I am trying to merge based on Address and Participant Age Group, but the observations aren't actually being joined. I want Participant Names from GVA with the details from the other.

newmerge<-merge(Philadelphia_PA_Nonfatal_Shootings_Sheet_Jan_1_Sept_30_2021, export_89ce5a4e_f66a_4a10_8fdd_ee778a7e3d66, by=c("Address", "Participant Age Group"), all=TRUE)

This is what I get Results after Merge with Unmatched Rows:

Results after Merge with Unmatched Rows I have checked that my variables are both character format, along with other commong troubleshoots from this sight, so any advice is welcome.

rjoinmergeduplicatesrow
Please provide a minimal example with data & code. You can post your data with dput() – MKR
add some relevant sample data using dput().. (i.e.: no images!) – Wimpel
Agree with MKR and Wimpel. By the way, this is the longest and most complicated names for data frames I have ever seen. – www