Stránka venovaná štatistike hovorov získaných z Android telefónu Ide o prehľad prichádzajúcich alebo zmeškaných hovorov na diplomatickú službu

              
              import pandas as pd
              from datetime import datetime, timedelta
              # Set the Pandas display options to show all rows
              pd.set_option('display.max_rows', None)
            

        
        # Mapa pre preklad mesiacov zo slovenského na číselný formát
        month_map = {
        'január': '01', 'február': '02', 'marec': '03', 'apríl': '04',
        'máj': '05', 'jún': '06', 'júl': '07', 'august': '08',
        'september': '09', 'október': '10', 'november': '11', 'december': '12',
        'jan': '01', 'feb': '02', 'mar': '03', 'apr': '04',
        'jun': '06', 'jul': '07', 'aug': '08',
        'sep': '09', 'okt': '10', 'nov': '11', 'dec': '12'
        }
        month_order = ['jan', 'feb', 'mar', 'apr', 'máj', 'jun', 'jul', 'aug', 'sep', 'okt', 'nov', 'dec']
        def convert_date(date_str):
        # Check if the input is a string
        if not isinstance(date_str, str):
        return None  # Return None or some default value for non-string inputs
        # Preklad mesiaca a úprava reťazca dátumu
        for sk, num in month_map.items():
            if sk in date_str.lower():
                date_str = date_str.lower().replace(sk, num)
                break

        try:
            # Konverzia upraveného reťazca dátumu na datetime objekt
            return datetime.strptime(date_str, '%d %m %Y %H:%M')
        except ValueError:
            return None
    

def is_holiday_or_weekend(call_time, holidays):
        if isinstance(call_time, str):
            try:
                call_time = datetime.strptime(call_time, '%Y-%m-%d %H:%M:%S')
            except ValueError:
                print(f"Date format error with: {call_time}")
                return False

        formatted_date = call_time.strftime('%d.%m.') + ' '
        return call_time.weekday() > 4 or formatted_date in holidays
    

def is_outside_working_hours(call_time):
        morning_start = datetime(call_time.year, call_time.month, call_time.day, 8, 30)
        morning_end = datetime(call_time.year, call_time.month, call_time.day, 12, 0)
        afternoon_start = datetime(call_time.year, call_time.month, call_time.day, 13, 0)
        afternoon_end = datetime(call_time.year, call_time.month, call_time.day, 16, 30)
        return not (morning_start <= call_time < morning_end or afternoon_start <= call_time < afternoon_end)
    

# Uloženie zoznamov do pd a následne do csv
    def saving_df(ls, name, columns):
        # Create a DataFrame from the list with specific column names
        ls_df = pd.DataFrame(ls, columns=columns)
        ls_df.to_csv(name + '.csv', index=False)
    

# Načítanie údajov o hovoroch s konverziou dátumu
    # calls = pd.read_csv('\data\calllog.csv', encoding='cp1252', delimiter=';')
    # calls = pd.read_csv(r'\data\calllog.csv', encoding='cp1252', delimiter=';')
    # calls = pd.read_csv('/data/calllog.csv', encoding='cp1252', delimiter=';')
    # calls = pd.read_csv('\\data\\calllog.csv', encoding='cp1252', delimiter=';')
    # calls = pd.read_csv('./data/calllog.csv', encoding='cp1252', delimiter=',')
    calls = pd.read_csv('./data/2023calllog.csv', encoding='cp1252', delimiter=';', dtype={'phoneNumber': str})

    # Správny formát dátumu a času
    # calls['DC'] = pd.to_datetime(calls['call Time'], format='%d.%m.%Y %H:%M', errors='coerce')
    # Konverzia dátumu a času s použitím upravenej funkcie
    calls['converted Time'] = calls['call Time'].apply(convert_date)
    

# Načítanie sviatkov
    with open('./data/sviatky23.csv', 'r', encoding='utf-8-sig') as file:
        holidays = [datetime.strptime(line.strip(), '%d.%m.').strftime('%d.%m.') + ' ' for line in file.readlines()]
    

# Filtrovanie prijatých hovorov pre rok 2023, mimo pracovných hodín, víkendov a sviatkov
    filtered_calls = []
    # Filter by year
    calls_2023 = calls[calls['year'] == 2023]

    # Filter by call log type
    missedrec_2023 = calls_2023[calls_2023['Call Log'].isin(['Received', 'Missed', 'Rejected'])]

    # Function to combine holiday and working hours checks
    def is_filtered(call_time):
        return is_holiday_or_weekend(call_time, holidays) or is_outside_working_hours(call_time)

    # Apply the function
    filtered_calls = missedrec_2023[missedrec_2023['converted Time'].apply(is_filtered)]

    # Create DataFrame
    data_df = filtered_calls.copy()
    

# Define the dictionary to track last call times
    last_call_times = {}
    filtered_calls1 = []

    # Start of your loop
    for index, call in calls.iterrows():
        if call['year'] == 2023:
            if call['Call Log'] in ['Received', 'Missed', 'Rejected']:
                # Convert 'call Time' to datetime if it's not already in that format
                current_call_time = pd.to_datetime(call['converted Time'])
                
                # Get the last call time for this phone number from the dictionary
                last_call_time = last_call_times.get(call['phoneNumber'], None)
                
                # Check if there's a last call and it was less than 5 minutes before this call
                if last_call_time and (current_call_time - last_call_time) < timedelta(minutes=5):
                    continue  # Skip adding this call to filtered_calls
                
                # Check for holiday or outside working hours
                if is_holiday_or_weekend(call['converted Time'], holidays) or is_outside_working_hours(call['converted Time']):
                    filtered_calls1.append(call)
                
                # Update the last call time for this phone number
                last_call_times[call['phoneNumber']] = current_call_time