CA2_Integrated_Assesment_MSc_Data_Analytics_CCT_Semester_1

Creating repo for CA2 first semester MSc Data Analytics CCT.

Please note that in order to run:

1. CA2_ML_Code_sba23021.ipynb
2. CA2_Statistics_Code_sba23021.ipynb
3. CA2_Programming_Code_sba23021.ipynb
4. CA2_Data_Visualisation_Code_sba23021.ipynb

You will need any of the following files:

1. iata-icao.csv
2. THA25.csv
3. TII03.20231227215009.csv
4. TRAN_HV_PSMOD.csv
5. Tweets.csv
6. Sentiment_Analysis_Ryanair_Reviews.csv
7. json_codebeautify_input.png
8. json_codebeautify_output.png

If you want to recreate the MySQL table for schema eurostat, please run:

1. TRAN_HV_PSMOD_table_creation.sql

Once you have the table loaded, upload the CSV file:

1. TRAN_HV_PSMOD.csv

Streamlit dashboard:

1. app_dash.py
2. requirements.txt

You can visit the dasboard at:

https://datavisualisationmoderntransportdashstudentsba23021.streamlit.app/

Thank you for taking the time to read it 😃