Performing Basic Data Manipulation and transformation using Pandas for Geo Loc data (Lat/Long)
The purpose of this question we have a dataset which needs to be processed and made ready to use for different applications. Every application would need geo information which contains
- Country Name
- Country Code
- Location Name
- Location code
- Location Type (Function)
- Longitudes
- Latitudes Here in this sample data you have location details in code-list.csv Country information in country.txt Location Type or otherwise known as Function in the dataset in function.txt You would have to read all three files and combine them together. After doing so you would have to translate the coordinates from a Degree/minute format into a Decimal Degree Final Dataset should be ############################################################################################################## #Country_code | country_name | Location_code | Location_Name | Location_Type | Longitude | Latitude #AU Australia ALO Adelong Road Terminal -35.3 148.06666666666666 #AU Australia ANB Agnes Bank Road Terminal -33.6 150.7 ##############################################################################################################