Data Entry Data Cleaning Web Scraping -- for Superheroes! (Licensed Merchandise)

Data cleaning, Data entry, Spreadsheet Excel You need a high speed internet to do this project. You need a spreadsheet software program. I suggest 6 milestone payments for these 6 individual tasks. Examples of the actual raw data are pictured below. You will complete this project in about 4 days. All 6 of these files (A), (B), (C), (D), (E), (F) need to be combined into 1 spreadsheet. They also need to be saved as separate spreadsheet files (A), (B), (C), (D), (E), (F) (A) FILENAME LABEL ANGELS 11 Label Angels 11 is a text file. Enter ALL company names, addresses, etc. into a spreadsheet. Approximately 75 names. Save the finished information for this file into a spreadsheet. Also append the finished information for this file into a spreadsheet for all 6 files (A) + (B) + (C) + (D) + (E) + (F) (B) FILENAME LABEL ANGELS 22 Label Angels 22 is a text file. spreadsheet. 75 names. (C) FILENAME LICENSEES TOP 150 Licensees Top 150 is a text file. spreadsheet, Approximately 80 names. (D) FILENAME LICENSING SCOTT SPORTS spreadsheet Attached is a sample of the spreadsheet titled : licensing scott sports This spreadsheet has approximately 550 records. Please filter the spreadsheet and list only companies with sales greater than $5 million dollars. Use the internet databases mergentmddi and reference usa to determine if the company has sales greater than $5 million dollars. These internet databases are no cost. For companies with sales greater than $5 million dollars, enter their address information, etc. into the spreadsheet. Note that many of these records are duplicates. Some spreadsheets such as Open Office, have a simple method to remove duplicates : [login to view URL] (E) LIMA : Here is the internet link : [login to view URL] Or use this link : [login to view URL] And choose the following "Types of Products Manufactured" and remove checkmark from the box "Show only LIMA member companies:" Apparel, Automotive, Bags, Gifts, Party Supplies, Posters, Publishing, Sporting Goods, Stationery, Toys & Games. This will output 15 pages of about 20 companies, for a total of about 300 companies. Filter for companies with sales of $5 million or more, same as above. (F) Sports Licensing Show spreadsheet 275 records. This list duplicates records from your previous work. Remove the duplicates from the list. I predict many fewer than 100 new records. Filter for $5 million or more, same as above.