Re: The sqlite3 timestamp conversion between unixepoch and localtime

2021-09-03 Thread Barry
> On 3 Sep 2021, at 13:40, Bob Martin wrote: > > On 2 Sep 2021 at 20:25:27, Alan Gauld wrote: >> On 02/09/2021 20:11, MRAB wrote: >> In one of them (I can't recall which is which) they change on the 4th weekend of October/March in the other they change on the last weekend. >>

Re: Add a method to list the current named logging levels

2021-09-03 Thread Barry
> On 2 Sep 2021, at 23:38, Dieter Maurer wrote: > > Edward Spencer wrote at 2021-9-2 10:02 -0700: >> Sometimes I like to pass the logging level up to the command line params so >> my user can specific what level of logging they want. However there is no >> easy method for pulling the named l

Re: The sqlite3 timestamp conversion between unixepoch and localtime can't be done according to the timezone setting on the machine automatically.

2021-09-03 Thread Chris Angelico
On Sat, Sep 4, 2021 at 3:33 AM Alan Gauld via Python-list wrote: > > On 02/09/2021 19:30, Chris Angelico wrote: > > >> Without DST the schools opened in the dark so all the kids > >> had to travel to school in the dark and the number of > >> traffic accidents while crossing roads jumped. > > > > H

Re: Connecting python to DB2 database

2021-09-03 Thread Dennis Lee Bieber
On Fri, 3 Sep 2021 09:29:20 -0400, DFS declaimed the following: > >Now can you get DB2 to accept ; as a SQL statement terminator like the >rest of the world? They call it "An unexpected token"... I've never seen a semi-colon used for SQL statements via a db-api adapter. The semi-colon

Re: The sqlite3 timestamp conversion between unixepoch and localtime can't be done according to the timezone setting on the machine automatically.

2021-09-03 Thread Alan Gauld via Python-list
On 02/09/2021 19:30, Chris Angelico wrote: >> Without DST the schools opened in the dark so all the kids >> had to travel to school in the dark and the number of >> traffic accidents while crossing roads jumped. > > How do they manage in winter? That was the winter. Sunrise wasn't till 10:00 or

Re: on floating-point numbers

2021-09-03 Thread Peter Pearson
On Thu, 2 Sep 2021 07:54:27 -0700 (PDT), Julio Di Egidio wrote: > On Thursday, 2 September 2021 at 16:51:24 UTC+2, Christian Gollwitzer wrote: >> Am 02.09.21 um 16:49 schrieb Julio Di Egidio: >> > On Thursday, 2 September 2021 at 16:41:38 UTC+2, Peter Pearson wrote: >> >> On Thu, 02 Sep 2021 10:51

Re: The sqlite3 timestamp conversion between unixepoch and localtime

2021-09-03 Thread Michael F. Stemper
On 03/09/2021 01.14, Bob Martin wrote: On 2 Sep 2021 at 20:25:27, Alan Gauld wrote: On 02/09/2021 20:11, MRAB wrote: In one of them (I can't recall which is which) they change on the 4th weekend of October/March in the other they change on the last weekend. In the EU (and UK) it's the last

Re: Select columns based on dates - Pandas

2021-09-03 Thread Martin Di Paola
You may want to reshape the dataset to a tidy format: Pandas works better with that format. Let's assume the following dataset (this is what I understood from your message): In [34]: df = pd.DataFrame({ ...: 'Country': ['us', 'uk', 'it'], ...: '01/01/2019': [10, 20, 30], ...: '02/

RE: on floating-point numbers

2021-09-03 Thread Schachner, Joseph
Actually, Python has an fsum function meant to address this issue. >>> math.fsum([1e14, 1, -1e14]) 1.0 >>> Wow it works. --- Joseph S. Teledyne Confidential; Commercially Sensitive Business Data -Original Message- From: Hope Rouselle Sent: Thursday, September 2, 2021 9:51 AM To: pyth

RE: on floating-point numbers

2021-09-03 Thread Schachner, Joseph
What's really going on is that you are printing out more digits than you are entitled to. 39.61 : 16 decimal digits. 4e16 should require 55 binary bits (in the mantissa) to represent, at least as I calculate it. Double precision floating point has 52 bits in the mantissa, plus o

Re: on floating-point numbers

2021-09-03 Thread MRAB
On 2021-09-03 16:13, Chris Angelico wrote: On Sat, Sep 4, 2021 at 12:08 AM o1bigtenor wrote: Hmmm - - - ZI would suggest that you haven't looked into taxation yet! In taxation you get a rational number that MUST be multiplied by the amount in currency. (You can, of course, multiply a curr

Re: on floating-point numbers

2021-09-03 Thread Chris Angelico
On Sat, Sep 4, 2021 at 12:08 AM o1bigtenor wrote: > Hmmm - - - ZI would suggest that you haven't looked into > taxation yet! > In taxation you get a rational number that MUST be multiplied by > the amount in currency. (You can, of course, multiply a currency amount by any scalar. Just not by

Re: on floating-point numbers

2021-09-03 Thread o1bigtenor
On Thu, Sep 2, 2021 at 2:27 PM Chris Angelico wrote: > On Fri, Sep 3, 2021 at 4:58 AM Hope Rouselle wrote: > > > > Hope Rouselle writes: > > > > > Just sharing a case of floating-point numbers. Nothing needed to be > > > solved or to be figured out. Just bringing up conversation. > > > > > >

Re: Connecting python to DB2 database

2021-09-03 Thread Chris Angelico
On Fri, Sep 3, 2021 at 11:37 PM DFS wrote: > > On 9/3/2021 1:47 AM, Chris Angelico wrote: > > On Fri, Sep 3, 2021 at 3:42 PM DFS wrote: > >> > >> Having a problem with the DB2 connector > >> > >> test.py > >> > >> import ibm_db_dbi

Re: Connecting python to DB2 database

2021-09-03 Thread DFS
On 9/3/2021 1:47 AM, Chris Angelico wrote: On Fri, Sep 3, 2021 at 3:42 PM DFS wrote: Having a problem with the DB2 connector test.py import ibm_db_dbi connectstring = 'DATABASE=xxx;HOSTNAME=localhost;PORT=5;PROTOCOL=TCPIP;UI

Re: on floating-point numbers

2021-09-03 Thread Oscar Benjamin
On Fri, 3 Sept 2021 at 13:48, Chris Angelico wrote: > > On Fri, Sep 3, 2021 at 10:42 PM jak wrote: > > > > Il 03/09/2021 09:07, Julio Di Egidio ha scritto: > > > On Friday, 3 September 2021 at 01:22:28 UTC+2, Chris Angelico wrote: > > >> On Fri, Sep 3, 2021 at 8:15 AM Dennis Lee Bieber > > >> w

Re: on floating-point numbers

2021-09-03 Thread Chris Angelico
On Fri, Sep 3, 2021 at 10:42 PM jak wrote: > > Il 03/09/2021 09:07, Julio Di Egidio ha scritto: > > On Friday, 3 September 2021 at 01:22:28 UTC+2, Chris Angelico wrote: > >> On Fri, Sep 3, 2021 at 8:15 AM Dennis Lee Bieber > >> wrote: > >>> On Fri, 3 Sep 2021 04:43:02 +1000, Chris Angelico > >>

Re: on floating-point numbers

2021-09-03 Thread jak
Il 03/09/2021 09:07, Julio Di Egidio ha scritto: On Friday, 3 September 2021 at 01:22:28 UTC+2, Chris Angelico wrote: On Fri, Sep 3, 2021 at 8:15 AM Dennis Lee Bieber wrote: On Fri, 3 Sep 2021 04:43:02 +1000, Chris Angelico declaimed the following: The naive summation algorithm used by sum(

Re: The sqlite3 timestamp conversion between unixepoch and localtime

2021-09-03 Thread Bob Martin
On 2 Sep 2021 at 20:25:27, Alan Gauld wrote: > On 02/09/2021 20:11, MRAB wrote: > >>> In one of them (I can't recall which is which) they change on the 4th >>> weekend of October/March in the other they change on the last weekend. >>> >>> >> In the EU (and UK) it's the last Sunday in March/October

Re: on floating-point numbers

2021-09-03 Thread Christian Gollwitzer
Am 02.09.21 um 21:02 schrieb Julio Di Egidio: On Thursday, 2 September 2021 at 20:43:36 UTC+2, Chris Angelico wrote: On Fri, Sep 3, 2021 at 4:29 AM Hope Rouselle wrote: All I did was to take the first number, 7.23, and move it to the last position in the list. (So we have a violation of the

Re: on floating-point numbers

2021-09-03 Thread Roel Schroeven
Op 2/09/2021 om 17:08 schreef Hope Rouselle: ls = [7.23, 8.41, 6.15, 2.31, 7.73, 7.77] sum(ls) > 39.594 > ls = [8.41, 6.15, 2.31, 7.73, 7.77, 7.23] sum(ls) > 39.61 > > All I did was to take the first number, 7.23, and move it to the last > position in t