Thanks for checking out my portfolio. This repository contains my solo projects I’ve worked whilst teaching myself Python, SQL and data visualisation. Take a look at my first project on economic growth and public transport infrastructure in the EU (visualisations on tableau)
Railway Infrastructure and Economic Growth in the EU: In this SQL project, I used data from eurostat to produce summary statistics on the level of railway and bus provision for 24 EU member states. I joined data from a macroeconomic dataset from the World Bank Organisation to provide further insights such as GDP growth, railway density, buses per capita and railway per capita. My results suggest a strong correlation between the number of buses per 1000 people and gdp per capita growth in the EU. Click here for Tableau visualisations, or here to acces the data files used in this project.
Predicting Yearly Customer Spending in E-commerce Using Linear Regression In this Python project, I analyse ecommerce sales to predict the yearly amount spent by customers based on features such as average session length, time on app, time on website, and length of membership. After loading and exploring the data, a linear regression model is built to examine the relationship between these features and yearly spending. The data is split into training and testing sets, and the model is trained on the training data. The model’s accuracy is evaluated using metrics like Mean Absolute Error (MAE) and Root Mean Squared Error (RMSE), with residuals analyzed to assess model performance