Question : convert excel file to csv with pandas
Answered by : sadegh-pouriyan
import pandas as pd
import os
df = pd.read_excel('Book1.xlsx', sheet_name='Sheet1')
current_working_directory = os.getcwd()
save_path = current_working_directory + '\\file_name.csv'
df.to_csv(save_path)
Source : https://datatofish.com/excel-to-csv-python/ | Last Update : Sat, 11 Dec 21