# US 2025/0147937 A1 · Data cleaning device and data cleaning method

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2025/0147937 A1
- Document ID: US20250147937A1
- Status: Published application
- Kind: A1
- Application number: 18/522,849
- Filed: 2023-11-29
- Published: 2025-05-08
- Earliest claimed: 2023-11-06
- Assignees: Institute for Information Industry
- Applicants: Institute for Information Industry
- Inventors: Yu-Chen TSAI; Ming-Fang WENG
- Web page: https://patentgrep.com/patent/US20250147937A1

## CPC

- G06F 16/215: Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
- G06F 16/258: {Data format conversion from or to a database}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

The present invention is a data cleaning device executing a data cleaning method. The data cleaning method includes executing an application, and executing a prompt plugin management program. The operation of executing the prompt plugin management program includes generating a prompt instruction based on an unformatted content via a first prompt template, transmitting the prompt instruction to a first device, and receiving a formatted content from the first device. The formatted content is generated by the first device based on the prompt instruction through a large language model.

## Claims

### Claim 1

A data cleaning device, comprising:
a storage unit, configured to store an application, a prompt plugin managing program, and a prompt template registry;
a processor, connected to the storage unit, configured to read the application from the storage unit and execute the application, wherein executing the application comprises:
executing the prompt plugin managing program to access a first prompt template from at least one prompt template indicated in the prompt template registry;
generating a prompt instruction based on an unformatted content through the first prompt template and transmitting the prompt instruction to a first device; and
receiving a formatted content from the first device, wherein the first device generates the formatted content based on the prompt instruction through a large language model.

### Claim 2 (depends on 1)

The data cleaning device of claim 1, wherein executing the prompt plugin managing program further comprises:
scanning a prompt template directory at a preset address; and
downloading at least one second prompt template from a second device through a loader and storing the at least one second prompt template in the prompt template directory at the preset address, in response to the execution of the prompt plugin managing program.

### Claim 3 (depends on 2)

The data cleaning device of claim 2, wherein executing the prompt plugin managing program further comprises:
updating the prompt template registry according to the at least one second prompt template.

### Claim 4 (depends on 2)

The data cleaning device of claim 2, wherein a purpose of each of the at least one second prompt template and the at least one prompt template is predefined through a prompt template service interface.

### Claim 5 (depends on 1)

The data cleaning device of claim 1, wherein executing the application further comprises:
generating the unformatted content based on an input from a user.

### Claim 6 (depends on 1)

The data cleaning device of claim 1, wherein the prompt instruction comprises at least one of an output data type definition, an output format definition, and an output example definition.

### Claim 7 (depends on 1)

The data cleaning device of claim 1, wherein generating the prompt instruction based on the unformatted content through the first prompt template comprises:
performing a preprocessing on the unformatted content to generate a preprocessed unformatted content; and
generating the prompt instruction based on the preprocessed unformatted content, wherein the preprocessing comprises a data cleaning process.

### Claim 8 (depends on 7)

The data cleaning device of claim 7, wherein the data cleaning process comprises at least one of a typo handling, an illegal character handling, a missing value handling, and a data type handling.

### Claim 9 (depends on 1)

The data cleaning device of claim 1, wherein executing the application further comprises:
storing the formatted content or displaying the formatted content; and
clearing a resource used for executing the prompt plugin managing program, wherein the resource comprises at least one storage space.

### Claim 10

A data cleaning method, implemented by a data cleaning device, comprising the steps of:
reading an application and executing the application, wherein executing the application comprises:
executing a prompt plugin managing program to access a first prompt template from at least one prompt template indicated in the prompt template registry;
generating a prompt instruction based on an unformatted content through the first prompt template and transmitting the prompt instruction to a first device; and
receiving a formatted content from the first device, wherein the first device generates the formatted content based on the prompt instruction through a large language model.

### Claim 11 (depends on 10)

The data cleaning method of claim 10, wherein executing the prompt plugin managing program further comprises:
scanning a prompt template directory at a preset address; and
downloading at least one second prompt template from a second device through a loader and storing the at least one second prompt template in the prompt template directory at the preset address, in response to the execution of the prompt plugin managing program.

### Claim 12 (depends on 11)

The data cleaning method of claim 11, wherein executing the prompt plugin managing program further comprises:
updating the prompt template registry according to the at least one second prompt template.

### Claim 13 (depends on 11)

The data cleaning method of claim 11, wherein a purpose of each of the at least one second prompt template and the at least one prompt template is predefined through a prompt template service interface.

### Claim 14 (depends on 10)

The data cleaning method of claim 10, wherein executing the application further comprises:
generating the unformatted content based on an input from a user.

### Claim 15 (depends on 10)

The data cleaning method of claim 10, wherein the prompt instruction comprises at least one of an output data type definition, an output format definition, and an output example definition.

### Claim 16 (depends on 10)

The data cleaning method of claim 10, wherein generating the prompt instruction based on the unformatted content through the first prompt template comprises:
performing a preprocessing on the unformatted content to generate a preprocessed unformatted content; and
generating the prompt instruction based on the preprocessed unformatted content, wherein the preprocessing comprises a data cleaning process.

### Claim 17 (depends on 16)

The data cleaning method of claim 16, wherein the data cleaning process comprises at least one of a typo handling, an illegal character handling, a missing value handling, and a data type handling.

### Claim 18 (depends on 10)

The data cleaning method of claim 10, wherein executing the application further comprises:
storing the formatted content or displaying the formatted content; and
clearing a resource used for executing the prompt plugin managing program, wherein the resource comprises at least one storage space.
