Created
December 28, 2020 11:11
-
-
Save lewiuberg/bbc6c41ef58b0e27d5457f9e381a830a to your computer and use it in GitHub Desktop.
Active Airport code 10
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
path = "df_geo_manual.csv" | |
read = True | |
if read: | |
if path_checker(path): | |
df = pd.read_csv(path) | |
if "date" in df: | |
df["date"] = pd.to_datetime(df["date"]) | |
else: | |
if df is None: | |
print("You need a DataFrame to export.") | |
else: | |
from geopy.geocoders import Nominatim | |
from geopy.point import Point | |
geolocator = Nominatim(user_agent="my_geocoder") | |
location = geolocator.reverse | |
df.loc[df["airport"] == "Mo i Rana Røssvold", "latitude"] = 66.3646621704102 | |
df.loc[df["airport"] == "Mo i Rana Røssvold", "longitude"] = 14.3028783798218 | |
df.loc[df["airport"] == "Mo i Rana Røssvold", "altitude"] = 0.0 | |
df.loc[df["airport"] == "Skien Geitryggen", "latitude"] = 59.18429939776701 | |
df.loc[df["airport"] == "Skien Geitryggen", "longitude"] = 9.569653883827625 | |
df.loc[df["airport"] == "Skien Geitryggen", "altitude"] = 0.0 | |
mask = df[(df["airport"] == ("Mo i Rana Røssvold")) | |
| (df["airport"] == ("Skien Geitryggen"))] | |
df.loc[mask.index, "point"] = [ | |
', '.join(str(x) for x in y) | |
for y in map(tuple, df.loc[mask.index, ["latitude", "longitude"]].values) | |
] | |
df.loc[mask.index, "location"] = df.loc[mask.index, "point"].apply(location) | |
df["location"] = df["location"].apply(str) | |
# df = df.drop(['location', "altitude"], axis=1) | |
df.to_csv(f'{path}', index=False) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment