How To Create A Csv File Using Python

# importing csv
import csv
# Data
data = [
    ['Name', 'Age', 'City'],
    ['Aman', 28, 'Pune'],
    ['Poonam', 24, 'Jaipur'],
    ['Bobby', 32, 'Delhi']
]
# File path for the CSV file
csv_file_path = 'example.csv'
# Open the file in write mode
with open(csv_file_path, mode='w', newline='') as file:
    # Create a csv.writer object
    writer = csv.writer(file)
    # Write data to the CSV file
    writer.writerows(data)
# Print a confirmation message
print(f"CSV file '{csv_file_path}' created successfully.")

# Step 1 Importing pandas
import pandas as pd
# Step 2 Prepare your data
data = {
    'Name': ['Rajat', 'Tarun', 'Bobby'],
    'Age': [30, 25, 35],
    'City': ['New York', 'Delhi', 'Pune']
}
# Step 3 Create a DataFrame using DataFrame function
df = pd.DataFrame(data)
# Step 4 Specify the file path to save data
csv_file_path = 'data.csv'
# Step 5 Write the DataFrame to a CSV file using to_csv() function where file path is passed
df.to_csv(csv_file_path, index=False)
print(f'CSV file "{csv_file_path}" has been created successfully.')

# data to be stored in csv in form of list of list
data = [
    ['Name', 'Gender', 'Age', 'Course'],
    ['Aman', 'M', 22, 'B.Tech'],
    ['Pankaj', 'M', 24, 'M.Tech'],
    ['Beena', 'F', '23', 'MBA']
]
# file path of csv to be stored
csv_file_path = 'ex3.csv'
# opening file in write mode using a context manager
with open(csv_file_path, mode='w') as file:
    for row in data:
        file.write(','.join(map(str, row)) + '\n')  # writing data row by row
print(f"CSV file '{csv_file_path}' created successfully!!!")