MySQL Matrix manipulation in Python
MRAB
python at mrabarnett.plus.com
Tue Sep 29 04:46:47 EDT 2009
Threader Slash wrote:
> Hello Everybody,
>
> My doubt is about matrix data manipulation in python - I hope someone
> can point me some direction.
>
> I googled around, but there is not much good examples about playing with
> matrix in python on internet.
>
> My following function works pretty well, and gives me the outup from my
> MySQL db:
>
> * Code:
> def employee(self, verifyName):
> runQuery= """.... = %s"""
> self.cursor.execute(runQuery,(verifyName,))
> for row in self.cursor.fetchall():
> print row
> print "Number of lines returned: %d" % self.cursor.rowcount
> print "tell column numbers: %d" % len(row)
>
> * output
>
> ('John', 'Plumber')
> ('Bill', 'Driver')
> ('Mark', 'Lawyer')
> Number of lines returned: 3
> tell column numbers: 2
>
> Now, how can I transfer this output to provide a matrix with a content
> like this:
>
> my_array = [['John','Plumber'],
> ['Bill','Driver'],
> ['Mark','Lawyer']]
>
> All comments and suggestions are highly appreciated!
>
my_array = [list(row) for row in self.cursor.fetchall()]
More information about the Python-list
mailing list