Python- replacing date stored in csv file with a string

Question

I have a csv file that stores dates (format 12 june 2019,), i want to replace a date that a user chooses with 0 (basciaclly deleting it) when ever the function is called. The code runs with no errors however when i check the file again the date hasnt been replaced.

from datetime import datetime


def Remove_event():
    date_string = input("Enter date for event (Format: day month, year): ")

    date_object = datetime.strptime(date_string, "%d %B, %Y")  # converts inputted date into date time data type
    date_object = date_object.strftime("%d %B, %Y")  # formats the date
    date_object = date_object.replace(",", "")  # removes comma in the middle
    date_object1 = date_object + ","  # adds comma at the end

    f = open("dates1.csv", "rt")
    data = f.read()
    data = data.replace(date_object1, '0')
    print("yes")
    f.close()


Remove_event()

Ioanna · Accepted Answer · 2020-02-01 13:48:11Z

1

You need to add the following code at the end to actually write the replacement to the file:

fin = open("dates1.csv", "wt")
fin.write(data)
fin.close()

answered Feb 1, 2020 at 13:48

Ioanna

3761 silver badge5 bronze badges

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

Collectives™ on Stack Overflow

Python- replacing date stored in csv file with a string

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related