python - Ploting data in geopandas

Question

I am working on Kaggle Global Terrorism Database (https://www.kaggle.com/START-UMD/gtd/download) and I am trying to use geopandas for visualization.

I am also using countries dataset (http://www.naturalearthdata.com/downloads/110m-cultural-vectors/110m-admin-0-countries/)

import seaborn as sns
import geopandas as gpd
import matplotlib.pyplot as plt
sns.set(style = "ticks", context = "poster")
from shapely.geometry import Point


countries = gpd.read_file("C:/Users/petr7/Desktop/ne_110m_admin_0_countries/")
countries = countries[(countries['NAME'] != "Antarctica")]
countries.plot(figsize = (15, 15))

using code above I can easily plot entire Europe,

after that I import kaggle terrorist dataset and define it as geopandas dataframe

DF = pd.read_csv("C:/Users/petr7/Desktop/gtd/globalterrorismdb_0718dist.csv", encoding='latin1')
crs = {"init": "epsg:4326"}

geometry = [Point(xy) for xy in zip ( DF["longitude"], DF["latitude"])]
geo_DF = gpd.GeoDataFrame(DF, geometry = geometry)
geo_DF.head()

Until this point everything is working and dataset can be inspect

NOW when I try to plot it it return nonsense plot:

geo_DF.plot()

I am prety new to geopandas so I wanted to ask what I am missing and also how would you plot entire europe map (countries.plot) and above that terrorist attacks?

PICTURE HERE

Answer 1

There is an error in the data. DF["longitude"].min() gives -86185896.0.

DF.loc[DF["longitude"] == DF["longitude"].min()]

As you can see if you run the snippet above, row with the error is 17658.

It seems to be missing comma. If you do

DF.at[17658, 'longitude'] = -86.185896

before generating geometry, it will work. Or you can drop the row if you are not sure what is exactly wrong with the data.