Snowpark DataFrames — Question 3

Building on the last question, adjust the line where you use df_table.filter by adding the .select method and COL to the end of that line to only pull two columns: MENU_ITEM_NAME and ITEM_CATEGORY. (So now you’re pulling the “The Mac Shack” rows and those two columns.) As we discussed in the video, using more than one method in a single statement like this is called chaining. When you run the worksheet, what are the two different kinds of item categories you see in the results?