HumanExposure / ChemicalExposure-SSC

2 stars 1 forks source link

Special Chem Document Name Cleanup #1177

Closed Sakshi-Handa closed 5 months ago

Sakshi-Handa commented 7 months ago

In the datagroup SpecialChem Adhesives: https://ccte-factotum.epa.gov/datagroup/887/

Some of the document titles are inaccurate, and need to be fixed manually.

  1. Some documents are missing the full document title. Ex. https://ccte-factotum.epa.gov/datadocument/1631571/ Shows the title as '1' but the title for the substance is '1,6-Hexanediol'.

  2. Some documents have the substance name repeated in the document title. Ex. https://ccte-factotum.epa.gov/datadocument/1629337/ Has the substance '10 WOLLASTOCOAT 10 WOLLASTOCOAT' repeated in the title.

To address this, look through the Special Chem documents for errors in the document name, such as missing info or repeated text. I would suggest doing a database query to see all of the document titles at once.

use the below csv file to identify documents that have issues.

Factotum_SpecialChem_Adhesives_documents_20240502.csv