Data analysis method and system for spot resources in the steel trade industry

Abstract

The invention provides a data analysis method and system of spot resources for the steel trading industry. The method includes: 1, acquiring an Excel document containing steel spot resources, as a data source to be analyzed; 2, recognizing and partitioning the data source to be analyzed; 3, screening data of each zone through a steel header feature database after recognizing and partition, and retaining the data most matching with the steel header database so as to determine all target areas; 4, starting a preprocessing program to preliminarily format the data of the target areas; 5, extracting and sampling the data of the target areas, comparing the data with basic data provided by the steel header database, and determining specific names of data columns or data rows; 6, washing the compared data to obtain complete data information, and storing the complete data information into a base. The data analysis method and system has the advantage that data conversion rate is greatly increased.

Description

technical field [0001] The invention relates to the technical field of data analysis, in particular to a data analysis method and system for spot resources in the steel trade industry. Background technique [0002] The "search" of the steel trade industry is the same as other industries. When users enter any website of the steel trade industry, they will find a search box in a prominent position, and they can search by entering keywords in the search box. The search boxes in various industries and fields are similar in form, but the implementation methods of the background are very different based on the characteristics of the industry or the website itself. But no matter what method is based on, all search behaviors will be carried out within a given area. In the steel trade industry, such a given area for finding target information is called a "resource pool". The "resource pool" of the steel trade industry generally includes the following information: variety, product n...

AI Technical Summary

Problems solved by technology

[0005] The purpose of the present invention is to provide a data analysis method and system for the analysis of resource documents in the steel trade industry in the prior art, which has relatively high requirements for the format specifications of the original document content itself and the technical problem that the effective data conversion rate is relatively low. By using the steel header feature library and a variety of data algorithms, the effective data conversion rate has been greatly improved

Images