# Utility functions for data conversion
import pandas as pd
import numpy as np
from datetime import datetime


def safe_convert_numeric(series):
    """
    Safely convert a pandas Series to numeric values, coercing errors to NaN.
    
    Args:
        series: Pandas Series to convert
        
    Returns:
        Pandas Series with numeric values
    """
    try:
        return pd.to_numeric(series, errors='coerce')
    except Exception as e:
        print(f"Error converting to numeric: {e}")
        return series


def safe_convert_datetime(series):
    """
    Safely convert a pandas Series to datetime, coercing errors to NaN.
    
    Args:
        series: Pandas Series to convert
        
    Returns:
        Pandas Series with datetime values
    """
    try:
        return pd.to_datetime(series, errors='coerce')
    except Exception as e:
        print(f"Error converting to datetime: {e}")
        return series