Data Alignment and Pantone Mapping

I already have the full raw data set for the Hanky Family art project and a live reference feed from the NTA on https://hankyfamily.com/. What still needs doing is the precise record-to-record alignment between my data and the NTA data, using their shared record IDs / reference numbers as the single source of truth.

Once every record is correctly paired, each one must carry the accurate Pantone colour that belongs to it. That involves three steps:
• assigning the correct Pantone to every matched record,
• checking and standardising the Pantone references already in the file so they follow the exact Pantone naming conventions, and
• producing a compact colour guide that shows every Pantone used, its code, and the records it appears in.

Deliverables I’ll accept:
• a cleaned, fully aligned master file (CSV or XLSX) ready to slot straight back into the site’s database,
• a stand-alone colour guide, and
• brief notes outlining any IDs that could not be paired and how you resolved colour conflicts.

Strong data-wrangling skills and solid familiarity with official Pantone values are essential for this to run smoothly.