mattia-ficarelli
Health Data Engineer, Azure Engineer, and Python Developer. PhD in Molecular Virology.
@Lane, Clark & PeacockLondon
Pinned Repositories
ae_attendances_modelling
This repository contains the raw data and a python notebook to ingest historical A&E attendance data and then use a simple Prophet model to predict the number of A&E attendances in England if the COVID-19 pandemic had not happened. The predicted A&E attendance values from (2020-01 to 2021-12) are then compared to the actual data to quantify the impact of the pandemic on A&E attendances.
antibiotic_cost
Plotly chart and folium map visualizing the prescribing cost of the antibiotics Amoxicillin, Doxycycline Hyclate and Caefalexin for Clinical Commissioning Groups (CCGs).
azure_functionapps
Personal space to develop Azure Functions for use in Azure Data Factory ETL pipelines. DevOps .yaml pipeline used to push and deploy functions to Azure Enviroments.
fetch-boundaries
NHS organisation shapefile boundary fetching script for the DataLab OpenPrescribing platform
gp_mapping
Plotly chart and folium map visualizing the number of patients registered at individual GP practices in the London Commissioning Region (Y56).
hackathon_map
The solution to the Multiverse Hackathon: Finding the best location to open a company’s first operational facility.
nhs_time_of_travel
This GitHub repository and accompanying webpage contain the initial proof of concept and exploratory analysis for the design of a holistic and interactive mapping tool to support decision-making in health and social care.
restapi_flask
Development of a simple REST API with Flask
test_devops_databricks
Repository to develop databricks notebooks suitable for use in a Azure DevOps environment, and space for refactoring existing ETL design
AIF_Allocation_Tool
This project is a tool built in Python to assist Integrated Care Boards (ICBs) to perform need based allocation based on defined place. It uses the most recently produced GP Registered Practice Populations as well as the weighted populations calculated from the Allocation model for each of its components.
mattia-ficarelli's Repositories
mattia-ficarelli/antibiotic_cost
Plotly chart and folium map visualizing the prescribing cost of the antibiotics Amoxicillin, Doxycycline Hyclate and Caefalexin for Clinical Commissioning Groups (CCGs).
mattia-ficarelli/ae_attendances_modelling
This repository contains the raw data and a python notebook to ingest historical A&E attendance data and then use a simple Prophet model to predict the number of A&E attendances in England if the COVID-19 pandemic had not happened. The predicted A&E attendance values from (2020-01 to 2021-12) are then compared to the actual data to quantify the impact of the pandemic on A&E attendances.
mattia-ficarelli/azure_functionapps
Personal space to develop Azure Functions for use in Azure Data Factory ETL pipelines. DevOps .yaml pipeline used to push and deploy functions to Azure Enviroments.
mattia-ficarelli/fetch-boundaries
NHS organisation shapefile boundary fetching script for the DataLab OpenPrescribing platform
mattia-ficarelli/gp_mapping
Plotly chart and folium map visualizing the number of patients registered at individual GP practices in the London Commissioning Region (Y56).
mattia-ficarelli/hackathon_map
The solution to the Multiverse Hackathon: Finding the best location to open a company’s first operational facility.
mattia-ficarelli/nhs_time_of_travel
This GitHub repository and accompanying webpage contain the initial proof of concept and exploratory analysis for the design of a holistic and interactive mapping tool to support decision-making in health and social care.
mattia-ficarelli/restapi_flask
Development of a simple REST API with Flask
mattia-ficarelli/test_devops_databricks
Repository to develop databricks notebooks suitable for use in a Azure DevOps environment, and space for refactoring existing ETL design
mattia-ficarelli/advent_of_code_2002
mattia-ficarelli/AIF_Allocation_Tool
Allocation Tool Design
mattia-ficarelli/ascof-r-model
R model of Adult social care outcomes framework
mattia-ficarelli/au-azure-databricks
NHSX AU-Data Engineering - Azure Databricks Analytics
mattia-ficarelli/azure-sql-db-python-rest-api
REST API using Python, Flask and Azure SQL
mattia-ficarelli/Azure_GitHub_workflows
GitHub Workflows using the bacon-gobbler library to upload files to Azure Data Lake
mattia-ficarelli/coding-club-Python-Data-Wrangling
mattia-ficarelli/multiverse_sales_modelling