⚠️ This column is a sharing of the prompt creation process for free educational purposes, and is not any investment, legal, or financial advice. AI execution results may contain errors and independent verification is essential, and all responsibility for use is entirely attributed to the user. It cannot be used directly for business decision-making. [View all mandatory confirmation items below the 30-week timeline before use[]](https://www.notion.so/30-29f84ddcec3c80a1a87eda9883d81453?pvs=21)
Now the search methodology is complete. We have designed how to find classification codes from 5 sources. But what should we do after searching for classification codes from each of the 5 sources?
How do we combine the classification codes scattered across sources into one? And do all Products really have classification codes? Are there any missing products?
I checked the situation using Sequential Thinking. 'Can we realistically obtain all the data after searching 5 sources?’
Claude analyzed. "1st thought: Each source will have found classification codes for some products.", "3rd thought: Some products will only appear in source 1. Some products will appear in sources 2 and 3.", "5th thought: There will be duplicates. The same product may appear in multiple sources.”
"7th thought: There will also be omissions. Some products may not appear in any of the 5 sources.", "10th thought: Therefore, two tasks are needed. First, duplicate removal. Second, omission verification.", "12th thought: Omission verification comes before duplicate removal. Because the mapping between Product and HTS codes is the core.”
Ultimately, integration work is needed, but before integrating, we must first verify that all Products have classification codes.
In Week 11, when collecting Economic data, we needed economic scale for all Products as much as possible, and HTS codes are the same. Before integrating, we must first verify the mapping. How do we verify?