pyhton对oracle 数据库表缺失数据补齐

最新推荐文章于 2022-10-19 17:32:55 发布

SZleoWang

最新推荐文章于 2022-10-19 17:32:55 发布

阅读量171

点赞数

分类专栏：数据分析文章标签： python

本文链接：https://blog.csdn.net/rdhj5566/article/details/119882405

版权

使用Python的cx_Oracle库连接Oracle数据库，通过Pandas处理数据，找出缺失值，并用相同分组下的平均值进行填充。最后将处理后的数据插入到新的表中。

摘要由CSDN通过智能技术生成

import cx_Oracle
import pandas as pd
import numpy as np
import math as mt

host = "127.0.01"
port = "1521"
sid = "1111"
dsn = cx_Oracle.makedsn(host, port, sid)
conn = cx_Oracle.connect("111", "111", dsn)
cursor = cx_Oracle.Cursor(conn)
cursor.execute("SELECT md.meter_no, md.dater,  d.data_value,decode(data_value,null,0,1) flag FROM(SELECT m.meter_no, m.meter_id, m.con_id, c.dater FROM (SELECT * FROM g_ar_meter mm left outer join G_AC_DEPT gad ON mm.dept_id = gad.dept_id WHERE mm.dev_status = '5' and (meter_no ='11011001440' or meter_no ='11011001441')) m INNER JOIN (SELECT MIN(c.dater) dater FROM g_sys_calendar c WHERE c.dater >= to_date('2021-01-01 00:00:00', 'yyyy-MM-dd hh24:mi:ss') AND c.dater < to_date('2021-08-01 23:59:59', 'yyyy-MM-dd hh24:mi:ss') GROUP BY TO_CHAR(c.dater, 'yyyy-MM')) c ON 1 = 1 AND m.dev_status &#