Sr. Programmer Analyst
Carey Business School
Students input the same employer name in multiple ways in a post-graduation survey for Carey students. Adam previously had to manually check for and then standardize various versions of employer names. This process was time-consuming and introduced the possibility of human error.
Copilot identified multiple versions of the same company name and created a standardized name for each employer to avoid duplicative entries.
If you have data/survey results that need to be cleaned up, you can use Copilot to produce this type of streamlined result.
“I am going to provide you with a list of companies that people work for. Sometimes, the same company may be listed multiple times, but it could be spelled differently, abbreviated, etc. For example, Panasonic, Panasonic Corporation of China, Panasonic Information Systems (Shanghai) Co.,Ltd. are all associated with “Panasonic” so the corrected, standardized name would be “Panasonic.” Please create a table with the entry from the provided list in the first column, and the corrected, standardized name in the second column. Default to including “llc”,”co.”, “ltd.” etc. if one of the items in the first column includes it.”
Copilot reduced the number of distinct entries from 7769 to 5823. Not only did this save time and avoid the need for manual searching and replacing, but future years’ surveys can use the standardized employer name.
| STUDENT SUBMISSION | STUDENT SUBMISSION |
|---|---|
| United States Army Reserve | U.S Army Reserve |
| United States Army War College | U.S Army War College |
| United States Chamber of Commerce | U.S Chamber of Commerce |
| United States Cyber Command | U.S Cyber Command |
| United States Department of Agriculture | U.S Department of Agriculture |
| United States Department of State | U.S Department of State |
| United States Department of the Treasury Office of Intelligence & Analysis | U.S Department of the Treasury |
| United States Department of Veteran Affairs | U.S Department of Veteran Affairs |
| United States Gypsum | U.S Gypsum |
| United States House of Representatives | U.S House of Representatives |
| United States Marine Corps | U.S Marine Corps |
| United States MArine Corps | U.S Marine Corps |
| United States Marine Corps, 1st Marine Logistics Group | U.S Marine Corps |
| United States Military | U.S. Military |
| united states navy | U.S Navy |
| United States Navy | U.S Navy |
| UNITED STATES NAVY | U.S Navy |
| United States Navy (Naval Hospital Camp Pendleton) | U.S Navy |
| United States Navy Reserves / Naval Operation Support Center Lehigh Valley | U.S Navy Reserve |
| United States Navy, Walter Reed National Military Medical Center | U.S Navy |
| United States Navy / Naval Academy | U.S Navy |
| United States Olympic Committee | U.S Olympic Committee |
| United States Patent and Trademark Office | U.S Patent and Trademark Office |
| United States Pharmacopeia | U.S Pharmacopeia |
| United States Postal Service | U.S Postal Service |
| United States Senate | U.S Senate |
| United States Surgical Partners Internaltional | United Surgical Partners Internaltional |
| United Technologies Corp | United Technologies Corporation |
| United Technologies Corporation | United Technologies Corporation |
| United Technologies Corporation (UTC) | United Technologies Corporation |
| United Vision Asset Management Co., Ltd. | United Vision Asset Management Co., Ltd. |
| United Way of Monroe County | United Way of Monroe County |
