Export List of Dicts to CSV in Python

import csv

def export_to_csv(data, filename):
    """Export a list of dicts to a CSV file."""
    if not data:
        print("No data to export")
        return
    
    # Get column names from the keys of the first dict
    fieldnames = list(data[0].keys())
    
    with open(filename, 'w', newline='', encoding='utf-8') as csvfile:
        writer = csv.DictWriter(csvfile, fieldnames=fieldnames)
        
        # Write header row
        writer.writeheader()
        
        # Write data rows
        writer.writerows(data)
    
    print(f"Exported {len(data)} rows to {filename}")

if __name__ == "__main__":
    # Example data - list of dicts (dataframe-like structure)
    people = [
        {"name": "Alice", "age": 30, "city": "New York"},
        {"name": "Bob", "age": 25, "city": "Los Angeles"},
        {"name": "Charlie", "age": 35, "city": "Chicago"}
    ]
    
    export_to_csv(people, "people.csv")
    
    # Verify by reading back the file
    with open("people.csv", 'r') as f:
        print("\nCSV contents:")
        print(f.read())