Reading Data from CSVs and Databases

From CSV

import pandas as pd

df = pd.read_csv('sales_data.csv')

From SQL Database

from sqlalchemy import create_engine

engine = create_engine('postgresql://user:pass@localhost/db')

df = pd.read_sql('SELECT * FROM orders', engine)

Pro Tip

Pandas works seamlessly with your existing SQL skills. You can pull data with SQL and manipulate it in Python.

*Day 105: Selecting and Filtering Data.*