我试图在页面源中检索如下所示的数据:
“date”:“2011-04-03T00:00:00.000Z”,
“等级”:55182
}, {
“date”:“2011-04-10T00:00:00.000Z”,
“等级”:23649
}, {
“date”:“2011-04-17T00:00:00.000Z”,
“等级”:26064
}, {
“date”:“2011-04-24T00:00:00.000Z”,
“等级”:18373
}, {
“date”:“2011-05-01T00:00:00.000Z”,
“等级”:18073
}, {
“date”:“2011-05-08T00:00:00.000Z”,
“等级”:15539
}, {
“date”:“2011-05-15T00:00:00.000Z”,
“等级”:14562
}, {
“date”:“2011-05-22T00:00:00.000Z”,
“等级”:18921
}, {
“date”:“2011-05-29T00:00:00.000Z”,
“等级”:10849
}, {
“date”:“2011-06-05T00:00:00.000Z”,
“等级”:5871
}, {
“date”:“2011-06-12T00:00:00.000Z”,
“等级”:3804
}, {
“date”:“2011-06-19T00:00:00.000Z”,
“等级”:8243
}, {
“date”:“2011-06-26T00:00:00.000Z”,
“等级”:9688
}, {
“date”:“2011-07-03T00:00:00.000Z”,
“等级”:11592
}, {
“date”:“2011-07-10T00:00:00.000Z”,
“等级”:11508
}, {
“date”:“2011-07-17T00:00:00.000Z”,
“等级”:10405
}, {
“date”:“2011-07-24T00:00:00.000Z”,
“等级”:10080
}, {
“date”:“2011-07-31T00:00:00.000Z”,
“等级”:10392
}在
我想用Python爬虫从网站检索这些数据,我需要将数据存储在MYSql数据库中。在
我该怎么做呢?
我需要根据数据库中的日期值存储52周。
另外,这个网站目前已经安装了一个验证码。在
我该如何绕过验证码,我应该制作52列数据来存储这个?在