Ukończone

Matching/Correcting Firm Names Contained in a .CSV File

I have a .csv file which contains the names of 431,359 firms in one column. Some of the names are unique while others are common but differ by punctuation, spacing or one word. For example, there exists five observations of ABC Corporation. However, each observation differs: (1) "ABC Corp." (2) "ABC; Corp." (3) " ABC Corp " (4) "ABC Corp., Inc" (5) " \ABC Corporation ". The goal is to create an adjacent column which contains the corrected firm name, "ABC Corp."

The objective:

* **Standardize the names** (e.g. the above case with 5 observations). Create an adjacent column containing the edited firm names. This entails removing extraneous spacing and punctuation along with ensuring that all instances of the name are the same. In the event, there is a unique firm name, it should also be free of extraneous spacing and punctuation.

* **Add two additional columns to the file**. (1) The first column will contain a variable that is equal to 1 if the firm name was edited in anyway and zero otherwise. (2) The second column will contain a variable equal to 1 if the firm name appears more than once and zero otherwise.

If you have any further questions, please advise.

Umiejętności:

Zobacz więcej: goal zero, first data corporation, abc data entry, the firm, or 4 names are in the same column, word csv, zero data entry, unique name file, data matching, data entry csv file, create matching word, correcting, csv file data entry, abc corp, inc file, free matching, data entry objective, csv column, column csv, column csv

O pracodawcy:
( 1 ocena ) Santa Cruz, United States

Numer ID Projektu: #2746321

Przyznany użytkownikowi:

jadinv

See private message.

$283 USD w ciągu 14 dni
(17 ocen)
2.9

24 freelancerów złożyło ofertę na kwotę $135 do tego projektu

ianoc

See private message.

$425 USD w ciągu 14 dni
(79 Oceny)
2.2
mvjindia

See private message.

$500.65 USD w ciągu 14 dni
(48 Oceny)
2.0
CherylFernandes

See private message.

$40.8 USD w ciągu 14 dni
(262 Oceny)
2.0
Baxter2008

See private message.

$9 USD w ciągu 14 dni
(70 Oceny)
1.7
brainsrussw

See private message.

$300 USD w ciągu 14 dni
(13 Oceny)
0.8
neeeeeeext

See private message.

$30.6 USD w ciągu 14 dni
(85 Oceny)
0.5
cbaulier

See private message.

$50.15 USD w ciągu 14 dni
(0 Oceny)
0.0
mbutton

See private message.

$50.15 USD w ciągu 14 dni
(0 Oceny)
0.0
rachaelv81

See private message.

$23 USD w ciągu 14 dni
(10 Oceny)
0.0
mukul71sl

See private message.

$50.15 USD w ciągu 14 dni
(21 Oceny)
0.0
awabid

See private message.

$68 USD w ciągu 14 dni
(12 Oceny)
0.0
stevensmann

See private message.

$7 USD w ciągu 14 dni
(0 Oceny)
0.0
reliableworkervw

See private message.

$255 USD w ciągu 14 dni
(0 Oceny)
0.0
mikemcguire93

See private message.

$2 USD w ciągu 14 dni
(0 Oceny)
0.0
avosoft

See private message.

$7 USD w ciągu 14 dni
(40 Oceny)
0.0
I88A5A

See private message.

$500.65 USD w ciągu 14 dni
(2 Oceny)
0.0
sqweek

See private message.

$75.65 USD w ciągu 14 dni
(10 Oceny)
0.0
AshrafSabryM

See private message.

$42.5 USD w ciągu 14 dni
(63 Oceny)
0.0
piscespalio

See private message.

$50.15 USD w ciągu 14 dni
(688 Oceny)
0.0
garimatech

See private message.

$56.1 USD w ciągu 14 dni
(0 Oceny)
0.0