Data files were provided by the National Oceanic and Atmospheric Administration:
Atlantic hurricane database (HURDAT2) 1851-2018
Northeast and North Central Pacific hurricane database (HURDAT2) 1949-2018
First, files provided were saved and converted to .csv files. The data was organized by the name of the hurricane in one row followed by a uniform data values of that hurricane. The data was then parsed to fit the name of the data next to each of its data values for a uniform way of pulling what kind of data we wanted. this was done by using our formatting python code which can be found in our Github
All data members for all data columns provided in the file were given new types and arrangements:
Date column was formatted into a date/time and new columns were given to Year, Month, Day, Time
Longitude and Latitude columns were given integer types and proper negative and positive coordinates
Landfall Column was turned to a boolean type
Status/Type column was given character types
MinPressure column was given integer types and excluded -999 values
A Hurricane ID column was created for each Specific hurricane
Unnamed hurricanes where displayed by their year/number
The time of the hurricane was formatted into their own column of list by the Hour and Minute it occurred