Plotting data

Intermediate Python for Finance

Kennedy Behrman

Data Engineer, Author, Founder

Look at your data

Plot of stock prices

exxon.head()

Introducing the data

exxon.head()

    Date         High        Volume      Month
0   2015-05-01   90.089996   198924100   May
1   2015-06-01   85.970001   238808600   Jun
2   2015-07-01   83.529999   274029000   Jul
3   2015-08-01   79.290001   387523600   Aug
4   2015-09-01   75.470001   316644500   Sep

Matplotlib

my_dataframe.plot()

Line plot

exxon.plot(x='Date', 
           y='High' )

Line plot of stock prices

Rotate

exxon.plot(x='Date', 
           y='High', 
           rot=90 )

Line plot with rotated labels

Title

exxon.plot(x='Date', 
           y='High', 
           rot=90, 
           title='Exxon Stock Price')

Line plot with title

Index

exxon.set_index('Date', inplace=True)
exxon.plot(y='High', 
           rot=90, 
           title='Exxon Stock Price')

Line plot using index as x-axis

Plot types

line
bar
barh
hist
box
kde

density
area
pie
scatter
hexbin

Bar

exxon2018.plot(x='Month', 
               y='Volume', 
               kind='bar', 
               title='Exxon 2018')

Bar plot

Hist

exxon.plot(y='High',kind='hist')

Histogram

Let's practice!

Intermediate Python for Finance