This data set was obtained from the European Centre for Disease Control and Prevention (ECDC). It tracks all reported human West Nile virus infections across Europe from February 2024 to October 2024, and details the reported date, country, region, and NUTS3 geocode standard for where each infection originated. Pandas (Python) was used for data cleaning and preliminary EDA.
Though the ECDC’s report includes the timing and geographic distribution of these case reports, it does not feature population-adjusted metrics that would more accurately convey the burden of this disease by region. To add further insight into the ECDC’s epidemiological report, I downloaded country/regional population estimates from the European Union's Eurostat resource and linked these to the West Nile data set using the NUTS3 geocode as the key. Prior to linkage, geocoding for Albania and Serbia listings had to be corrected in the ECDC data set, as their original entries did not correspond to recognized NUTS3 codes and could not be interpreted by Tableau’s geo mapping function.
After joining the data sets in Tableau, several calculated fields were coded to quantify infection rates, and a choropleth map, tables, and bar and line graphs were developed to more clearly depict the burden of infection after adjusting for population size.
The highest rates of West Nile virus infection for 2024 were concentrated in southern Europe, particularly in Greece and Albania.
My Tableau Dashboard that further unpacks the disease surveillance data can be viewed here.