The invention relates to the technical field of
artificial intelligence and
data processing, in particular to a
data format conversion and import method and device based on
artificial intelligence. The method comprises the following steps: acquiring a
source data file containing a plurality of fields, wherein the names, formats or units of the fields are not uniform; analyzing
semantics of the
source data through a large
language model (LLM) or other
artificial intelligence models, and determining a mapping relation with a target
data structure; deducing or complementing missing or non-direct corresponding fields, including unit or format conversion, character
string analysis, numerical calculation, time conversion and deduction based on external knowledge or business rules; and generating target data meeting the requirements of the target
system, and importing the target data into a
database or outputting the target data as a file in a specified format. The method can be suitable for various scenes, such as reckoning the year of birth according to the age, deriving the city according to the postcode, analyzing the packaging information to calculate the weight of a single piece, converting the exchange rate, reckoning the
natural language time and the like. According to the method and the device, the intelligent import of the
open data file can be realized without a fixed template, the manual operation cost is remarkably reduced, the
data processing efficiency and accuracy are improved, and the method and the device have good universality and expansibility.