Create chart/statistics for selected mysql table through python

Question

Hi all,

I'd like to start by asking for your opinion on how I should tackle this task, instead of simply how to structure my code.

Here is what I'm trying to do: I have a lot of data loaded into a mysql table for a large number of unique names + dates (i.e., where the date is a separate field). My goal is to be able to select a particular name (using rawinput, and perhaps in the future add a drop-down menu) and see a monthly trend, with a moving average, and perhaps other stats, for one of the fields (revenue, revenue per month, clicks, etc). What is your advice - to move this data to an excel workbook via python, or is there a way to display this information in python (with charts that compare to excel, of course)?

Thanks!

Answer 1

Your problem can be broken down into two main pieces: analyzing the data, and presenting it. I assume that you already know how to do the data analysis part, and you're wondering how to present it.

This seems like a problem that's particularly well suited to a web app. Is there a reason why you would want to avoid that?

If you're very new to web programming and programming in general, then something like web2py could be an easy way to get started. There's a simple tutorial here.

For a desktop database-heavy app, have a look at dabo. It makes things like creating views on database tables really simple. wxpython, on which it's built, also has lots of simple graphing features.