Drop all nan value in Series I have try to drop a nan value like so 

import pandas
data = pandas.read_json("data.json")
lat = data["Latitude"]
lng = data["Longitude"]
shop = data["Store - Business Name"]
df2 = lat.dropna(axis=0, how='any')
df1 = pandas.to_numeric(df2, errors='coerce')

print(df1)


what am i missing, because i still get nan value in my panda series.
lat is a series in your data, if you have even only one nan value in your series ,lat, then you will loose all of your series. 
Another problem might be in the lat column values might not be suitable for converting to pd.to_numeric such as "1,2" (not "1.2"), "a", "nan" etc. Then you will loose your series again. 
Therefore:

Check:
len(lat.dropna()) == len(lat) 
if it is True then check:

len(df2[df2.str.contains(",")]) &gt; 0


I hope it works!