Skip to content

Instantly share code, notes, and snippets.

View tkanngiesser's full-sized avatar

Tino Kanngiesser tkanngiesser

View GitHub Profile
@tkanngiesser
tkanngiesser / fiscal_year_dataframe.py
Last active February 4, 2021 08:01
create fiscal year dataframe
import numpy as np
import pandas as pd
def get_fy_df(start_date, end_date, fy_start=4):
df = pd.DataFrame({"date":pd.date_range(start=start_date,end=end_date)})
df["day_of_week"] = df["date"].dt.weekday
df["day_name"] = df["date"].dt.day_name()
df["month"] = df["date"].dt.month
df["month_name"] = df["date"].dt.month_name()
df["month_abbr"] = df["month_name"].str.slice(stop=3)
@tkanngiesser
tkanngiesser / get_file_from_url.py
Created August 4, 2021 08:16
get files from url (txt or json)
def get_text_from_url(url, file_name, split_pattern):
filename, file_extension = os.path.splitext(file_name)
url = os.path.join(url, file_name)
if file_extension == ".txt":
text = requests.get(url).text
else:
resp = requests.get(url)
text = json.loads(resp.text, encoding="utf-8")
if split_pattern:
text = text.split(split_pattern)