def covid():
from dtale.cli.loaders.csv_loader import loader_func as load_csv
data = load_csv(
path=
"https://raw.githubusercontent.com/nytimes/covid-19-data/master/us-states.csv",
parse_dates=["date"],
)
codes = load_csv(
path=
"https://raw.githubusercontent.com/jasonong/List-of-US-States/master/states.csv",
)
codes = codes.set_index("State").to_dict()["Abbreviation"]
data["state_code"] = data["state"].map(codes)
return data, None
def seinfeld():
from dtale.cli.loaders.csv_loader import loader_func as load_csv
episodes = load_csv(
path=
"https://github.com/4m4n5/the-seinfeld-chronicles/raw/master/episode_info.csv"
)
episodes = episodes[[
c for c in episodes.columns if c not in ["Unnamed: 0"]
]]
scripts = load_csv(
path=
"https://github.com/4m4n5/the-seinfeld-chronicles/raw/master/scripts.csv"
)
scripts = scripts[[
c for c in scripts.columns
if c not in ["Unnamed: 0", "Season", "EpisodeNo"]
]]
return pd.merge(episodes, scripts, how="inner", on="SEID"), None
def simpsons():
from dtale.cli.loaders.csv_loader import loader_func as load_csv
episodes = load_csv(
path=
"https://github.com/aschonfeld/dtale-media/raw/master/datasets/simpsons_episodes.csv"
)
episodes = episodes.rename(columns={"id": "episode_id"})
_, scripts = next(
load_zip(
"https://github.com/aschonfeld/dtale-media/raw/master/datasets/simpsons_script_lines.csv.zip"
))
scripts = pd.read_csv(scripts)
return pd.merge(episodes, scripts, how="inner", on="episode_id")
def simpsons():
from dtale.cli.loaders.csv_loader import loader_func as load_csv
import dtale.global_state as global_state
global_state.set_app_settings(
dict(max_column_width=100, max_row_height=100))
episodes = load_csv(
path=
"https://github.com/aschonfeld/dtale-media/raw/master/datasets/simpsons_episodes.csv"
)
episodes = episodes.rename(columns={"id": "episode_id"})
episodes.loc[:, "image_url"] = episodes["image_url"].apply(
lambda x: "<img src='{}' style='height: auto; width: 100px;' />".
format(x))
_, scripts = next(
load_zip(
"https://github.com/aschonfeld/dtale-media/raw/master/datasets/simpsons_script_lines.csv.zip"
))
scripts = pd.read_csv(scripts)
df = pd.merge(episodes, scripts, how="inner", on="episode_id")
formatting = {"image_url": {"fmt": {"html": True}}}
return df, {"columnFormats": formatting}