master.py

# AUTOGENERATED! DO NOT EDIT! File to edit: ../../nbs/book/EventTracker/12_MasterTable.ipynb.

# %% auto 0
__all__ = ['df', 'get_data']

# %% ../../nbs/book/EventTracker/12_MasterTable.ipynb 2
import streamlit as st
import pandas as pd
import numpy as np
import pandas as pd
import matplotlib.pyplot as plt


# %% ../../nbs/book/EventTracker/12_MasterTable.ipynb 6
st.set_page_config(
    page_title="Master",
    page_icon="👋",
    layout='wide'
)

# %% ../../nbs/book/EventTracker/12_MasterTable.ipynb 7
# st.sidebar.success("Select a demo above.")

# %% ../../nbs/book/EventTracker/12_MasterTable.ipynb 9
def get_data(url="https://docs.google.com/spreadsheets/d/1TbqmmSzXtY8DwolVo9rN7M1QdZxLG30nro2cqrvn2CA/export?format=csv&#gid=294763682"):
    df = pd.read_csv(url).dropna(how='all')
    df['Alert Date'] = df['Alert Date'].str.replace("//", "-")
    df = df.dropna(subset=['Alert Date'])
    df['Type of Alert'] = df['Type of Alert'].str.strip()
    return df

# %% ../../nbs/book/EventTracker/12_MasterTable.ipynb 10
#|eval: false
df = get_data()
st.write("# Master Table")

st.table(data=df)