Data normalization and irregularity detection system

Patent metadata

Field	Value
Publication number	US-12417337-B2
Application number	US-202217652646-A
Country	US
Kind code	B2
Filing date	Feb 25, 2022
Priority date	Dec 22, 2017
Publication date	Sep 16, 2025
Grant date	Sep 16, 2025

Abstract

A computer-implemented method is provided to provide analysis of claim information. The system may receive claim data from a plurality of entities and, for one or more claim items in the received claim data, determine a format of the claim item. The system may convert the claim item from the determined format into a standard format. The system may receive a selection of one or more providers, and determine one or more claim items associated with the provider in the selection. The system may generate a user interface, the user interface comprising a visual representation of one or more attributes of the one or more claim items.

First claim

What is claimed is:

1. A method comprising:
receiving a file comprising a plurality of records, the plurality of records comprising: (i) a first record associated with a first person and a first provider, and (ii) a second record associated with a second person and a second provider, the first person different from the second person;
determining a first format of the plurality of records;
converting, from the first format into a standard format, (i) the first record to a first data item and (ii) the second record to a second data item, wherein converting the first record to the first data item further comprises:
applying a regular expression to a data value of the first record;
receiving a match between the regular expression and the data value; and
assigning text to a data field in the first data item based at least in part on receiving the match between the regular expression and the data value; and

causing presentation, in a first user interface, of a statistical measure based at least in part on a plurality of data items comprising at least one of the first data item or the second data item,
wherein the method is performed by one or more computer hardware processors.

2. The method of claim 1 , further comprising:
causing presentation, in a second user interface, of a table comprising the plurality of data items;
receiving, via the second user interface, a filter parameter;
determining, from the plurality of data items, a subset of data items associated with the filter parameter; and
causing presentation, in the second user interface, of the subset of data items in the table.

3. The method of claim 1 , further comprising:
causing presentation, in a second user interface, of a graph based at least in part on the plurality of data items.

4. The method of claim 1 , further comprising:
receiving, in the first user interface, user input indicating receive a selection of the first provider;
determining, from the plurality of data items, a subset of data items associated with the first provider, the subset of data items (i) including the first data item and (ii) excluding the second data item; and
causing presentation, in a second user interface, of a visualization based at least in part on the subset of data items associated with the first provider.

5. The method of claim 4 , wherein the visualization comprises at least one of a plot, a graph, or a chart.

6. The method of claim 1 , wherein converting the first record to the first data item further comprises:
identifying, from a description mapping list, a first mapping between the text and the regular expression.

7. The method of claim 1 , wherein converting the second record to the second data item further comprises:
identifying a data type for a second data value of the second record;
calculating, based at least in part on the data type, a converted value from the second data value; and
assigning the converted value to a second data field in the second data item.

8. The method of claim 7 , wherein calculating the converted value further comprises:
at least one of, multiplying or dividing the second data value by a conversion factor.

9. A system comprising:
a computer readable storage medium having program instructions embodied therewith; and
one or more processors configured to execute the program instructions to cause the system to:
receive a file comprising a plurality of records, the plurality of records comprising: (i) a first record associated with a first person and a first provider, and (ii) a second record associated with a second person and a second provider, the first person different from the second person;
determine a first format of the plurality of records;
convert, from the first format into a standard format, (i) the first record to a first data item and (ii) the second record to a second data item, wherein converting the first record to the first data item further comprises:
applying a regular expression to a data value of the first record;
receiving a match between the regular expression and the data value; and
assigning text to a data field in the first data item based at least in part on receiving the match between the regular expression and the data value; and

cause presentation, in a first user interface, of a statistical measure based at least in part on a plurality of data items comprising at least one of the first data item or the second data item.

10. The system of claim 9 , wherein the one or more processors are configured to execute additional program instructions to cause the system to:
cause presentation, in a second user interface, of a table comprising the plurality of data items;
receive, via the second user interface, a filter parameter;
determine, from the plurality of data items, a subset of data items associated with the filter parameter; and
cause presentation, in the second user interface, of the subset of data items in the table.

11. The system of claim 9 , wherein the one or more processors are configured to execute additional program instructions to cause the system to:
cause presentation, in a second user interface, of a graph based at least in part on the plurality of data items.

12. The system of claim 9 , wherein the one or more processors are configured to execute additional program instructions to cause the system to:
receive, in the first user interface, user input indicating receive a selection of the first provider;
determine, from the plurality of data items, a subset of data items associated with the first provider, the subset of data items (i) including the first data item and (ii) excluding the second data item; and
cause presentation, in a second user interface, of a visualization based at least in part on the subset of data items associated with the first provider.

13. The system of claim 12 , wherein the visualization comprises at least one of a plot, a graph, or a chart.

14. The system of claim 9 , wherein converting the first record to the first data item further comprises:
identifying, from a description mapping list, a first mapping between the text and the regular expression.

15. The system of claim 9 , wherein converting the second record to the second data item further comprises:
identifying a data type for a second data value of the second record;
calculating, based at least in part on the data type, a converted value from the second data value; and
assigning the converted value to a second data field in the second data item.

16. The system of claim 15 , wherein calculating the converted value further comprises:
at least one of, multiplying or dividing the second data value by a conversion factor.

Assignees

• Palantir Technologies Inc

Inventors

• Sharzer Charles
• Bhat Meghana
• Brady William

Classifications

• G06F16/90332

  Natural language query formulation or dialogue systems · CPC title

• G06F16/907

  Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually · CPC title

• G06F3/0482

  Interaction with lists of selectable items, e.g. menus · CPC title

• H04W12/12

  Detection or prevention of fraud · CPC title

• G06F17/18

  for evaluating statistical data {, e.g. average values, frequency distributions, probability functions, regression analysis (forecasting specially adapted for a specific administrative, business or logistic context G06Q10/04)} · CPC title