This should be fairly easy job for someone who knows how scrape data well. I will award this project to the person who can complete the fastest and with experience.
I need a script that can take the company name information on this page:
and count how many times it occurred in its particular category (free,paid,or grossing).
With the link above:
"Gameloft" = 19 times out of 500 total in action free games category column
"Gameloft" = 12 times out of 500 total in action paid games category column
"Gameloft" = 24 times out of 500 total in action grossing games
The data will be organized from highest to lowest count next to the company name and placed in its appropriate price category column. Please see mockup I made in excel of the format I would like.
Company name will be a hyperlink to that company name's app annie url which is already in there when you hover of the company name in app annie. For example, http://www.appannie.com/company/gameloft/
There will be a refresh all button that will allow me to refresh all data.
Finally I need to switch to other game categories (20 Total). Each category is a hyperlink which will take me to the game category where I will be presented with new data for that category. Each link below is exactly same format as the action link provided. 3 price categories, each with 500 entries per column.
Script must be self contained in a folder and I should be able to transfer to my hosting account. You must host the script on your site for development until work is complete.