14.2 Cats and commas
The City of Greater Dandenong in Australia freely provides data about the cats that have been registered with the city as of January 6, 2021. [CAT] Greater Dandenong is in the state of Victoria and is a suburb of Melbourne. [DAN]
The file is in CSV format, which means that commas separate the values on each line. You may think of the commas as separating columns of data. Each row of data contains the information about one cat.
We can peek at the file by opening it in a text editor or using the read function to examine the lines at the beginning of the file. The first line is not data but is a list of the labels or headings for each column.
cats = open("src/examples/registered-cats.csv", "rt")
print(cats.readline())
"Locality","Postcode","Animal_Type","Breed_Description",
"Colour_Description","GENDER"
There...
