EDA https://www.kaggle.com/uttam94/eda-on-us-car-accident Data https://www.kaggle.com/sobhanmoosavi/us-accidents
Step 1: Downloading folder<PHP_DBMS> and moving it to the “wamp64 > www” folder.
Step 2: Visiting localhost:80/PHP_DBMS/insertzip for inserting data into location_zip table.
Step 3: Visiting localhost:80/PHP_DBMS/getaudit for getting the audit table for the location_zip table. It will log the change for the table.
Step 4: Visiting localhost:80/PHP_DBMS/delectzip for deleting data from location_zip table.
Step 5: Visiting localhost:80/PHP_DBMS/getaudit for getting the audit table for the location_zip table. It will log the change for the table.
Step 1: Installing the streamlit package for python.
Step 2: Running the accdients python file.
Step 3: Typing
The visulization parts can be checked in the sql_python.ipynb.