Convert E32 N32 to Lat Long
import utm
import pandas as pd
# example from utm
utm.to_latlon(473978.0, 5797401.0, 32, 'U')
(52.326310175082746, 8.618166607021827)
df = pd.read_csv('geo.csv')
df.columns
Index(['gewaesser_id', 'gewaessername', 'messstellen_id', 'name',
'messstellentyp_opt', 'stationierung_st_3', 'rechtswert', 'hochwert',
'e32', 'n32', 'ofwk_nrw_id', 'brd_typ', 'oekoregion', 'geochemie_opt'],
dtype='object')
df = df.dropna()
def getUTMs(row):
tup = utm.to_latlon(row.iloc[0],row.iloc[1], 32, 'U')
return pd.Series(tup[:2])
df[['lat','long']] = df[['e32','n32']].apply(getUTMs , axis=1)
df.head()
.dataframe tbody tr th {
vertical-align: top;
}
.dataframe thead th {
text-align: right;
}