Printing tuple data in normal text in Python

Question

I have variable r=(u'East london,London,England', u'Mr.Baker in East london (at 2010-02-21 15:25:27.0)') in this format from webservice as a output from small program. How can I print these tuple data as normal string like:

East london,London,England   Mr.Baker in East london (at 2010-02-21 15:25:27.0)

can anybody help me out of this please?Thanks in advance!

my code is giving now!

from sqlite3 import *

import feedparser
import codecs# newly added


data = feedparser.parse("some url")


conn = connect('location2.db')
curs = conn.cursor()

curs.execute('''create table location_top6
  ( id integer primary key,title text ,
        updated text)''')


for i in range(len(data['entries'])):
    curs.execute("insert into location_top6 values\
        (NULL, '%s', '%s')" % (data.entries[i].title,data.entries[i].summary))

conn.commit()
curs.execute("select * from location_top6")
for r in curs:
    print r

and I want this r value printed as normal string!

SilentGhost · Accepted Answer · 2010-02-22 13:28:02Z

3

just join on the separator, if it's space it would be:

' '.join(r)

edit: re your update code. Your table contains primary key, as can be seen from the table definition, that primary key is an integer. That's why you're getting that TypeError. The question is whether you want to print that primary key or not. If the answer is yes you could do the following:

' '.join(str(i) for i in r)

if no is the answer: you just need to ' '.join(r[1:]).

edited Feb 22, 2010 at 13:28

answered Feb 22, 2010 at 12:54

SilentGhost

322k67 gold badges312 silver badges294 bronze badges

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

7 Comments

rahman.bd Over a year ago

well I tried it but showing error that : Traceback (most recent call last): File "F:\JavaWorkspace\Test\src\sqlite_example.py", line 28, in <module> print ''.join(row) TypeError: sequence item 0: expected string, int found Here int is found in the database content!...so ?

Johannes Charra Over a year ago

' '.join([str(x) for x in r])

rahman.bd Over a year ago

@silentghost : it doesnt show error right now for considering integer value ! but it neither show anything in output console!

SilentGhost Over a year ago

@rahman: it's hard to know what the reason for this w/o seeing the actual code

rahman.bd Over a year ago

@Silentghost: I have attached my actual code for your concerned in the above!could you please have a look of it?and another issue is that: I have some finnish language alphabet in that r variable representing location ,which need to handle with UTF-8, I guess so! But stuck with that problem too!.Can you please have a look it as well?

|

poke · Accepted Answer · 2010-02-22 13:27:04Z

0

If the sequence x contains other types than string, convert those first:

' '.join( map( str, x ) )

answered Feb 22, 2010 at 13:27

poke

392k80 gold badges596 silver badges632 bronze badges

Collectives™ on Stack Overflow

Printing tuple data in normal text in Python

2 Answers 2

7 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related