Extracting longitude and latitude
A DataFrame named df
has been pre-loaded for you. Complete the code to extract longitude and latitude to new, separate columns.
This exercise is part of the course
Visualizing Geospatial Data in Python
Exercise instructions
- Print the first few rows with
print()
anddf.head()
. - Use a list comprehension to extract latitude to a new column called
lat
. - Use a list comprehension to extract longitude to a new column called
lng
. - Print the first few rows with
print()
anddf.head()
again to confirm the new columns.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# print the first few rows of df
print(df.head())
# extract latitude to a new column: lat
df['lat'] = [loc[_____] for loc in df.Location]
# extract longitude to a new column: lng
df['lng'] = [loc[_____] for loc in df.Location]
# print the first few rows of df again
print(df.head())