This repository provides simple scripts to pull, fuse, and transform data from X-Wing Data and List Juggler, which are linked by the X-Wing Squadron Specification. In particular, it provides a tool to export pilot stats and usage data to CSV so non-programmers can easily use their spreadsheet tool of choice to incorporate some quantitative analysis into their list building.
For convenience, a collection of archived script output is included in this repository itself:
-
February 12, 2017: This is very shortly after the entirety of Wave X became available in stores, but before much of it has seen much tournament use---the U-Wing and TIE Striker came out almost exactly two months ago with the release of Rogue One, but the Upsilon-Class Shuttle, Quadjumper, and Sabine's TIE Fighter just hit stores two weeks ago. This capture includes 1556 tournaments reporting results, comprising 21,529 squadron lists and 67,107 pilot instances. The "Recent" data is from the past four months, comprising 256 tournaments, 3,869 lists, and 10,973 pilot instances.
archives/20160212-ships.csv: Summary of all ships in the game right now.archives/20160212-pilots.csv: Summary of all pilots in the game right now and their use.archives/20160212-lists.csv: Summary of all lists in ListJuggler.
These should be able to be imported into all major spreadsheet packages, including LibreOffice, Google Docs, and presumably Microsoft Excel (untested) as well as many other tools. The smaller files can also be viewed in readable tabular fashion directly in GitHub's file viewer.
The scripts require the Logberry logging package, which can be easily installed with:
% go get -u github.com/BellerophonMobile/logberry
The tools are all written as Go programs intended to be used in script fashion, i.e.:
% go run script.go
This retrieves the current list of tournaments available in
ListJuggler, and then downloads all of them into the tournaments/
folder. Note that a good portion of them will fail with an internal
server error. The cause of this is currently unknown.
This compiles ship and pilot stats from X-Wing Data and usage data
from ListJuggler into a simple CSV format. The most recent X-Wing
Data is pulled directly from its repository. The script assumes that
the fetch-tournaments.go script has been previously used to pull
down tournament data from ListJuggler.
The script creates the following CSV files:
-
ships.csv: All the nominal ships stats and properties. Technically stats are associated with specific pilot cards, but in reality there is only one pilot with different stats for its class: The Outer Rim Smuggler, a lesser version of the YT-1300. So most people tend to think in terms of ship chassis and associated stats, which are presented here. The Smuggler is included as a separate entry. -
pilots.csv: All of the pilots in the game, their ship stats, and counts breaking down all the times that pilot has been used in a list captured in ListJuggler. For simplicity, the compilation excludes:- Epic Play: Tournaments for Epic games are ignored, as are the huge ships since they're only for Epic play and complicate analysis with fore & aft sections.
- The Nashtah Pup: It's not fieldable on its own.
-
lists.csv: Summaries of all the lists captured in ListJuggler. The core of this are summed stats needed to do some simple analysis based on raw attacks, agility, hull points+shields, and the number of ships.
The script also generates pilot-duplicates.csv, but this is only for
development purposes (there are several duplicate entities following
the XWS, which this output presents to enable deconfliction).
Please submit any problems or suggestions using the Issues tab above.
These tools and resources are provided under the open source MIT license:
The MIT License (MIT)
Copyright (c) 2017 Joe Kopena
Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:
The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.