Python Automation #3: Data ingestion w/pandas, SQLAlchemy, dataprep.connector, petl

Dec 6, 2024 · 6 min read · 1. Read Data from CSV, Excel, or JSON (pandas.read_csv, pandas.read_excel, pandas.read_json) Read CSV: import pandas as pd # Read data from CSV df = pd.read_csv("data.csv") print(df.head()) Output (Sample): ID Name Age 0 1 Alice 25 1 2 ...