Automate some statistics methods in Python. A lot of statistics calculations(Correlation Coefficient, Chi-square tests, Binomial Variables, Poisson Distributions etc.) can be automated and used in large scale projects.
- Find the Correlation Coefficient between every pair of columns from a fully numeric table.
MySQL Workbench
Python(mysql.connector, math and re libraries)
- Pick or create a numeric-only table in MySQL.
- Use your hostname, username and password to connect python with MySQL using mysql.connector.
- Change tha table near the end of the script with your own table(correlation_c = correlation_coeficient('world_2.country_x')).
The result should look like this:
