Troubleshooting data issues

You will be building popups for the downtown art using the title and desc columns from the urban_art DataFrame. Here, you will inspect those columns to identify and clean up any problematic values.

This exercise is part of the course

Visualizing Geospatial Data in Python

View Course

Exercise instructions

Print and inspect the values in the title column of the urban_art DataFrame.
Print and inspect the values in the desc column of the urban_art DataFrame.
Use the fillna() method to replace the NaN values in the desc column with empty strings, and use .str.replace to replace the apostrophes (') with back-ticks (`).
Print the descriptions again to verify your work.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

# Print the urban_art titles
print(urban_art.____)

#Print the urban_art descriptions
print(urban_art.____)

# Replace Nan and ' values in description
urban_art.desc.____('', inplace = True)
urban_art.desc = urban_art.desc.____.____("'", "`")

#Print the urban_art descriptions again
print(urban_art.desc)

Edit and Run Code