import pandas as pd
import locale
import datetime
import math
from collections import Counter

locale.setlocale(locale.LC_ALL, '')
df = pd.read_csv('/home/bqeuux/anaconda3/envs/python-beadando/TGLOB_3052019_HON.CSV', delimiter=';')


ticket_number = df['TICK_NB'].count()
maximum_gain = df['GAIN'].max()
maximum_gain_currency = locale.currency(maximum_gain, grouping=True)


print("A legnagyobb elért nyeremény: " + maximum_gain_currency)

buying_time_range = df['E_HEURE']
buying_time_date_format = pd.to_datetime(buying_time_range)
buying_time_date_format_avearge = buying_time_date_format.mean()
avearge_buying_time_hour_minute = buying_time_date_format_avearge.strftime('%H:%M')
print("Az időpont, amikor a legtöbb ticket-et eladták: " + avearge_buying_time_hour_minute)

repay = df['REMBOUR']
repay_avearge = repay.mean()
repay_avearge_currency = locale.currency(repay_avearge, grouping=True)
repay_minimum = repay.min()
repay_minimum_currency = locale.currency(repay_minimum, grouping=True)
repay_maximum = repay.max()
repay_maximum_curreny = locale.currency(repay_maximum, grouping=True)
repay_piece = repay.count()
repay_piece_string = str(repay_piece)


print("Az átlagos visszafiztetés értéke: " + repay_avearge_currency)
print("A legkisebb visszafizetés értéke: " + repay_minimum_currency)
print("A legnagyobb visszafizetés értéke: " + repay_maximum_curreny)
print("A visszafizetések száma: " + repay_piece_string + " db")

base_bet_range = df['ENJEUX']
base_bet_maximum = base_bet_range.max()
base_bet_minimum = base_bet_range.min()
base_bet_median = base_bet_range.median()

base_bet_minimum_currecy = locale.currency(base_bet_minimum, grouping=True)
base_bet_maximum_currecy = locale.currency(base_bet_maximum, grouping=True)
base_bet_median_currency = locale.currency(base_bet_median, grouping=True)

print("A legkisebb alaptét: " + base_bet_minimum_currecy)
print("A legnagyobb alaptét: " + base_bet_maximum_currecy)
print("Az átlagos alaptét: " + base_bet_median_currency)

betting_types_range = df['PARI']

each_betting_type_from_range = Counter(betting_types_range).keys()
each_betting_numbers_from_range = Counter(betting_types_range).values()

print("Játszott játékok darabszáma típusonként: ")
for n,v in zip(each_betting_type_from_range, each_betting_numbers_from_range):
    print("{} = {}db".format(n,v))