#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
Created on Thu Aug  1 16:30:49 2019

@author: smahanam
"""
import pandas as pd
import matplotlib.pyplot as plt

nas  = [250., 252., 300., 240., 270.]
djia = [420., 330., 370., 390., 400.]
djt  = [298., 312., 350., 340., 335.]
sap  = [260., 275., 300., 280., 295.]
nyse = [420., 415., 418., 400., 405.]
hsi  = [410., 390., 350., 376., 390.]
sgx  = [376., 360., 370., 380., 390.]

index_name = ['NASDAQ', 'DOWIA', 'DOWT', 'S&P500', 'NYSE', 'HANG SENG', 'SGX']

index_dict = {}
dates = pd.date_range('20190727', periods=5)

for i in range(7)`:
    if i == 0: var = nas
    if i == 1: var = djia
    if i == 2: var = djt
    if i == 3: var = sap
    if i == 4: var = nyse
    if i == 5: var = hsi
    if i == 6: var = sgx
    index_dict[index_name[i]] = var
    
print('dictrionary')
print(index_dict)    
df1 = pd.DataFrame(index_dict, index=dates)

print ('df1')
print(df1)
print('head')
print(df1.head(3))
print('tail')
print(df1.tail(2))

print('index')
print(df1.index)

print('Transpose')
print(df1.T)

print('Sorting')
print(df1.sort_values(by='NASDAQ'))

print('DOWIA')
print(df1['DOWIA'])

print('Particular days')
print(df1['2019-07-28':'2019-07-28'])

print('Particular dtes for few indices')
print(df1.loc['2019-07-28':'2019-07-29',['DOWT','NYSE']])

print('mean')
print(df1.mean())
print(df1.mean(1))

plt.figure()
df1.plot()
plt.legend(loc='best')
plt.figure()
df1.boxplot(column=['NASDAQ', 'DOWIA', 'DOWT', 'S&P500', 'NYSE' ])