# -*- coding: utf-8 -*-
"""
Created on Tue Nov 17 14:28:10 2020
@author: Shalaka
"""
import pandas as pd
import seaborn as sns
import matplotlib.pyplot as plt
import numpy as np
data1=pd.read_csv('Stock_File_1.csv')
data2=pd.read_csv('Stock_File_2.txt')
unique1,counts1=np.unique(data1['Date'],return_counts=True)
unique2,counts2=np.unique(data2['Date'],return_counts=True)
data_merged=pd.concat([data1,data2],axis=0,join='inner',ignore_index=True)
data_merged['Volume']=data_merged.Volume.replace("zero",0)
data_merged['Volume']=data_merged.Volume.astype(int)
data_merged.info()
data_merged.describe()
data_merged['Volume']=data_merged['Volume'].map({843600:'model_good',6800:'model_bad'})
data_merged['Volume']=data_merged['Volume'].astype('category')
print(data_merged.head())
import numpy as np
model_good=data_merged.loc[data_merged['Volume']=='model_good']
model_bad=data_merged.loc[data_merged['Volume']=='model_bad']
plt.figure(1,figsize=(14,4))
plt.subplot(121)
plt.plot(model_good["Open"],np.zeros_like(model_good['Open']),'o',label="model_good")
plt.plot(model_bad["Open"],np.zeros_like(model_bad['Open']),'o',label="model_bad")
plt.legend()
plt.xlabel('Open')
plt.title('Volume based on Open')
plt.show()
plt.subplot(122)
plt.plot(model_good["Close"],np.zeros_like(model_good['Close']),'o',label="model_good")
plt.plot(model_bad["Close"],np.zeros_like(model_bad['Close']),'o',label="model_bad")
plt.legend()
plt.xlabel('Close')
plt.title('Volume based Close')
plt.show()
import numpy as np
model_good=data_merged.loc[data_merged['Volume']=='model_good']
model_bad=data_merged.loc[data_merged['Volume']=='model_bad']
plt.figure(1,figsize=(14,4))
plt.subplot(121)
plt.plot(model_good["High"],np.zeros_like(model_good['High']),'o',label="model_good")
plt.plot(model_bad["High"],np.zeros_like(model_bad['High']),'o',label="model_bad")
plt.legend()
plt.xlabel('High')
plt.title('Volume based on High')
plt.show()
plt.subplot(122)
plt.plot(model_good["Low"],np.zeros_like(model_good['Low']),'o',label="model_good")
plt.plot(model_bad["Low"],np.zeros_like(model_bad['Low']),'o',label="model_bad")
plt.legend()
plt.xlabel('Low')
plt.title('Volume based Low')
plt.show()
sns.FacetGrid (data_merged,hue="Volume", size =5).map(sns.distplot,"Close").add_legend()
plt.title('histogram for Volume based on Close')
plt.show()
sns.FacetGrid (data_merged,hue="Volume", size =5).map(sns.distplot,"High").add_legend()
plt.title('histogram for Volume based on High')
plt.show()
df = data_merged
stats_df = df \
.groupby('Open') \
['Open'] \
.agg('count') \
.pipe(pd.DataFrame) \
.rename(columns = {'Open': 'Close'})
# PDF
stats_df['pdf'] = stats_df['Close'] / sum(stats_df['Close'])
# CDF
stats_df['cdf'] = stats_df['pdf'].cumsum()
stats_df = stats_df.reset_index()
stats_df
s = pd.Series(np.random.normal(loc = 10, scale = 0.1, size = 300), name = 'Open')
stats_df.plot(x = 'Open', y = ['pdf', 'cdf'], grid = True)
s = pd.Series(np.random.normal(loc = 10, scale = 0.1, size = 300), name = 'Close')
stats_df.plot(x = 'Close', y = ['pdf', 'cdf'], grid = True)
sns.boxplot(x='Volume',y='Open',data=data_merged)
plt.title('box_plot based on Open')
plt.show()
sns.boxplot(x='Volume',y='High',data=data_merged)
plt.title('box_plot based on High')
plt.show()
sns.violinplot(x='Volume',y='Open',data=data_merged,size=8)
plt.title('box_plot based on Open')
sns.violinplot(x='Volume',y='Close',data=data_merged,size=8)
plt.title('box_plot based on Close')
sns.set_style('whitegrid')
sns.FacetGrid(data_merged,hue="Volume",size=5).map(plt.scatter,"Open","Close").add_legend()
plt.title('2D scatter plot for Open vs Close ')
plt.show()
plt.close()
sns.set_style('whitegrid')
sns.pairplot(data_merged,hue="Volume",vars=['Open','Close'],size=4)
plt.show()
sns.jointplot(x="Open",y="Close",data=data_merged,kind="kde")
plt.title('contour plot Open vs Close')
plt.show()