https://nbviewer.org/github/byeJohn/JupyterNotebook-4308/blob/main/DataCleaning.ipynb

Dataset: https://www.kaggle.com/datasets/joebeachcapital/medical-insurance-costs/code

-- DataCleaning.ipynb - Code used to clean and visual the data

cleanedInsurance.csv - cleaned Data

descStats.txt - File that gives a summary of the data (min, max, mean, etc.)

insurance.csv - data before it was clean

Contains the files to convert the clean data(.csv) to a data file.

cleanedInsurance.csv - cleaned Data

ImportData.py - script to convert .csv -> .db

Medical.db - Newly created .db file that can be imported into a database (if no database is installed you can import it to this website https://inloop.github.io/sqlite-viewer/)

https://jupyter.org/install

pip install notebook

jupyter notebook

https://www.sqlite.org/download.html

https://sqlitebrowser.org/dl/

https://inloop.github.io/sqlite-viewer/

.csv -> Database File with Python : https://www.youtube.com/watch?v=UZIhVmkrAEs