我想從“https://www.macrotrends.net/stocks/charts/TSLA/tesla/revenue”獲取“特斯拉季度收入”表資料。有2個表具有相同的表類（表類=“historical_data_table表” )。所以我試圖獲取所需表的表索引，但它給了我一個錯誤。感謝您幫助解決這個問題。謝謝
url = "https://www.macrotrends.net/stocks/charts/TSLA/tesla/revenue"
data = requests.get(url).text
soup = BeautifulSoup(data,"html5lib")
tables = soup.find('table')
# find table with "Tesla Quarterly Revenue"
for index,table in enumerate(tables):
if ("Tesla Quarterly Revenue" in str(table)):
table_index = index
print(tables[table_index].prettify())
uj5u.com熱心網友回復：
試試這些：
import pandas as pd
df=pd.read_html("https://www.macrotrends.net/stocks/charts/TSLA/tesla/revenue")
print(df)
輸出：
[ Tesla Annual Revenue(Millions of US $) Tesla Annual Revenue(Millions of US $).1
0 2020 $31,536
1 2019 $24,578
2 2018 $21,461
3 2017 $11,759
4 2016 $7,000
5 2015 $4,046
6 2014 $3,198
7 2013 $2,013
8 2012 $413
9 2011 $204
10 2010 $117
11 2009 $112
12 2008 $15, Tesla Quarterly Revenue(Millions of US $) Tesla Quarterly Revenue(Millions of US $).1
0 2021-09-30 $13,757
1 2021-06-30 $11,958
2 2021-03-31 $10,389
3 2020-12-31 $10,744
4 2020-09-30 $8,771
5 2020-06-30 $6,036
6 2020-03-31 $5,985
7 2019-12-31 $7,384
8 2019-09-30 $6,303
9 2019-06-30 $6,350
10 2019-03-31 $4,541
11 2018-12-31 $7,226
12 2018-09-30 $6,824
13 2018-06-30 $4,002
14 2018-03-31 $3,409
15 2017-12-31 $3,288
16 2017-09-30 $2,985
17 2017-06-30 $2,790
18 2017-03-31 $2,696
19 2016-12-31 $2,285
20 2016-09-30 $2,298
21 2016-06-30 $1,270
22 2016-03-31 $1,147
23 2015-12-31 $1,214
24 2015-09-30 $937
25 2015-06-30 $955
26 2015-03-31 $940
27 2014-12-31 $957
28 2014-09-30 $852
29 2014-06-30 $769
30 2014-03-31 $621
31 2013-12-31 $615
32 2013-09-30 $431
33 2013-06-30 $405
34 2013-03-31 $562
35 2012-12-31 $306
36 2012-09-30 $50
37 2012-06-30 $27
38 2012-03-31 $30
39 2011-12-31 $39
40 2011-09-30 $58
41 2011-06-30 $58
42 2011-03-31 $49
43 2010-12-31 $36
44 2010-09-30 $31
45 2010-06-30 $28
46 2010-03-31 $21
47 2009-12-31 NaN
48 2009-09-30 $46
49 2009-06-30 $27
50 2008-12-31 NaN, Sector ... Revenue
0 Auto/Tires/Trucks ... $31.536B
1 Tesla Inc. designs, develops, manufactures, an... ... Tesla Inc. designs, develops, manufactures, an...
[2 rows x 4 columns], Stock Name Country Market Cap PE Ratio
0 General Motors (GM) United States $90.901B 8.16
1 Ford Motor (F) United States $79.086B 10.58
2 Polaris (PII) United States $7.596B 12.13
3 IAA (IAA) United States $7.311B 23.89
4 Harley-Davidson (HOG) United States $5.960B 10.11, Link Preview HTML Code (Click to Copy)
0 Tesla Revenue 2009-2021 | TSLA NaN
1 Macrotrends NaN
2 Source NaN, Link Preview HTML Code (Click to Copy)
0 Tesla Revenue 2009-2021 | TSLA NaN
1 Macrotrends NaN
2 Source NaN]
uj5u.com熱心網友回復：
哦，我發現了錯誤..我應該使用tables = soup.find_all('table')而不是的愚蠢錯誤tables = soup.find('table')
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/361656.html