Task 1:
You are given a “regtable old.csv” file containing the subjects taken by IITP students. You need to make files for individual roll numbers with their subject information.
Template of “regtable old.csv” is as follows:
rollno: Roll number of the student register sem: Semester for which registered. schedule sem: Semester for which registered .
subno : Course Code. grade1: Ignore. date ofentry1: Ignore.
grade2:Ignore . date ofentry2: Ignore.
sub type: Core/Elective.
If a roll number has taken k subjects, there would be k rows against the roll number in the input file “regtable old.csv”. Your task to read the “regtable old.csv” file without the csv library and make k files corresponding to k roll numbers. A sample output for Task 1 is shown in 1901EE01.csv file. (Note the, between the text. You cannot use CSV module for writing also)
Check the sample output folder 1901EE01.csv rollno,register sem,subno,sub type
1901EE01,5,CS384,Open Elective
1901EE01,5,EE330,CORE
1901EE01,5,EE331,CORE
1
1901EE01,5,EE350,CORE
1901EE01,5,EE370,CORE
1901EE01,5,EE372,CORE
1901EE01,5,EE381,CORE
All of the outputs for Task 1 should go into the folder “output individual roll” Task 2:
Now you need to make a file for every individual subject listed in the “regtable old.csv”. Read the subno column and for each individual subject you need to include all students that have taken those subject. (Note the, between the text. You cannot use CSV module for writing also). Check the file sample output \CS384.csv file and make for all unique subjects.
All the outputs relating to Task 2 should go into “output by subject” folder.
I placed the sample output folder just for ease of viewing the output. Your outputs should go to folders as described in Task 1 and Task 2.
