Question

You are using a Jupyter Notebook to explore data in a DataFrame named productDF. You want to write some inline SQL by using the following code, and visualize the results as a scatter plot: %%sql SELECT cost, price FROM product What should you do before running a cell with the %%sql magic? a. Create a new DataFrame named product from productDF.select("cost", "price") b. Persist the productDF DataFrame using productDF.createOrReplaceTempView("product") c. Filter the productDF dataframe using productDF.filter("cost == price") d. Rename the columns in the productDF DataFrame using productDF.withColumnRenamed("cost", "price")

Answer 1

You need to explain it more simple as everyone is clueless