Question 1

Create a Python program to access the Excel workbook and store the three spreadsheets as three MySQL tables in your MySQL database.

Question 2

Construct a single MySQL query to create a new table named “source” that contains all the data from the “demo” table plus the additional columns of information from the “survey” and “spend” tables.

Question 3

Create an R program that reads in the “source” MySQL table directly from your MySQL database.

Question 4

Using R, design two visuals that show whether there is a difference between customers who responded to the survey and customers who did not.

cta_ question_1