Analysis of State Schools in Scotland: K-Means Clustering by Deprivation Rate and Pupils Quantity

The objective of this project is to conduct a comprehensive analysis of Scottish schools in order to derive valuable insights. The analysis includes clustering and descriptive analysis, taking into account factors such as deprivation rate and total number of pupils. Additionally, an interactive map of Scotland has been developed to visually represent the location of each school. The clustering model has categorized local authorities into three distinct clusters based on average pupil count and deprivation score. The map highlights areas predominantly occupied by schools facing high levels of deprivation. The aim is to assist charities or non-governmental organizations (NGOs) involved in projects supporting these school pupils. All data used in this analysis is publicly available and sourced from the Scottish Government website. The Postcodes.io API was utilized to gather latitude and longitude coordinates for each school based on their respective postcodes. The codes for clustering, visualizations, map generation, and API application can be found in my GitHub repository. You are welcome to access and utilize the repository’s contents for personal or commercial purposes without seeking my consent. I hope you find this information enlightening and enjoyable to read. ...

October 8, 2023 · 11 min · Elvin Zeynalli

Non-capital UK Cities with High-tech Potential

This project is carried out by me under a final assignment for one of my courses at the University of Edinburgh. The project received an A grade. Project description Language: Python Libraries: requests, pandas, numpy, matplotlib, seaborn, os, math, time, datetime, json IDE: Microsoft Visual Studio Code, Jupyter Notebook Project type: Data analytics, Web scraping, API Companies House is an agency formed by the British Government to maintain the registration of all the companies in the UK. It maintains a database that stores the information of the registered companies. Each company has features such as company name, Standard Industrial Classification (SIC) code, creation date, cessation date (if ceased operating), company board and shareholder info, etc. By using an API, it is possible to scrape the data from that database by using various specifications. ...

January 5, 2023 · 9 min · Elvin Zeynalli