Pattern recognizing

With开发者_如何学运维 an IQ of 70, I'm simply not smart enough to find out how I should do this. But! What I want is... to let Python e.g. read a table from MySQL and find a pattern for columns! Like, column X usually is value 'foo' when column Y is around '1.56' AND colum Z is around '756' e.g. That it finds all this 'OBVIOUS' data... Do some of you have a simple plan for how I can do this? Or reference me to some information, book etc.? Not a book for a genius!

And, is Python suitable for this? It will contains around 600 000 rows, around 20 columns... and it's on a up today standard gaming computer.....

---

This is a complex topic. If you want to get started, try clustering your data using the scipy clustering libraries.