Pandas SQL Update

2015-06-15 Thread chrismeek4542
I have an app that basically compares a old foxpro database to a MySQL database. If the time-stamp does not match up then it updates the MySQL. My question is, is there a more officiant way of doing the MySQL update. I am using pandas itterrows() then doing an update query on each iteration.

Knowledge Requirements for Machine Learning (SKLearn)

2015-06-02 Thread chrismeek4542
I would like to get into Machine learning. The problem I have is that my Math skills are sadly lacking. I went through SKlearn docs but it is beyond me. Could anyone recommended some resources to get up to speed with the subject? -- https://mail.python.org/mailman/listinfo/python-list

Re: Knowledge Requirements for Machine Learning (SKLearn)

2015-06-02 Thread chrismeek4542
Thank you both. Just what i was looking for -- https://mail.python.org/mailman/listinfo/python-list

MySQL connection over SSH

2015-05-12 Thread chrismeek4542
I am trying to connect to a remote MySQL Database over SSH. I am using paramiko and SQLAlchemy. I assume that my sqlalchemy engine is not going through the SSH tunnel. Here is what i have so far. Not sure where to go from here though. import paramiko from sqlalchemy import create_engine ssh =

Re: MySQL connection over SSH

2015-05-12 Thread chrismeek4542
(2003, Can't connect to MySQL server on 'mcsdev.croft-it.com' (60)) -- https://mail.python.org/mailman/listinfo/python-list