lewiuberg

miss_col

lewiuberg

	location	point	latitude	longitude	altitude

lewiuberg

miss_only

lewiuberg

2011-01-01 00:00:00

	airport	type of traffic	2010-10-01 00:00:00	2010-11-01 00:00:00	2010-12-01 00:00:00

lewiuberg

path = "df_geo.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:

lewiuberg

find_missing_values(df)

lewiuberg

2011-01-01 00:00:00

	airport	type of traffic	2010-10-01 00:00:00	2010-11-01 00:00:00	2010-12-01 00:00:00

lewiuberg

df = replace_df_ax_name(df, "Passengers ", "", 1)
df = replace_df_ax_name(df, "M", "-", 1)
df = replace_df_ax_name(df, "-", "d_to_datetime", 1)

df.head()

lewiuberg

Passengers 2011M01

	airport	type of traffic	Passengers 2010M10	Passengers 2010M11	Passengers 2010M12

lewiuberg

df = pd.read_csv("passenger_data.csv", delimiter=";", header=1).drop(["domestic/international flights", "passenger group"], axis=1)
df = df.sort_values(by="airport")
df.reset_index(drop=True, inplace=True)

df.head()