Project 2

Learning Outcome:

• Learned how to clean the data.
• Learned how to create a connection between SQL and Python.
• Learned how to create a connection between SQL andExecel.
• Learned how to combine the different table to get the desired output.

5. Import first 1500 rows of tables (College_A_HS, College_A_SE, College_A_SJ, College_B_HS, College_B_SE, College_B_SJ) into MS Excel.

• Check the Limit box and replaced the value with 1500 but it changes back to the default set value.

• Attached the file xlsx below

• Please find the Ipyb , sql and xlsx file attachment below.