Python for Data Science

5 questions. Use Show Answer, then slide right (or use Next) to continue.

Card 1 of 5

Question 1 Create and activate a virtual environment

python -m venv .venv

Mac/Linux:
source .venv/bin/activate

Windows:
.venv\Scripts\activate

Question 2 Read and inspect a CSV file

import pandas as pd

df = pd.read_csv("file.csv")
df.head()
df.shape
df.info()

Question 3 Group and aggregate like SQL GROUP BY

df.groupby("col").agg({"amount": "sum"}).reset_index()

Question 4 Merge two DataFrames (SQL JOIN equivalent)

df.merge(df2, on="key", how="left")

Question 5 Convert to datetime and sort

df["date"] = pd.to_datetime(df["date"])
df = df.sort_values("date")