Convert Number of tuples to List of List in python

Question

postgreSQL_select_Query = "select Query"

        cur.execute(postgreSQL_select_Query)

        records = cur.fetchall() 
        print("Selecting rows ",records)
        print("Print each row and it's columns values")
        for row in records:
             print(row)

in the above code print row is given below.

('1970-01-01', '1')
('2019-01-01', '2')
('2019-01-12', '3')
('2019-01-19', '2')
('2019-02-16', '1')
('2019-02-19', '1')
('2019-02-22', '1')
('2019-02-24', '1')
('2019-02-25', '1')
('2019-02-26', '1')
('2019-03-02', '1')
('2019-03-05', '1')
('2019-03-07', '1')
('2019-03-08', '1')
('2019-03-10', '1')
('2019-03-13', '2')
('2019-03-16', '1')

How to convert above result to list of list in python The assumed result is list=[['1970-01-01', '1'],['1970-01-01', '1']]

What is wrong with tuples? If you must convert it, you can use `my_lists = list(map(list, my_tuples))`. — Selcuk, Nov 29 '19 at 06:17
Very basic problem, already answered hundreds of times: [convert-a-list-of-tuples-to-a-list-of-lists](https://stackoverflow.com/questions/14831830/convert-a-list-of-tuples-to-a-list-of-lists) — Patrick Artner, Nov 29 '19 at 06:22

Shrey · Answer 1 · 2019-11-29T08:45:28.617

-1

list comprehension is what i am going to use

postgreSQL_select_Query = "select Query"
cur.execute(postgreSQL_select_Query)
records = cur.fetchall() 
output = [list(row) for row in records]

output is what you need here i guess

edited Nov 29 '19 at 08:45

answered Nov 29 '19 at 06:19

Shrey

1,242
1
13
27

... only if he hast a tuple of tuples as input ... and the question is so basic and so often answered it is a dupe. – Patrick Artner Nov 29 '19 at 06:21
That's why i created the input in my answer. Yes, it seems possible duplicate – Shrey Nov 29 '19 at 06:22
what are you saying here? tuple of tuples in I/P and list of list is O/P here i guess – Shrey Nov 29 '19 at 06:28
check for [list(i) for i in t] line – Shrey Nov 29 '19 at 06:29

Convert Number of tuples to List of List in python

1 Answers1