FP_Lab7........

Question

Use the following file as input:  Track.txt 

open file information. When writing the open statement for both files add this to the statement(see in red)

open("Name of your file", "r", encoding="utf8")

Your program criteria are: 

All rows that have TrackID of even and Albumid of even are written to one file.

All rows that have TrackID of odd and Albumid of odd are written to one file.

Your output should contain all the elements in the rows that fit the above criteria.

All output should be written to the output file in your program. In this case, you will have two output files.

Note: the first row in the input file is the file header which indicates the column names for the data.

Answer 1

Breaking the assignment into basic steps:

1. Read the lines of the file into a list
2. Read the first line to determine which column holds which data
3. convert the current line's albumid and trackid to integers
4. Check to see which ids are even/odd using the modulo operator (%)
5. If both are even, write the original line to the even track file
6. Else if both are odd, write to the odd track file
7. Instructions unclear whether to write to separate neither file or just ignore lines that have a mix of both.
8. Go back to step 3 and loop until all lines are read

Note:

In the instructions, it mentions:

When writing the open statement for both files add this to the statement(see in red)

open("Name of your file", "r", encoding="utf8")

However it should be using "w" when writing as it would have insufficient permissions to write otherwise. So should be something like:

open("Name of your file", "w", encoding="utf8")