TypeError sequence item 0 expected string int found

Question

I am attempting to insert data from a dictionary into a database  I want to iterate over the values and format them accordingly  depending on the data type  Here is a snippet of the code I am using   def  db inserts dbinfo       try          rows   dbinfo  datarows            for row in rows              field names       join     0    format x  for x in row keys                 value list   row values                for pos  value in enumerate value list                   if isinstance value  str                       value list pos       0    format value                  elif isinstance value  datetime                       value list pos       0    format value strftime   Y- m- d                 values       join value list               sql    INSERT INTO table foobar   0   VALUES   1    format field names  values       except Exception as e          print  BARFED with msg   e   When I run the algo using some sample data  see below   I get the error      TypeError  sequence item 0  expected string  int found   An example of a value list data which gives the above error is   value list    377  -99999  -99999   f   -99999  -99999  -99999  1108 0999999999999  0   f   -99999  0   f   -99999   f   -99999  1108 0999999999999  -99999   f   -99999   f   -99999   f    f   0  1108 0999999999999  -99999  -99999   f    f    f   -99999   f    1984-04-02   -99999   f   -99999   f   1108 0999999999999     What am I doing wrong

User · Answer

The answers by cval and Priyank Patel work great. However, be aware that some values could be unicode strings and therefore may cause the str to throw a UnicodeEncodeError error. In that case, replace the function str by the function unicode.

For example, assume the string Libië (Dutch for Libya), represented in Python as the unicode string u'Libi\xeb':

print str(u'Libi\xeb')

throws the following error:

Traceback (most recent call last):
  File "/Users/tomasz/Python/MA-CIW-Scriptie/RecreateTweets.py", line 21, in <module>
    print str(u'Libi\xeb')
UnicodeEncodeError: 'ascii' codec can't encode character u'\xeb' in position 4: ordinal not in range(128)

The following line, however, will not throw an error:

print unicode(u'Libi\xeb') # prints Libië

So, replace:

values = ','.join([str(i) for i in value_list])

by

values = ','.join([unicode(i) for i in value_list])

to be safe.

User · Answer

you can convert the integer dataframe into string first and then do the operation e g   df3  nID   df3  nID   astype str  grp   df3 groupby  userID    nID   aggregate lambda x   - gt   join tuple x

User · Answer

Although the given list comprehension   generator expression answers are ok  I find this easier to read and understand   values       join map str  value list

User · Answer

string join connects elements inside list of strings  not ints    Use this generator expression instead    values       join str v  for v in value list

User · Answer

Replace    values       join value list    with  values       join  str i  for i in value list     OR  values       join str value list  1 -1

User · Answer

String interpolation is a nice way to pass in a formatted string   values        join    s    v for v in value list

[python] TypeError: sequence item 0: expected string, int found

Examples related to python