PANDAS TUTORIALS

Answer Key

1. engine = create_engine('postgresql+psycopg2://test:test@localhost:5432/ecommerce_shop')
2. pd.read_sql_table('customers', con=engine)
3. pd.read_sql_table('orders', con=engine)
4. most_recent_orders = pd.read_sql('SELECT first_name, last_name, MAX(order_date) AS order_date FROM customers JOIN orders ON customers.id = orders.customer_id', con=engine)
5. top_orders = pd.read_sql('SELECT * FROM orders ORDER BY total_price LIMIT 5', con=engine)
6. most_recent_orders.to_sql('most_recent_orders', con=engine, if_exists='fail')