Find Jobs
Hire Freelancers

Clean up this Data

$30-250 USD

処理中
投稿日: 約8年前

$30-250 USD

完了時にお支払い
I have a list of companies that I need information on. I have a spreadsheet with some of this information, but its incomplete and has many inaccuracies. I want to hire someone to clean this data up. The attached spreadsheet has a list of around 1100 companies with locations and year founded. Some of these locations are incorrect, and quite a few of the dates are incorrect. There are also many blank fields in the dataset, and several typos in company names. In addition to verifying/fixing the locations and dates founded, I'd like to have the have the blank fields filled and the typos fixed. I'm also attaching a folder of pictures from which the spreadsheet was generated. This should help with fixing typos and narrowing down correct addresses. If the company is a branch and was not founded in Pittsburgh (examples in this data set include Google, Microsoft, and Ciber), I need the 'date founded' to be the date that the Pittsburgh branch was established. A key error in this dataset is many of the incorrect dates are of companies which have a branch in Pittsburgh, and the founding date present is the date the parent company was founded instead of when the Pittsburgh branch was founded. This is one of the main things I want fixed. I also want a column with the street address added to this file. To reiterate, the final product I need is a CSV file with 5 columns: Name, Lat, Long, Street Address, and Date Founded (In Pittsburgh). I also want to ensure that all this data is as accurate as possible. If there is any ambiguity or uncertainty of a particular data point, please indicate this in a comment in the 6th column next to that data point. Some of these companies have this information readily accessible through a few Google searches (founding date can be sometimes found on Crunchbase, Manta, LinkedIn, Buzzfile, and location can be found on Google Maps), but others require a bit more research to get all the information (potentially a phone call to the company to ask). If a phone call is necessary and the company asks why the information is needed, say that you are participating in a project mapping the tech sector of Pittsburgh.
プロジェクト ID: 10316759

プロジェクトについて

7個の提案
リモートプロジェクト
アクティブ 8年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です

クライアントについて

UNITED STATESのフラグ
Pittsburgh, United States
5.0
1
お支払い方法確認済み
メンバー登録日:4月 19, 2016

クライアント確認

このクライアントからの他の仕事

Find Information from Websites
$30-250 USD
ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。