Question: # Step 3 : Understand the data using SQL ( via SQLDF ) > ############## 5 . how many accidents happen on Sunday? > #

# Step 3: Understand the data using SQL (via SQLDF)
> ############## 5. how many accidents happen on Sunday?
> # Use sql to count how many accidents on "Sunday"
> sun_acc <- sqldf("SELECT COUNT(*) as sunday_accidents FROM df1 WHERE day_of_week = 'Sun'")
Error in `[.data.frame`(data, setdiff(names(data), names(field_types))) :
undefined columns selected

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!