import pandas as pd
import math
from ticket import Ticket
# Importar CSV files
data = pd.read_csv('jira_cases.csv')
# Total de datos
total_rows = len(data)
print("Total rows: {0}".format(total_rows))
#Convierte el DataFrame a una lista de objetos tipo Ticket
tickets = Ticket.convert_all_tickets(data)
print(len(tickets))
# Prioridades de los tickets
lowp, mediump, highp, urgentp = Ticket.get_priority_tickets(tickets)
# Obtiene el total de tickets escalados en DataFrame
escalated_tickets = Ticket.get_escalated_tickets(data)
print(escalated_tickets.iloc[0]['Created'])
"""
# Numero de tiquets escalados Frontend
frons = 0
for ticket in tickets:
if 'Frontend' in ticket.labels:
frons += 1
