Displaying 2 results from an estimated 2 matches for "prescribed_date".
2010 Mar 15
1
inner join sqldf
Hi,
I have two dataframes that have some common columns. 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.nabb...
2010 Mar 12
7
sqldf not joining all the fields
...64284,
skip = 0, check.names = TRUE,fill=TRUE,
strip.white = TRUE, blank.lines.skip = TRUE,
comment.char = "#", allowEscapes = FALSE, flush = FALSE,
fileEncoding = "", encoding = "unknown")
x_data
prochi prescribed_date dataMonth item_code res_seqno quantity directions
CAO0000713 22/06/2001 NULL 842752 NULL 60 1/D
CAO0000713 28/04/2000 NULL 7800 NULL 100G A/TD
CAO0000713 10/04/2000 NULL 842652 NULL 60 1/D
CAO0000713 03...