Systems and methods for data type identification and adjustment

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.

1 - 20 . (canceled) 
     
     
         21 . 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:
 identify a dataset including a plurality of data entries, each data entry from the plurality of data entries having a data type identifier indicating a type of data for a value in the corresponding data entry; 
 determine mismatched data type identifiers within the dataset based on a first subset of data entries from the dataset being associated with a first data type and a second subset of data entries from the dataset being associated with a second data type, wherein determining the mismatched data type identifiers is based on the first data type being incompatible with performing an operation that calls for 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, cause each value from the first subset of data entries to be reassigned to the second data type. 
   
     
     
         22 . The system of  claim 21 , wherein the dataset includes a relational database of data including a table of data entries, the table of data entries being organized in a plurality of columns and a plurality of rows. 
     
     
         23 . The system of  claim 22 , wherein the plurality of data entries includes a selected column or row of data entries within the table of data entries, and wherein the first subset of data entries and the second subset of data entries are interspersed throughout the selected column or row of data entries. 
     
     
         24 . The system of  claim 21 , wherein the data type identifier for each data entry includes data type metadata associated with a respective data entry indicating the type of data, and wherein causing each value from the first subset of data entries to be reassigned to the second data type includes modifying data type metadata associated with the first subset of entries to match data type metadata for the second subset of entries. 
     
     
         25 . The system of  claim 21 , wherein where determining the mismatched data type identifiers includes:
 detecting a selection of a grouping of data entries from the dataset;   identifying the first subset of data entries based on data entries from the selected grouping of data entries being associated with a first data type; and   identifying the second subset of data entries based on data entries from the selected grouping of data entries being associated with a second data type being different from the first data type and being incompatible with performing the operation that calls for the second data type.   
     
     
         26 . The system of  claim 21 , 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. 
     
     
         27 . The system of  claim 21 , wherein the data type identifier changing application is further configured to:
 determine additional mismatched data type identifiers within the dataset based on a third subset of data entries from the dataset being associated with a third data type from the reassigned second data type, wherein determining the additional mismatched data type identifiers is based on the third data type being incompatible with performing the operation that calls for the reassigned second data type; and   based on determining the additional mismatched data type identifiers, cause each value from the third subset of data entries to be reassigned to the second data type.   
     
     
         28 . The system of  claim 21 , 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. 
     
     
         29 . The system of  claim 21 , wherein causing each value from the first subset of data entries to be reassigned to the second data type includes:
 determining whether reassigning the first data type identifier to the second data type identifier for any of the first subset of data entries would cause invalid data in other entries from the dataset; and   reassigning the first subset of data entries to the second data type is based on determining that reassigning the first data type identifier to the second data type identifier would not cause invalid data in other entries from the dataset.   
     
     
         30 . A method, comprising:
 identifying a dataset including a plurality of data entries, each data entry from the plurality of data entries having a data type identifier indicating a type of data for a value in the corresponding data entry;   determining mismatched data type identifiers within the dataset based on a first subset of data entries from the dataset being associated with a first data type and a second subset of data entries from the dataset being associated with a second data type, wherein determining the mismatched data type identifiers is based on the first data type being incompatible with performing an operation that calls for 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 each value from the first subset of data entries to be reassigned to the second data type.   
     
     
         31 . The method of  claim 30 , wherein the dataset includes a relational database of data including a table of data entries, the table of data entries being organized in a plurality of columns and a plurality of rows. 
     
     
         32 . The method of  claim 31 , wherein the plurality of data entries includes a selected column or row of data entries within the table of data entries, and wherein the first subset of data entries and the second subset of data entries are interspersed throughout the selected column or row of data entries. 
     
     
         33 . The method of  claim 30 , wherein the data type identifier for each data entry includes data type metadata associated with a respective data entry indicating the type of data, and wherein causing each value from the first subset of data entries to be reassigned to the second data type includes modifying data type metadata associated with the first subset of entries to match data type metadata for the second subset of entries. 
     
     
         34 . The method of  claim 30 , wherein where determining the mismatched data type identifiers includes:
 detecting a selection of a grouping of data entries from the dataset;   identifying the first subset of data entries based on data entries from the selected grouping of data entries being associated with a first data type; and   identifying the second subset of data entries based on data entries from the selected grouping of data entries being associated with a second data type being different from the first data type and being incompatible with performing the operation that calls for the second data type.   
     
     
         35 . The method of  claim 30 , 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. 
     
     
         36 . The method of  claim 30 , wherein the data type identifier changing application is further configured to:
 determine additional mismatched data type identifiers within the dataset based on a third subset of data entries from the dataset being associated with a third data type from the reassigned second data type, wherein determining the additional mismatched data type identifiers is based on the third data type being incompatible with performing the operation that calls for the reassigned second data type; and   based on determining the additional mismatched data type identifiers, cause each value from the third subset of data entries to be reassigned to the second data type.   
     
     
         37 . The method of  claim 30 , 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. 
     
     
         38 . The method of  claim 30 , wherein causing each value from the first subset of data entries to be reassigned to the second data type includes:
 determining whether reassigning the first data type identifier to the second data type identifier for any of the first subset of data entries would cause invalid data in other entries from the dataset; and   reassigning the first subset of data entries to the second data type is based on determining that reassigning the first data type identifier to the second data type identifier would not cause invalid data in other entries from the dataset.   
     
     
         39 . A non-transitory computer readable medium storing instructions thereon that, when executed by one or more processors, causes a computing device to:
 identify a dataset including a plurality of data entries, each data entry from the plurality of data entries having a data type identifier indicating a type of data for a value in the corresponding data entry;   determine mismatched data type identifiers within the dataset based on a first subset of data entries from the dataset being associated with a first data type and a second subset of data entries from the dataset being associated with a second data type, wherein determining the mismatched data type identifiers is based on the first data type being incompatible with performing an operation that calls for 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, cause each value from the first subset of data entries to be reassigned to the second data type.   
     
     
         40 . The non-transitory computer readable medium of  claim 39 ,
 wherein the dataset includes a relational database of data including a table of data entries, the table of data entries being organized in a plurality of columns and a plurality of rows,   wherein the plurality of data entries includes a selected column or row of data entries within the table of data entries, and wherein the first subset of data entries and the second subset of data entries are interspersed throughout the selected column or row of data entries, and   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.