CODEWITHSUNDEEP
pythonpandas
Greencolor
Greencolor

Reputation: 687

Convert Excel to CSV using Python

I would like to name new CSV files similar to their corresponding xlsx files

import pandas as pd

for filename in my_path.glob('*.xlsx'):

    read_file = pd.read_excel (str(filename)', sheet_name='My Excel sheet name')
    read_file.to_csv ("XLSX NAME SHOULD = CSV NAME.csv', index = None, header=True)

Upvotes: 0

Views: 315

Answers (1)

vinalti
vinalti

Reputation: 1194

To get the filename with path but without extension use os.path.splitext

from os import path 

path = "/path/to/file.txt"
path.splitext(path)
# -> ["/path/to/file", "txt"]

To get the filename without the path :

from os import path 

path = "/path/to/file.txt"
path.basename(path)
# -> "file.txt"

So to change the extension from xlsx to csv :

from os import path 

path = "/path/to/file.xlsx"
filename = path.splitext(path)[0] + '.csv'
# -> "/path/to/file.csv"

And if you need to change the path to save the file in another folder, then you can use basename first.

Upvotes: 1

Related Questions