How to Convert Data Types in a Python Data Pipeline

import json
from datetime import datetime

def convert_value(value):
    """Convert string values to appropriate Python types."""
    if value.lower() == "true":
        return True
    if value.lower() == "false":
        return False
    if value.isdigit():
        return int(value)
    try:
        return float(value)
    except ValueError:
        pass
    try:
        return datetime.fromisoformat(value)
    except ValueError:
        return value

def process_pipeline(raw_data):
    """Convert and structure raw CSV-like data into JSON-friendly format."""
    records = []
    for line in raw_data.strip().split("\n"):
        fields = [item.strip() for item in line.split(",")]
        record = {
            "name": fields[0],
            "age": convert_value(fields[1]),
            "active": convert_value(fields[2]),
            "score": convert_value(fields[3]),
            "joined": convert_value(fields[4]),
        }
        records.append(record)
    return json.dumps(records, indent=2, default=str)

if __name__ == "__main__":
    raw_data = """
Alice, 30, true, 92.5, 2023-05-15
Bob, 25, false, 78.0, 2022-11-01
Charlie, 35, true, 88.75, 2024-01-20
"""
    print(process_pipeline(raw_data))