Skip to content

Instantly share code, notes, and snippets.

View MarcinMoskala's full-sized avatar

Marcin Moskała MarcinMoskala

986 followers · 17 following
View GitHub Profile
@MarcinMoskala
MarcinMoskala / by_tepmerature_by_category.py
Created June 6, 2020 09:00
from itertools import count, takewhile
def frange(start, stop, step):
return takewhile(lambda x: x < stop, count(start, step))
def show_avg_hist(df, column, buckets=40):
counts = df[column].value_counts()
counts = counts[counts > 20] # Drop rare values
@MarcinMoskala
MarcinMoskala / by_temp.py
Created June 6, 2020 08:58
from itertools import count, takewhile
def frange(start, stop, step):
return takewhile(lambda x: x < stop, count(start, step))
def show_avg_hist(df, column, buckets=40):
counts = df[column].value_counts()
counts = counts[counts > 20] # Drop rare values
@MarcinMoskala
MarcinMoskala / by_weekday.py
Created June 6, 2020 08:39
from pandas import read_csv
crimes_df = read_csv("CrimeData.csv")
crimes_df = crimes_df[crimes_df.year <= "2019"]
days_df = read_csv("DaysData.csv")
from datetime import datetime
def to_weekday(date):
return datetime.strptime(date, "%m/%d/%Y").strftime("%A")
@MarcinMoskala
MarcinMoskala / crimes_by_month.py
Last active June 6, 2020 08:46
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
@MarcinMoskala
MarcinMoskala / crimes_by_month.py
Last active June 6, 2020 08:45
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
@MarcinMoskala
MarcinMoskala / by_year_by_type.py
Last active June 6, 2020 08:45
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
@MarcinMoskala
MarcinMoskala / by_month_by_category.py
Created June 6, 2020 08:04
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
@MarcinMoskala
MarcinMoskala / by_year.py
Last active June 6, 2020 08:45
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
@MarcinMoskala
MarcinMoskala / by_year_by_category.py
Created June 6, 2020 07:57
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
@MarcinMoskala
MarcinMoskala / by_year.py
Created June 6, 2020 07:55
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