Document (#40894)

Author

Bartczak, J.
Glendon, I.

Title

Python, Google Sheets, and the Thesaurus for Graphic Materials for efficient metadata project workflows

Source

Code4Lib journal. Issue 35(2017), [http://journal.code4lib.org]

Year

2017

Abstract

In 2017, the University of Virginia (U.Va.) will launch a two year initiative to celebrate the bicentennial anniversary of the University's founding in 1819. The U.Va. Library is participating in this event by digitizing some 20,000 photographs and negatives that document student life on the U.Va. grounds in the 1960s and 1970s. Metadata librarians and archivists are well-versed in the challenges associated with generating digital content and accompanying description within the context of limited resources. This paper describes how technology and new approaches to metadata design have enabled the University of Virginia's Metadata Analysis and Design Department to rapidly and successfully generate accurate description for these digital objects. Python's pandas module improves efficiency by cleaning and repurposing data recorded at digitization, while the lxml module builds MODS XML programmatically from CSV tables. A simplified technique for subject heading selection and assignment in Google Sheets provides a collaborative environment for streamlined metadata creation and data quality control.

Content

Vgl.: http://journal.code4lib.org/articles/12182.

Theme

Metadaten

Similar documents (content)

1. Lorenzo, L.; Mak, L.; Smeltekop, N.: FAST Headings in MODS : Michigan State University libraries digital repository case study (2023) 0.16

   0.15519589 = sum of:
     0.15519589 = product of:
       0.64664954 = sum of:
         0.10861968 = weight(abstract_txt:workflows in 2179) [ClassicSimilarity], result of:
           0.10861968 = score(doc=2179,freq=1.0), product of:
             0.15128584 = queryWeight, product of:
               1.0215614 = boost
               7.6584163 = idf(docFreq=56, maxDocs=44421)
               0.019337257 = queryNorm
             0.7179765 = fieldWeight in 2179, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               7.6584163 = idf(docFreq=56, maxDocs=44421)
               0.09375 = fieldNorm(doc=2179)
         0.03756414 = weight(abstract_txt:university in 2179) [ClassicSimilarity], result of:
           0.03756414 = score(doc=2179,freq=1.0), product of:
             0.09391139 = queryWeight, product of:
               1.1382546 = boost
               4.2666197 = idf(docFreq=1693, maxDocs=44421)
               0.019337257 = queryNorm
             0.3999956 = fieldWeight in 2179, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.2666197 = idf(docFreq=1693, maxDocs=44421)
               0.09375 = fieldNorm(doc=2179)
         0.078388534 = weight(abstract_txt:digital in 2179) [ClassicSimilarity], result of:
           0.078388534 = score(doc=2179,freq=4.0), product of:
             0.09660901 = queryWeight, product of:
               1.1544873 = boost
               4.3274655 = idf(docFreq=1593, maxDocs=44421)
               0.019337257 = queryNorm
             0.8113998 = fieldWeight in 2179, product of:
               2.0 = tf(freq=4.0), with freq of:
                 4.0 = termFreq=4.0
               4.3274655 = idf(docFreq=1593, maxDocs=44421)
               0.09375 = fieldNorm(doc=2179)
         0.16865769 = weight(abstract_txt:mods in 2179) [ClassicSimilarity], result of:
           0.16865769 = score(doc=2179,freq=1.0), product of:
             0.20286015 = queryWeight, product of:
               1.1829426 = boost
               8.868255 = idf(docFreq=16, maxDocs=44421)
               0.019337257 = queryNorm
             0.83139884 = fieldWeight in 2179, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               8.868255 = idf(docFreq=16, maxDocs=44421)
               0.09375 = fieldNorm(doc=2179)
         0.05479115 = weight(abstract_txt:description in 2179) [ClassicSimilarity], result of:
           0.05479115 = score(doc=2179,freq=1.0), product of:
             0.12078404 = queryWeight, product of:
               1.2908777 = boost
               4.83871 = idf(docFreq=955, maxDocs=44421)
               0.019337257 = queryNorm
             0.45362905 = fieldWeight in 2179, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.83871 = idf(docFreq=955, maxDocs=44421)
               0.09375 = fieldNorm(doc=2179)
         0.19862834 = weight(abstract_txt:metadata in 2179) [ClassicSimilarity], result of:
           0.19862834 = score(doc=2179,freq=2.0), product of:
             0.30704364 = queryWeight, product of:
               3.254246 = boost
               4.87927 = idf(docFreq=917, maxDocs=44421)
               0.019337257 = queryNorm
             0.6469059 = fieldWeight in 2179, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               4.87927 = idf(docFreq=917, maxDocs=44421)
               0.09375 = fieldNorm(doc=2179)
       0.24 = coord(6/25)
   

2. Kurth, M.; Ruddy, D.; Rupp, N.: Repurposing MARC metadata : using digital project experience to develop a metadata management design (2004) 0.15

   0.14941286 = sum of:
     0.14941286 = product of:
       0.74706423 = sum of:
         0.024244584 = weight(abstract_txt:design in 5748) [ClassicSimilarity], result of:
           0.024244584 = score(doc=5748,freq=1.0), product of:
             0.079201475 = queryWeight, product of:
               1.0453144 = boost
               3.9182436 = idf(docFreq=2399, maxDocs=44421)
               0.019337257 = queryNorm
             0.3061128 = fieldWeight in 5748, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.9182436 = idf(docFreq=2399, maxDocs=44421)
               0.078125 = fieldNorm(doc=5748)
         0.031303454 = weight(abstract_txt:university in 5748) [ClassicSimilarity], result of:
           0.031303454 = score(doc=5748,freq=1.0), product of:
             0.09391139 = queryWeight, product of:
               1.1382546 = boost
               4.2666197 = idf(docFreq=1693, maxDocs=44421)
               0.019337257 = queryNorm
             0.33332968 = fieldWeight in 5748, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.2666197 = idf(docFreq=1693, maxDocs=44421)
               0.078125 = fieldNorm(doc=5748)
         0.05657205 = weight(abstract_txt:digital in 5748) [ClassicSimilarity], result of:
           0.05657205 = score(doc=5748,freq=3.0), product of:
             0.09660901 = queryWeight, product of:
               1.1544873 = boost
               4.3274655 = idf(docFreq=1593, maxDocs=44421)
               0.019337257 = queryNorm
             0.58557737 = fieldWeight in 5748, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               4.3274655 = idf(docFreq=1593, maxDocs=44421)
               0.078125 = fieldNorm(doc=5748)
         0.22949576 = weight(abstract_txt:repurposing in 5748) [ClassicSimilarity], result of:
           0.22949576 = score(doc=5748,freq=2.0), product of:
             0.2232646 = queryWeight, product of:
               1.24101 = boost
               9.303573 = idf(docFreq=10, maxDocs=44421)
               0.019337257 = queryNorm
             1.0279093 = fieldWeight in 5748, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               9.303573 = idf(docFreq=10, maxDocs=44421)
               0.078125 = fieldNorm(doc=5748)
         0.40544838 = weight(abstract_txt:metadata in 5748) [ClassicSimilarity], result of:
           0.40544838 = score(doc=5748,freq=12.0), product of:
             0.30704364 = queryWeight, product of:
               3.254246 = boost
               4.87927 = idf(docFreq=917, maxDocs=44421)
               0.019337257 = queryNorm
             1.3204911 = fieldWeight in 5748, product of:
               3.4641016 = tf(freq=12.0), with freq of:
                 12.0 = termFreq=12.0
               4.87927 = idf(docFreq=917, maxDocs=44421)
               0.078125 = fieldNorm(doc=5748)
       0.2 = coord(5/25)
   

3. Wacker, M.; Han, M.-J.; Dartt, J.: Testing Resource Description and Access (RDA) with non-MARC standards (2011) 0.14

   0.1361021 = sum of:
     0.1361021 = product of:
       0.68051046 = sum of:
         0.10861968 = weight(abstract_txt:workflows in 2900) [ClassicSimilarity], result of:
           0.10861968 = score(doc=2900,freq=1.0), product of:
             0.15128584 = queryWeight, product of:
               1.0215614 = boost
               7.6584163 = idf(docFreq=56, maxDocs=44421)
               0.019337257 = queryNorm
             0.7179765 = fieldWeight in 2900, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               7.6584163 = idf(docFreq=56, maxDocs=44421)
               0.09375 = fieldNorm(doc=2900)
         0.065063 = weight(abstract_txt:university in 2900) [ClassicSimilarity], result of:
           0.065063 = score(doc=2900,freq=3.0), product of:
             0.09391139 = queryWeight, product of:
               1.1382546 = boost
               4.2666197 = idf(docFreq=1693, maxDocs=44421)
               0.019337257 = queryNorm
             0.6928127 = fieldWeight in 2900, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               4.2666197 = idf(docFreq=1693, maxDocs=44421)
               0.09375 = fieldNorm(doc=2900)
         0.16865769 = weight(abstract_txt:mods in 2900) [ClassicSimilarity], result of:
           0.16865769 = score(doc=2900,freq=1.0), product of:
             0.20286015 = queryWeight, product of:
               1.1829426 = boost
               8.868255 = idf(docFreq=16, maxDocs=44421)
               0.019337257 = queryNorm
             0.83139884 = fieldWeight in 2900, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               8.868255 = idf(docFreq=16, maxDocs=44421)
               0.09375 = fieldNorm(doc=2900)
         0.09490105 = weight(abstract_txt:description in 2900) [ClassicSimilarity], result of:
           0.09490105 = score(doc=2900,freq=3.0), product of:
             0.12078404 = queryWeight, product of:
               1.2908777 = boost
               4.83871 = idf(docFreq=955, maxDocs=44421)
               0.019337257 = queryNorm
             0.78570855 = fieldWeight in 2900, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               4.83871 = idf(docFreq=955, maxDocs=44421)
               0.09375 = fieldNorm(doc=2900)
         0.24326904 = weight(abstract_txt:metadata in 2900) [ClassicSimilarity], result of:
           0.24326904 = score(doc=2900,freq=3.0), product of:
             0.30704364 = queryWeight, product of:
               3.254246 = boost
               4.87927 = idf(docFreq=917, maxDocs=44421)
               0.019337257 = queryNorm
             0.7922947 = fieldWeight in 2900, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               4.87927 = idf(docFreq=917, maxDocs=44421)
               0.09375 = fieldNorm(doc=2900)
       0.2 = coord(5/25)
   

4. Kirschenbaum, M.: Documenting digital images : textual meta-data at the Blake Archive (1998) 0.12

   0.12266066 = sum of:
     0.12266066 = product of:
       0.6133033 = sum of:
         0.11899148 = weight(abstract_txt:accompanying in 4287) [ClassicSimilarity], result of:
           0.11899148 = score(doc=4287,freq=1.0), product of:
             0.16076933 = queryWeight, product of:
               1.0530934 = boost
               7.894805 = idf(docFreq=44, maxDocs=44421)
               0.019337257 = queryNorm
             0.74013793 = fieldWeight in 4287, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               7.894805 = idf(docFreq=44, maxDocs=44421)
               0.09375 = fieldNorm(doc=4287)
         0.13665052 = weight(abstract_txt:virginia in 4287) [ClassicSimilarity], result of:
           0.13665052 = score(doc=4287,freq=1.0), product of:
             0.17630588 = queryWeight, product of:
               1.102805 = boost
               8.267481 = idf(docFreq=30, maxDocs=44421)
               0.019337257 = queryNorm
             0.7750763 = fieldWeight in 4287, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               8.267481 = idf(docFreq=30, maxDocs=44421)
               0.09375 = fieldNorm(doc=4287)
         0.03756414 = weight(abstract_txt:university in 4287) [ClassicSimilarity], result of:
           0.03756414 = score(doc=4287,freq=1.0), product of:
             0.09391139 = queryWeight, product of:
               1.1382546 = boost
               4.2666197 = idf(docFreq=1693, maxDocs=44421)
               0.019337257 = queryNorm
             0.3999956 = fieldWeight in 4287, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.2666197 = idf(docFreq=1693, maxDocs=44421)
               0.09375 = fieldNorm(doc=4287)
         0.039194267 = weight(abstract_txt:digital in 4287) [ClassicSimilarity], result of:
           0.039194267 = score(doc=4287,freq=1.0), product of:
             0.09660901 = queryWeight, product of:
               1.1544873 = boost
               4.3274655 = idf(docFreq=1593, maxDocs=44421)
               0.019337257 = queryNorm
             0.4056999 = fieldWeight in 4287, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.3274655 = idf(docFreq=1593, maxDocs=44421)
               0.09375 = fieldNorm(doc=4287)
         0.2809029 = weight(abstract_txt:metadata in 4287) [ClassicSimilarity], result of:
           0.2809029 = score(doc=4287,freq=4.0), product of:
             0.30704364 = queryWeight, product of:
               3.254246 = boost
               4.87927 = idf(docFreq=917, maxDocs=44421)
               0.019337257 = queryNorm
             0.9148631 = fieldWeight in 4287, product of:
               2.0 = tf(freq=4.0), with freq of:
                 4.0 = termFreq=4.0
               4.87927 = idf(docFreq=917, maxDocs=44421)
               0.09375 = fieldNorm(doc=4287)
       0.2 = coord(5/25)
   

5. Hardesty, J.L.; Young, J.B.: ¬The semantics of metadata : Avalon Media System and the move to RDF (2017) 0.12

   0.12077688 = sum of:
     0.12077688 = product of:
       0.503237 = sum of:
         0.07932766 = weight(abstract_txt:accompanying in 4896) [ClassicSimilarity], result of:
           0.07932766 = score(doc=4896,freq=1.0), product of:
             0.16076933 = queryWeight, product of:
               1.0530934 = boost
               7.894805 = idf(docFreq=44, maxDocs=44421)
               0.019337257 = queryNorm
             0.4934253 = fieldWeight in 4896, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               7.894805 = idf(docFreq=44, maxDocs=44421)
               0.0625 = fieldNorm(doc=4896)
         0.03541581 = weight(abstract_txt:university in 4896) [ClassicSimilarity], result of:
           0.03541581 = score(doc=4896,freq=2.0), product of:
             0.09391139 = queryWeight, product of:
               1.1382546 = boost
               4.2666197 = idf(docFreq=1693, maxDocs=44421)
               0.019337257 = queryNorm
             0.37711945 = fieldWeight in 4896, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               4.2666197 = idf(docFreq=1693, maxDocs=44421)
               0.0625 = fieldNorm(doc=4896)
         0.05225902 = weight(abstract_txt:digital in 4896) [ClassicSimilarity], result of:
           0.05225902 = score(doc=4896,freq=4.0), product of:
             0.09660901 = queryWeight, product of:
               1.1544873 = boost
               4.3274655 = idf(docFreq=1593, maxDocs=44421)
               0.019337257 = queryNorm
             0.5409332 = fieldWeight in 4896, product of:
               2.0 = tf(freq=4.0), with freq of:
                 4.0 = termFreq=4.0
               4.3274655 = idf(docFreq=1593, maxDocs=44421)
               0.0625 = fieldNorm(doc=4896)
         0.11243846 = weight(abstract_txt:mods in 4896) [ClassicSimilarity], result of:
           0.11243846 = score(doc=4896,freq=1.0), product of:
             0.20286015 = queryWeight, product of:
               1.1829426 = boost
               8.868255 = idf(docFreq=16, maxDocs=44421)
               0.019337257 = queryNorm
             0.5542659 = fieldWeight in 4896, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               8.868255 = idf(docFreq=16, maxDocs=44421)
               0.0625 = fieldNorm(doc=4896)
         0.036527433 = weight(abstract_txt:description in 4896) [ClassicSimilarity], result of:
           0.036527433 = score(doc=4896,freq=1.0), product of:
             0.12078404 = queryWeight, product of:
               1.2908777 = boost
               4.83871 = idf(docFreq=955, maxDocs=44421)
               0.019337257 = queryNorm
             0.30241936 = fieldWeight in 4896, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.83871 = idf(docFreq=955, maxDocs=44421)
               0.0625 = fieldNorm(doc=4896)
         0.1872686 = weight(abstract_txt:metadata in 4896) [ClassicSimilarity], result of:
           0.1872686 = score(doc=4896,freq=4.0), product of:
             0.30704364 = queryWeight, product of:
               3.254246 = boost
               4.87927 = idf(docFreq=917, maxDocs=44421)
               0.019337257 = queryNorm
             0.60990876 = fieldWeight in 4896, product of:
               2.0 = tf(freq=4.0), with freq of:
                 4.0 = termFreq=4.0
               4.87927 = idf(docFreq=917, maxDocs=44421)
               0.0625 = fieldNorm(doc=4896)
       0.24 = coord(6/25)