import os,csv
import os.path
from pandasql import sqldf
import pandas as pd
x=pd.read_csv('./output/test.csv')
pysqldf=lambda q:sqldf(q,globals())
q="""
select
Date_ID,sum(Voice_Erl) as erl
,SUM(RRC_chenggongshu) as cg,SUM(RRC_qingqiushu) as 'qqs'
,sum(rrc_chenggongshu)/sum(rrc_qingqiushu) as 'RRCSR'
,sum(pmPdcpPktLostUlQci1) as 上行丢包数
,sum([UL Packet Loss Rate_fenmu]) as plk_fw
from
x #####表名,上述表为x=pd.read_csv('./output/test.csv')
group by
Date_ID;
"""
pysqldf(q)
(pysqldf(q)).to_csv('test1.csv')
PYTHON--实现SQLDF操作
最新推荐文章于 2025-05-31 22:54:14 发布