添加链接
link之家
链接快照平台
  • 输入网页链接,自动生成快照
  • 标签化管理网页链接

请教各位大侠,运行程序的时候,一直提示报错:

Traceback (most recent call last):
File "C:/Python_3.6/Python_File_Py/EX_001/003.py", line 14, in <module>
address = house_num + ' ' + street + "," + city
TypeError: ufunc 'add' did not contain a loop with signature matching types dtype('<U21') dtype('<U21') dtype('<U21')

代码如下:

import xlrd  # 导入xlrd模块
import requests  # 导入requests模块
from datetime import date, datetime  # 从模块datetime中导入函数date,datetime
import pandas as pd  # 导入pandas大熊猫模块,并将其命名为pd
from math import sin, asin, cos, radians, fabs, sqrt
loc_list = [],
df = pd.read_excel('C:\Python_3.6\Python_File_Py\EX_001\\KS_01.xlsx')
rows = df.iloc[:, 0].size  # 行数 3
for indexs in df.index:
    street = df.loc[indexs].values[0]
    house_num = df.loc[indexs].values[1]
    city = df.loc[indexs].values[2]
    address = house_num + ' ' + street + "," + city
print(address)

请问问题出在哪里啊

引用来自“giguga”的评论

pandas中取出的数据不一定是string, 相加时不能做自动转换,所以出错,调试看一下house_num等的type就明白了。加油了,小伙。

谢谢你的回复,很有帮助~~~

现在就按照你的说的办法改正,谢啦!

评论 (0)