Working with raw datasets

Financial Forecasting in Python

Victoria Clark

CGMA Financial Analyst

Obtaining a dataset for forecasting

Tesla Motors Inc.
Historic information publicly available
Income statement as .csv

TeslaLogo

First look

TeslaIS

Filtering the data in Python

# Choose some interesting metrics
interesting_metrics = ['Gross profit', 'Net income']

# Using the .isin() method, filter for rows containing these metrics
filter = income_statement.metric.isin(interesting_metrics)
filtered_income_statement = income_statement[filter]

print(filtered_income_statement)

TeslaISFiltered

Let's practice!

Financial Forecasting in Python