Pandas: Simplifying Data Manipulation and Analysis
pandas is a fast, powerful, flexible and easy to use open source data analysis and manipulation tool, built on top of the Python programming language.
import pandas as pd
read_file = pd.read_excel (r'Path where the Excel file is stored\File name.xlsx', sheet_name='Your Excel sheet name')
read_file.to_csv (r'Path to store the CSV file\File name.csv', index = None, header=True)
df['column_name'] = '' add a new column