blocks|key|226353|text|string.join连接字符串列表中的元素，而不是int。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|226354|请改用以下生成器表达式：|226355|values+=+','.join(str(v)+for+v+in+value_list)|code-block|syntax|javascript|226356|entityMap^0|0|B|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|R|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|S|8|@]|D|@]|E|$K|L]]|$1|M|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|N|$]]

<code>string.join</code> connects elements inside list of strings, not ints. 

Use this generator expression instead :

<pre><code>values = ','.join(str(v) for v in value_list)
</code></pre>

blocks|key|226358|text|替换|type|unstyled|depth|inlineStyleRanges|entityRanges|data|226359|values+=+",".join(value_list)|code-block|syntax|javascript|226360|使用|226361|values+=+','.join([str(i)+for+i+in+value_list])|226362|或|226363|values+=+','.join(str(value_list)[1:-1])|226364|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

Replace 

<pre><code>values = ",".join(value_list)
</code></pre>

with

<pre><code>values = ','.join([str(i) for i in value_list])
</code></pre>

OR

<pre><code>values = ','.join(str(value_list)[1:-1])
</code></pre>

blocks|key|225852|text|cval和Priyank+Patel的回答效果很好。但是，请注意，某些值可能是unicode字符串，因此可能会导致str引发UnicodeEncodeError错误。在这种情况下，将函数str替换为函数unicode。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|225853|例如，假设字符串Libië(荷兰语，表示利比亚)，在Python语言中表示为unicode字符串u'Libi\xeb'|225854|print+str(u'Libi\xeb')|code-block|syntax|javascript|225855|抛出以下错误：|225856|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)|225857|但是，下面这行不会抛出错误：|225858|print+unicode(u'Libi\xeb')+#+prints+Libië|225859|因此，请替换：|225860|values+=+','.join([str(i)+for+i+in+value_list])|225861|通过|225862|values+=+','.join([unicode(i)+for+i+in+value_list])|225863|为了安全起见。|225864|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/users/923813/cval|1|https://stackoverflow.com/users/887668/priyank-patel^0|1L|3|1Q|I|2L|3|2T|7|0|4|0|5|D|1|0|1C|B|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1E|8|@$9|1F|A|1G|B|C]|$9|1H|A|1I|B|C]|$9|1J|A|1K|B|C]|$9|1L|A|1M|B|C]]|D|@$9|1N|A|1O|1|1P]|$9|1Q|A|1R|1|1S]]|E|$]]|$1|F|3|G|5|6|7|1T|8|@$9|1U|A|1V|B|C]]|D|@]|E|$]]|$1|H|3|I|5|J|7|1W|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|1X|8|@]|D|@]|E|$]]|$1|O|3|P|5|J|7|1Y|8|@]|D|@]|E|$K|L]]|$1|Q|3|R|5|6|7|1Z|8|@]|D|@]|E|$]]|$1|S|3|T|5|J|7|20|8|@]|D|@]|E|$K|L]]|$1|U|3|V|5|6|7|21|8|@]|D|@]|E|$]]|$1|W|3|X|5|J|7|22|8|@]|D|@]|E|$K|L]]|$1|Y|3|Z|5|6|7|23|8|@]|D|@]|E|$]]|$1|10|3|11|5|J|7|24|8|@]|D|@]|E|$K|L]]|$1|12|3|13|5|6|7|25|8|@]|D|@]|E|$]]|$1|14|3|-4|5|6|7|26|8|@]|D|@]|E|$]]]|15|$16|$5|17|18|19|E|$1A|1B]]|1C|$5|17|18|19|E|$1A|1D]]]]

The answers by <a href="https://stackoverflow.com/users/923813/cval">cval</a> and <a href="https://stackoverflow.com/users/887668/priyank-patel">Priyank Patel</a> work great. However, be aware that some values could be unicode strings and therefore may cause the <code>str</code> to throw a <code>UnicodeEncodeError</code> error. In that case, replace the function <code>str</code> by the function <code>unicode</code>.

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

<pre><code>print str(u'Libi\xeb')
</code></pre>

throws the following error:

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

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

<pre><code>print unicode(u'Libi\xeb') # prints Libië
</code></pre>

So, replace:

<pre><code>values = ','.join([str(i) for i in value_list])
</code></pre>

by

<pre><code>values = ','.join([unicode(i) for i in value_list])
</code></pre>

to be safe.

blocks|key|226375|text|虽然给定的列表理解/生成器表达式答案是ok的，但我发现这更容易阅读和理解：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|226376|values+=+','.join(map(str,+value_list))|code-block|syntax|javascript|226377|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Although the given list comprehension / generator expression answers are ok, I find this easier to read and understand:

<pre><code>values = ','.join(map(str, value_list))
</code></pre>

blocks|key|2879949|text|字符串插值是传递格式化字符串的一种很好的方法。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2879950|values+=+',+'.join('$%25s'+%25+v+for+v+in+value_list)|offset|length|style|CODE|2879951|entityMap^0|0|0|1D|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

String interpolation is a nice way to pass in a formatted string.

<code>values = ', '.join('$%s' % v for v in value_list)</code>

blocks|key|3093992|text|您可以先将整数数据帧转换为字符串，然后执行操作，例如|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3093993|df3['nID']=df3['nID'].astype(str)
grp+=+df3.groupby('userID')['nID'].aggregate(lambda+x:+'->'.join(tuple(x)))|code-block|syntax|javascript|3093994|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

you can convert the integer dataframe into string first and then do the operation e.g.

<pre><code>df3['nID']=df3['nID'].astype(str)
grp = df3.groupby('userID')['nID'].aggregate(lambda x: '-&gt;'.join(tuple(x)))
</code></pre>

blocks|key|223083|text|解决方案：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|223084|++++email+=+''.join([str(nip),+settings.ORGANISATION_EMAIL_SUFFIX])|code-block|syntax|javascript|223085|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

solution:
<pre><code> email = ''.join([str(nip), settings.ORGANISATION_EMAIL_SUFFIX])
</code></pre>

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:

<pre><code>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
</code></pre>

When I run the algo using some sample data (see below), I get the error:

<blockquote>
 TypeError: sequence item 0: expected string, int found
</blockquote>

An example of a value_list data which gives the above error is:

<pre><code>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] 
</code></pre>

What am I doing wrong?

TypeError: sequence item 0: expected string, int found

数据库

Python

我正在尝试将字典中的数据插入到数据库中。我希望遍历这些值，并根据数据类型对它们进行相应的格式化。下面是我使用的代码片段：def _db_inserts(dbinfo):    try:        rows = dbinfo['datarows']        for row in rows:           ...

问TypeError: sequence item 0:应为字符串，找到的是int
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问TypeError: sequence item 0:应为字符串，找到的是intEN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问TypeError: sequence item 0:应为字符串，找到的是int
EN