import pandas as pd
import matplotlib.pyplot as plt

ADBE = pd.read_csv(r"C:\Users\Badaboom\Desktop\ADBE.csv", delimiter = ",")
ADBE['Date'] = ADBE['Date'].astype('datetime64[ns]')

AA = pd.read_csv(r"C:\Users\Badaboom\Desktop\AA.csv", delimiter = ",")
AA['Date'] = AA['Date'].astype('datetime64[ns]')

AXP = pd.read_csv(r"C:\Users\Badaboom\Desktop\AXP.csv", delimiter = ",")
AXP['Date'] = AXP['Date'].astype('datetime64[ns]')

AAPL = pd.read_csv(r"C:\Users\Badaboom\Desktop\AAPL.csv", delimiter = ",")
AAPL['Date'] = AAPL['Date'].astype('datetime64[ns]')

BA = pd.read_csv(r"C:\Users\Badaboom\Desktop\BA.csv", delimiter = ",")
BA['Date'] = BA['Date'].astype('datetime64[ns]')

CAT = pd.read_csv(r"C:\Users\Badaboom\Desktop\CAT.csv", delimiter = ",")
CAT['Date'] = CAT['Date'].astype('datetime64[ns]')

CVX = pd.read_csv(r"C:\Users\Badaboom\Desktop\CVX.csv", delimiter = ",")
CVX['Date'] = CVX['Date'].astype('datetime64[ns]')

CSCO = pd.read_csv(r"C:\Users\Badaboom\Desktop\CSCO.csv", delimiter = ",")
CSCO['Date'] = CSCO['Date'].astype('datetime64[ns]')

#zadanie2
ADBE['Volume'] = ADBE['Volume'] / 1000000000 #в миллиардах
AA['Volume'] = AA['Volume'] / 1000000000
AXP['Volume'] = AXP['Volume'] / 1000000000
AAPL['Volume'] = AAPL['Volume'] / 1000000000
BA['Volume'] = BA['Volume'] / 1000000000
CAT['Volume'] = CAT['Volume'] / 1000000000
CVX['Volume'] = CVX['Volume'] / 1000000000
CSCO['Volume'] = CSCO['Volume'] / 1000000000

zadanie2 = pd.DataFrame(index = range(2003,2018), columns = ['Adobe Systems','Alcoa','American Express','Apple','Boeing','Caterpillar','Chevron','Cisco Systems'])
zadanie2['Adobe Systems']= ADBE['Volume'].groupby(ADBE.Date.dt.year).agg('sum').round(1)
zadanie2['Alcoa']= AA['Volume'].groupby(AA.Date.dt.year).agg('sum').round(1)
zadanie2['American Express']= AXP['Volume'].groupby(AXP.Date.dt.year).agg('sum').round(1)
zadanie2['Apple']= AAPL['Volume'].groupby(AAPL.Date.dt.year).agg('sum').round(1)
zadanie2['Boeing']= BA['Volume'].groupby(BA.Date.dt.year).agg('sum').round(1)
zadanie2['Caterpillar']= CAT['Volume'].groupby(CAT.Date.dt.year).agg('sum').round(1)
zadanie2['Chevron']= CVX['Volume'].groupby(CVX.Date.dt.year).agg('sum').round(1)
zadanie2['Cisco Systems']= CSCO['Volume'].groupby(CSCO.Date.dt.year).agg('sum').round(1)

#zadanie3
plt.plot(ADBE['Date'], ADBE['Close'])
plt.title('График цены закрытия Adobe Systems')
plt.ylabel('Close')
plt.xlabel('Years')
plt.show()