Python pandas save multiple CSV with different names

Question

I am reading multiple files using pandas and need to save each file with the original filename_corrected. How do you rename the output file with it's original filename + a prefix or number?

import pandas as pd
import glob
import os

#Read all files in using pandas
path = r'J:\Temp\\' 
all_files = glob.glob(path + "/*.97o")

for filename in all_files:
   df = pd.read_csv (filename)
   df = df.replace(to_replace ='1997     7    23 ', value = '2019     5    23 ', regex = True)
   df = df.replace(to_replace ='97  7 23', value = '19  5 23', regex = True)
   df.to_csv('J:\Temp\94512040_corrected.97o', index=False)

Output file should be called: filename_corrected.97o

You can use df.to_csv('J:\Temp\'+filename+'_corrected.97o', index=False) — Bugs 404
– Bugs 404, Commented May 23, 2019 at 14:54

kudeh · Accepted Answer · 2019-05-24 15:08:28Z

2

You can create a new filename using a format string based on the old name:

import pandas as pd
import glob
import os

#Read all files in using pandas
path = r'J:\Temp\\' 
all_files = glob.glob(path + "/*.97o")

for filename in all_files:

   df = pd.read_csv(filename)
   df = df.replace(to_replace ='1997     7    23 ', value = '2019     5    23 ', regex = True)
   df = df.replace(to_replace ='97  7 23', value = '19  5 23', regex = True)
   fileBaseName = os.path.basename(filename).split('.')[0]
   newFilename = '{}{}_corrected.97o'.format(path, fileBaseName)
   df.to_csv(newFilename, index=False)

edited May 24, 2019 at 15:08

answered May 23, 2019 at 14:53

kudeh

9131 gold badge6 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

M.Lord Over a year ago

Hi thanks for the answer but seems to be messing with the path - getting a 'no such file or directory' error - code seems to be adding extra \\ into the filepath

M.Lord Over a year ago

this is what I get:

M.Lord Over a year ago

FileNotFoundError: [Errno 2] No such file or directory: "J:\\Temp\\Michael\\Python\\Rinex Date Error\\J:\\Temp\\Michael\\Python\\Rinex Date Error\\'+filename+_corrected.97o_corrected.97o"

Collectives™ on Stack Overflow

Python pandas save multiple CSV with different names

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related