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":"---"},