# Lesson 8: pandas - reading and exploring data
import pandas as pd
df = pd.read_csv("sales.csv", parse_dates=["date"])
print(df.shape)                  # (rows, columns)
print(df.dtypes.to_string())
print(df.head(3).to_string(index=False))
df["amount"] = df["qty"] * df["rate"]
print("Total sales:", f"{df['amount'].sum():,}")
print("Laptop orders:", (df["product"] == "Laptop").sum())
big = df[(df["amount"] > 100000) & (df["region"] == "North")]
print("Big North orders:", len(big))