Answers for "where should i put my excel csv file for python to read"

Convert Excel to CSV using Python

import pandas as pd
data_xls = pd.read_excel('excelfile.xlsx', 'Sheet2', dtype=str, index_col=None)
data_xls.to_csv('csvfile.csv', encoding='utf-8', index=False)

python openpyxl csv to excel

import pandas as pd

read_file = pd.read_csv (r'Path where the CSV file is storedFile name.csv')
read_file.to_excel (r'Path to store the Excel fileFile name.xlsx', index = None, header=True)