Skip to content

Instantly share code, notes, and snippets.

@MarcinMoskala
Last active June 6, 2020 08:45
Show Gist options
  • Save MarcinMoskala/826369e01c6b861f17463e870194fbb8 to your computer and use it in GitHub Desktop.
Save MarcinMoskala/826369e01c6b861f17463e870194fbb8 to your computer and use it in GitHub Desktop.
def add_day_month_year(df):
dates = df["Date"].map(lambda x: x[:10])
df["day_of_month"] = dates.map(lambda x: x.split("/")[1])
df["month"] = dates.map(lambda x: x.split("/")[0])
df["year"] = dates.map(lambda x: x.split("/")[2])
df["date"] = dates
return df
from pandas import read_csv
crimes_df = read_csv("CrimeData.csv")
crimes_df = add_day_month_year(crimes_df)
crimes_df = crimes_df[crimes_df.year <= "2019"]
crimes_count_df = crimes_df \
.groupby(["year"]) \
.size() \
.to_frame("crimes") \
.reset_index()
print(crimes_count_df.to_string())
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment