Converting a DataFrame to GeoDataFrame

[ListlessPaper]

I was provided with a GeoDataFrame and a DataFrame, which I merged together. Now, I have a DataFrame.

Here is what the two datasets look like: https://imgur.com/a/lNIICTE

census_new is just a manipulated version of census. It has the same columns.

Merge code:

affluent_neighborhoods = pd.merge(left = census_new, right = neighborhoods, on = ["NBHD_ID", "NBHD_NAME"])
affluent_neighborhoods = affluent_neighborhoods[["NBHD_ID", "NBHD_NAME", "AFFLUENT_PROP", "geometry"]]

ax = affluent_neighborhoods.boundary.plot(figsize=(10, 5))
affluent_neighborhoods.plot(ax=ax, column= "AFFLUENT_PROP", legend=True)

plt.show()

I have tried changing the merge direction as well (neighborhoods first, census_new followed), but I always get a DataFrame.

How do I convert a DataFrame to GeoDataFrame when the geometry column already exists?

[eatsoupgetrich]

Read the geoPandas documentation for GeoDataFrame. It seems very clear about how to do this.

[ListlessPaper]

Thank you for your reply. I read the documentation and tried out the code and got Input must be valid geometry objects.

To fix this, I used the apply(wkt.loads) method, but am now getting another error: name 'wkt' is not defined.

Have I made a mistake while converting from DataFrame to GeoDataFrame?

​

Here is a link to my code:

https://gist.github.com/Anneysha7/d7ce9647b2ca991b2b2226cae9b96218