Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- for table_name, table_data in tables.items():
- query = '''
- DELETE FROM {} WHERE year_of_release BETWEEN '{}'::TIMESTAMP AND '{}'::TIMESTAMP
- '''.format(table_name, start_dt, end_dt)
- engine.execute(query)
- table_data.to_sql(name=table_name, con=engine, if_exists='append', index=False)
- print('All done.')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement