Yahoo's Stock Price Before vs. During Marissa Mayer's Tenure

A quick notebook show the difference Marissa Mayer's tenure made to Yahoo's stock price.



In [1]:

    
%matplotlib inline
import pandas as pd
import matplotlib.pyplot as plt



In [2]:

    
plt.style.use('seaborn-notebook')



In [3]:

    
df_during = pd.read_csv('yhoo-2012-07-16-to-2017-06-04.csv',
                        parse_dates=['Date'])
df_during.sort_values('Date')
df_during.head()



In [4]:

    
df_before = pd.read_csv('yhoo-2007-08-28-to-2012-07-16.csv',
                        parse_dates=['Date'])
df_before.sort_values('Date')
df_before.head()



In [5]:

    
df_during.plot(x='Date', y='Close', ylim=[10, 60],
               title="During Mayer's Tenure")









    Out[5]:





<matplotlib.axes._subplots.AxesSubplot at 0x7fda31f6d5f8>



In [6]:

    
df_before.plot(x='Date', y='Close', ylim=[10, 60],
               title="Before Mayer's Tenure")









    Out[6]:





<matplotlib.axes._subplots.AxesSubplot at 0x7fda310b7e48>



In [ ]:

	Date	Open	High	Low	Close	Volume
0	2017-06-02	50.53	50.75	50.31	50.60	9857195
1	2017-06-01	50.49	50.70	50.07	50.65	7776690
2	2017-05-31	50.60	50.65	49.96	50.32	8750770
3	2017-05-30	50.67	50.94	50.50	50.56	8400168
4	2017-05-26	50.50	50.74	50.32	50.67	6049533

	Date	Open	High	Low	Close	Volume
0	2012-07-16	15.69	15.80	15.60	15.64	14982860
1	2012-07-13	15.70	15.84	15.69	15.74	11812343
2	2012-07-12	15.63	15.81	15.54	15.69	18393087
3	2012-07-11	15.82	15.94	15.68	15.80	16482409
4	2012-07-10	15.83	15.98	15.71	15.82	15935347