Re: Numpy outlier removal

"Steven D'Aprano" wrote in message news:[email protected]... > On Sun, 06 Jan 2013 19:44:08 +, Joseph L. Casale wrote: > >> I have a dataset that consists of a dict with text descriptions and >> values that are integers. If required, I collect the values int

Re: serial module

(serial.py?) with good results. Paul Simon "Ron Eggler" wrote in message news:[email protected]... > Hoi, > > I'm trying to connect to a serial port and always get the error > "serial.serialutil.SerialException: Port is already open." w

Re: How to round trip python and sqlite dates

"Mark Lawrence" wrote in message news:[email protected]... > All the references regarding the subject that I can find, e.g. > http://stackoverflow.com/questions/1829872/read-datetime-back-from-sqlite-as-a-datetime-in-python, > > talk about creating a table in

Re: Retrieving possible list for use in a subsequent INSERT

ger(5) not null default 1, > visits datetime not null, > downloads set('None Yet'), > > foreign key (counterID) references counters(ID), > unique index (visits) > )ENGINE = MYISAM; > > > Is the SET column type the way to do it? > i tried it but the error i'm receiving is: > > > pymysql.err.InternalError: (1241, 'Operand should contain 1 column(s)') > > Please help pick the necessary column type that will be able to store a a > list of values. > -- > https://mail.python.org/mailman/listinfo/python-list If you have a list of values of the same type, but different values, you need a new table with a foreign key to the table it relates to. This is a relational database question. You can read more here: http://en.wikipedia.org/wiki/Database_normalization#Normal_forms -- Joel Goldstick http://joelgoldstick.com He doesn't a many to many table, although that would put the schema into a classic normal form. Yes, there will be duplicated data. Sometimes de-normalizing a schema may make things simpler and easier to use for someone not used to database work. I would also use a many to many table being familiar with normal forms but it is not a neccessity. Paul Simon -- https://mail.python.org/mailman/listinfo/python-list

Re: Retrieving possible list for use in a subsequent INSERT

"Nick the Gr33k" wrote in message news:[email protected]... > 1/11/2013 7:07 ??, ?/? Paul Simon ??: > >> If you have a list of values of the same type, but different values, >> you need a new table with a foreign key to the table it relates

Re: Data acquisition

After receiving the data, check the received data for correct format, correct first and last characters, and if possible, check sum. I've worked through this problem with rs-485 data collection systems where there is no hand shaking and would not be surprised to expect the same even with rs-232. Paul Simon -- http://mail.python.org/mailman/listinfo/python-list

Re: Making ETL from Access 97 to Access 2003

browne.com/ser-48.html ? If there are indices and especially linked primary and foreign keys its much more complicated than that. One has to delve into Access container structures etc. As far as I know it has to be done from Access. Paul Simon -- http://mail.python.org/mailman/listinfo/python-list

Re: Making ETL from Access 97 to Access 2003

"rusi" wrote in message news:92551c63-1347-4f1a-9dca-d1bbd5e4d...@ys5g2000pbc.googlegroups.com... Its hard to distinguish what you are saying from what I said because you've lost the quotes. On Apr 15, 9:01 pm, "Paul Simon" wrote: > "rusi" wrote in me

Re: Graphical library - charts

I suggest you look at matplotlib. It's a bit of a learning curve but will do whatever you need. I have a similar requirement and found that gnuplot did not work for me. The plots are impressive. Paul Simon wrote in message news:[email protected]... > Hello, &g

problem installing python 2.6.2 from tarball

subdirectories like "build", "Demo", "Doc", "Include", "Lib", etc. There are many files under /usr/bin/local/ which appear to be duplicates. This looks like a mess to me and would like some help to sort this out. Paul Simon -- http://mail.python.org/mailman/listinfo/python-list

tkinter problem

only to the point of confusion. I'm not an expert. How do I modify my python configuration? Is there a file that needs to be edited? Which setup.py file do I use? Make? or python setup.py build and python setup.py install? Thanks. I appreciate your help. Paul Simon -- http://mail.python.org/mailman/listinfo/python-list

Re: tkinter problem

"Chris Rebert" wrote in message news:[email protected]... On Wed, Jul 8, 2009 at 4:18 PM, Paul Simon wrote: > I have the "tkinter" problem and need some assistance to straighten it > out. > >From the web page "http://wiki.

Re: tkinter problem

"Peter Otten" <[email protected]> wrote in message news:[email protected]... > Paul Simon wrote: > >> "Chris Rebert" wrote in message >> news:[email protected]... >> On Wed, Jul 8, 2009 at

Re: tkinter problem

"David Smith" wrote in message news:[email protected]... > Paul Simon wrote: >> "Peter Otten" <[email protected]> wrote in message >> news:[email protected]... >>> Paul Simon wrote: >>> >>>>