请教各位大侠,运行程序的时候,一直提示报错:
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就明白了。加油了,小伙。
谢谢你的回复,很有帮助~~~
现在就按照你的说的办法改正,谢啦!
address = house_num + ' ' + street + "," + city这句代码中的house_num后面的''错了,你的是中文符号‘’,应该是英文符号''
address = house_num + ' ' + street + "," + city这句代码中的house_num后面的''错了,你的是中文符号‘’,应该是英文符号''
嗯谢谢你,非常感谢~~
今天把问题解决了,哈哈