Extract standard deviation from open and high. Easily copy and paste code. Easily explained.

#Extract standard deviation from stock yearly

#Go to link to extract data
#https://finance.yahoo.com/quote/FB/history?p=FB&.tsrc=fin-tre-srch

#After that apply this formula to all H column  =(C1/B1 - 1) * 100 and
#this to I column =(1 - D1/B1 ) * 100
#reason is to determine percentage variation. Next project automate this with python
#Your data should look like image below.

#facebook_2019
import pandas as pd     #import libraries
import matplotlib as plt


#code below is from other year           
#Before opening the excel, erase the headlines(e.g Date, open, .....) as it could
#cause problems to extract data. I will come back to reduce this manual job. hopefully with code.

# Procceed to the path of your csv (comma separated values or excel

path = "FB_2019.csv"                   # This code redirects to path of file,


df = pd.read_csv(path, header=None)
headers= ['date','open','High','low','close','Adj Close','Volume', 'range_high', 'range_low']



df.columns = headers


data2019 = df[['date','open','High','low','close','Adj Close','Volume','range_high', 'range_low']].describe()
#code above replace'date' or 'open' by 'low' or any other parameter in headers

print('data2019')
print(data2019)

year_of_selection = df[['open']]

import matplotlib.pyplot as plt
plt.plot(year_of_selection)
plt.ylabel('prices 2019')
plt.show()

#You could choose any column you want by modifying data 2019