Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- case_ids = ['5454655', '4083087']
- case_ids_str = ', '.join([f"'{case_id}'" for case_id in case_ids])
- query = f'''
- SELECT *
- FROM collisions
- WHERE case_id IN ({case_ids_str});
- '''
- df_sample_collisions = pd.read_sql_query(query, con = engine)
- df_sample_collisions
- query = f'''
- SELECT *
- FROM parties
- WHERE case_id IN ({case_ids_str});
- '''
- df_sample_parties = pd.read_sql_query(query, con = engine)
- df_sample_parties.sort_values(by='case_id')
- query = f'''
- SELECT *
- FROM vehicles
- WHERE case_id IN ({case_ids_str});
- '''
- df_sample_vehicles = pd.read_sql_query(query, con = engine)
- df_sample_vehicles.sort_values(by='case_id')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
