Python3: SQlite3 list format

Question

when i fetch data from a table in SQlite3 it formats each value ('value',) the data in the column: Regi Bob Jeff

how to i remove/ stop the extra round brackets and comma?

c.execute('SELECT Name from information')
data = c.fetchall()
valNameNS = data
valName = str(data)
valNameL = list(valNameNS)
print(valNameL)
[('Regi',), ('Bob',), ('Jeff',)]

Thanks

I can't even tell what you're asking.

kindall
– kindall

2017-03-14 19:17:40 +00:00
Commented Mar 14, 2017 at 19:17 — kindall
– kindall, Commented Mar 14, 2017 at 19:17
how do i remove the round brackets and extra comma

Regi Vaineikis
– Regi Vaineikis

2017-03-14 19:18:42 +00:00
Commented Mar 14, 2017 at 19:18 — Regi Vaineikis
– Regi Vaineikis, Commented Mar 14, 2017 at 19:18

radishes · Accepted Answer · 2017-03-14 19:20:46Z

2

The items in parenthesis with commas are length-one tuples. Use a list comprehension to extract them.

new_list = [x[0] for x in valNameL]

answered Mar 14, 2017 at 19:20

radishes

1361 silver badge2 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

roganjosh Over a year ago

Beat me to it. But valNameL is not needed in the first place. You can get rid of those lines (cast to string, using list()) and just use data.

Collectives™ on Stack Overflow

Python3: SQlite3 list format

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related