请教python爬虫问题

  • t
    topeak
    python爬取chinamoney上国债、3A债券收益率,抓到数据后怎么把records里的数据给按行、分字段的抓取出来啊,知道有个pandas read_html,但好像是抓取了所有数据出来。
    {"head":{"version":"2.0","provider":"CWAP","req_code":"","rep_code":"200","rep_message":"","ts":1602087059691,"producer":"","tstext":"2020-10-08 00:10:59"},"data":{"message":null,"total":503,"showKey":"1,","pageTotal":1,"firstBondType":"CYCC000","pageSize":9000,"startDateCN":"2020-09-30","endDateCN":"2020-09-30","reference":["1"],"dateList":["2020-09-30"],"pageNum":1},"records":[{"newDateValueCN":"2020-09-30","newDateValue":"30 Sep 2020","yearTermStr":"0.083","maturityYieldStr":"1.9854","currentYieldStr":"1.9854","futureYieldStr":"---"},{"newDateValueCN":"2020-09-30","newDateValue":"30 Sep 2020","yearTermStr":"0.1","maturityYieldStr":"2.0170","currentYieldStr":"2.0170","futureYieldStr":"---"},{"newDateValueCN":"2020-09-30","newDateValue":"30 Sep 2020","yearTermStr":"0.2","maturityYieldStr":"2.2066","currentYieldStr":"2.2066","futureYieldStr":"---"},
  • 老蜜蜂
    不懂帮顶
  • s
    syf_alan
    json数组格式化提取一下HiPDA·NG
  • b
    bbbzzz
    回复1#topeak

    还有个取表的函数的,取掉以后抓取列数据。
  • k
    kkzxak47
    JSON都有了,把records数组取出来就是了啊
  • g
    gdw1986
    json.loads
  • f
    fqxufo
    学一下json的格式规范和读取方法,搞清楚每个key对应什么信息就好了 iOS fly ~