Getting large datasets to analyze

90 Undead Priest
4870
I would like to get large datasets, such as arena rankings (really, whatever Blizzard offers). Then, I would like to put the in SPSS and analyze them. So here are the steps I think:

1) Use web browser to get a JSON string (using API)
2) Turn JSON string into XML doc
3) Turn XML into Excel doc
4) Open in SPSS
5) Analyze

I'm having trouble with the first two steps. Is there an easier way?
Reply Quote
90 Draenei Paladin
11740
http://ramblings.mcpher.com/Home/excelquirks/json
Reply Quote
90 Undead Priest
4870
Oh goodness...thank you for the link. However, I'm a research and not a computer scientists. I really do not understand what that website is instructing me to do. I'll keep at it and maybe it will click after a few reads.
Reply Quote
90 Draenei Paladin
11740
ok this is what i got ...
http://www.vijayjoshi.org/?s=excel
download the lib...
include it like in ther example...

then the magic.. arena lader example

your json call here
(ex http://us.battle.net//api/wow/pvp/arena/retaliation/2v2?locale=en_US)


$headers = array('name','level','rank','bgRating','wins','losses','played','realm');
$excel->writeLine($headers, array('text-align'=>'center', 'color'=> 'red'));
foreach ($json['bgRecord'] as $idx => $data)
{
$excel->writeRow();
$excel->writeCol($data['character']['name']);
$excel->writeCol($data['character']['level']);
$excel->writeCol($data['rank']);
$excel->writeCol($data['bgRating']);
$excel->writeCol($data['wins']);
$excel->writeCol($data['losses']);
$excel->writeCol($data['played']);
$excel->writeCol($data['realm']['name']);
}
$excel->close();

and it saves it all in an xls file :) hope thats a help....
Reply Quote
90 Undead Priest
4870
I'll try this when I get home. To run that code, do I open up Excel Macros?

Thanks!!!
Reply Quote
90 Draenei Paladin
11740
no
this code uses php on a webserver to pull the data and make the excel file for you
Reply Quote
90 Undead Priest
4870
so would you save as a notepad.html and open in a web browser?
Reply Quote
90 Draenei Paladin
11740
this script formats the info into a excel book format and saves the excel file to the server for you to download this is just an example of what you can do to make the file you can make the page when rendering is finished to prompt you to download the file if you wanted
Reply Quote
90 Undead Mage
13830
What other import formats can you use? If you are doing an analysis that will produce some interesting results, feel free to PM me on mmo-champion or our IRC channel. I would wager that I have the largest set of up to date profiles of level 85 characters and might be able to help you get data if you are producing something interesting / useful.
Reply Quote

Please report any Code of Conduct violations, including:

Threats of violence. We take these seriously and will alert the proper authorities.

Posts containing personal information about other players. This includes physical addresses, e-mail addresses, phone numbers, and inappropriate photos and/or videos.

Harassing or discriminatory language. This will not be tolerated.

Forums Code of Conduct

Report Post # written by

Reason
Explain (256 characters max)
Submit Cancel

Reported!

[Close]