Question 1: Use yfinance to Extract Tesla Stock Data
In [73]:
# Step 1: Install required packages (run this first)
!pip install yfinance
!pip install pandas
!pip install requests
!pip install bs4
!pip install plotly
!pip install html5lib
Requirement already satisfied: yfinance in /usr/local/lib/python3.12/dist-packages (0.2.66) Requirement already satisfied: pandas>=1.3.0 in /usr/local/lib/python3.12/dist-packages (from yfinance) (2.2.2) Requirement already satisfied: numpy>=1.16.5 in /usr/local/lib/python3.12/dist-packages (from yfinance) (2.0.2) Requirement already satisfied: requests>=2.31 in /usr/local/lib/python3.12/dist-packages (from yfinance) (2.32.4) Requirement already satisfied: multitasking>=0.0.7 in /usr/local/lib/python3.12/dist-packages (from yfinance) (0.0.12) Requirement already satisfied: platformdirs>=2.0.0 in /usr/local/lib/python3.12/dist-packages (from yfinance) (4.5.0) Requirement already satisfied: pytz>=2022.5 in /usr/local/lib/python3.12/dist-packages (from yfinance) (2025.2) Requirement already satisfied: frozendict>=2.3.4 in /usr/local/lib/python3.12/dist-packages (from yfinance) (2.4.6) Requirement already satisfied: peewee>=3.16.2 in /usr/local/lib/python3.12/dist-packages (from yfinance) (3.18.2) Requirement already satisfied: beautifulsoup4>=4.11.1 in /usr/local/lib/python3.12/dist-packages (from yfinance) (4.13.5) Requirement already satisfied: curl_cffi>=0.7 in /usr/local/lib/python3.12/dist-packages (from yfinance) (0.13.0) Requirement already satisfied: protobuf>=3.19.0 in /usr/local/lib/python3.12/dist-packages (from yfinance) (5.29.5) Requirement already satisfied: websockets>=13.0 in /usr/local/lib/python3.12/dist-packages (from yfinance) (15.0.1) Requirement already satisfied: soupsieve>1.2 in /usr/local/lib/python3.12/dist-packages (from beautifulsoup4>=4.11.1->yfinance) (2.8) Requirement already satisfied: typing-extensions>=4.0.0 in /usr/local/lib/python3.12/dist-packages (from beautifulsoup4>=4.11.1->yfinance) (4.15.0) Requirement already satisfied: cffi>=1.12.0 in /usr/local/lib/python3.12/dist-packages (from curl_cffi>=0.7->yfinance) (2.0.0) Requirement already satisfied: certifi>=2024.2.2 in /usr/local/lib/python3.12/dist-packages (from curl_cffi>=0.7->yfinance) (2025.10.5) Requirement already satisfied: python-dateutil>=2.8.2 in /usr/local/lib/python3.12/dist-packages (from pandas>=1.3.0->yfinance) (2.9.0.post0) Requirement already satisfied: tzdata>=2022.7 in /usr/local/lib/python3.12/dist-packages (from pandas>=1.3.0->yfinance) (2025.2) Requirement already satisfied: charset_normalizer<4,>=2 in /usr/local/lib/python3.12/dist-packages (from requests>=2.31->yfinance) (3.4.4) Requirement already satisfied: idna<4,>=2.5 in /usr/local/lib/python3.12/dist-packages (from requests>=2.31->yfinance) (3.11) Requirement already satisfied: urllib3<3,>=1.21.1 in /usr/local/lib/python3.12/dist-packages (from requests>=2.31->yfinance) (2.5.0) Requirement already satisfied: pycparser in /usr/local/lib/python3.12/dist-packages (from cffi>=1.12.0->curl_cffi>=0.7->yfinance) (2.23) Requirement already satisfied: six>=1.5 in /usr/local/lib/python3.12/dist-packages (from python-dateutil>=2.8.2->pandas>=1.3.0->yfinance) (1.17.0) Requirement already satisfied: pandas in /usr/local/lib/python3.12/dist-packages (2.2.2) Requirement already satisfied: numpy>=1.26.0 in /usr/local/lib/python3.12/dist-packages (from pandas) (2.0.2) Requirement already satisfied: python-dateutil>=2.8.2 in /usr/local/lib/python3.12/dist-packages (from pandas) (2.9.0.post0) Requirement already satisfied: pytz>=2020.1 in /usr/local/lib/python3.12/dist-packages (from pandas) (2025.2) Requirement already satisfied: tzdata>=2022.7 in /usr/local/lib/python3.12/dist-packages (from pandas) (2025.2) Requirement already satisfied: six>=1.5 in /usr/local/lib/python3.12/dist-packages (from python-dateutil>=2.8.2->pandas) (1.17.0) Requirement already satisfied: requests in /usr/local/lib/python3.12/dist-packages (2.32.4) Requirement already satisfied: charset_normalizer<4,>=2 in /usr/local/lib/python3.12/dist-packages (from requests) (3.4.4) Requirement already satisfied: idna<4,>=2.5 in /usr/local/lib/python3.12/dist-packages (from requests) (3.11) Requirement already satisfied: urllib3<3,>=1.21.1 in /usr/local/lib/python3.12/dist-packages (from requests) (2.5.0) Requirement already satisfied: certifi>=2017.4.17 in /usr/local/lib/python3.12/dist-packages (from requests) (2025.10.5) Requirement already satisfied: bs4 in /usr/local/lib/python3.12/dist-packages (0.0.2) Requirement already satisfied: beautifulsoup4 in /usr/local/lib/python3.12/dist-packages (from bs4) (4.13.5) Requirement already satisfied: soupsieve>1.2 in /usr/local/lib/python3.12/dist-packages (from beautifulsoup4->bs4) (2.8) Requirement already satisfied: typing-extensions>=4.0.0 in /usr/local/lib/python3.12/dist-packages (from beautifulsoup4->bs4) (4.15.0) Requirement already satisfied: plotly in /usr/local/lib/python3.12/dist-packages (5.24.1) Requirement already satisfied: tenacity>=6.2.0 in /usr/local/lib/python3.12/dist-packages (from plotly) (8.5.0) Requirement already satisfied: packaging in /usr/local/lib/python3.12/dist-packages (from plotly) (25.0) Requirement already satisfied: html5lib in /usr/local/lib/python3.12/dist-packages (1.1) Requirement already satisfied: six>=1.9 in /usr/local/lib/python3.12/dist-packages (from html5lib) (1.17.0) Requirement already satisfied: webencodings in /usr/local/lib/python3.12/dist-packages (from html5lib) (0.5.1)
In [74]:
# Step 2: Import necessary libraries
import requests
import yfinance as yf
import pandas as pd
from bs4 import BeautifulSoup
import plotly.graph_objects as go
from plotly.subplots import make_subplots
import warnings
warnings.simplefilter("ignore")
# Question 1: Extract Tesla Stock Data Using yfinance
tesla = yf.Ticker('TSLA')
tesla_data = tesla.history(period='max')
tesla_data.reset_index(inplace=True)
print("Tesla Stock Data - First 5 rows:")
print(tesla_data.head())
Tesla Stock Data - First 5 rows:
Date Open High Low Close \
0 2010-06-29 00:00:00-04:00 1.266667 1.666667 1.169333 1.592667
1 2010-06-30 00:00:00-04:00 1.719333 2.028000 1.553333 1.588667
2 2010-07-01 00:00:00-04:00 1.666667 1.728000 1.351333 1.464000
3 2010-07-02 00:00:00-04:00 1.533333 1.540000 1.247333 1.280000
4 2010-07-06 00:00:00-04:00 1.333333 1.333333 1.055333 1.074000
Volume Dividends Stock Splits
0 281494500 0.0 0.0
1 257806500 0.0 0.0
2 123282000 0.0 0.0
3 77097000 0.0 0.0
4 103003500 0.0 0.0
Question 2: Use Webscraping to Extract Tesla Revenue Data
In [75]:
# Question 2: Extract Tesla Revenue Data Using Webscraping
tesla_url = "https://www.macrotrends.net/stocks/charts/TSLA/tesla/revenue"
tesla_html_data = requests.get(tesla_url).text
tesla_soup = BeautifulSoup(tesla_html_data, "html5lib")
tesla_revenue = pd.DataFrame(columns=['Date', 'Revenue'])
for table in tesla_soup.find_all('table'):
if table.find('th') and 'Tesla Quarterly Revenue' in table.find('th').getText():
for row in table.find("tbody").find_all("tr"):
col = row.find_all("td")
if len(col) != 2:
continue
date = col[0].text
revenue = col[1].text.replace("$", "").replace(",", "")
tesla_revenue = pd.concat([tesla_revenue, pd.DataFrame({"Date": [date], "Revenue": [revenue]})], ignore_index=True)
# Clean Tesla revenue data
tesla_revenue.dropna(inplace=True)
tesla_revenue = tesla_revenue[tesla_revenue['Revenue'] != ""]
print("\nTesla Revenue Data - Last 5 rows:")
print(tesla_revenue.tail(5))
Tesla Revenue Data - Last 5 rows: Empty DataFrame Columns: [Date, Revenue] Index: []
Question 3: Use yfinance to Extract GameStop Stock Data
In [76]:
# Question 3: Extract GameStop Stock Data Using yfinance
gme = yf.Ticker('GME')
gme_data = gme.history(period='max')
gme_data.reset_index(inplace=True)
print("\nGameStop Stock Data - First 5 rows:")
print(gme_data.head())
GameStop Stock Data - First 5 rows:
Date Open High Low Close Volume \
0 2002-02-13 00:00:00-05:00 1.620128 1.693350 1.603296 1.691666 76216000
1 2002-02-14 00:00:00-05:00 1.712707 1.716074 1.670626 1.683251 11021600
2 2002-02-15 00:00:00-05:00 1.683250 1.687458 1.658001 1.674834 8389600
3 2002-02-19 00:00:00-05:00 1.666417 1.666417 1.578047 1.607504 7410400
4 2002-02-20 00:00:00-05:00 1.615921 1.662210 1.603296 1.662210 6892800
Dividends Stock Splits
0 0.0 0.0
1 0.0 0.0
2 0.0 0.0
3 0.0 0.0
4 0.0 0.0
Question 4: Use Webscraping to Extract GME Revenue Data
In [77]:
# Question 4: Extract GameStop Revenue Data Using Webscraping
gme_url = "https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-PY0220EN-SkillsNetwork/labs/project/stock.html"
gme_html_data = requests.get(gme_url).text
gme_soup = BeautifulSoup(gme_html_data, "html5lib")
gme_revenue = pd.DataFrame(columns=['Date', 'Revenue'])
for table in gme_soup.find_all('table'):
if table.find('th') and 'GameStop Quarterly Revenue' in table.find('th').getText():
for row in table.find("tbody").find_all("tr"):
col = row.find_all("td")
if len(col) != 2:
continue
date = col[0].text
revenue = col[1].text.replace("$", "").replace(",", "")
gme_revenue = pd.concat([gme_revenue, pd.DataFrame({"Date": [date], "Revenue": [revenue]})], ignore_index=True)
# Clean GameStop revenue data
gme_revenue.dropna(inplace=True)
gme_revenue = gme_revenue[gme_revenue['Revenue'] != ""]
print("\nGameStop Revenue Data - Last 5 rows:")
print(gme_revenue.tail(5))
GameStop Revenue Data - Last 5 rows:
Date Revenue
57 2006-01-31 1667
58 2005-10-31 534
59 2005-07-31 416
60 2005-04-30 475
61 2005-01-31 709
In [78]:
# Question 5 & 6: Create Dashboard Function
def make_graph(stock_data, revenue_data, stock):
"""Create a dashboard with historical share price and revenue data"""
fig = make_subplots(rows=2, cols=1, shared_xaxes=True,
subplot_titles=("Historical Share Price", "Historical Revenue"),
vertical_spacing=0.3)
# Add stock price trace
fig.add_trace(go.Scatter(x=pd.to_datetime(stock_data.Date, infer_datetime_format=True),
y=stock_data.Close.astype("float"),
name="Share Price"),
row=1, col=1)
# Add revenue trace
fig.add_trace(go.Scatter(x=pd.to_datetime(revenue_data.Date, infer_datetime_format=True),
y=revenue_data.Revenue.astype("float"),
name="Revenue"),
row=2, col=1)
# Update layout
fig.update_xaxes(title_text="Date", row=1, col=1)
fig.update_xaxes(title_text="Date", row=2, col=1)
fig.update_yaxes(title_text="Price ($US)", row=1, col=1)
fig.update_yaxes(title_text="Revenue ($US Millions)", row=2, col=1)
fig.update_layout(showlegend=False,
height=900,
title=stock,
xaxis_rangeslider_visible=True)
fig.show()
Question 5: Plot Tesla Stock Graph
In [79]:
# Question 5: Tesla Stock and Revenue Dashboard
print("\nGenerating Tesla Dashboard...")
make_graph(tesla_data, tesla_revenue, 'Tesla Stock Data')
Generating Tesla Dashboard...
Question 6: Plot GameStop Stock Graph
In [80]:
# Question 6: GameStop Stock and Revenue Dashboard
print("\nGenerating GameStop Dashboard...")
make_graph(gme_data, gme_revenue, 'GameStop Stock Data')
print("\n✓ Assignment Complete! Take screenshots of your outputs for submission.")
Generating GameStop Dashboard...
✓ Assignment Complete! Take screenshots of your outputs for submission.
In [80]: