用漂亮的汤从桌子上刮下价值观

2024-06-28 11:12:57 发布

您现在位置:Python中文网/ 问答频道 /正文

我正试图搜集一些历史天气数据,却不知道如何从表中提取值。我已经能够打印表中的行了,但是当我试图从每一行提取'td'(更具体地说是值)时,我得到了一个属性错误。到目前为止,我的情况是:

import requests
from random import choice
from bs4 import BeautifulSoup
import pandas as pd

#---------------------------------------------------------------------------------------#
url = "https://www.wunderground.com/history/airport/KORD/2017/4/1/CustomHistory.html?dayend=10&monthend=4&yearend=2017&req_city=&req_state=&req_statename=&reqdb.zip=&reqdb.magic=&reqdb.wmo="
page = requests.get(url)

soup = BeautifulSoup(page.text,"lxml")
#---------------------------------------------------------------------------------------#
table = soup.find('table', id='obsTable')

table_head = table.find('thead')
header_1 = []    
for th in table_head.find_all('th'):
    key_1 = th.get_text()
    header_1.append(key_1)
#---------------------------------------------------------------------------------------#
table_head_2 = table.find_all('tr')[1]
header_2 = []
for td in table_head_2.find_all('td'):
    key_2 = td.get_text()
    header_2.append(key_2)
#---------------------------------------------------------------------------------------#    
rows = table.find_all('tr')[2]

for row in rows.find_all('td'):
    print(row)

打印一行数据时返回:

<tr>
<td><a href="/history/airport/KORD/2017/4/1/DailyHistory.html">1</a></td>
<td>
<span class="wx-value">59</span>
</td>
<td>
<span class="wx-value">47</span>
</td>
<td>
<span class="wx-value">34</span>
</td>
<td>
<span class="wx-value">31</span>
</td>
<td>
<span class="wx-value">23</span>
</td>
<td>
<span class="wx-value">16</span>
</td>
<td>
<span class="wx-value">82</span>
</td>
<td>
<span class="wx-value">51</span>
</td>
<td>
<span class="wx-value">20</span>
</td>
<td>
<span class="wx-value">30.24</span>
</td>
<td>
<span class="wx-value">30.19</span>
</td>
<td>
<span class="wx-value">30.09</span>
</td>
<td>
<span class="wx-value">10</span>
</td>
<td>
<span class="wx-value">10</span>
</td>
<td>
<span class="wx-value">10</span>
</td>
<td>
<span class="wx-value">13</span>
</td>
<td>
<span class="wx-value">6</span>
</td>
<td>
<span class="wx-value">17</span>
</td>
<td>
<span class="wx-value">0.00</span>
</td>
<td>
     
</td>
</tr>

如果有人能帮我,我将不胜感激


Tags: keyimportvaluetableallfindreqhead
1条回答
网友
1楼 · 发布于 2024-06-28 11:12:57

如果您只是想打印这些值,可以通过调用row.text属性来完成。但是,值周围有很多空白,因此您需要strip()它们

for row in rows.find_all('td'):
    print(row.text.strip())

将返回:

1
59
47
34
31
23
16
82
51
20
30.24
30.19
30.09
10
10
10
13
6
17
0.00

相关问题 更多 >