Looking for advice

2018-04-20 Thread 20/20 Lab
Going to write my first python program that uses a database. Going to store 50-100 rows with 5-10 columns.  Which database / module would you advise me to use?  It's basically going to be processing order status emails for the sales staff.  Producing a webpage (2-3 times daily, as updates arriv

Re: Easier way to do this?

2017-10-05 Thread 20/20 Lab
On 10/04/2017 05:11 PM, Irv Kalb wrote: I'm assuming from your posts that you are not a student. If that is the case, look at my solution below. On Oct 4, 2017, at 9:42 AM, 20/20 Lab wrote: Looking for advice for what looks to me like clumsy code. I have a large csv (effectively ga

Re: Easier way to do this?

2017-10-05 Thread 20/20 Lab
On 10/04/2017 04:48 PM, Dennis Lee Bieber wrote: On Wed, 4 Oct 2017 09:42:18 -0700, 20/20 Lab declaimed the following: Well -- since your later post implies this is not some "homework assignment"... Looking for advice for what looks to me like clumsy code. EMP1 = [0,0] E

Re: Easier way to do this?

2017-10-05 Thread 20/20 Lab
On 10/05/2017 07:28 AM, Neil Cerutti wrote: On 2017-10-04, 20/20 Lab wrote: It's not quite a 'learning exercise', but I learn on my own if I treat it as such.  This is just to cut down a few hours of time for me every week filtering the file by hand for the office manager. Th

Re: Easier way to do this?

2017-10-04 Thread 20/20 Lab
On 10/04/2017 01:55 PM, Ben Bacarisse wrote: 20/20 Lab writes: Looking for advice for what looks to me like clumsy code. I have a large csv (effectively garbage) dump.  I have to pull out sales information per employee and count them by price range. I've got my code working, bu

Re: Easier way to do this?

2017-10-04 Thread 20/20 Lab
On 10/04/2017 12:47 PM, breamore...@gmail.com wrote: On Wednesday, October 4, 2017 at 8:29:26 PM UTC+1, 20/20 Lab wrote: Any help / advice is appreciated, Matt Use the csv module https://docs.python.org/3/library/csv.html to read the file with a Counter https://docs.python.org/3/library

Easier way to do this?

2017-10-04 Thread 20/20 Lab
Looking for advice for what looks to me like clumsy code. I have a large csv (effectively garbage) dump.  I have to pull out sales information per employee and count them by price range. I've got my code working, but I'm thinking there must be a more refined way of doing this. ---snippet of w

Re: If you are running 32-bit 3.6 on Windows, please test this

2017-08-31 Thread 20/20 Lab
On 08/31/2017 01:53 AM, Pavol Lisy wrote: On 8/31/17, Terry Reedy wrote: On 8/30/2017 1:35 PM, Terry Reedy wrote: https://stackoverflow.com/questions/45965545/math-sqrt-domain-error-when-square-rooting-a-positive-number reports the following: - Microsoft Windows [Version 10.0.16251.10

Re: If you are running 32-bit 3.6 on Windows, please test this

2017-08-30 Thread 20/20 Lab
On 08/30/2017 10:35 AM, Terry Reedy wrote: https://stackoverflow.com/questions/45965545/math-sqrt-domain-error-when-square-rooting-a-positive-number reports the following: - Microsoft Windows [Version 10.0.16251.1002] (c) 2017 Microsoft Corporation. All rights reserved. C:\Users\Adam>pyth

Re: os.getlogin() Error

2017-05-05 Thread 20/20 Lab
I'm not sure if this will help you, but I found some stuff on accident looking at something related. Not sure if it will help, but looked promising https://github.com/parmentelat/apssh/issues/1 ==Some snippets from the page From the os.getlogin() docs: "Returns the user logged in to the cont

Re: OT: Anyone here use the ConEmu console app?

2016-04-11 Thread 20/20 Lab
win+alt+space does not work? ctrl+alt+win+space? http://conemu.github.io/en/KeyboardShortcuts.html Says those are not configurable, so they should work. On 04/11/2016 02:49 PM, DFS wrote: I turned on the Quake-style option (and auto-hide when it loses focus) and it disappeared and I can't fig

Re: Linux users: please run gui tests

2015-08-10 Thread 20/20 Lab
On 08/06/2015 07:07 PM, Terry Reedy wrote: Python has an extensive test suite run after each 'batch' of commits on a variety of buildbots. However, the Linux buildbots all (AFAIK) run 'headless', with gui's disabled. Hence the following test_tk test_ttk_guionly test_idle (and on 3.5, test_t

Re: Looking for direction

2015-05-21 Thread 20/20 Lab
Your the second to recommend this to me. I ended up picking it up last week. So I need to sit down with it. I was able to get a working project. However, I dont fully grasp the details on how. So the book will help I'm sure. Thank you. On 05/20/2015 05:50 AM, darnold via Python-list wrote

Re: Looking for direction

2015-05-15 Thread 20/20 Lab
On 05/13/2015 06:12 PM, Dave Angel wrote: On 05/13/2015 08:45 PM, 20/20 Lab wrote:> You accidentally replied to me, rather than the mailing list. Please use reply-list, or if your mailer can't handle that, do a Reply-All, and remove the parts you don't want. > > On

Re: Looking for direction

2015-05-15 Thread 20/20 Lab
On 05/13/2015 06:12 PM, Dave Angel wrote: On 05/13/2015 08:45 PM, 20/20 Lab wrote:> You accidentally replied to me, rather than the mailing list. Please use reply-list, or if your mailer can't handle that, do a Reply-All, and remove the parts you don't want. ...and now that y

Re: Looking for direction

2015-05-14 Thread 20/20 Lab
On 05/13/2015 06:23 PM, Steven D'Aprano wrote: On Thu, 14 May 2015 09:24 am, 20/20 Lab wrote: I'm a beginner to python. Reading here and there. Written a couple of short and simple programs to make life easier around the office. That being said, I'm not even sure what I

Looking for direction

2015-05-13 Thread 20/20 Lab
I'm a beginner to python. Reading here and there. Written a couple of short and simple programs to make life easier around the office. That being said, I'm not even sure what I need to ask for. I've never worked with external data before. I have a LARGE csv file that I need to process. 110