The present invention discloses a method for extracting standardized product units based on the details data of commodities in invoices, belonging to the field of
big data processing. Specifically, it includes: First, define the industrial chain and determine the scope of the industrial chain; and initially establish a knowledge-based industrial
chain structure. Then, determine the basic SPU for each link in the upstream,
midstream, and downstream of the industrial chain, that is, the
common name of the commodity link. Next, write the policy statements for the commodity / service link and determine the
invoice code. In the superset internal
system platform, use MySQL statements to search for the
invoice details data related to the commodity / service link, extract the standardized product units of the
invoice details data after removing the
impurity invoice data, and finally,
label the SPU tags for the invoice details data. The present invention has the advantages of fast extraction and batch acquisition, as well as the significance of improving the
data analysis efficiency and increasing the
data application fields.