ddsna/dnd-learn-sql-and-python

Shenanigans with fictional markets!

dnd-learn-sql-and-python's Issues

Initial files and set-up

-create py files for scripts and data analysis
-create directories for documentation
-create kanban project
-understand how git and github work
-set a shortlist of data viz software
-set a workload
-set up a template for project management

Server to MySQL JSON dump and table data import (most likely after json to csv conversion)

https://www.red-gate.com/simple-talk/blogs/setting-up-a-simple-rest-interface-with-sql-server/

Need to find an alterantive to js

Front-End Brainstorm

Database Automated Cleaning Scripts

Tools: SQL and Python
Goals: Create for-self-cleaning scripts in Python or SQL to assist us in case we fuzz our data sets or something goes wrong with the data.

Create Visualizations

Tools: PowerBI/Tableau/other such software
Goal: Create visualizations for "customers" based on our calculations and data

JSON Downloader

Fetch information from fuzzwork

Goal: Grab info from fuzzwork's api jsons
Explained: Grab info about EVE's trade nodes and items traded and import the data into a db to use in further calculations/operations

https://market.fuzzwork.co.uk/aggregates/?region=30000142&types=626

Process Data

Take the info from the layout and DBs and process it in order to show which is the best transaction we can make, currently. Create indices and rankings as well as figure out which is consistently the place best suited for our operations, ranked.

Tools: Python

Importing JSON to MySQL results in table with a single row