On 16 Jul 2019 23:31, Daniel Bosah <dbo...@buffalo.edu> wrote:
Hi all,
I have a problem trying to match items in a dict and pandas series in
Python.
I have a dict ( called city_dict )of cities and city_id's ; for each city (
which is a key in the dict ), a unique city_id is a value in that dict.
So for example, city_dict = { New York : 1001, LA : 1002, Chicago : 1003 }.
New York is a key, 1001 is a value.
Now I have a panda Series called dfCities. In this series is a bunch of
cities, including the cities in city_dict.
My goal is to replace the cities in dfCities with the city_id's in a brand
new csv file. So if dfCities has New York in it, I want to replace it with
it's value in the dictionary, so 1001.
=====》 check out
https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.replace.html.
It accepts a dict, see also examples below.
_______________________________________________
Tutor maillist - Tutor@python.org
To unsubscribe or change subscription options:
https://mail.python.org/mailman/listinfo/tutor
