ooopy: newbie cannot get basic functionality to work

2006-12-09 Thread Andrew Sackville-West
Hi list, I am new to python and old to coding (as in I did it a long time ago). I've got a task that cries out for a scripted solution -- importing chunks of ASCII data dumps from a point-of-sale system into an openoffice.org spreadsheet. What a great chance for me to get my coding skills back an

Re: ooopy: newbie cannot get basic functionality to work

2006-12-09 Thread Andrew Sackville-West
On Sat, Dec 09, 2006 at 09:42:40PM -0600, Paul Watson wrote: > Andrew Sackville-West wrote: > > Hi list, > > > > I am new to python and old to coding (as in I did it a long time > > ago). I've got a task that cries out for a scripted solution -- > > impor

Re: ooopy: newbie cannot get basic functionality to work

2006-12-09 Thread Andrew Sackville-West
On Sat, Dec 09, 2006 at 09:30:32PM -0800, John Machin wrote: > > Andrew Sackville-West wrote: > > > > >>> o = OOoPy (infile='/home/andrew/monthly.ods') > > Traceback (most recent call last): > > File "", line 1, in ? > > TypeErro

Re: speed of python vs matlab.

2006-12-13 Thread Andrew Sackville-West
On Wed, Dec 13, 2006 at 04:07:20PM -0800, Chao wrote: > I've been trying to develop some numerical codes with python, however > got disappointed. > > A very simple test, > > a = 1.0 > > for i in range(1000): > for j in range(1000): >a = a+1 > > unfortunately, it took 4.5 second

Re: automatically grading small programming assignments

2006-12-15 Thread Andrew Sackville-West
On Fri, Dec 15, 2006 at 06:44:37AM +, Dennis Lee Bieber wrote: > On Thu, 14 Dec 2006 12:27:07 -0500, Brian Blais <[EMAIL PROTECTED]> > declaimed the following in gmane.comp.python.general: > > > > I envision a number of possible solutions. In one solution, I provide a > > function > > temp

MySQLdb, lots of columns and newb-ness

2006-12-19 Thread Andrew Sackville-West
Hi list, I've tried, lots of interpreter testing and google grepping to figure this out and I think I'm missing something fundamental. I have an ascii data dump from a POS system that has 131 fields in a single column in a flat file. I can easily open the file, read in the data and assemble it i

Re: MySQLdb, lots of columns and newb-ness

2006-12-19 Thread Andrew Sackville-West
On Tue, Dec 19, 2006 at 07:34:58PM -0800, Todd Neal wrote: > Andrew Sackville-West wrote: > > > > I can successfully connect to mysql and do stuff to my tables my > > specific problem is how to efficiently put those 132 fields into the > > thing. All I have been able t

Re: MySQLdb, lots of columns and newb-ness

2006-12-20 Thread Andrew Sackville-West
On Wed, Dec 20, 2006 at 07:00:38AM -0800, Ant wrote: > > > On Dec 20, 5:20 am, Andrew Sackville-West <[EMAIL PROTECTED]> > wrote: > > > >>> values = ", ".join([escapeAndQuote(f[:-2]) for f in fields]) > > Obviously this is the appropriate c

Re: MySQLdb, lots of columns and newb-ness

2006-12-20 Thread Andrew Sackville-West
On Wed, Dec 20, 2006 at 09:22:59AM +0100, Fredrik Lundh wrote: > Andrew Sackville-West wrote: > > > I've also tried building tuples and lists and then using this > > > > cursor.execute("insert into daily values (%s)", values) > > > > with no l