Starting from:

$30

Tutorial 04 CS384 - Academic Subject Record with Excel Output Solved

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 using the csv library and make k xlsx files corresponding to k roll numbers. A sample output for Task 1 is shown in 1901EE01.xlsx file.

Check the sample output folder 1901EE01.xlsx rollno,register sem,subno,sub  type

1901EE01,5,CS384,Open Elective

1901EE01,5,EE330,CORE

1

1901EE01,5,EE331,CORE

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 that have taken those subject. Check the file sample output \CS384.xlsx 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.

2

More products