数据分析(基金)1.数据获取：python爬虫2.数据清洗及计算指标3.数据分析：SQL

["000001","HXCZHH","华夏成长混合","混合型-灵活","HUAXIACHENGZHANGHUNHE"],["000002","HXCZHH","华夏成长混合(后端)","混合型-灵活","HUAXIACHENGZHANGHUNHE"],["000003","ZHKZZZQA","中海可转债债券A","债券型-可转债","ZHONGHAIKEZHUANZHAIZHAIQUANA"],["000004","ZHKZZZQC","中海可转债债券C","债券型-可转债","ZHONGHAIKEZHUANZHAIZHAIQUANC"],["000005","JSZQXYDQZQ","嘉实增强信用定期债券","债券型-长债","JIASHIZENGQIANGXINYONGDINGQIZHAIQUAN"],["000006","XBLDLHCZHHA","西部利得量化成长混合A","混合型-偏股","XIBULIDELIANGHUACHENGZHANGHUNHEA"],["000008","JSZZ500ETFLJA","嘉实中证500ETF联接A","指数型-股票","JIASHIZHONGZHENG500ETFLIANJIEA"],["000009","YFDTTLCHBA","易方达天天理财货币A","货币型","YIFANGDATIANTIANLICAIHUOBIA"],["000010","YFDTTLCHBB","易方达天天理财货币B","货币型","YIFANGDATIANTIANLICAIHUOBIB"],["000011","HXDPJXHHA","华夏大盘精选混合A","混合型-灵活","HUAXIADAPANJINGXUANHUNHEA"],["000012","HXDPJXHHA","华夏大盘精选混合A(后端)","混合型-灵活","HUAXIADAPANJINGXUANHUNHEA"],["000013","YFDTTLCHBR","易方达天天理财货币R","货币型","YIFANGDATIANTIANLICAIHUOBIR"],["000014","HXJLZQA","华夏聚利债券A","债券型-混合债","HUAXIAJULIZHAIQUANA"],["000015","HXCZZQA","华夏纯债债券A","债券型-长债","HUAXIACHUNZHAIZHAIQUANA"],["000016","HXCZZQC","华夏纯债债券C","债券型-长债","HUAXIACHUNZHAIZHAIQUANC"],["000017","CTKCXHH","财通可持续混合","混合型-偏股","CAITONGKECHIXUHUNHE"],["000020","JSCCPZTZHHA","景顺长城品质投资混合A","混合型-偏股","JINGSHUNCHANGCHENGPINZHITOUZIHUNHEA"],["000021","HXYSZZHH","华夏优势增长混合","混合型-偏股","HUAXIAYOUSHIZENGZHANGHUNHE"],["000024","DMSLZQZQA","大摩双利增强债券A","债券型-长债","DAMOSHUANGLIZENGQIANGZHAIQUANA"],["000025","DMSLZQZQC","大摩双利增强债券C","债券型-长债","DAMOSHUANGLIZENGQIANGZHAIQUANC"],["000028","HFAXZQ","华富安鑫债券","债券型-混合债","HUAFUANXINZHAIQUAN"],["000029","FGHGCLLHPZHHA","富国宏观策略灵活配置混合A","混合型-灵活","FUGUOHONGGUANCELUELINGHUOPEIZHIHUNHEA"],["000030","CCHXYXHH","长城核心优选混合","混合型-灵活","CHANGCHENGHEXINYOUXUANHUNHE"],["000031","HXFXHHA","华夏复兴混合A","混合型-偏股","HUAXIAFUXINGHUNHEA"],["000032","YFDXYZZQA","易方达信用债债券A","债券型-长债","YIFANGDAXINYONGZHAIZHAIQUANA"],["000033","YFDXYZZQC","易方达信用债债券C","债券型-长债","YIFANGDAXINYONGZHAIZHAIQUANC"],["000037","GFJNZQA","广发景宁债券A","债券型-长债","GUANGFAJINGNINGZHAIQUANA"],["000039","NYGZZHH","农银高增长混合","混合型-偏股","NONGYINGAOZENGZHANGHUNHE"],["000041","HXQQGPQDII","华夏全球股票(QDII)","QDII","HUAXIAQUANQIUGUPIAOQDII"],["000042","CTZZESG100ZSZQA","财通中证ESG100指数增强A","指数型-股票","CAITONGZHONGZHENGESG100ZHISHUZENGQIANGA"],["000043","JSMGCZGPRMB","嘉实美国成长股票人民币","QDII","JIASHIMEIGUOCHENGZHANGGUPIAORENMINBI"],["000044","JSMGCZGPMYXH","嘉实美国成长股票美元现汇","QDII","JIASHIMEIGUOCHENGZHANGGUPIAOMEIYUANXIANHUI"],["000045","GYCYZZQA","工银产业债债券A","债券型-混合债","GONGYINCHANYEZHAIZHAIQUANA"],["000046","GYCYZZQB","工银产业债债券B","债券型-混合债","GONGYINCHANYEZHAIZHAIQUANB"],["000047","HXSZZQA","华夏双债债券A","债券型-混合债","HUAXIASHUANGZHAIZHAIQUANA"],["000048","HXSZZQC","华夏双债债券C","债券型-混合债","HUAXIASHUANGZHAIZHAIQUANC"],["000051","HXHS300ETFLJA","华夏沪深300ETF联接A","指数型-股票","HUAXIAHUSHEN300ETFLIANJIEA"],["000053","PHYCYNDKZQ","鹏华永诚一年定开债券","债券型-长债","PENGHUAYONGCHENGYINIANDINGKAIZHAIQUAN"],["000054","PHSZZLZQA","鹏华双债增利债券A","债券型-混合债","PENGHUASHUANGZHAIZENGLIZHAIQUANA"],["000055","GFNSDK100ETFLJMYQDIIA","广发纳斯达克100ETF联接美元(QDII)A","QDII","GUANGFANASIDAKE100ETFLIANJIEMEIYUANQDIIA"],["000056","JXXFSJHH","建信消费升级混合","混合型-灵活","JIANXINXIAOFEISHENGJIHUNHE"],["000057","ZYXFZTHH","中银消费主题混合","混合型-偏股","ZHONGYINXIAOFEIZHUTIHUNHE"],["000058","GLAATLHPZHH","国联安安泰灵活配置混合","混合型-灵活","GUOLIANANANTAILINGHUOPEIZHIHUNHE"],["000059","GLAZZYY100A","国联安中证医药100A","指数型-股票","GUOLIANANZHONGZHENGYIYAO100A"],["000061","HXSSHH","华夏盛世混合","混合型-偏股","HUAXIASHENGSHIHUNHE"],["000063","CSDZXXZTLHPZHH","长盛电子信息主题灵活配置混合","混合型-灵活","CHANGSHENGDIANZIXINXIZHUTILINGHUOPEIZHIHUNHE"],["000064","DM18GYDKZC","大摩18个月定开债C","债券型-长债","DAMO18GEYUEDINGKAIZHAIC"],["000065","GFJDQDHHA","国富焦点驱动混合A","混合型-灵活","GUOFUJIAODIANQUDONGHUNHEA"],["000066","NAHXHHA","诺安鸿鑫混合A","混合型-偏股","NUOANHONGXINHUNHEA"],["000067","MSJYZZYXA","民生加银转债优选A","债券型-可转债","MINSHENGJIAYINZHUANZHAIYOUXUANA"],["000068","MSJYZZYXC","民生加银转债优选C","债券型-可转债","MINSHENGJIAYINZHUANZHAIYOUXUANC"],["000069","GTRYZGDJZQA","国投瑞银中高等级债券A","债券型-混合债","GUOTOURUIYINZHONGGAODENGJIZHAIQUANA"],["000070","GTRYZGDJZQC","国投瑞银中高等级债券C","债券型-混合债","GUOTOURUIYINZHONGGAODENGJIZHAIQUANC"],["000071","HXHSETFLJA","华夏恒生ETF联接A","QDII","HUAXIAHENGSHENGETFLIANJIEA"],["000072","HAWJHBHHA","华安稳健回报混合A","混合型-灵活","HUAANWENJIANHUIBAOHUNHEA"],["000073","MGCZDLHHA","摩根成长动力混合A","混合型-灵活","MOGENCHENGZHANGDONGLIHUNHEA"],["000074","GYXYCZYNDKZA","工银信用纯债一年定开债A","债券型-长债","GONGYINXINYONGCHUNZHAIYINIANDINGKAIZHAIA"],["000075","HXHSETFLJXH","华夏恒生ETF联接现汇","QDII","HUAXIAHENGSHENGETFLIANJIEXIANHUI"],["000076","HXHSETFLJXC","华夏恒生ETF联接现钞","QDII","HUAXIAHENGSHENGETFLIANJIEXIANCHAO"],["000077","GYXYCZYNDKZC","工银信用纯债一年定开债C","债券型-长债","GONGYINXINYONGCHUNZHAIYINIANDINGKAIZHAIC"],["000078","GYXYCZSGYDKZA","工银信用纯债三个月定开债A","债券型-长债","GONGYINXINYONGCHUNZHAISANGEYUEDINGKAIZHAIA"],["000079","GYXYCZSGYDKZC","工银信用纯债三个月定开债C","债券型-长债","GONGYINXINYONGCHUNZHAISANGEYUEDINGKAIZHAIC"],["000080","TZKZZZQZQA","天治可转债增强债券A","债券型-可转债","TIANZHIKEZHUANZHAIZENGQIANGZHAIQUANA"],["000081","TZKZZZQZQC","天治可转债增强债券C","债券型-可转债","TIANZHIKEZHUANZHAIZENGQIANGZHAIQUANC"],["000082","JSYJAEFGP","嘉实研究阿尔法股票","股票型","JIASHIYANJIUAERFAGUPIAO"],["000083","HTFXFHYHH","汇添富消费行业混合","混合型-偏股","HUITIANFUXIAOFEIHANGYEHUNHE"],["000084","BSAYZQA","博时安盈债券A","债券型-中短债","BOSHIANYINGZHAIQUANA"],["000085","BSAYZQC","博时安盈债券C","债券型-中短债","BOSHIANYINGZHAIQUANC"],["000086","NFWL1NCYQZQA","南方稳利1年持有期债券A","债券型-长债","NANFANGWENLI1NIANCHIYOUQIZHAIQUANA"],["000089","MSJYGDJXYZC","民生加银高等级信用债C","债券型-长债","MINSHENGJIAYINGAODENGJIXINYONGZHAIC"],["000090","MSJYGDJXYZA","民生加银高等级信用债A","债券型-长债","MINSHENGJIAYINGAODENGJIXINYONGZHAIA"],["000103","GTZGQYJWGSYZ","国泰中国企业境外高收益债","QDII","GUOTAIZHONGGUOQIYEJINGWAIGAOSHOUYIZHAI"],["000104","HCWLWJTLZQA","华宸未来稳健添利债券A","债券型-长债","HUACHENWEILAIWENJIANTIANLIZHAIQUANA"],["000105","JXAXHBZQA","建信安心回报债券A","债券型-长债","JIANXINANXINHUIBAOZHAIQUANA"],["000106","JXAXHBZQC","建信安心回报债券C","债券型-长债","JIANXINANXINHUIBAOZHAIQUANC"],["000107","FGWJZQZQAB","富国稳健增强债券A/B","债券型-混合债","FUGUOWENJIANZENGQIANGZHAIQUANAB"],["000108","FGWJZQZQAB","富国稳健增强债券A/B(后端)","债券型-混合债","FUGUOWENJIANZENGQIANGZHAIQUANAB"],["000109","FGWJZQZQC","�