Hi,
I have coding experience, but not with R and I have a question I wonder if someone could help me with please.
I trying to merge and filter a file ("temp_data") that has already been filtered (successfully) using tables created from excel worksheets. However, this second stage of filtering is not proving successful as I am finding 0 records.
temp_data <- merge(temp_data, sdate[,c("Date","Select_d","GMT")],by.x = "date_1", by.y = "Date",all.x = TRUE) %>%
filter(Select_d==1)
Both "date_1" and "Date" have the same format, i.e. 2019-04-29, where "Select_d" is equal to 1, so there should be some matches.
Apologies if I haven't given enough details here but please let me know if so and I will of course be happy to provide them.
Many thanks.