merge(Divvy_Trips_2019_NEW,Divvy_Trips_2020_Q1,by=c("start_time","end_time","start_station_name","start_station_id","end_station_name","end_station_id","user_type")) Error in fix.by(by.x, x) : 'by' must specify uniquely valid columns
I am not sure why I am getting this error message, I am trying to combine two clean large data sets, all with the same column names and formatting in the cells. I have tried inner joining, full_join, nothing is working. When I have managed to combine the data, I receive a data chart with all of my values, but doubled.
How can I merge two data sets with the same column names to format perfectly into a single data chart?
Megan Rainey is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
4