from datetime import datetime
import numpy as np
import pandas as pd
from pandas import ExcelWriter
from tabulate import tabulate
from openpyxl import load_workbook

# Setting PD option to view
pd.set_option('display.max_rows', 30000)
pd.set_option('display.max_columns', 500)
pd.set_option('display.width', 1000)

start = datetime.now()

# path = r"C:\Users\harsh\Google Drive\Oddsportal\Files\Oddsportal Data\Historical Worksheet\data.xlsx"
#
# book = load_workbook(path)
# writer = pd.ExcelWriter(path, engine='openpyxl')
# writer.book = book

df = pd.read_excel(r"C:\Users\harsh\Google Drive\Oddsportal\Files\Oddsportal "
                   r"Data\Historical Worksheet\data.xlsx", sheet_name='upcoming_archive')
df['run_time'] = start

print(df)

df1 = pd.read_csv(r"C:\Users\harsh\Google Drive\Oddsportal\Files\Oddsportal "
                  r"Data\Pre-processed\oddsportal_upcoming_matches.csv")
df1['run_time'] = start
print(df.head())

concat = [df, df1]
df_c = pd.concat(concat)

path = r"C:\Users\harsh\Google Drive\Oddsportal\Files\Oddsportal Data\Historical Worksheet\data.xlsx"

writer = df_c.ExcelWriter(r"C:\Users\harsh\Google Drive\Oddsportal\Files\Oddsportal Data\Historical Worksheet\data.xlsx", sheetname = 'upcoming_archive',
                      mode='a', engine='openpyxl')

# print(df1)