These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

a way to extract kb data in region/constellation

First post
Author
Previous Topic Next Topic
Zosius
The Nordic Associates
Fraternity.
#1 - 2015-02-28 16:03:30 UTC
Hi,

I was wondering if someone can help me to find a good way to extract kb data to get statistics of items/ships blown up in certain region or constellation. I would prefer to be able to upload this list to excel.

BR,
Zosius

http://cloakybastard.blogspot.com
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2015-02-28 21:25:11 UTC
in the end, it's always going to be better do do this with a proper programming language. spreadsheets are fine, but not so good for taking data feeds and reworking them into a different form.

ZKill has an api (https://neweden-dev.com/ZKillboard_API ) which allows for getting data on kills. I suspect it'll be painful to work with with just excel, due to nesting. (you want the items on a ship, as well as just a ship. There are multiple items, thus they'll be nested in a kill)

I'd recommend learning something like python to play with this data. http://learnpythonthehardway.org/ is recommended by many people. (if you need to work with the internet, you want to use the requests library, rather than the builtin urllib)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Zosius
The Nordic Associates
Fraternity.
#3 - 2015-02-28 21:29:12 UTC
Steve Ronuken wrote:
in the end, it's always going to be better do do this with a proper programming language. spreadsheets are fine, but not so good for taking data feeds and reworking them into a different form.

ZKill has an api (https://neweden-dev.com/ZKillboard_API ) which allows for getting data on kills. I suspect it'll be painful to work with with just excel, due to nesting. (you want the items on a ship, as well as just a ship. There are multiple items, thus they'll be nested in a kill)

I'd recommend learning something like python to play with this data. http://learnpythonthehardway.org/ is recommended by many people. (if you need to work with the internet, you want to use the requests library, rather than the builtin urllib)


I would like to learn python and have done some basics. If there is some sample already created, that would be a great help, then i could play with it

http://cloakybastard.blogspot.com