Ingest Ultracool Sheet v2.0

Here's some code which can help with mapping their reference codes onto ours.

db.Publications.update().where(db.Publications.c.publication == 'Dupu12a').\
    values(publication='Dupu12').execute()
# Fix some references
'''for i, ref in enumerate(df.ref_plx_lit):
    if ref == 'Burg08b':
        df.ref_plx_lit[i] = "Burg08c"
    if ref == 'Burg08c':
        df.ref_plx_lit[i] = "Burg08d"
    if ref == 'Burg08d':
        df.ref_plx_lit[i] = "Burg08b"
    if ref == 'Gagn15b':
        df.ref_plx_lit[i] = "Gagn15c"
    if ref == 'Gagn15c':
        df.ref_plx_lit[i] = "Gagn15b"
    if ref == 'Lodi07a':
        df.ref_plx_lit[i] = "Lodi07b"
    if ref == 'Lodi07b':
        df.ref_plx_lit[i] = "Lodi07a"
    if ref == 'Reid02c':
        df.ref_plx_lit[i] = "Reid02b"
    if ref == 'Reid06a':
        df.ref_plx_lit[i] = "Reid06b"
    if ref == 'Reid06b':
        df.ref_plx_lit[i] = "Reid06a"
    if ref == 'Scho04b':
        df.ref_plx_lit[i] = "Scho04a"
    if ref == 'Scho10a':
        df.ref_plx_lit[i] = "Scho10b"
    if ref == 'Tinn93b':
        df.ref_plx_lit[i] = "Tinn93c"
    if ref == 'Lieb79f':
        df.ref_plx_lit[i] = "Lieb79"
    if ref == 'Prob83c':
        df.ref_plx_lit[i] = "Prob83"
    if ref == 'Jame08a':
        df.ref_plx_lit[i] = 'Jame08'
    if ref == 'Lepi05a':
        df.ref_plx_lit[i] = 'Lepi05'
    if ref == 'Lodi05b':
        df.ref_plx_lit[i] = 'Lodi05'
    if ref == 'Tinn95c':
        df.ref_plx_lit[i] = 'Tinn95'
    if ref == 'Roes10b':
        df.ref_plx_lit[i] = 'Roes10'
    if ref == 'Hog_00a':
        df.ref_plx_lit[i] = 'Hog_00'
    if ref == 'Ditt14a':
        df.ref_plx_lit[i] = 'Ditt14'
    if ref == 'Schn16b':
        df.ref_plx_lit[i] = 'Schn16'
    if ref == 'Tinn03b':
        df.ref_plx_lit[i] = 'Tinn03'
    if ref == 'Phan08a':
        df.ref_plx_lit[i] = 'Phan08'
    if ref == 'Gizi15a':
        df.ref_plx_lit[i] = 'Gizi15'
        '''
SIMPLE-AstroDB / SIMPLE-db

Ingest Ultracool Sheet v2.0 #452
