Kernel: Python [default]

Apple Stock

We are going to use Apple's stock price.

In [4]:

import pandas as pd
import numpy as np

# visualization
import matplotlib.pyplot as plt

%matplotlib inline

In [32]:

Out[32]:

In [33]:

Out[33]:

Date          object
Open         float64
High         float64
Low          float64
Close        float64
Volume         int64
Adj Close    float64
dtype: object

In [34]:

Out[34]:

 2014-07-08
 2014-07-07
 2014-07-03
 2014-07-02
 2014-07-01
Name: Date, dtype: datetime64[ns]

In [35]:

Out[35]:

In [36]:

# NO! All are unique

Out[36]:

True

In [39]:

Out[39]:

In [48]:

Out[48]:

In [65]:

Out[65]:

12261

In [66]:

Out[66]:

404

In [81]:

Out[81]:

In [ ]:

Apple Stock

Apple Stock

Introduction:

Step 1. Import the necessary libraries

Step 2. Import the dataset from this address

Step 3. Assign it to a variable apple

Step 4. Check out the type of the columns

Step 5. Transform the Date column as a datetime type

Step 6. Set the date as the index

Step 7. Is there any duplicate dates?

Step 8. Ops...it seems the index is from the most recent date. Make the first entry the oldest date.

Step 9. Get the last business day of each month

Step 10. What is the difference in days between the first day and the oldest

Step 11. How many months in the data we have?

Step 12. Plot the 'Adj Close' value. Set the size of the figure to 13.5 x 9 inches

BONUS: Create your own question and answer it.