search for: test_sql_psd

Displaying 1 result from an estimated 1 matches for "test_sql_psd".

2010 Mar 15
1
inner join sqldf
...umns. I would like to join them by the common columns prochi and prescribed_date as there are duplicate prochis but they will be made unique by date. I tried doing an inner join but that just duplicated the columns whereas I would like the information from the test_sql_tsf to fill the NAs in the test_sql_psd common columns. require(sqldf) test_sql_psd <- http://n4.nabble.com/file/n1593282/test_sql_psd.txt test_sql_psd.txt , header=TRUE, sep="\t", dec=".", na.strings="NA", check.names=TRUE, quote= "\"'") test_sql_tsf <-read.table(file= http:/...