On 11/13/2022 7:37 AM, Pancho wrote:
On 11/11/2022 19:56, DFS wrote:
Edit: found a solution online:
-
x = [(11,1,1),(1,41,2),(9,3,12)]
maxvals = [0]*len(x[0])
for e in x:
maxvals = [max(w,int(c)) for w,c in zip(maxvals,e)]
pri
On 11/11/2022 19:56, DFS wrote:
Edit: found a solution online:
-
x = [(11,1,1),(1,41,2),(9,3,12)]
maxvals = [0]*len(x[0])
for e in x:
maxvals = [max(w,int(c)) for w,c in zip(maxvals,e)]
print(maxvals)
[11,41,12]
---
On Sat, 12 Nov 2022 13:24:37 -0500, Dennis Lee Bieber
declaimed the following:
> Granted, this will NOT work with "select *" unless one does the select
>*/fetchall first, AND extracts the names from the cursor description --
>then run a loop to create the select max(length(col)), ... state
On Fri, 11 Nov 2022 21:20:10 -0500, DFS declaimed the
following:
>Yeah, I don't know why cursor.description doesn't work with SQLite; all
>their columns are basically varchars.
>
If you read PEP 249 (the general DB-API), everything except column name
and data type code are optional. And
type checking in
addition to the dyunamic typing.
> From: Python-list on
> behalf of Pancho via Python-list
> Date: Friday, November 11, 2022 at 6:28 PM
> To: python-list@python.org
> Subject: Re: Need max values in list of tuples, based on position
>
> That was one of the thing
Types are available if you want to use them.
https://www.pythontutorial.net/python-basics/python-type-hints/
From: Python-list on
behalf of Pancho via Python-list
Date: Friday, November 11, 2022 at 6:28 PM
To: python-list@python.org
Subject: Re: Need max values in list of tuples, based on
On 11/11/2022 7:04 PM, Dennis Lee Bieber wrote:
On Fri, 11 Nov 2022 15:03:49 -0500, DFS declaimed the
following:
Thanks for looking at it. I'm trying to determine the maximum length of
each column result in a SQL query. Normally you can use the 3rd value
of the cursor.description object (se
On Fri, 11 Nov 2022 15:03:49 -0500, DFS declaimed the
following:
>Thanks for looking at it. I'm trying to determine the maximum length of
>each column result in a SQL query. Normally you can use the 3rd value
>of the cursor.description object (see the DB-API spec), but apparently
>not with
On 11/11/2022 20:58, Thomas Passin wrote:
On 11/11/2022 2:22 PM, Pancho via Python-list wrote:
On 11/11/2022 18:53, DFS wrote:
On 11/11/2022 12:49 PM, Dennis Lee Bieber wrote:
On Fri, 11 Nov 2022 02:22:34 -0500, DFS declaimed the
following:
[(0,11), (1,1), (2,1),
(0,1) , (1,41), (2,2),
On 11/11/2022 2:22 PM, Pancho wrote:
On 11/11/2022 18:53, DFS wrote:
On 11/11/2022 12:49 PM, Dennis Lee Bieber wrote:
On Fri, 11 Nov 2022 02:22:34 -0500, DFS declaimed the
following:
[(0,11), (1,1), (2,1),
(0,1) , (1,41), (2,2),
(0,9) , (1,3), (2,12)]
The set of values in elements[0]
On 11/11/2022 2:22 AM, DFS wrote:
[(0,11), (1,1), (2,1),
(0,1) , (1,41), (2,2),
(0,9) , (1,3), (2,12)]
The set of values in elements[0] is {0,1,2}
I want the set of max values in elements[1]: {11,41,12}
This request is ambiguous. Do you want to get the maximum value for
each row, and
On 11/11/2022 2:22 PM, Pancho via Python-list wrote:
On 11/11/2022 18:53, DFS wrote:
On 11/11/2022 12:49 PM, Dennis Lee Bieber wrote:
On Fri, 11 Nov 2022 02:22:34 -0500, DFS declaimed the
following:
[(0,11), (1,1), (2,1),
(0,1) , (1,41), (2,2),
(0,9) , (1,3), (2,12)]
The set of value
On 11/11/2022 7:50 AM, Stefan Ram wrote:
Pancho writes:
def build_max_dict( tups):
dict = {}
for (a,b) in tups:
if (a in dict):
if (b>dict[a]):
dict[a]=b
else:
dict[a]=b
return(sorted(dict.values()))
Or,
import it
On Fri, 11 Nov 2022 02:22:34 -0500, DFS declaimed the
following:
>
>[(0,11), (1,1), (2,1),
> (0,1) , (1,41), (2,2),
> (0,9) , (1,3), (2,12)]
>
>The set of values in elements[0] is {0,1,2}
>
>I want the set of max values in elements[1]: {11,41,12}
Do they have to be IN THAT OR
On 11/11/2022 07:22, DFS wrote:
[(0,11), (1,1), (2,1),
(0,1) , (1,41), (2,2),
(0,9) , (1,3), (2,12)]
The set of values in elements[0] is {0,1,2}
I want the set of max values in elements[1]: {11,41,12}
def build_max_dict( tups):
dict = {}
for (a,b) in tups:
if (a in di
On 11/11/2022 18:53, DFS wrote:
On 11/11/2022 12:49 PM, Dennis Lee Bieber wrote:
On Fri, 11 Nov 2022 02:22:34 -0500, DFS declaimed the
following:
[(0,11), (1,1), (2,1),
(0,1) , (1,41), (2,2),
(0,9) , (1,3), (2,12)]
The set of values in elements[0] is {0,1,2}
I want the set of max val
On 11/11/2022 12:49 PM, Dennis Lee Bieber wrote:
On Fri, 11 Nov 2022 02:22:34 -0500, DFS declaimed the
following:
[(0,11), (1,1), (2,1),
(0,1) , (1,41), (2,2),
(0,9) , (1,3), (2,12)]
The set of values in elements[0] is {0,1,2}
I want the set of max values in elements[1]: {11,41,12}
17 matches
Mail list logo
