<jupyter_start><jupyter_text>Old Stuff<jupyter_code>affil_query = f"""
SELECT
   COLUMN_NAME
FROM
   information_schema.COLUMNS
WHERE
   TABLE_NAME = 'contributors';
    """
affil = pd.read_sql_query(affil_query, con=engine)
print(affil)
affilx_query = f"""
SELECT
   COLUMN_NAME
FROM
   information_schema.COLUMNS
WHERE
   TABLE_NAME = 'contributors_aliases';
    """
affilx = pd.read_sql_query(affilx_query, con=engine)
print(affilx)
affilx2_query = f"""
SELECT
   canonical_email, alias_email
FROM
   contributors_aliases
;
    """
affilx2 = pd.read_sql_query(affilx2_query, con=engine)
print(affilx2)
affil2_query = f"""
SELECT
   ca_domain, ca_affiliation
FROM
   contributor_affiliations
;
    """
affil2 = pd.read_sql_query(affil2_query, con=engine)
print(affil2)
affil_by_person_query = f"""
    select distinct(count(cmt_commit_hash))
    from commits
    where cmt_author_email = '<EMAIL>';
    """
affil_by_person = pd.read_sql_query(affil_by_person_query, con=engine)
print(affil_by_person)
affil_by_person_query = f"""
    select cmt_author_name, cmt_author_affiliation, cmt_author_email
    from commits
    where cmt_author_name like '%%rraca%%'
    group by cmt_author_name, cmt_author_affiliation, cmt_author_email;
    """
affil_by_person = pd.read_sql_query(affil_by_person_query, con=engine)
print(affil_by_person)
affil3_query = f"""
SELECT
   cntrb_company, cntrb_email, cntrb_canonical, cntrb_full_name, cntrb_login
FROM
   contributors
GROUP BY
   cntrb_company, cntrb_email, cntrb_canonical, cntrb_full_name, cntrb_login
;
    """
affil3 = pd.read_sql_query(affil3_query, con=engine)
affil3[0:20]
affil4_query = f"""
SELECT
   cntrb_email, cntrb_type
FROM
   contributors
GROUP BY
   cntrb_email, cntrb_type
;
    """
affil4 = pd.read_sql_query(affil4_query, con=engine)
with pd.option_context('display.max_rows', None, 'display.max_columns', None):
    print(affil4)
affil5_query = f"""
SELECT
   cntrb_email
FROM
   contributors
GROUP BY
   cntrb_email
;
    """
affil5 = pd.read_sql_query(affil5_query, con=engine)
with pd.option_context('display.max_rows', None, 'display.max_columns', None):
    print(affil5)<jupyter_output>cntrb_email
0                                 <EMAIL>
1                                               demunso
2                            <EMAIL>
3                   <EMAIL>
4                                      <EMAIL>
5                                          <EMAIL>
6                                      <EMAIL>
7                                 <EMAIL>
8                                           pernet@john
9                                                   jya
10                                   <EMAIL>
11           41344266+<EMAIL>
12                              <EMAIL>
13                                 <EMAIL>
14                                     <EMAIL>
15                                     <EMAIL>
16                                     elove@san[...]
{'fraction_non_alphanumeric': 0.08588957055214724, 'fraction_numerical': 0.01874573960463531, 'mean_word_length': 2.1390374331550803, 'pattern_counts': {'":': 0, '<': 18, '<?xml version=': 0, '>': 18, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 17, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '1', 'dir': 'jupyter-structured-clean-dedup', 'id': '193422', 'license': 'MIT', 'n_tokens_mistral': 1023, 'n_tokens_neox': 992, 'n_words': 176, 'path': 'inquiry-notebooks/affiliations.ipynb', 'repo_name': 'chaoss/augur-hackathon-reports', 'size': '3133'}