Python Project : Result Printing in PDF Project for School or College Students

# ResultPDFPython
Result generation in PDF format using python
The following program is to generate PDF files for all students of a certain class. The PDF files has been generated by Python and the data for the results has been kept in a EXCEL file. There are eight subjects, namely 1. Varnacular 2. English 3. Math 4. Physical Science 5. Life Sciene 6. History 7. Geography and 8. Computer. For a given academic year each student has to give three written exams ( First Summative - 50 marks, Second Summative - 50 marks, Third Summative - 90 marks ) and one project ( 10 marks) for each of the subjects. The marks for the whole academic session will be stored in a Excel file ( see the excel file). 

One has to fetch the marks and print the result individually for each students ( along with their name and roll number). The excel file contains all the data in a pre-defined manner. After the extraction the year total for each subject has to be calculated ( out of 200 ) then the average ( out of 100 ) has also to be displayed. After that the grades has to be calculated based on the following scheme.
  > greater than equal to 90 ----- A+
  > greater than equal to 80 and less than 90 ----- A 
  > greater than equal to 70 and less than 80 ----- B+
  > greater than equal to 60 and less than 70 ----- B
  > greater than equal to 50 and less than 60 ----- C+
  > greater than equal to 25 and less than 50 ----- C
  > less than 25 ------ D
If a student has 3 or more D's out of eight subjects, he/she will be detained otherwise he/she will be promoted.

Note the total marks for the full academic session will be the sum of all the average marks in all subjects ( except Computer) and the percentage will be calculated out of 700.
The format of the result is shown below:                                    

The pdf files along with the excel sheet is present in the repository.
(https://github.com/mathsvinu/ResultPDFPython)

View on Google CodeLabs

https://colab.research.google.com/drive/1Cppy4A7yu1_lwJiFUMtscrI7tkb6VM2X?usp=sharing

import pandas as pd

import openpyxl

from fpdf import FPDF

def grades(averageMarks):

    if averageMarks >= 90:

        return "A+"

    if averageMarks >= 80 and averageMarks < 90:

        return "A"

    if averageMarks >= 70 and averageMarks < 80:

        return "B+"

    if averageMarks >= 60 and averageMarks < 70:

        return "B"

    if averageMarks >= 50 and averageMarks < 60:

        return "C+"

    if averageMarks >= 25 and averageMarks < 50:

        return "C"

    if averageMarks < 25:

        return "D"

# read by default 1st sheet of an excel file

# dataframe1 = pd.read_excel('IX_A_RESULT.xlsx')

# print(dataframe1)

wb = openpyxl.load_workbook('IX_A_RESULT.xlsx')

sh = wb.active

entireMarksList = []

subjectList = ["Bengali","English","Math","PScience","LScience","History","Geography","Computer"]

top = ("Subjects", "First Term", "Second Term", "Annual Written","Project","Annual Total","Grand Total","Average","Grades")

passingGrades =["P","P1","P2","P3","P4","P5","P6","P7","P8"]

for i in range(2,sh.max_row+1):

    for j in range(4,12):

        cellvalue = sh.cell(row=i,column=j)

        entireMarksList.append(cellvalue.value)

#print(entireMarksList)

nametag = 2

for roll in range(0,int((sh.max_row-1)/4)):

    print("Roll Number",roll+1," Name:",sh.cell(row=nametag,column=2).value)

    totalPercentage = 0

    dCounter = 0

    bengaliAnnual = 0

    bengaliTotal = 0

    englishAnnual = 0

    englishTotal = 0

    mathAnnual = 0

    mathTotal = 0

    physcnAnnual = 0

    physcnTotal = 0

    lfscnAnnual = 0

    lfscnTotal = 0

    hisAnnual = 0

    hisTotal = 0

    geoAnnual = 0

    geoTotal = 0

    comAnnual = 0

    comTotal = 0

    bindex = 32*roll

    eindex = 32*roll+1

    mindex = 32*roll+2

    pindex = 32*roll+3

    lindex = 32*roll+4

    hindex = 32*roll+5

    gindex = 32*roll+6

    cindex = 32*roll+7

    subjectAnnualTotal = []

    subjectSessionTotal = []

    firstSummative = []

    secondSummative = []

    thirdSummative = []

    project = []

    # EXTRACTING INDIVIDUAL MARKS FROM THE LIST

    bengaliAnnual += entireMarksList[bindex+2*8]+entireMarksList[bindex+3*8]

    bengaliTotal += bengaliAnnual + entireMarksList[bindex]+entireMarksList[bindex+8]

    subjectAnnualTotal.append(bengaliAnnual)

    subjectSessionTotal.append(bengaliTotal)

    firstSummative.append(entireMarksList[bindex])

    secondSummative.append(entireMarksList[bindex+8])

    thirdSummative.append(entireMarksList[bindex+2*8])

    project.append(entireMarksList[bindex+3*8])

    englishAnnual += entireMarksList[eindex+2*8]+entireMarksList[eindex+3*8]

    englishTotal += englishAnnual + entireMarksList[eindex]+entireMarksList[eindex+8]

    subjectAnnualTotal.append(englishAnnual)

    subjectSessionTotal.append(englishTotal)

    firstSummative.append(entireMarksList[eindex])

    secondSummative.append(entireMarksList[eindex+8])

    thirdSummative.append(entireMarksList[eindex+2*8])

    project.append(entireMarksList[eindex+3*8])

    mathAnnual += entireMarksList[mindex+2*8]+entireMarksList[mindex+3*8]

    mathTotal += mathAnnual + entireMarksList[mindex]+entireMarksList[mindex+8]

    subjectAnnualTotal.append(mathAnnual)

    subjectSessionTotal.append(mathTotal)

    firstSummative.append(entireMarksList[mindex])

    secondSummative.append(entireMarksList[mindex+8])

    thirdSummative.append(entireMarksList[mindex+2*8])

    project.append(entireMarksList[mindex+3*8])

    physcnAnnual += entireMarksList[pindex+2*8]+entireMarksList[pindex+3*8]

    physcnTotal += physcnAnnual + entireMarksList[pindex]+entireMarksList[pindex+8]

    subjectAnnualTotal.append(physcnAnnual)

    subjectSessionTotal.append(physcnTotal)

    firstSummative.append(entireMarksList[pindex])

    secondSummative.append(entireMarksList[pindex+8])

    thirdSummative.append(entireMarksList[pindex+2*8])

    project.append(entireMarksList[pindex+3*8])

    lfscnAnnual += entireMarksList[lindex+2*8]+entireMarksList[lindex+3*8]

    lfscnTotal += lfscnAnnual + entireMarksList[lindex]+entireMarksList[lindex+8]

    subjectAnnualTotal.append(lfscnAnnual)

    subjectSessionTotal.append(lfscnTotal)

    firstSummative.append(entireMarksList[lindex])

    secondSummative.append(entireMarksList[lindex+8])

    thirdSummative.append(entireMarksList[lindex+2*8])

    project.append(entireMarksList[lindex+3*8])

    hisAnnual += entireMarksList[hindex+2*8]+entireMarksList[hindex+3*8]

    hisTotal += hisAnnual + entireMarksList[hindex]+entireMarksList[hindex+8]

    subjectAnnualTotal.append(hisAnnual)

    subjectSessionTotal.append(hisTotal)

    firstSummative.append(entireMarksList[hindex])

    secondSummative.append(entireMarksList[hindex+8])

    thirdSummative.append(entireMarksList[hindex+2*8])

    project.append(entireMarksList[hindex+3*8])

    geoAnnual += entireMarksList[gindex+2*8]+entireMarksList[gindex+3*8]

    geoTotal += geoAnnual + entireMarksList[gindex]+entireMarksList[gindex+8]

    subjectAnnualTotal.append(geoAnnual)

    subjectSessionTotal.append(geoTotal)

    firstSummative.append(entireMarksList[gindex])

    secondSummative.append(entireMarksList[gindex+8])

    thirdSummative.append(entireMarksList[gindex+2*8])

    project.append(entireMarksList[gindex+3*8])

    comAnnual += entireMarksList[cindex+2*8]+entireMarksList[cindex+3*8]

    comTotal += comAnnual + entireMarksList[cindex]+entireMarksList[cindex+8]

    subjectAnnualTotal.append(comAnnual)

    subjectSessionTotal.append(comTotal)

    firstSummative.append(entireMarksList[cindex])

    secondSummative.append(entireMarksList[cindex+8])

    thirdSummative.append(entireMarksList[cindex+2*8])

    project.append(entireMarksList[cindex+3*8])

    # CREATING DATA FOR TABLE PRINTING

    rowOne = []

    rowTwo = []

    rowThree = []

    rowFour = []

    rowFive = []

    rowSix = []

    rowSeven =[]

    rowEight =[]

    for i in range(0,8):

        if i == 0:

            rowOne.append(str(subjectList[i]))

            rowOne.append(str(firstSummative[i]))

            rowOne.append(str(secondSummative[i]))

            rowOne.append(str(thirdSummative[i]))

            rowOne.append(str(project[i]))

            rowOne.append(str(subjectAnnualTotal[i]))

            rowOne.append(str(subjectSessionTotal[i]))

            rowOne.append(str(subjectSessionTotal[i]/2))

            rowOne.append(grades(subjectSessionTotal[i]/2))

        if i == 1:

            rowTwo.append(str(subjectList[i]))

            rowTwo.append(str(firstSummative[i]))

            rowTwo.append(str(secondSummative[i]))

            rowTwo.append(str(thirdSummative[i]))

            rowTwo.append(str(project[i]))

            rowTwo.append(str(subjectAnnualTotal[i]))

            rowTwo.append(str(subjectSessionTotal[i]))

            rowTwo.append(str(subjectSessionTotal[i]/2))

            rowTwo.append(grades(subjectSessionTotal[i]/2))

        if i == 2:

            rowThree.append(str(subjectList[i]))

            rowThree.append(str(firstSummative[i]))

            rowThree.append(str(secondSummative[i]))

            rowThree.append(str(thirdSummative[i]))

            rowThree.append(str(project[i]))

            rowThree.append(str(subjectAnnualTotal[i]))

            rowThree.append(str(subjectSessionTotal[i]))

            rowThree.append(str(subjectSessionTotal[i]/2))

            rowThree.append(grades(subjectSessionTotal[i]/2))

        if i == 3:

            rowFour.append(str(subjectList[i]))

            rowFour.append(str(firstSummative[i]))

            rowFour.append(str(secondSummative[i]))

            rowFour.append(str(thirdSummative[i]))

            rowFour.append(str(project[i]))

            rowFour.append(str(subjectAnnualTotal[i]))

            rowFour.append(str(subjectSessionTotal[i]))

            rowFour.append(str(subjectSessionTotal[i]/2))

            rowFour.append(grades(subjectSessionTotal[i]/2))

        if i == 4:

            rowFive.append(str(subjectList[i]))

            rowFive.append(str(firstSummative[i]))

            rowFive.append(str(secondSummative[i]))

            rowFive.append(str(thirdSummative[i]))

            rowFive.append(str(project[i]))

            rowFive.append(str(subjectAnnualTotal[i]))

            rowFive.append(str(subjectSessionTotal[i]))

            rowFive.append(str(subjectSessionTotal[i]/2))

            rowFive.append(grades(subjectSessionTotal[i]/2))

        if i == 5:

            rowSix.append(str(subjectList[i]))

            rowSix.append(str(firstSummative[i]))

            rowSix.append(str(secondSummative[i]))

            rowSix.append(str(thirdSummative[i]))

            rowSix.append(str(project[i]))

            rowSix.append(str(subjectAnnualTotal[i]))

            rowSix.append(str(subjectSessionTotal[i]))

            rowSix.append(str(subjectSessionTotal[i]/2))

            rowSix.append(grades(subjectSessionTotal[i]/2))

        if i == 6:

            rowSeven.append(str(subjectList[i]))

            rowSeven.append(str(firstSummative[i]))

            rowSeven.append(str(secondSummative[i]))

            rowSeven.append(str(thirdSummative[i]))

            rowSeven.append(str(project[i]))

            rowSeven.append(str(subjectAnnualTotal[i]))

            rowSeven.append(str(subjectSessionTotal[i]))

            rowSeven.append(str(subjectSessionTotal[i]/2))

            rowSeven.append(grades(subjectSessionTotal[i]/2))

        if i == 7:

            rowEight.append(str(subjectList[i]))

            rowEight.append(str(firstSummative[i]))

            rowEight.append(str(secondSummative[i]))

            rowEight.append(str(thirdSummative[i]))

            rowEight.append(str(project[i]))

            rowEight.append(str(subjectAnnualTotal[i]))

            rowEight.append(str(subjectSessionTotal[i]))

            rowEight.append(str(subjectSessionTotal[i]/2))

            rowEight.append(grades(subjectSessionTotal[i]/2))

    # CALCULATING PERCENTAGE AND NUMBER OF D's        

    for l in range(0,7):

        totalPercentage += (subjectSessionTotal[l]/2)

        if grades(subjectSessionTotal[l]/2) == 'D':

            dCounter +=1

    totalMarks = totalPercentage

    totalPercentage /=7

    totalPercentage = round(totalPercentage,2)        

    data = (top,rowOne,rowTwo,rowThree,rowFour,rowFive,rowSix,rowSeven,rowEight)

    # CREATING MARKSHEET

    pdf = FPDF(format='A4')

    pdf.add_page()

    pdf.set_font("helvetica", size = 15)

    pdf.cell(150, 10, txt = "KUMAR ASHUTOSH INSTITUTION (MAIN) BOYS",border=1,align = "C")

    pdf.ln(15)

    pdf.set_font("helvetica", size = 10)

    pdf.set_font(style="I")

    pdf.cell(150, 2, txt = "NAME: "+str(sh.cell(row=nametag,column=2).value) + "                     Roll No." + str(roll+1),align = "C")

    pdf.ln(10)

    pdf.set_font("helvetica", size = 8)

    pdf.cell(150, 2, txt = "ACADEMIC SESSION: 2023",align = "C")

    pdf.set_draw_color(r=0, g=51, b=102)

    pdf.line(x1=10, y1=30, x2=169, y2=30)

    pdf.set_font_size(8)

    pdf.write_html(

        f"""<table border="1"><thead><tr>

        <th width="9%">{data[0][0]}</th>

        <th width="9%">{data[0][1]}</th>

        <th width="10%">{data[0][2]}</th>

        <th width="12%">{data[0][3]}</th>

        <th width="8%">{data[0][4]}</th>

        <th width="10%">{data[0][5]}</th>

        <th width="10%">{data[0][6]}</th>

        <th width="9%">{data[0][7]}</th>

        <th width="7%">{data[0][8]}</th>

        </tr></thead><tbody><tr>

        <td>{'</td><td>'.join(data[1])}</td>

        </tr><tr>

        <td>{'</td><td>'.join(data[2])}</td>

        </tr><tr>

        <td>{'</td><td>'.join(data[3])}</td>

        </tr><tr>

        <td>{'</td><td>'.join(data[4])}</td>

        </tr><tr>

        <td>{'</td><td>'.join(data[5])}</td>

        </tr><tr>

        <td>{'</td><td>'.join(data[6])}</td>

        </tr><tr>

        <td>{'</td><td>'.join(data[7])}</td>

        </tr><tr>

        <td>{'</td><td>'.join(data[8])}</td>

        </tr></tbody></table>""",

        table_line_separators=True,

    )

    """

    for j in range(0,8):

        stringRow = ""

        print(subjectList[j],firstSummative[j],secondSummative[j],thirdSummative[j],project[j],subjectAnnualTotal[j],subjectSessionTotal[j],subjectSessionTotal[j]/2)

        if len(subjectList[j]) < 22:

            for k in range(0, 22-len(subjectList[j])):

                subjectList[j] += " "

        average = subjectSessionTotal[j]/2

        if average < 25.0:

            stringRow += subjectList[j]+" | "+str(firstSummative[j])+" | "+str(secondSummative[j])+" | "+str(thirdSummative[j])+" | "+str(project[j])+" | "+str(subjectAnnualTotal[j])+" | "+str(subjectSessionTotal[j]) + " | "+str(average) + " | "+"D"

        else:

            stringRow += subjectList[j]+" | "+str(firstSummative[j])+" | "+str(secondSummative[j])+" | "+str(thirdSummative[j])+" | "+str(project[j])+" | "+str(subjectAnnualTotal[j])+" | "+str(subjectSessionTotal[j]) + " | "+str(average)

        pdf.cell(200,10, txt = stringRow, ln = 2, align = 'L')

        pdf.cell(200, 10, txt = "-----------------------------------------------------------------------------",ln = 2, align = 'C')

    #end of j-for loop    """

    pdf.ln(4)

    pdf.set_font("helvetica", size = 8)

    pdf.cell(150,2, txt="Attendance ________________                                              Total Marks:"+str(totalMarks)+"    Percentage:"+str(totalPercentage)+"%",align="L")

    pdf.ln(8)

    pdf.cell(150, 2, txt = "Teacher's Signature ________________                                       Signature of HOI ___________________",align = "L")

    pdf.ln(8)

    pdf.cell(150, 2, txt = "Remarks  _________________________________                Guardian's Signature ___________________",align = "L")

    pdf.ln(8)

    pdf.set_font(style="I")

    if dCounter >= 3:

        pdf.cell(150,2,txt="NOT PROMOTED."+ "FAILED IN "+str(dCounter)+" SUBJECTS. ("+str(passingGrades[dCounter])+")",align="L")

    else:

        pdf.cell(150,2,txt="PROMOTED TO CLASS X. ("+str(passingGrades[dCounter])+")",align="L")    

    pdf.output("Roll No.{0}.pdf".format(roll+1))

    nametag +=4

    print() # END OF ROLL - LOOP

KAIM Co-operative Loan Calculator

 

ENTER THE LOAN AMOUNT:

ENTER THE PRINCIPAL TO BE PAID PER MONTH:

AFTER HOW MANY MONTHS DO YOU WANT TO CLOSE THE LOAN:

THE RATE OF INTEREST is 9% (PER ANNUM):

GPF - PPF - EPF Calculator

Calculator for GPF/PPF. This calculator allows you to calculate the closing balance for a given fiscal year.
Note: Contribution done after 15th of every month will not earn interest for the given month.

Enter the balance of the last FY:

Enter the rate for Q1:

Enter the rate for Q2:

Enter the rate for Q3:

Enter the rate for Q4:

Contribution: April

Contribution: May

Contribution: June

Contribution: July

Contribution: August

Contribution: September

Contribution: October

Contribution: November

Contribution: December

Contribution: January

Contribution: February

Contribution: March

PPF Calculator - Monthly Basis

Public Provident Fund is a long-term investment option that comes with a sovereign guarantee. Not just generally higher than FD returns, the PPF scheme comes power-packed with several benefits for the common man. The interest on PPF deposits is calculated on a monthly basis but credited to the account at the end of the financial year. The interest get added to the principal and one earns interest on the interest for the coming years!
The following calculator allows you to calculate the maturity value for a specified term or for a given financial year. Assuming one is investing a regular amount monthly ( before 5^th of each month). Initial investment corresponds to the total amount for the last financial year.

For example, if someone has Rs. 250000 in his/her account for the financial year 2021-22 and he/she wants to contribute Rs. 3000 monthly for the financial year 2022-23 then the total value at the end of FY 2022-23 can be calculated by entering 250000 in the initial investment, 3000 in the monthly investment, 1 as time period and the exisiting rate.

ENTER THE INITIAL INVESTMENT:

ENTER THE MONTHLY INVESTMENT:

ENTER THE TIME PERIOD:

ENTER THE EXPECTED RATE OF INTEREST:

ICSE Java Programming String Edit 2018 Q6

Write a program to accept a string in lower case and change the first letter of every word to upper case.
Display the new string.
Sample input: we are in cyber world.
Sample output: We Are In Cyber World.

ENTER A STRING IN LOWER CASE:

 flag = False

while (flag == False):

    msg = str(input("Enter a string in lower case:"))

    if(msg.islower() == False):

        print("Every character must be in lower case, try again:")

        flag = False

    else:

        flag = True

outputmsg = []

outputmsg.append(msg[0].upper())

for k in range (1,len(msg)):

    if (msg[k-1] == ' '):

        outputmsg.append(msg[k].upper())

    else:

        outputmsg.append(msg[k])

string = ""

for i in range (len(outputmsg)):

    string += outputmsg[i]

print(string)

 import java.util.*;

public class ICSEJava {

    public static void main(String[] args) {

        String input;

        boolean flag;

        char[] output;

        Scanner in = new Scanner(System.in);

        do {

            System.out.println("Enter a string in lower case:");

            input = in.nextLine();

            flag = false;

            for (int i = 0; i < input.length(); i++) {

                if (input.charAt(i) >= 65 && input.charAt(i) <= 90) {

                    System.out.println("Every character must be in lower case, try again:");

                    flag = true;

                    break;

                }

            }

        } while (flag);

        in.close();

        output = new char[input.length()];

        output[0] = Character.toUpperCase(input.charAt(0));

        for (int k = 1; k < input.length(); k++) {

            if (input.charAt(k) == ' ') {

                output[k] = (input.charAt(k));

                output[k + 1] = Character.toUpperCase(input.charAt(k + 1));

                k += 1;

            } else

                output[k] = input.charAt(k);

        }

        for (int j = 0; j < input.length(); j++)

            System.out.print(output[j]);

    }

}

ICSE 2018 Pronic Number Question 5

Write a program to input a positive number and check and print whether it is a Pronic number or not. (Pronic number is a number which can be written as product of two consecutive integers)
Example:
12 = 3 x 4
42 = 6 x 7
20 = 4 x 5

ENTER A POSITIVE INTEGER:

 class PronicNumber:

    def pronicRepresentation(self):

        print(self.__number," is a Pronic Number. ",self.__number," = ",self.__index," x ",(self.__index+1))

    def isPronic(self):

        i = 1

        while (i*(i+1) <= self.__number):

            if(i*(i+1) == self.__number):

                self.__flag = True

                self.__index = i

                break

            i +=1

        return(self.__flag)

    def __init__(self,n):

        self.__number = n

    __number = 0

    __index = -1

    __flag = False

n = int(input("Enter a positive integer."))

obj = PronicNumber(n)

if(obj.isPronic()):

    obj.pronicRepresentation()

else:

    print(n," is not a Pronic Number.")

 import java.util.Scanner;

public class ICSEJava {

    public static void main(String[] args) {

        int n;

        Scanner in = new Scanner(System.in);

        System.out.println("Enter a positive integer:");

        n = in.nextInt();

        PronicNumber obj = new PronicNumber(n);

        if(obj.isPronic())

            obj.pronicRepresentation();

        else

            System.out.println(n+" is not a Pronic Number");

        in.close();

    }

}

class PronicNumber {

    public void pronicRepresentation() {

        System.out.println(number+" is a Pronic Number. "+number+" = "+index+" x "+(index+1));        

    }

    public boolean isPronic() {

        int i = 1;

        while(i*(i+1) <= number){

            if(i*(i+1) == number) {

                flag = true;

                index = i;

                break;

            }

            i++;

        }

        return(flag);

    }

    PronicNumber(int n){

        number = n;

        flag = false;

        index = -1;

    }

    int number;

    int index;

    boolean flag;

}