Convert a CSV file to an Excel file using Python | Gun Wardhan Aditya
Here are the step-by-step instructions to convert a CSV file to an Excel file using Python and the pandas library:
Install the pandas library if you haven't already. You can install it by running pip install pandas in your terminal or command prompt.
Import the pandas library in your Python script: import pandas as pd.
Specify the path and filename of your CSV input file. For example: csv_file = 'input.csv'.
Use the pd.read_csv() function to read the CSV file and store its contents in a DataFrame variable. For example: df = pd.read_csv(csv_file).
Specify the path and filename of the output Excel file. For example: excel_file = 'output.xlsx'.
Use the df.to_excel() function to write the DataFrame to an Excel file. Specify the output Excel file path and set index=False to exclude the row index from being written. For example: df.to_excel(excel_file, index=False).
Run your Python script, and it will convert the CSV file to an Excel file at the specified location.
Make sure to replace 'input.csv' and 'output.xlsx' with the actual paths and filenames of your input CSV file and desired output Excel file.
By following these steps, you will be able to convert a CSV file to an Excel file using Python and the pandas library.