WWII ALLIED AERIAL BOMBING MISSIONS
DATA CLEANSING AND VISUALIZATION OF HISTORICAL RECORDS.
The dashboard may run slow due to the amount of data entries. Filtering the data by an individual year may help increase speeds.
The raw data file contains duplicates, inconsistencies, and blank values that were cleaned in Excel before importing to Tableau:
1) COUNTA was used to tally columns relative to a mission id column (178,282 entries). Columns with substantially less data without context to backfill were dropped.
2) Rows with NULL values of target latitude and longtitude were dropped.
3) Rows with impossible latitude and longtitude values were dropped.
4) On a few occasions the latitude and longtitude values were flipped. These inconsistencies were reversed.
5) Rows with unrealistic tonnes of explosives were dropped - likely a unit conversion error during tabulation.
6) Duplicate rows were eliminated based on "Mission Date" (by day), "Attacking Country", "Target Latitude", and "Target Longtitude". Approximately 100,000 duplicate entries were found.
7) Replaced NULL "Attacking Country" values with "X.UNKNOWN".
SOURCES estimate Allied bombers dropped 1,400,000 tonnes of explosives on Germany, 570,000 tonnes on France, 380,000 tonnes on Italy, etc. Approximately 10,000 entries contain NULL values for "Tonnes of Explosive" and total tonnage esimates by target country in this dataset are substantially lower.
A "Mission" in this dataset is defined by a dinstinct date (by day), distinct attacking country, and distinct combination of target coordinates.
