JupyterLab Extension for INFACore

Back Next

Standardize the United States company names

You can apply rules to standardize United States company names and provide acronyms for the acronyms if possible.

To perform this operation, select the

Standardize US Companyname

function, and specify the data object variable. Then, enter the column name that contains the United States company names that you want to standardize.

For example, the input flat file includes a column named company that contains few company names in the Unites States.

The following snippet is the input code when you apply the function:

import informatica.infacore as ic
FF_DV = ic.get_data_source("Flat File").get_connection("DR_FlatFile").get_data_object("input.csv")
dqf = ic.DataQualityFunctions()
dqf.standardize_us_companyname(FF_DV,"company"))

The following snippet shows the output with the standardized company names:

Input_Company_Name: string
Out_CompanyName_Std: string
Out_CompanyName_Acronym: string
----
Input_Company_Name: [["Informatica","ABC","Amazon"]]
Out_CompanyName_Std: [["Informatica Corp.","American Broadcasting Co.","Amazon"]]
Out_CompanyName_Acronym: [["Informatica Corp.","American Broadcasting Co.","Amazon"]]

Rename Saved Search

Table of Contents

JupyterLab Extension for INFACore

JupyterLab Extension for INFACore

Standardize the United States company names

Standardize the United States company names