-1

With California Traffic Collision Data from Kaggle I want to join two tables based on case id but selecting only rows that have a collision date of > 2020:

con = sqlite3.connect(".../switrs.sqlite")

df_sqllite = pd.read_sql_query('SELECT * FROM parties JOIN collisions USING (case_id) WHERE collision_date >= "2020-01-01"', con)

I get this error:

DatabaseError: Execution failed on sql 'SELECT * FROM parties JOIN collisions USING (case_id) WHERE collision_date >= "2020-01-01"': database or disk is full

How to solve this?

user4157124
  • 2,809
  • 13
  • 27
  • 42
Jean-Paul Azzopardi
  • 401
  • 1
  • 2
  • 10

1 Answers1

0

SELECT * FROM parties as p JOIN collisions as c USING c.case_id WHERE c.collision_date >= "2020-01-01

Lev Tikhonov
  • 1
  • 3
  • As it’s currently written, your answer is unclear. Please [edit] to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Nov 25 '22 at 06:17