你好,我想從這個網站上提取表格:
我嘗試使用bs4以及pd.read_html。盡管在 "湯 "中看到了表標簽,但我無法讓它找到它們。我的猜測是,資料是在加載之后才進入的。我希望能在不使用Selenium的情況下做到這一點。我注意到它還有一個類似于dict的物件,叫做 "var model",有沒有辦法通過請求訪問這個物件?我已經從源代碼中復制了它,并張貼在下面。
歡呼吧var model = {"CurrentInterbankRate": 74. 72140399,"CurrentInverseInterbankRate":0.01338305, "Average":15. 14101240,"HistoricalPoints":[{"PointInTime": 978307199999,"InterbankRate"/span>:0. 99973015,"InverseInterbankRate":1. 00027002},{"PointInTime":1009843199999, "InterbankRate":1. 00000857,"InverseInterbankRate"/span>:0. 99999155},{"PointInTime":1041379199999, "InterbankRate":2. 63289734,"InverseInterbankRate"/span>:0. 43403613},{"PointInTime":1072915199999, "InterbankRate":2. 94796721,"InverseInterbankRate"/span>:0. 34009351},{"PointInTime":1104537599999, "InterbankRate":2. 94124008,"InverseInterbankRate"/span>:0. 34012553},{"PointInTime":1136073599999, "InterbankRate":2. 91477610,"InverseInterbankRate"/span>:0. 54410527},{"PointInTime":1167609599999, "InterbankRate":3. 07339545,"InverseInterbankRate"/span>:0. 32538532},{"PointInTime":1199145599999, "InterbankRate":3. 11525349,"InverseInterbankRate"/span>:0. 32103202},{"PointInTime":12307679999, "InterbankRate":3. 16700443,"InverseInterbankRate"/span>:0. 31621115},{"PointInTime":12623039999, "InterbankRate":3. 72898339,"InverseInterbankRate"/span>:0. 26848343},{"PointInTime":12938399999, "InterbankRate":3. 91137986,"InverseInterbankRate"/span>:0. 25571003},{"PointInTime":13253759999, "InterbankRate":4. 12870331,"InverseInterbankRate"/span>:0. 24233673},{"PointInTime":1356998399999, "InterbankRate":4. 54916212,"InverseInterbankRate"/span>:0. 22016157},{"PointInTime":1388534399999, "InterbankRate":5. 47453082,"InverseInterbankRate"/span>:0. 18368720},{"PointInTime":1420070399999, "InterbankRate":8. 11288453,"InverseInterbankRate"/span>:0. 12367665},{"PointInTime":1451606399999, "InterbankRate":9. 24612693,"InverseInterbankRate"/span>:0. 10878823},{"PointInTime":1483228799999, "InterbankRate":14. 75736653,"InverseInterbankRate"/span>:0. 06790187},{"PointInTime":1514764799999, "InterbankRate":16. 55924652,"InverseInterbankRate"/span>:0. 06057628},{"PointInTime":1546300799999, "InterbankRate":28. 14054973,"InverseInterbankRate"/span>:0. 03813937},{"PointInTime":1577836799999, "InterbankRate":48. 19220455,"InverseInterbankRate"/span>:0. 02137447},{"PointInTime":1609459199999, "InterbankRate":70. 63534275,"InverseInterbankRate"/span>:0. 01430140},{"PointInTime":1631282400000, "InterbankRate":92. 87351896,"InverseInterbankRate":0.01078530}},
txt = $$('TEXTAREA')[0] 。
humanize = true && location.hash.indexOf('dehumanize') == -1,
uj5u.com熱心網友回復:
你不需要搜刮表格,因為資料已經有了JSON格式(除此之外)。只需將&format=json附加到URL的末尾,如:
然后你得到以下結果:
{}。
"CurrentInterbankRate": 74.72140399,
"CurrentInverseInterbankRate": 0.01338305,
"平均": 15.14101240,
"HistoricalPoints": [/span>{
"PointInTime": 978307199999,
"InterbankRate": 0.99973015,
"InverseInterbankRate": 1.00027002
}, {
"PointInTime": 1009843199999,
"InterbankRate": 1.00000857,
"InverseInterbankRate": 0.99999155
}, {
"PointInTime": 1041379199999,
"InterbankRate": 2.63289734,
"InverseInterbankRate": 0.43403613
}, {
"PointInTime": 1072915199999,
"InterbankRate": 2.94796721,
"InverseInterbankRate": 0.34009351
}, {
"PointInTime": 1104537599999,
"InterbankRate": 2.94124008,
"InverseInterbankRate": 0.34012553
}, {
"PointInTime": 1136073599999,
"InterbankRate": 2.91477610,
"InverseInterbankRate": 0.54410527
}, {
"PointInTime": 1167609599999,
"InterbankRate": 3.07339545,
"InverseInterbankRate": 0.32538532
}, {
"PointInTime": 1199145599999,
"InterbankRate": 3.11525349,
"InverseInterbankRate": 0.32103202
}, {
"PointInTime": 12307679999,
"InterbankRate": 3.16700443,
"InverseInterbankRate": 0.31621115
}, {
"PointInTime": 12623039999,
"InterbankRate": 3.72898339,
"InverseInterbankRate": 0.26848343
}, {
"PointInTime": 1293839999999,
"InterbankRate": 3.91137986,
"InverseInterbankRate": 0.25571003
}, {
"PointInTime": 13253759999,
"InterbankRate": 4.12870331,
"InverseInterbankRate": 0.24233673
}, {
"PointInTime": 1356998399999,
"InterbankRate": 4.54916212,
"InverseInterbankRate": 0.22016157
}, {
"PointInTime": 1388534399999,
"InterbankRate": 5.47453082,
"InverseInterbankRate": 0.18368720
}, {
"PointInTime": 1420070399999,
"InterbankRate": 8.11288453,
"InverseInterbankRate": 0.12367665
}, {
"PointInTime": 1451606399999,
"InterbankRate": 9.24612693,
"InverseInterbankRate": 0.10878823
}, {
"PointInTime": 1483228799999,
"InterbankRate": 14.75736653,
"InverseInterbankRate": 0.06790187
}, {
"PointInTime": 1514764799999,
"InterbankRate": 16.55924652,
"InverseInterbankRate": 0.06057628
}, {
"PointInTime": 1546300799999,
"InterbankRate": 28.14054973,
"InverseInterbankRate": 0.03813937
}, {
"PointInTime": 1577836799999,
"InterbankRate": 48.19220455,
"InverseInterbankRate": 0.02137447
}, {
"PointInTime": 1609459199999,
"InterbankRate": 70.63534275,
"InverseInterbankRate": 0.01430140
}, {
"PointInTime": 1631282400000,
"InterbankRate": 92.87351896,
"InverseInterbankRate": 0.01078530
}]
}
(有一點格式化)。
轉載請註明出處,本文鏈接:https://www.uj5u.com/net/320268.html
標籤:
