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.