Appendix B — pandas Cheat Sheet

df.head()
df.tail()
df.shape
df.columns
df.dtypes
df.info()
df.describe()

B.1 Select and filter

df["city"]
df[["city", "value"]]
df.loc[df["value"] > 10]
df.iloc[:5, :3]

B.2 Transform

df.rename(columns={"old": "new"})
df.assign(rate=df["part"] / df["total"])
df.sort_values("value", ascending=False)
df.drop_duplicates("id")