/Extract-and-Load-Script

Extract xls datas and load into html table and slq database using python

Primary LanguageJupyter Notebook

Convert xls to html table and load data into sql

Extract and transfrom a xls file with pandas library.

Load the data into a html table and into a sql database.

Download the data

Create the datas folder using the command line.

mkdir datas
  • You can download the xls document here.
  • Click on the second button ("Les prix médian 2015") to download the xls data file.

Requirements

  • Python 3.10.6
  • jupyter 1.0.0
  • pandas 1.5.2
  • openpyxl 3.0.10
  • xlrd 2.0.1