Month: December 2016

Think Python, 2e ©2016

Posted by

0

Think Python 2e
©2016
by Allen B. Downey
http://greenteapress.com/wp/think-python-2e

recommended by: Coursera Exploring Neural Data! 2014

from this book:

Building Machine Learning Systems with Python (Community Experience Distilled)
July 26, 2013
by Willi Richert, Luis Pedro Coelho
http://www.amazon.com/Building-Learning-Community-Experience-Distilled/dp/1782161406

Machine Learning: The Art and Science of Algorithms that Make Sense of Data November 12, 2012
by Peter Flach
http://www.amazon.com/Machine-Learning-Science-Algorithms-Sense/dp/1107422221

Bayesian Reasoning and Machine Learning
March 12, 2012
by David Barber
http://www.amazon.com/Bayesian-Reasoning-Machine-Learning-Barber/dp/0521518148

Foundations of Machine Learning (Adaptive Computation and Machine Learning series) August 17, 2012
Mehryar Mohri, Afshin Rostamizadeh, Ameet Talwalkar
http://www.amazon.com/Foundations-Machine-Learning-Adaptive-Computation/dp/026201825X

Introduction to Machine Learning (Adaptive Computation and Machine Learning series)
August 22, 2014
by Ethem Alpaydin
http://www.amazon.com/Introduction-Machine-Learning-Adaptive-Computation/dp/0262028182

Understanding Machine Learning: From Theory to Algorithms
May 19, 2014
Shai Shalev-Shwartz, Shai Ben-David
http://www.amazon.com/Understanding-Machine-Learning-Theory-Algorithms/dp/1107057132

Machine Learning: An Algorithmic Perspective, Second Edition (Chapman & Hall/Crc Machine Learning & Pattern Recognition)
October 8, 2014
by Stephen Marsland
http://www.amazon.com/Machine-Learning-Algorithmic-Perspective-Recognition/dp/1466583282

Doing Bayesian Data Analysis, Second Edition: A Tutorial with R, JAGS, and Stan
November 17, 2014
by John Kruschke
http://www.amazon.com/Doing-Bayesian-Analysis-Second-Edition/dp/0124058884

Bayesian Data Analysis, Third Edition (Chapman & Hall/CRC Texts in Statistical Science)
November 1, 2013
by Andrew Gelman
http://www.amazon.com/Bayesian-Analysis-Edition-Chapman-Statistical/dp/1439840954

Bayes’ Rule: A Tutorial Introduction to Bayesian Analysis
June 4, 2013
by James V Stone
http://www.amazon.com/Bayes-Rule-Tutorial-Introduction-Bayesian/dp/0956372848

Think Bayes
October 4, 2013
by Allen B. Downey
O’Reilly Media
http://www.amazon.com/Think-Bayes-Allen-B-Downey/dp/1449370780

Think Complexity: Complexity Science and Computational Modeling
March 12, 2012
by Allen B. Downey
O’Reilly Media
http://www.amazon.com/Think-Complexity-Science-Computational-Modeling/dp/1449314635

Python 3 Object Oriented Programming
July 26, 2010
by Dusty Phillips
http://www.amazon.com/Python-3-Object-Oriented-Programming/dp/1849511268

Core Python Applications Programming (3rd Edition) (Core Series)
March 19, 2012
by Wesley Chun
Prentice Hall
http://www.amazon.com/Python-Applications-Programming-Edition-Series/dp/0132678209

mysql-connector-python 2.1.5

Posted by

0

connector_invisibleThe installed version (mysql-connector-python-2.1.5-py3.4-winx64.msi) is undetected by Oracle’s MySQL

myqlconnector

connector…ending support for OS versions that are obsolete or have reached end of life, we plan to discontinue building all MySQL binaries for Microsoft Windows 7 as of June 23, 2016
http://www.mysql.com/support/eol-notice.html

MySQL 5.7.1 since ~ April 2013

mysql-connector-python 2.1.5
MySQL driver written in Python
https://pypi.python.org/pypi/mysql-connector-python is this page updated??
https://dev.mysql.com/downloads/connector/python/2.1.html

MySQL Connector/Python Developer Guide
http://dev.mysql.com/doc/connector-python/en/index.html
Chapter 1 Introduction to MySQL Connector/Python
http://dev.mysql.com/doc/connector-python/en/connector-python-introduction.html
up to and including MySQL Server version 5.7.
Chapter 3 Connector/Python Versions
http://dev.mysql.com/doc/connector-python/en/connector-python-versions.html
http://dev.mysql.com/doc/connector-python/en/connector-python-coding.html
Another recommendation is to declare a numeric primary key for each table, which offers the fastest way to look up values and can act as a pointer to associated values in other tables (a foreign key).

=======================

import mysql.connector

help(module)

dir(module)

mysql.connector.__version__

======================

For nonbuffered cursors, rows are not fetched from the server until a row-fetching method is called.
In this case, you must be sure to fetch all rows of the result set before executing any other statements on the same connection, or an InternalError (Unread result found) exception will be raised.
http://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursorbuffered.html
solution: cnx.close()

python34lib
python36lib

“developer milestone”
https://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-2.html