Python Automation #3: Data ingestion w/pandas, SQLAlchemy, dataprep.connector, petl
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 ...
anixblog.hashnode.dev6 min read