Systems and methods for data type identification and adjustment

Patent metadata

Field	Value
Publication number	US-11093516-B2
Application number	US-201615270396-A
Country	US
Kind code	B2
Filing date	Sep 20, 2016
Priority date	Sep 20, 2016
Publication date	Aug 17, 2021
Grant date	Aug 17, 2021

Abstract

A system includes an operating system executed by a processor and memory. A data type identifier changing application is executed by the operating system and is configured to display a table including data entries that are arranged in rows and columns and that include data type identifiers. The data type identifier changing application is configured to generate a list including two or more of the data type identifiers corresponding to rows in a selected column. The data type identifier changing application is configured to change one of the data type identifiers in the list corresponding to a plurality of rows in the selected column to one of another one of the data type identifiers in the list or a data type identifier that is not in the list.

First claim

What is claimed is:

1. A system comprising:
a processor and memory;
an operating system executed by the processor and memory;
a data type identifier changing application that is executed by the operating system and that is configured to:
provide, via a graphical user interface on a device, a display of a table including data entries that are arranged in rows and columns, wherein each data entry in the table is assigned a data type identifier identifying a type of data for a value in the corresponding data entry;
detect a selection of a column of data entries from the table;
determine mismatched data type identifiers within the selected column of data entries based on a first subset of data entries from the column of data entries being associated with a first data type and a second subset of data entries from the column of data entries being associated with a second data type, wherein the mismatched data type identifiers refer to different datatypes where one of the different datatypes is incompatible with performing operations that call for one of the first data type and the second data type; and
based on determining the mismatched data type identifiers between the first subset of data entries and the second subset of data entries, causing the first datatype associated with the first subset of data entries to be reassigned to the second datatype, wherein causing the first datatype to be reassigned includes:
generating a list of two or more datatype identifiers corresponding to the mismatched datatype identifiers within the selected group of data entries, the list including a first indicator of the first data type and a second indicator of the second data type;
providing a display of a selectable command to reassign a first data type identifier for each entry from the first subset of entries to a second data type identifier corresponding to the second subset of entries; and
based on a detected selection of the selectable command, reassigning the first data type identifier for each entry from the first subset of entries to the second data type identifier to correct at least one of the two or more mismatched data type identifiers within the selected group of data entries.

2. The system of claim 1 , wherein the data type identifier changing application generates row counts corresponding to a number of rows in the selected column having a corresponding one of the two or more data type identifiers and displays the row counts in the list.

3. The system of claim 1 , wherein at least one data type identifier from the two or more data type identifiers include data entities selected from one or more of an address, a social security number, a phone number, or a zip code.

4. The system of claim 1 , wherein the data type identifier changing application iteratively performs acts of providing displays of the table, detecting selections of the column of data entries, determining one or more additional mismatched data type identifiers within detected selections of the column of data entries, generating one or more additional lists of multiple datatype identifiers corresponding to the one or more additional mismatched data type identifiers, providing additional displays of selectable commands to reassign data type identifiers, and reassigning one or more additional data type identifiers until only one data type identifier is associated with each data entry from the selected column of data entries from the table.

5. The system of claim 1 , wherein the data type identifier changing application is configured as an add-in application to an application selected from one or more of a database application, a spreadsheet application, or a data wrangling application.

6. The system of claim 1 , wherein the data type identifier changing application selectively displays sample data entries in rows of one of the two or more data type identifiers in the list.

7. The system of claim 1 , wherein the list is displayed in a dialog box including a plurality of command buttons corresponding to the two or more data type identifiers.

8. The system of claim 7 , wherein of the selectable command includes a text descriptor for a corresponding one of the two or more data type identifiers, the text descriptor including a count of rows for the corresponding one of the two or more data type identifiers.

9. A non-transitory, tangible computer-readable medium storing instructions for changing data type identifiers, the non-transitory, tangible computer-readable medium comprising instructions for:
providing, via a graphical user interface on a device, a display of a table including data entries that are arranged in rows and columns, wherein each data entry in the table is assigned a data type identifier identifying a type of data for a value in the corresponding data entry;
detecting a selection of a column of data entries from the table;
determining mismatched data type identifiers within the selected column of data entries based on a first subset of data entries from the column of data entries being associated with a first data type and a second subset of data entries from the column of data entries being associated with a second data type, wherein the mismatched data type identifiers refer to different datatypes where one of the different datatypes is incompatible with performing operations that call for one of the first data type and the second data type; and
based on determining the mismatched data type identifiers between the first subset of data entries and the second subset of data entries, causing the first datatype associated with the first subset of data entries to be reassigned to the second datatype, wherein causing the first datatype to be reassigned includes:
generating a list of two or more datatype identifiers corresponding to the mismatched datatype identifiers within the selected group of data entries, the list including a first indicator of the first data type and a second indicator of the second data type;
providing a display of a selectable command to reassign a first data type identifier for each entry from the first subset of entries to a second data type identifier corresponding to the second subset of entries; and
based on a detected selection of the selectable command, reassigning the first data type identifier for each entry from the first subset of entries to the second data type identifier to correct at least one of the two or more mismatched data type identifiers within the selected group of data entries.

10. The non-transitory, tangible computer-readable medium of claim 9 , further comprising instructions for:
generating row counts corresponding to a number of rows in the selected column having a corresponding one of the two or more data type identifiers; and
displaying the row counts in the list.

11. The non-transitory, tangible computer-readable medium of claim 9 , wherein at least one data type identifier from the two or more data type identifiers include data entities selected from one or more of an address, a social security number, a phone number, and a zip code.

12. The non-transitory, tangible computer-readable medium of claim 9 , further comprising instructions for iteratively performing acts of providing displays of the table, detecting selections of the column of data entries, determining one or more additional mismatched data type identifiers within detected selections of the column of data entries, generating one or more additional lists of multiple datatype identifiers corresponding to the one or more additional mismatched data type identifiers, providing additional displays of selectable commands to reassign data type identifiers, and reassigning one or more additional

Assignees

• Microsoft Technology Licensing Llc

Inventors

• Cheung Chairy Chiu Ying
• Jones Taurean Addair

Classifications

• G06F16/2462 Primary

  Approximate or statistical queries · CPC title