python - 类型错误 : descriptor 'replace' requires a 'str' object but received a 'NoneType '

Question

我正在尝试使用 python 直接从远程 Oracle 数据库查询的元组列表中将值“\x1c”替换为空格(“”)。我收到此错误:

TypeError: descriptor 'replace' requires a 'str' object but received a 'NoneType '

下面是我正在使用的代码，错误来自的最后一行代码:

connection = cx_Oracle.connect("WELCOME", "welcome", "(ABC)")
cursor = connection.cursor()
querystring = "select CUST_OR_CARD_ID,MESG from tbaadm.rtt where 
SYSTEM_DATE_TIME >= '01/JAN/18' and dcc_id='SPR'"
cursor.execute(querystring)
col=cursor.fetchall()

col = [tuple(map(lambda i: str.replace(i, "\x1c"," "), tup)) for tup in col]

Answer 1

我认为元组中没有None，因此需要将其过滤掉

col = [tuple([str.replace(i, "\x1c"," ") for i in tup if pd.notnull(i)]) for tup in col]

或仅替换非None值:

col=[tuple([str.replace(i, "\x1c"," ") if pd.notnull(i) else i for i in tup ]) for tup in col]

编辑:谢谢@Paul Cornelius建议使用string.replace:

col = [tuple([i.replace("\x1c"," ") for i in tup if pd.notnull(i)]) for tup in col]

col = [tuple([i.replace("\x1c"," ") if pd.notnull(i) else i for i in tup ]) for tup in col]