Question

In R how do I delete rows that contain NA values

My code below dosn't give me what I am looking for

Gamma <- sqldf("SELECT DISTINCT A.Record_ID, A.Day, B.Date
FROM Slot_Info as A
LEFT JOIN Volume_Info as B
ON A.Day = B.Date
Where Date not Null ")

Answer 1

In the above given query, when you are checking for date to be null, then you are using "Date" for comparison. Since you have used an alias for the join for the table names, you must be doing this in format "tableAlias.attributeName". Also an "is" is missing.

So, if everything else like your attributes and table names are correct, then the correct query will be,

Gamma <- sqldf("SELECT DISTINCT A.Record_ID, A.Day, B.Date
FROM Slot_Info as A
LEFT JOIN Volume_Info as B
ON A.Day = B.Date
Where B.Date is not Null ")

Since, you are using equality for checking equality of A.Day and B.Date, I am assuming that A.Day and B.Date are of same data types