| 1 | Removing Columns | Table.RemoveColumns(Source, {"Column1", "Column2"}) | df.drop(columns=["Column1", "Column2"]) |
| 2 | Filtering Rows | Table.SelectRows(Source, each [Column1] > 10) | df[df["Column1"] > 10] |
| 3 | Renaming Columns | Table.RenameColumns(Source, { "OldName" => "NewName" }) | df.rename(columns={"OldName": "NewName"}) |
| 4 | Adding a New Column | Table.AddColumn(Source, "NewColumn", each [Column1] * 2, type number) | df["NewColumn"] = df["Column1"] * 2 |
| 5 | Changing Data Type | Table.TransformColumnTypes(Source, { "Column1", type number }) | df["Column1"] = df["Column1"].astype(int) |
| 6 | Sorting Data | Table.Sort(Source, {{"Column1", Order.Ascending}}) | df.sort_values(by="Column1", ascending=True) |
| 7 | Grouping & Aggregating | Table.Group(Source, {"Category"}, {{"Total", each List.Sum([Value]), type number}}) | df.groupby("Category")["Value"].sum().reset_index() |
| 8 | Removing Duplicates | Table.Distinct(Source) | df.drop_duplicates() |
| 9 | Merging (Joining) Tables | Table.NestedJoin(Source, "ID", OtherTable, "ID", "NewTable", JoinKind.LeftOuter) | df.merge(other_df, on="ID", how="left") |
| 10 | Pivoting Data | Table.Pivot(Source, List.Distinct(Source[Category]), "Category", "Value", List.Sum) | df.pivot_table(index="IndexColumn", columns="Category", values="Value", aggfunc="sum") |
| 11 | Replacing Missing/Null Values | Table.ReplaceValue(Source, null, 0, Replacer.ReplaceValue, {"Column1"}) | df["Column1"] = df["Column1"].fillna(0) |
| 12 | Dropping Rows with Nulls | Table.SelectRows(Source, each [Column1] <> null) | df.dropna(subset=["Column1"]) |
| 13 | Filling Missing Values | Table.FillDown(Source, {"Column1"}) | df["Column1"] = df["Column1"].ffill() |
| 14 | Unpivoting Data | Table.UnpivotOtherColumns(Source, {"ID"}, "Attribute", "Value") | df.melt(id_vars=["ID"], var_name="Attribute", value_name="Value") |
| 15 | Pivoting Data (Wide Format) | Table.Pivot(Source, List.Distinct(Source[Category]), "Category", "Value", List.Sum) | df.pivot_table(index="ID", columns="Category", values="Value", aggfunc="sum") |