I've been stuck on the following query. I'm trying to delete half of the rows in my dataframe that contain a certain string. Here is my code:
sqldf("Delete * From CyclicTest Where ( SELECT month from CyclicTest Where ( SELECT TOP 50 PERCENT where month = 'May'"))
Is sqldf the best way? or is there a different way I could go about this?