Python Forum
How to rename a CSV file by adding MODIFIED in the filename?
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to rename a CSV file by adding MODIFIED in the filename?
#23
(Dec-07-2020, 10:17 PM)Larz60+ Wrote:
Quote:What does this part of the code below? Could you provide some explanation behind the lines of code as comments?

for example, filename = Path('/media/stubens/DataDrive-3XT/projs/T-Z/T/TryStuff/data/csv/IllinoisData.csv')
def read_csv_file(filename):

    parts = list(filename.parts)
    # parts = ['/', 'media', '/', 'stubens', '/', 'DataDrive-3XT','/', 'projs', '/', 'T-Z', '/', 'T', '/', 'TryStuff', '/', 'data', '/', 'csv', '/', 'IllinoisData.csv']

    parts[-1] = f"{filename.stem}Modified{filename.suffix}"
    # parts[-1] = 'IllinoisDataModified.csv'
    # parts = ['/', 'media', '/', 'stubens', '/', 'DataDrive-3XT','/', 'projs', '/', 'T-Z', '/', 'T', '/', 'TryStuff', '/', 'data', '/', 'csv', '/', 'IllinoisDataModified.csv']

    parts[0] = ''
    # removes '/' from index 0 because join will add it back again
    # parts = ['media', '/', 'stubens', '/', 'DataDrive-3XT','/', 'projs', '/', 'T-Z', '/', 'T', '/', 'TryStuff', '/', 'data', '/', 'csv', '/', 'IllinoisDataModified.csv']

    outfilename = Path(f"{'/'.join(parts)}")
    # join fileparts back together
    # outfilename = '/media/stubens/DataDrive-3XT/projs/T-Z/T/TryStuff/data/csv/IllinoisDataModified.csv'
 
    print(f"new output file name: {outfilename}")
    # will print
    # '/media/stubens/DataDrive-3XT/projs/T-Z/T/TryStuff/data/csv/IllinoisDataModified.csv'

    # open two files, filename as input (fp), outfilename as output (fout)
    with filename.open() as fp, outfilename.open('w') as fout:

        # set csv reader to flename (fp)
        crdr = csv.reader(fp, delimiter=',')

        # set csv writer to outfilename (fout), delimiter = ','
        cwrtr = csv.writer(fout, delimiter=',')

        # for each row in crdr (csv input)
        for row in crdr:

            # print the row
            print(row)

            # ...
            # Your code goes here
            # ...

            # write modified row
            cwrtr.writerow(row)

Thanks!!
Reply


Messages In This Thread
RE: How to rename a CSV file by adding MODIFIED in the filename? - by Python_User - Dec-08-2020, 07:13 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Rename first row in a CSV file James_S 3 693 Dec-17-2023, 05:20 AM
Last Post: James_S
  PDF properties doesn't show created or modified date Pedroski55 4 1,231 Jun-19-2023, 08:09 AM
Last Post: Pedroski55
  rename file RolanRoll 0 580 May-18-2023, 02:17 PM
Last Post: RolanRoll
  File path by adding various variables Mishal0488 2 1,181 Apr-28-2023, 07:17 PM
Last Post: deanhystad
  '' FTP '' File upload with a specified string and rename midomarc 1 1,273 Apr-17-2023, 03:04 AM
Last Post: bowlofred
  output provide the filename along with the input file processed. arjunaram 1 1,001 Apr-13-2023, 08:15 PM
Last Post: menator01
  rename same file names in different directories elnk 0 773 Nov-04-2022, 05:23 PM
Last Post: elnk
  rename and add desire "_date" to end of file name before extention RolanRoll 1 1,311 Jun-13-2022, 11:16 AM
Last Post: gruntfutuk
  Rename part of filename in multiple files atomxkai 7 7,605 Feb-18-2022, 10:03 PM
Last Post: atomxkai
  Adding to an XML file TeXaSpEtE83 0 1,314 Dec-22-2021, 08:28 AM
Last Post: TeXaSpEtE83

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020