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)
