Excel to SQlite

1. Download:

Jupyter notebook
Visual Studio Code

2. Put Excel file into folder

3. Write a code with PANDAS to read excel file

remember to import pandas, sqlalchemy and sqlite3
check your code on jupyter notebook weather it works

4. With pandas turn recieved dataframe into csv file

5. With sqlalchemy create engine and table

remember - columns in the table needs to be same as the one from csv file

6. With command .to_sql insert received csv file into database (SQLite)

7. Read table with pd.read_sql_table

8. Create prefect flow with your code - tutorial