Getting instead of the city name

Question

I am new to python

I am trying to extract the city from text which is all over the place:

For an Example: London, HighgateLondon, etc.

I am using GeoText to try and extract this. However, when I run it fills the column with <geotext.geotext.GeoText object at 0x106BFD78> instead of the city.

Despite setting the type it initially did not recoganise that the City Column was a string. Would that be the issue?

    calls = pd.read_csv("Call Analysis.csv", dtype={"Agent": str, "Telephone": 
    float,"Final Queue": str, "Date": str, "Time": str, "Hour": 
    int,"Duration": str,
    "Queue Time": str, "Ring Time [s]": str, "Outcome": str, "Type": str, 
    "Result": str, "Step: Substep": str, "Requisition: Requisition Title": 
    str, 
    "Candidate: DOB_Format": str, "Age": int, "Location": str, "City": str}, 
    parse_dates=["Date", "Time", "Duration", "Queue Time","Ring Time [s]", 
    "Candidate: DOB_Format"], dayfirst=True)

    #set City as a str
    calls["City"] = calls.City.astype(str)

    #extract city from City
    for x, value in calls.iterrows():
       place = GeoText(value["City"])

    #Assign to new column called place
    calls["Place"] = place

    print(calls.head(10))

try the following ```calls["Place"] = place.cities[0]``` or alternatively if you want all of them you can say ```calls["Place"] = ", ".join(place.cities)``` — Mahmoud Youssef, Feb 03 '21 at 10:16
Thanks, I tried that but it put Selby as every single location. — Red_bull, Feb 03 '21 at 11:06
you need to run the assignment in the loop not outside, in the loop select the specific row, and update its place value to be the place.cities — Mahmoud Youssef, Feb 03 '21 at 12:09
remove the for loop and ```calls["Place"] = calls["City"].map(lambda val: ", ".join(GeoText(val).cities))``` — Mahmoud Youssef, Feb 03 '21 at 18:17

Getting instead of the city name

0 Answers0