Aug-07-2017, 08:58 PM
(Aug-07-2017, 12:55 PM)QueenBee Wrote: so you would recommend Postgre over MySQL or MariaDB because of the integration with Python?
No, I only mention it because several members have voiced positive remarks about it. This site ODBC Drivers lists the DB's which can then be used with the appropriate Python ODBC interface. So, if you are more comfortable using MySQL (or other DB), by all means use it.
As to the actual data, rather than entering it all by hand you might rather use web scraping to gather the information automatically from an existing source like this site fftoday stats (note: this is not a recommendation nor promotion for this site, it's just the first one that came up in a web search). We have some very good tutorials on how to do this here Web Scraping and here Web sraping with Scrapy. (Yes, those are both blatant promotions ). You could collect the data as often as you like, every hour, every week, every month (or until they block your IP address if you do it too often )
Finally, once you have your data, you will want to present it to the end user, either as a stand alone GUI interface or perhaps even an interactive web page.
If, as ichabod801 points out, that R is better at data manipulation, then use it for that. If Python is better at presenting that information then use it for that. Perhaps your 'team' could be divided in a way where one group is focused to the data collection, another on data manipulation and another on presentation.
What ever you decide to do, I for one, would be interested in your final decision and why you chose to go that route.
If it ain't broke, I just haven't gotten to it yet.
OS: Windows 10, openSuse 42.3, freeBSD 11, Raspian "Stretch"
Python 3.6.5, IDE: PyCharm 2018 Community Edition
OS: Windows 10, openSuse 42.3, freeBSD 11, Raspian "Stretch"
Python 3.6.5, IDE: PyCharm 2018 Community Edition