我正试图搜集一些历史天气数据,却不知道如何从表中提取值。我已经能够打印表中的行了,但是当我试图从每一行提取'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>
如果有人能帮我,我将不胜感激
如果您只是想打印这些值,可以通过调用
row
的.text
属性来完成。但是,值周围有很多空白,因此您需要strip()
它们将返回:
相关问题 更多 >
编程相关推荐