3. Convert MARC files to a CSV

Set-up

To complete this step, you need:

• Access to the command line
• Python 3.0+ with:
  • pandas
  • pymarc
• Scripts:
  • extractMARCToGeoCSV.py

---

Purpose

Extracts relevant fields from MARC records to a CSV called "marcRecords.csv".

---

Instructions

1. Run extractMARCToGeoCSV.py on the MARC files edited in Step 1 & 2.
   • Converts language codes from the 008 field and the 041 field to the written value.
   • Converts the datetype code from the 008 field to the written value.
   • Coverts the category of material code from the 007 field to the written value.
   • Finds the OCLC number, deleting prefixes.
   • Transforms bounding box coordinates to W, S, E, N order.
   • Extracts geographic subject headings from the 600 fields, and divides them into likely FAST headings and LCNAF headings.

---

Go to next step (4. Clean up CSV metadata)→

---