主页 / 问题 / 1401660
Accepted
Arteil
Asked:2022-06-19 13:47:20 +0000 UTC2022-06-19 13:47:20 +0000 UTC

用空字符串Python替换请求中的所有None

  • 772

查询数据库时，空单元格被转换为 None 并且也显示在页面上。我需要将每个单元格从 None 替换为空字符串。这是一段带有请求的现有代码

        for id in tpaList:
        cursor = self.connections['DB_Name'].execute(f''' SELECT *
                                                            FROM [DB_Name].[dbo].[Table_Name]
                                                                AND EndDate IS NULL
                                                            ORDER BY StartDate DESC ''')
        columns = [column[0] for column in cursor.description]
        for row in cursor.fetchall():
            idleJournal.append(dict(zip(columns, row))) 
    return idleJournal
python sql

1 个回答

  1. Best Answer

    您可以通过替换来生成一个新None列表''：

    for row in cursor.fetchall():
    row = ['' if x is None else x for x in row]
    idleJournal.append(dict(zip(columns, row)))

    或者在生成字典时：

    for row in cursor.fetchall():
    idleJournal.append({k: ('' if v is None else v) for k, v in zip(columns, row)})
    • 2

相关问题