Call Functions on Pandas DataFrames Values
Explore how to call functions on pandas DataFrame values, focusing on Unicode normalization issues that affect string comparisons. Understand why some cities appear unequal due to encoding differences and learn practical methods, like using unicodedata and str.casefold, to handle case-insensitive and normalized string matching in pandas data.
We'll cover the following...
We'll cover the following...
Try it yourself
...import pandas as pd
cities = pd.DataFrame([
('Vienna', 'Austria', 1_899_055),
('Sofia', 'Bulgaria', 1_238_438),
('Tekirdağ', 'Turkey', 1_055_412),
], columns=['City', 'Country', 'Population'])
def population_of(city):
return cities[cities['City'] == city]['Population']
city = 'Tekirdağ'
print(population_of(city))How to retrieve specific data from a DataFrame
Explanation
The ...