search

PolloDiablo / SENG-371-Project-1

Investigating the effects of user feedback on video game updates and patches
1 stars 1 forks source link

How best to create visualizations from existing MySQL data? #1

Open PolloDiablo opened 9 years ago

PolloDiablo commented 9 years ago

Given the following data format (stored in a MySQL DB): https://github.com/PolloDiablo/SENG-371-Project-1/blob/master/docs/data.txt

The final output required is a chart plotting: forum/reddit posts relevant to a given game feature/character/item/map/etc. patch notes relevant to a given game feature/character/item/map/etc. vs. time (day granularity)

I'd expect this would be some kind of double-line chart, similar to the following: http://peltiertech.com/images/2012-02/twopanellines02.png

What is the best way (language/library/tool) to read from the two MySQL tables and output a chart?

PolloDiablo commented 9 years ago

I'm familiar with the Google Charts API. I've heard that the charts4j library has similar functionality and is available for Java (my preferred language).

lamjwe commented 9 years ago

Group @guand @paulmoon @lamj1234 You could create a nice line chart using Google Spreadsheets. By doing some tricks, you could have 2 y-axis on the line chart. Here is a good tutorial to look at: http://www.mousewhisperer.co.uk/drivebunny/google-sheets-charts-with-2-y-axes/ . Hope this helps.

Brayden-Arthur commented 9 years ago

You could use this I think http://www.mysql.com/why-mysql/windows/excel/ and then just use excel to output a graph

RyanMcDonald commented 9 years ago
  1. Use Python to connect to the MySQL database and execute a query to get your data.
    • See here for how to connect to a database with Python.
  2. Use Python's Matplotlib to plot your data.
    • See here for a beginner's tutorial on Matplotlib.
    • See here for plotting multiple lines.
PolloDiablo commented 9 years ago

Taking a quick look at: https://developers.google.com/google-apps/spreadsheets/ The Google Sheets API doesn't seem to have a way to automate graph generation, it might only be doable through the UI. Ideally I think I'd like the code to export an image file of some kind, rather than a spreadsheet which requires manually user interaction.