python统计缺失值数据_oracle 数据库表字段的缺失值统计 -- 基于python

oracle指定表缺失值统计 -- 基于cx_Oracle

import pandas as pd

import cx_Oracle as orcl

# 批量查询数据缺失率

def missing_count(table_name, where_condition={}, **engine):

#where 条件参数化， str或dict

sql_tab_columns = "select column_name from user_tab_columns \

where table_name = '{}'".format(table_name)

db = ConnectOracle(**engine)

#sql_select.encode('utf-8')

columns = db.select_oracle(sql=sql_tab_columns)

#生成select语句

ss = ''

for col in columns.COLUMN_NAME:

ss += 'sum(decode({},null, 1, 0)) as {}, '.format(col, col)

ss = ss[:-2]

#生成where条件

wh = ''

if where_condition:

wh += ' where '

if type(where_condition)==str:

wh += where_condition

if type(where_conditi