How many Presidents resigned the presidency? Identify them by name, and provide the date of their resignation.

Web Scraping and DatabasesCoursework :You are to create Python code which scraps data, starting from this WikiPedia HTML page:
https://en.wikipedia.org/wiki/List_of_Presidents_of_the_United_States.The scraped data is to be stored in a MySQL database (or MariaDB, if you prefer). You are to
create and provide the Python code which does the scraping (and any required cleaning), as well as the Python code which inserts the scraped data into MySQL. The SQL to create and define the required MySQL database and tables needs to be provided, too, but this does not need to be created from within Python (i.e., the “raw” SQL is fine).For the purposes of this assignment, you are to only use the data scraped from the above HTML page (and any that are linked-to from it). Access to and the use of all other potentially relevant precurated datasets is not allowed.Note: All of the work is to be submitted as a Jupyter Notebook.Deliverables:With the data scraped from the above HTML page and stored in MySQL, determine the answers to the following questions (using any combination of SQL and/or Python):1. How many Presidents died while in office? Identify them by name, and provide the date of their death.
2. How many Presidents resigned the presidency? Identify them by name, and provide the date of their resignation.
3. How many Presidents previously held the office of Vice-President? Identify them by name, and identify the name(s) of the President(s) they were Vice-President to.
4. Calculate the total amount of time (years and months) the office of Vice-President has been vacant since the formation of the republic.
5. Identify the youngest serving President. At what age did they become President?
6. Identify the oldest serving President. At what age did they leave office (die/resign/retire)?
7. Identify the president who served the shortest term in office. How long was that term?
8. Express the number of Presidents for each party-type as a percentage of the total.To answer the following questions, you’ll need to acquire more data by programmatically
“clicking” on the link associated with each President and scraping the data you need from each of the resulting pages. You are to provide Python code which programmatically scraps this “new” data.9. Categorize the Presidents by US state (i.e., place-of-birth).
10. Identify which state has produced the most Presidents.
11. Identify those state(s) which have produced only one President.
12. Provide a list of States which have never produced a President.Provide suggestions for a strategy (or strategies) that you would follow in an attempt to show that the answers you have for parts 1-12 of this assignment are correct. (A short paragraph is all that’s required here).Resources:
Requests: http://docs.python-requests.org/en/master/ – for working with the Web/HTTP.
Beautiful Soup: https://www.crummy.com/software/BeautifulSoup/ – for working with HTML.
SQL Alchemy: http://www.sqlalchemy.org/ – for working with SQL (although you can most likely make do with my DBcm module).
A good text reference which covers some of the techniques you’ll need to use is Kyran Dale’s Data Visualization with Python and JavaScript: Scrape, Clean, Explore & Transform Your Data. More info here: http://shop.oreilly.com/product/0636920037057.do – Chapter 5 is especially useful