from csv import reader OpenFile = open('Animal Names.csv') ReadFile = reader(OpenFile) AnimalNames = list(ReadFile) for row in AnimalNames: dogs = row cats = row dogs = dogs.title() cats = cats.title() row = dogs row = cats print(AnimalNames)
From the Data cleaning course listed above I tried the same coding technique on a personally owned set of data and it worked just fine(which is great thanks DataQuest). My issue came around when I closed out the code and opened the excel back up none of the changes were saved. How do I go about actually saving those changes made back to the document? Thank you!!