📊 Excel to Pandas Cheatsheet
Excel Function | Pandas Equivalent |
---|---|
VLOOKUP() |
merge() |
Pivot Table | pivot_table() |
Filter | df[df["col"] == "value"] |
SUMIFS | groupby() + sum() |
Remove Duplicates | drop_duplicates() |
Sort | sort_values(by="col") |
IF Formula | np.where() or df.apply() |