Rename Changing CSV file name in directory

Question

I have a csv file in which the name will always change when exported from an application. I want to rename the csv file using python. Here's what I have so far, but it's definitely wrong.

directory = "/files/"

for file in directory:
    if file.endswith('.csv'):
        os.rename('*.csv', 'tracking.csv')

try this: https://stackoverflow.com/questions/3964681/find-all-files-in-a-directory-with-extension-txt-in-python — Samer, May 13 '19 at 15:26

score 2 · Accepted Answer · answered May 13 '19 at 15:31

i assume you have only one csv file in your directory,

import os
directory = "/files/"

files = os.listdir(directory)

# remove the old tracking file if exists
if 'tracking.csv' in files:
    old_file = os.path.join(directory, 'tracking.csv')
    os.unlink(old_file)

# rename
for file in files:
    if file.endswith('.csv'):
        os.rename(os.path.join(directory, file), os.path.join(directory, 'tracking.csv'))
        break

Rename Changing CSV file name in directory

1 Answers1