英超买球

当前位置: 首页 > 综合论坛 > 一家之言

可视化分析方法在乡村振兴审计中的应用

来源:英超买球_英超买球app手机版|信誉平台 南通英超买球 发布时间: 2019-07-18 字体: [ ]

乡村振兴战略是党的十九大作出的一项重大部署,具有政策覆盖面广、资金体量大、业务数据多等特点。加强乡村振兴审计监督,SQL Server、Access、AO等传统的分析工具和方法难以完全满足审计需求。本文结合2019年乡村振兴审计,介绍Python语言、Neo4j图数据库和传统技术的融合运用,实现全量数据的可视化展示和分析,提高问题挖掘的精准度,提升审计效率。

YI、Python、Neo4jDEYINGYONGGAIKUANG

英超买球SHUJUKESHIHUASHISHIYONGTUXINGTUBIAOFANGSHILAIZHANSHISHUJU,BINGLIYONGSHUJUFENXIGONGJUSHENDUWAJUESHUJUWEIZHIXINXIDECHULIGUOCHENG。XIANGCUNZHENXINGSHENJIDESHUJULAIYUANYUCAIZHENG、FUPINBAN、MINZHENG、ZHUJIANDENG9GEBUMEN,SHUJUZONGLIANGYUE300GB,SHEJIXIANGMUZIJINGUANLIRENYUAN、CUNWEIHUIGONGZUORENYUANHESHOUBUTIEQUNZHONGDENGDUOLEIQUNTI。WEILEDUIHAILIANGSHUJUJINXINGZHIGUANFENXI,DUIFUZAGUANXIWANGJINXINGYIDIANDINGWEI,KEJIANGPythonHENeo4jYINGYONGYUSHENJIGUOCHENGZHONG,FANGFAGAIKUORUXIA:

英超买球(YI)LIYONGSQL ServerJINXINGSHUJUZHENGLIHETONGJI

ZAISHUJUZHENGLIJIEDUAN,JIANGCAIJIDAODEOracle、ExcelDENGBUTONGLEIXINGDESHUJUTONGYIZHUANHUAN、DAORUDAOSQL ServerSHUJUKUZHONG;JIANLIZHONGJIANBIAOMOBAN,DUIRUKUDEBUTONGDIQU、NIANDUSHUJUJINXINGERCIZHENGLI、HEBING,SHENGCHENGQUANSHI“YIKATONG”FAFANGMINGXI、FANGWUCHANQUANDENGJIXINXI、CAIZHENGGONGYANGRENYUANXINXI、CANJIRENMINGCE、TUDIQUEQUANDAOHUMINGXI、CUNGANBUJIASHUXINXIDENGZHONGJIANBIAO。WEIBIANYUZONGTIFENXI,DUIMINGXISHUJUJINXINGFENLEIHUIZONG,XINGCHENGTONGJISHUJUBIAO。

(ER)SHIYONGPython、Neo4jJINXINGSHUJUKESHIHUAFENXI

英超买球ZAISHUJUFENXIJIEDUAN,ZHUYAOSHIYONGPythonZHONGDEPyecharts、xlrdLEIKUDUITONGJISHUJUBIAOJINXINGTUXINGKESHIHUACHULIHEFENXI,YUNYONGNeo4jJINXINGGUANXITUZHANSHIHEFENXI。PythonSHIYIGEJIEHEJIESHIXING、BIANYIXING、HUDONGXINGHEMIANXIANGDUIXIANGDEJIAOBENYUYAN。PyechartsSHIYIGEZAIPythonZHONGSHENGCHENGEchartsTUBIAODELEIKU,KEYIZHANSHIZHUZHUANGTU、XIANGXINGTU、YIBIAOPAN、SANGJITU、SHUZHUANGTUDENGDUOZHONGTUXING;xlrdSHIYIGEDUQUExcelWENJIANDELEIKU,KEYIDUIExcelWENJIANJINXINGJINGXIKONGZHI。Neo4jSHIYIGECHANGJIANDETUSHUJUKU,TAYITULUNWEIJICHU,YONGJIEDIANHEGUANXIZUCHENGDETUDUIZHENSHISHIJIEDEGUANXIJINXINGZHIGUANJIANMO,KEYONGMIAOSHUXINGTUXINGCHAXUNYUYANCypherCHAXUNNeo4jZHONGDEJIEDIAN、GUANXI、LUJINGDENGXINXI。

ER、JIYUPythonDEBUTIETONGJISHUJUKESHIHUA

XIANGCUNZHENXINGBAOHANGENGDIDILIBAOHUBUTIE、WUBAOHUGONGYANGBUTIE、ZUNLAOJINBUTIEDENGZIJINBUTIELEIXING,ZHEIXIEBUTIEDOUSHITONGGUO“YIKATONG”FAFANGDE。YOUYUGEDIQURENKOUGUIMOJINIANLINGJIEGOU、TUDIMIANJIJIYONGTU、JINGJIFADACHENGDUJICHANYELEIXINGDENGFANGMIANBUJINXIANGTONG,HENGXIANGBIDUIFENXIKECANKAOXINGBUDA,YINCISHENJIKAOLVCONGDIQU、BUTIELEIXING、2017NIANHE2018NIANDEBUTIEBIANHUAESANGEWEIDUDUI“YIKATONG”BUTIEFAFANGQINGKUANGJINXINGZONGTIFENXI。CHUANTONGDEJIEGOUHUAFENXIGONGJUNANYICONGDUOGEWEIDUJINXINGZONGHE、ZHIGUANFENXI,BENWENXUANZESHIYONGSANWEIZHUZHUANGTUJINXINGBUTIEBIANHUAQINGKUANGDEDUOWEIZHANSHIHEFENXI。

(YI)DUOZHONGBUTIELEIXINGNIANDUCHAESHUJUYUCHULI

JIANGSQL ServerSHENGCHENGDE2017HE2018NIANGEDIQU、GELEIBUTIEDE“YIKATONG”BUTIEFAFANGJINETONGJISHUJUDAORUDAOPythonZHONG,WEIBIANYUDUOWEIDUZHANSHI,JIANGMEIZHONGLEIXINGNIANDUBUTIEBIANHUAEDEJUNZHIZUOWEICANKAOLIANG,JISUANGEDIQUMEILEIBUTIENIANDUBIANHUAEYUQUANSHIDUIYINGBUTIENIANDUBIANHUAEJUNZHIDEBILV,YIBUTIEJINEBIANHUADEXIANGDUIZHIJINXINGSHUJUZHANSHI,JUTIGONGSHIRUXIA:

ADIQUBLEIBUTIEBIANHUAEYUBLEIBUTIEBIANHUAEJUNZHIDEBILV=ADIQUBLEIBUTIEBIANHUAE/QUANSHIBLEIBUTIEBIANHUAEDEPINGJUNZHI

(ER)LIYONG3DZHUZHUANGTUJINXINGKESHIHUAFENXI

YIQSHISHUJUWEILI,LIYONGPyechartsLEIKUDE3DBarHANSHUJIANGSUOYOUXINGZHENGCUNGELEIBUTIEDENIANDUBIANHUAQINGKUANGZHANSHIZAISANWEIZHUZHUANGTUZHONG,RUTU1SUOSHI。XZHOUBIAOSHIBUTIELEIXING,YZHOUBIAOSHIXINGZHENGCUNMINGCHENG,ZZHOUBIAOSHI2017NIANHE2018NIANBUTIEBIANHUAEYUBIANHUAEJUNZHIDEBILV。

TONGGUOTUODONGTU1ZUOCEDESHAIXUANGONGJU,SHEZHIZZHOUSHUZHIQUJIAN,SHAIXUANCHUNIANDUBUTIEBIANHUAEZHANBIJIAODADEBUTIELEIXINGHEXINGZHENGCUN,RUTU2SUOSHI。CONGBUTIELEIXINGDEJIAODUKAN,NONGCUNZUIDISHENGHUOBAOZHANGBUTIE、NONGYEZHICHIBAOHUBUTIE(GENGDIDILIBUTIE)HEJIHUASHENGYUJIATINGJIANGLIBUTIEDENIANDUBIANHUAEYUQUANSHIPINGJUNBIANHUAEDEBILVJIAODA,ZUIDADEDADAOQUANSHIBUTIEBIANHUAEJUNZHIDE11.22BEI,YINGJIANGZHEISANLEIBUTIEFAFANGQINGKUANGZUOWEIGUANZHUZHONGDIAN;CONGDIQUFANWEIDEJIAODUKAN,“XU*CUN”“NAN*QUJIEDAO”CHUXIANDUOZHONGBUTIEDENIANDUBIANHUAEYUQUANSHIBUTIEBIANHUAEJUNZHIBILVJIAODADEQINGKUANG,YINGZUOWEIZHONGDIANGUANZHUDUIXIANG。SHENJIZUJINGGUOJINYIBUFENXIHESHIDIDIAOYUEXIANGGUANPINGZHENGHETAIZHANGZILIAO,FAXIANLETONGGUOXUBAOZHONGZHIMIANJI、XUGOUNONGJIJUDENGFANGSHIPIANQUHUINONGBUTIEZIJINDEWENTI。

图片1.png

 图1  Q市补贴差额3D直方图

图片2.png

 图2  Q市补贴差额3D直方图筛选结果

SAN、JIYUNeo4jDEBUTIELINGQUGUANLIANGUANXIFENXIKESHIHUA

英超买球XIANGCUNZHENXINGZHONGYUBUTIEXIANGGUANDERENYUANBAOKUOZIJINGUANLIRENYUAN、FAFANGRENYUAN、LINGQURENYUANDENG,RUHESHENRUWAJUEBUTIESHEJIDEDUOLEIRENYUANZHIJIANDEGUANXINI?CHUANTONGDESQL ServerHUOOracleJIEGOUHUASHUJUKUSUIRANKEYITONGGUOLIANJIECAOZUOJINXINGGUANLIANFENXI,DANSHIDANGLIANJIEDEBIAOJIAODUOSHICHAXUNXIAOLVBUGAO,ERQIETONGGUOsum、countDENGJUHEHANSHUJIEGUOLAIQUEDINGGUANJIANJIEDIANBUBIANJIEBUZHIGUAN,SUOYIXIANGMUZUXUANZETUSHUJUKUNeo4jJINXINGGUANXIWAJUEHEFENXI。

(YI)JIANLIJIEDIANHEGUANXISHUJU

英超买球LIYONGCAIJIDAODE“YIKATONG”FAFANGMINGXIHECUNGANBUJIASHUXINXIBIAO,SHULICHUSANLEIZHUTI: CUNGANBU、CUNGANBUJIASHUHEFAFANGDEBUTIE,LIANGGEGUANXI: CUNGANBUYUQIJIASHUZHIJIANDEQINSHUXINXI,JIASHUYUBUTIEZHIJIANDELINGQUGUANXI,JIANLIcsvGESHIDEJIEDIAN、BIANSHUJU。

英超买球(ER)SHENGCHENGCUNGANBUJIASHULINGQUBUTIEDEGUANXITU

英超买球JIANGJIEDIANHEBIANDESHUJUDAORUDAONeo4jZHONG,SHENGCHENGCUNGANBUJIASHULINGQUBUTIEDEGUANXITU。LIYONGCypherDEmatchZIJUTONGJIMEIMINGCUNGANBUDESUOYOUJIASHULINGQUBUTIEDELUJINGTIAOSHU,YUJURUXIA:

match (n:CUNGANBUJIEDIAN)-[]->(BUTIEJIEDIAN)

英超买球return n,count(n)   

英超买球order by count(n) desc

GENJUTONGJIJIEGUO,XUANZECUNGANBU->JIASHU->BUTIELUJINGTIAOSHUJIAODUODEJIEDIANHEBIANJINXINGZHANSHIHEFENXI,BUFENJIEGUORUTU3SUOSHI。CONGZHONGKEYIKANCHU,LUJINGTIAOSHUJIAODUODECUNGANBUJIASHULINGQUBUTIEGUANXIFENWEILIANGLEI: YILEISHIYOUTONGYICUNGANBUDEJIASHULINGQULEDUOZHONGBUTIE,YILEISHIYIGEJIASHUGUANLIANDUOGECUNGANBULINGQULEDUOZHONGBUTIE,ZHONGDIANWEIRAOLINGQUBUTIELUJINGDUODECUNGANBU、GUANLIANDUOGECUNGANBUDEJIASHULIANGGEJIAODUJINXINGHECHAYANSHEN。

LEISIDEFANGFAHAIKEYIYONGYULINGQUBUTIERENYUANHECAIZHENGGONGYANGRENYUAN、FANGWUCHANQUANSUOSHURENYUANZHIJIANGUANXIFENXI。JIYUBUTIELINGQUGUANXIDEFENXIJIEGUO,SHENJIZUTONGGUOJINYIBUHECHA,SUODINGLEBUFENCAIZHENGGONGYANGRENYUANLINGQUBAOZHANGJINDEWENTI。

图片3.png

 图3  部分村干部家属领取补贴关系图

SI、ZONGJIEJIZHANWANG

英超买球BENSHENJIXIANGMUCHONGFENYUNYONGLEPythonYUYAN、Neo4jTUSHUJUKUZAISHUJUKESHIHUAZHANSHIHEFENXISHANGDEYOUSHI,SHIXIANLEQUANLIANGSHUJUDETONGJIFENXIHEDUOZHUTIZHIJIANGUANLIANGUANXIFENXI。YIPython、Neo4jWEIDAIBIAODEXINJISHUTUPOLECHUANTONGGONGJUYINGUOFENXI、JIEGOUHUAFENXIMOSHI,ZAIFEIJIEGOUHUASHUJUFENXI、TUXINGZHANSHIDENGFANGMIANYOUSHIMINGXIAN,TONGSHIYINWEIXINJISHUDESHIYONGXUYAOYIDINGBIANCHENGJICHUHETONGJIXUE、TULUNDENGLILUNZHISHI,YEJISHENJIRENYUANDAILAILEXINTIAOZHAN。XINSHIDAI,SHENJIRENYUANYINGGAIGENGJIAZHUZHONGDASHUJUSHENJISIWEIDEPEIYUHENENGLIDEPEIYANG,CUJINXINJISHUHECHUANTONGFANGFAJIEHE,YIXINXIJISHUYUSHENJIYEWUDESHENDURONGHETUIDONGKEJIQIANGSHENMAISHANGXINTAIJIE。

英超买球NANTONGYINGCHAOMAIQIU  LIUYIN


英超买球_英超买球app手机版|信誉平台 英超竞猜网站_英超竞猜投注|首页 csgo投注官网_韦德投注|官网 im电竞官网_正规im电竞|正规授权 在线真人平台_真人网络赌钱平台|官方平台 AG开户|信誉平台 PG电子_官网平台|首页 yabo彩票_官方网站|官网 AG百家乐|首页 ag登录_ag网站|官网 ag真人_ag真人百家家乐|正规授权