Pandas & NumPy Cheat Sheet
NumPy
np.array([1, 2, 3]); np.zeros((2, 3)); np.arange(0, 10, 2); np.linspace(0, 1, 5)
a.shape; a.reshape(3, 4); a.T; a.flatten()
a[a > 5]; np.where(a > 5, 1, 0)
a.sum(axis=0); a.mean(); a.std(); a.argmax()
a @ b; np.linalg.inv(m)
Load and inspect
df = pd.read_csv("file.csv")
df.head(); df.info(); df.describe(); df.shape
df["col"].value_counts(); df.isna().sum()
df.to_csv("out.csv", index=False)
Select and filter
df["a"]; df[["a", "b"]]
df.loc[rows, cols]; df.iloc[0:5, 0:2]
df[(df.a > 1) & (df.b == "x")]
df.query("a > 1"); df[df.c.isin(["x", "y"])]
df.sort_values("a", ascending=False)
Clean and transform
df.dropna(); df.fillna(0); df.drop_duplicates()
df.rename(columns={"a": "b"}); df.drop(columns=["c"])
df["d"] = pd.to_datetime(df["d"])
df["s"] = df["s"].str.strip().str.lower()
df["n"] = pd.to_numeric(df["n"], errors="coerce")
Group, merge, reshape
df.groupby("k")["v"].agg(["mean", "sum", "count"])
pd.pivot_table(df, index="a", columns="b", values="v", aggfunc="sum")
pd.merge(a, b, on="id", how="left")
pd.concat([a, b], ignore_index=True)
df.melt(id_vars="id"); df.set_index("date").resample("ME").sum()
Full Pandas & NumPy documentation