There is a slight difference in the way sqldf treats variable names between R 3.1.1+ (‘sqldf’ version 0.4-10+) and 3.0.2 (‘sqldf’ version 0.4-6.4). If you run the code below, the variable separated by a period will be altered to be separated by an underscore in the older version and will remain period separated in the newer version. Posting here in case someone else is having difficulty with migrating code from older versions.
set.seed(123)
Data1 <- data.frame(
X = sample(1:10),
Y.n = (sample(c("E6 ", " B5"), 10, replace=T))
)
Data2 <- data.frame(
X = sample(1:10),
A = sample(c("Joined", "Yep joined"), 10, replace = TRUE)
)
require(sqldf)
DataSqldf <- sqldf('SELECT * FROM Data1 JOIN Data2 ON Data1.X = Data2.X')
require(stringr)
DataSqldf$Y_n <- str_trim(DataSqldf$Y_n, side = "both")
Question: Is there a good collation of change logs for packages?