def get_df(): df = fetch_sheet( url= "https://docs.google.com/spreadsheets/d/15SduszqpCEenMKPXw_yz5GjEtJbDqKfDtFWmmRKNFr0/edit?ts=5f647abb#gid=0" ) df = df.dropna(subset=["Email"]) return df
def get_df(): df = fetch_sheet( url= "https://docs.google.com/spreadsheets/d/1pG4D_6UoQs95mNB2HR8bKnkoW7Aj-vPqRP8coKF2_Lo/edit#gid=1642960737" ) df = df.dropna(subset=["Email"]) return df
def get_df(): df = fetch_sheet( url="https://docs.google.com/spreadsheets/d/1Vt_EbalUILVgyDG2qU8zY1KkszNc7KuqQK-s5XpnP3c/edit#gid=1544474779" ) df = df.dropna(subset=[CARD_ID]) df = df.dropna(subset=[REPO]) df = df[df[APPROVED] == "yes"] return df
def get_df(): df = fetch_sheet( url="https://docs.google.com/spreadsheets/d/1Vt_EbalUILVgyDG2qU8zY1KkszNc7KuqQK-s5XpnP3c" ) df = df.dropna(subset=["Approved"]) df = df[df["Approved"] == "yes"] df = df[df[REPO_COL].str.endswith(".git")] df = df[df[REPO_COL].str.startswith("https://github.com/")] return df
def get_df(): df = fetch_sheet( url= "https://docs.google.com/spreadsheets/d/1dqqz9hqKSxroYsK0GMW0HTfiBJoTxRB-lDlwKj95elI/edit#gid=0" ) df = df.dropna(subset=[EMAIL]) df = df.dropna(subset=[COURSE]) df = df[df[COURSE] != ""] df = df[df[EMAIL].str.contains("gmail")] df.columns = [s.strip() for s in df.columns] return df
def get_df(url): df = fetch_sheet(url=url) df = df.dropna(subset=[EMAIL]) df = df.dropna(subset=[COURSE]) df = df[df[COURSE] != ""] if SKIP in df.columns: df = df[df[SKIP] == ""] df[EMAIL] = df[EMAIL].str.lower() df.columns = [s.strip() for s in df.columns] return df
def get_df(): df = fetch_sheet( url= "https://docs.google.com/spreadsheets/d/1I_sQ8N08pi-oNqVIAk5Q7pb5G_kDMEzTbA0-_aJnAGo/edit#gid=999865580" ) df = df.dropna(subset=["Timestamp"]) df["clean_github_name"] = df.apply(clean_github_username, axis=1) df["clean_project_url"] = df.apply(clean_project_url, axis=1) df["repo_full_name"] = df.apply(clean_repo_url, axis=1) df = df.dropna(subset=["repo_full_name"], ) df = df.dropna(subset=["clean_project_url"], ) df = df.drop_duplicates(subset=["clean_project_url", "clean_github_name"], keep="last") return df
def handle(self, *args, **options): path = options["path"] df = fetch_sheet(url=path) df[OLD_EMAIL] = df[OLD_EMAIL].str.strip() df[NEW_EMAIL] = df[NEW_EMAIL].str.strip() df = df.dropna(subset=[OLD_EMAIL]) df = df[df[BROKEN] != 1] df = df[df[BROKEN] != "1"] df = df[df[OLD_EMAIL] != ""] # df = pd.read_csv(path) print("updating emails") df.apply(update_user_email, axis=1) print("setting up teams") df.apply(add_user_to_group, axis=1) print("setting up course registrations") df.apply(set_up_course_registrations, axis=1) print("setting up rocketchat users") setup_rocketchat_users(df)
def get_df(): df = fetch_sheet( url="https://docs.google.com/spreadsheets/d/1UWQRfdw95gnKyqoHNwn2yX8iJPdlued46goxZtVlPGQ/edit#gid=786487706" ) df = df.dropna(subset=["Gmail Address"]) return df
def handle(self, *args, **options): df = fetch_sheet( url= "https://docs.google.com/spreadsheets/d/1DgXzVzD6K_5x44MXP98HkY2fUhj7No5P17T613UcA4o/edit#gid=0" ) df.apply(process_row, axis=1)
def get_subs_df(): df = fetch_sheet( url="https://docs.google.com/spreadsheets/d/16kabZgFpZaBBUfuzvd5cWqKJbNWzMPZdL3Caq0q7veg/edit#gid=650997048" ) df = df.dropna(subset=["Email Address"]) return df
def get_users_df(): df = fetch_sheet( url="https://docs.google.com/spreadsheets/d/16ohoj81oF4Gws979tY02FYaKsxBATz7kN8yHudc-OeM" ) df = df.dropna(subset=["Email Address"]) return df
def handle(self, *args, **options): sheet = "https://docs.google.com/spreadsheets/d/1W3TYRS5CUlOUExMJsDepkX0Zw7yIvg0ukRxNQRzeQQQ/" df = fetch_sheet(url=sheet) df = df.dropna(subset=[email_column]) df.apply(process_row, axis=1)