Convert CSV to Excel with Python

This is a Python script that uses the pandas library to convert a CSV file to an Excel file:

# Source: https://websitefunctions.com

import pandas as pd

 

def convert_csv_to_excel(csv_file, excel_file):

    data = pd.read_csv(csv_file)

    data.to_excel(excel_file, index=False)

 

# Specify the paths of the CSV and Excel files

csv_file_path = 'path/to/input.csv'

excel_file_path = 'path/to/output.xlsx'

 

# Call the function to convert the CSV to Excel

convert_csv_to_excel(csv_file_path, excel_file_path)

 

Make sure to replace 'path/to/input.csv' with the actual path of your CSV file, and 'path/to/output.xlsx' with the desired path for the output Excel file.

The script uses the read_csv function from pandas to read the CSV file, and then the to_excel function to save the data into an Excel file. The index=False argument is used to exclude the row index from the Excel file.

You'll need to have the pandas library installed. You can install it using pip by running pip install pandas in your terminal or command prompt.

Once you've updated the file paths and have the pandas library installed, you can run the script to convert the CSV file to an Excel file.