import pandas as pd
ru1000=pd.read_html('https://en.wikipedia.org/wiki/Russell_1000_Index')[2]
ru1000.head()
ru1000= ru1000[['Company', 'Ticker']]
print(ru1000.shape)
ru1000.head(30)
(1018, 2)
| Company | Ticker | |
|---|---|---|
| 0 | 10x Genomics | TXG |
| 1 | 3M | MMM |
| 2 | Abbott | ABT |
| 3 | AbbVie | ABBV |
| 4 | Abiomed | ABMD |
! jupyter nbconvert Russell1000.ipynb --to html