Dissertation project - data to csv

Hi guys,

I am working on my dissertation project at the moment on the video game industry. I need to extract data from the API and store it in a csv file to perform some regressions on it. However much I would enjoy trying to write some Python code to do this, it would probably take ages for a completely newbie like me to figure it out (and the paper is due on April 2nd). Any of you willing to help me with this? it would probably take less than 15 minutes of your time. Let me know please and I'll tell you exactly what fields.

Many Thanks!

What kind of data?

Thanks for the reply!

I am interested in finding the following data for the games released between 2004-2014

Game name

Game publisher (Company)

Game publisher Founding year

Game Genre

Date of release of the game (month and year)

Some measure of Success (Rating if sales is not available)

Just for you to get a sense of what I am trying to do, I am trying to assess the choice of platform for the game producer considering the competition in that game genre for various platform. If you can think of any other information available in this database that would be valuable for this project do let me know.

Thanks!

A different API (perhaps metacritic) will be of more use, since the GB pages won't have reviews for most games.

Metacritic doesn't have a public API, though it has an okay third-party one. However, it's not meant to pull volumes of games data, and it's purposefully made to inhibit that kind of action. It looks like you could do it, but it'd take some work.

You might get some more traction with some kind of bounty, OP.

restrictions:

- you can't search for a year, just individual dates.

- you can only display 100 results at a time.

just use this filter and iterate over the date:

http://www.giantbomb.com/api/games/?api_key=YOURKEY&format=json&field_list=name,original_release_date&filter=original_release_date:2004-01-01

add fields (genre or whatever) to the url as you need them (http://www.giantbomb.com/api/documentation#toc-0-15).

you need to do one query for each date in a year.

if field "number_of_total_results" in the response is >100, do the same query again with added filter "&offset=100". do subsequent queries for that date while "number_of_total_results"-100 is >0. you _probably_ can get by without this whole mechanic as i guess it's unlikely that there's more than 100 releases for any given date, but you be the judge of that.

now you should have queried everything.

as to converting the json data to csv: there's tones of snippets and libraries out there: https://www.google.de/#q=python%20json%20to%20csv

i'm bored, so here's all of this in pseudo code: http://pastebin.com/Y9TBVibz