Data should be a table and include columns: rank, title, year, rating. It looks like a sample table

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Task 1: Collecting data using url

·         Get data from IMBD: https://www.imdb.com/chart/top

Data should be a table and include columns: rank, title, year, rating. It looks like a sample table:

o     

rank	title	year	rating
1	The Shawshank Redemption	1994	9.2
2	The Godfather	1972	9.1

·         You can save the data into a pandas DataFrame.

Task 2: Store data into MySQL using pymysql package. Please use Python to finish the first tasks below. 

·         Execute the create table query "CREATE TABLE imdb (rank INT, title TEXT, year INT, rating DOUBLE)" 

·         Insert each records using query "INSERT INTO imdb VALUES (rankv, titlev, yearv, ratingv)" by replacing rankv, titlev, yearv, ratingv with actual value for each row. You may need to make a loop and do the insert operation iteratively. 

·         Go to your MySQL and check the imdb table to see whether all data records are inserted correctly. 

Submission:

·         Please submit your python code - or a clear screenshot of your code for both tasks. 

·         Please submit a screenshot of your MySQL database showing that you have data in the imdb table. 

Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme