DEV Community

loading...

Day 40 Of 100DaysOfCode: Dummy Project In Database Using Python

Durga Pokharel
A mathematics student learning to code.
・25 min read

This is my 40th day of #100DaysOfCode and #python. Like yesterday today also continued to revised my old courses from coursera. And worked on more about Bubble sort, Insertion sort, Selection sort, Heap sort.

Finally I completed one dummy project in database using python.I prepared database which read data from voter file. In where I prepared the database table for geniue data, fraud data and parties who get how much vote.

Python Code

First import sqlite3 library. Connect database with voter database.sqlite. Drop table Votes if this already exist and recreate the Votes table. Open voter data. Then insert value to the table.


import sqlite3

conn = sqlite3.connect('voter database.sqlite')
cur = conn.cursor()
cur.execute('''DROP TABLE IF EXISTS Votes''')
cur.execute('''CREATE TABLE Votes (Id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
                Voter_Name TEXT, Age INTEGER,Citizen_no INTEGER,Parties TEXT)''')

lines = open('vote 1.txt').read().splitlines()
for data in lines:
    data = data.split(',')
    cur.execute('''INSERT INTO Votes(Voter_Name,Age,Citizen_no,Parties)VALUES(?,?,?,?)''',(data[0],data[1],data[2],data[3]))

cur.execute('SELECT Voter_Name,Age,Citizen_no,Parties FROM Votes')
for row in cur:
    print(row)
conn.commit()

cur.close(
Enter fullscreen mode Exit fullscreen mode

This is python code for admin table

cur = conn.cursor()
cur.execute('''DROP TABLE IF EXISTS Admin''')
cur.execute('''CREATE TABLE Admin (Id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
                Name TEXT, Password INTEGER)''')


cur.execute('''INSERT INTO Admin(Name,Password)VALUES(?,?)''',('Hari','Hari@1@99'))
cur.execute('''INSERT INTO Admin(Name,Password)VALUES(?,?)''',('Ram','Ram@451'))

cur.execute('SELECT Name,Password FROM Admin')
for row in cur:
    print(row)
conn.commit()

cur.close()
Enter fullscreen mode Exit fullscreen mode

Out put of above code is,

(1, 'durga2021', 'durga@2021')
(2, 'krishna2020', 'krishna@2020')
Enter fullscreen mode Exit fullscreen mode

If user enter the valid username and password then they access to the data else not. Code for genuine data

username = ['durga2021']
password = ['durga@2021']

cur = conn.cursor()
has_access=False
cur.execute('SELECT Password FROM Admin where Username=(?)', (username))
for row in cur:
    if password[0]==row[0]:
        has_access=True
        print("Password and Username Matched.")

Enter fullscreen mode Exit fullscreen mode

When above code is run we can get following output.

Password and Username Matched.
Enter fullscreen mode Exit fullscreen mode

This is for fraud data.

cur = conn.cursor()

if has_access:
    print('Username, Password Matched.')
    data2=[]
    cur.execute('''SELECT * FROM votes''')
    for row in cur:
        if len(row[1:])>1:
            data2.append(row[1:])
            #print(row[1:])
else:
    print('Username Password can not be matched.')
Enter fullscreen mode Exit fullscreen mode

Below is the code for Genuine votes data. Created table for genuine data.

#Genuine Votes, unique data only

cur = conn.cursor()
cur.execute('''DROP TABLE IF EXISTS Genuinedata''')
cur.execute('''CREATE TABLE Genuinedata (Id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
                Voter_Name TEXT, Age INTEGER,Citizen_no INTEGER,Parties TEXT)''')


for data in data1:
    cur.execute('''INSERT INTO Genuinedata(Voter_Name,Age,Citizen_no,Parties)VALUES(?,?,?,?)''',(data[0],data[1],data[2],data[3]))

cur.execute('SELECT Voter_Name,Age,Citizen_no,Parties FROM Genuinedata')
for row in cur:
    print(row)
conn.commit()

cur.close()
Enter fullscreen mode Exit fullscreen mode

When above code run we can get following output.

('Devi Kaji', 29, '2017-11-25-23', 'D')
('Devi Thapa', 78, '2059-2-0-144', 'D')
('Devi Phuyal', 46, '2047-1-24-24', 'D')
('Devi Lama', 39, '2058-10-19-158', 'D')
('Devi Parajuli', 60, '2042-1-26-1', 'A')
('Devi Syangbo', 77, '2025-5-22-34', 'C')
('Devi Poudel', 24, '2020-5-19-133', 'C')
('Devi Sinor', 18, '2050-6-20-156', 'D')
('Devi Hajari', 27, '2022-6-0-68', 'A')
('Devi Cena', 65, '2030-2-1-48', 'D')
('Devi Bhatta', 64, '2020-8-27-133', 'D')
('Devi Bhattarai', 61, '2018-4-2-77', 'A')
('Naran Kaji', 49, '2022-11-5-158', 'D')
('Naran Thapa', 45, '2044-10-4-122', 'B')
('Naran Phuyal', 24, '2029-3-29-70', 'C')
('Naran Lama', 69, '2037-10-19-14', 'D')
('Naran Parajuli', 87, '2050-7-14-39', 'A')
('Naran Pokharel', 27, '2031-8-21-142', 'A')
('Naran Bogati', 84, '2039-8-0-139', 'A')
('Naran Poudel', 21, '2035-11-0-137', 'A')
('Naran Sinor', 85, '2050-7-16-52', 'B')
('Naran Hajari', 28, '2030-2-28-66', 'A')
('Naran Newar', 33, '2026-7-17-99', 'A')
('Naran Cena', 18, '2017-4-13-15', 'B')
('Naran Silpakar', 26, '2036-8-24-137', 'C')
('Naran Bhatta', 60, '2051-0-20-132', 'C')
('Naran Bhattarai', 75, '2046-10-17-156', 'C')
('Shyam Bahadur Phuyal', 34, '2047-1-16-138', 'A')
('Shyam Bahadur Bogati', 89, '2035-6-11-159', 'A')
('Shyam Bahadur Timilsina', 57, '2057-6-2-94', 'B')
('Shyam Bahadur Syangbo', 89, '2042-11-29-157', 'C')
('Shyam Bahadur Poudel', 31, '2055-5-4-66', 'C')
('Shyam Bahadur Sinor', 27, '2042-2-24-120', 'C')
('Shyam Bahadur Hajari', 37, '2052-5-12-117', 'C')
('Shyam Bahadur Newar', 60, '2023-11-8-55', 'A')
('Shyam Bahadur Cena', 80, '2017-6-23-23', 'D')
('Shyam Bahadur Silpakar', 83, '2053-2-8-19', 'A')
('Shyam Bahadur Bhatta', 83, '2059-7-16-125', 'D')
('Torpe Kaji', 69, '2051-6-17-138', 'B')
('Torpe Thapa', 85, '2020-8-9-4', 'A')
('Torpe Phuyal', 68, '2043-8-26-79', 'B')
('Torpe Lama', 24, '2022-3-11-0', 'A')
('Torpe Parajuli', 36, '2022-9-16-80', 'D')
('Torpe Pokharel', 39, '2039-7-5-74', 'B')
('Torpe Sharma', 88, '2026-10-17-100', 'C')
('Torpe Bogati', 49, '2048-1-20-17', 'C')
('Torpe Timilsina', 79, '2018-3-3-130', 'A')
('Torpe Syangbo', 21, '2036-7-2-141', 'A')
('Torpe Silpakar', 57, '2045-1-7-144', 'C')
('Torpe Bhatta', 35, '2056-7-27-13', 'A')
('Torpe Bhattarai', 86, '2051-4-12-18', 'A')
('Ram Kaji', 61, '2049-0-2-68', 'A')
('Ram Thapa', 34, '2025-9-12-144', 'C')
('Ram Phuyal', 44, '2047-8-23-2', 'A')
('Ram Lama', 29, '2056-2-16-69', 'C')
('Ram Pokharel', 34, '2022-3-5-6', 'A')
('Ram Bogati', 37, '2031-0-29-32', 'C')
('Ram Timilsina', 60, '2033-10-22-82', 'B')
('Ram Newar', 59, '2021-8-1-146', 'D')
('Ram Cena', 63, '2042-3-11-108', 'B')
('Ram Silpakar', 88, '2029-4-11-65', 'B')
('Ram Bhatta', 18, '2026-9-13-132', 'D')
('Hari Phuyal', 25, '2050-8-13-35', 'B')
('Hari Lama', 31, '2053-5-11-139', 'C')
('Hari Parajuli', 65, '2044-10-15-27', 'B')
('Hari Sharma', 49, '2057-7-15-82', 'A')
('Hari Timilsina', 79, '2030-1-12-133', 'D')
('Hari Syangbo', 48, '2042-7-8-80', 'D')
('Hari Poudel', 89, '2017-5-24-102', 'D')
('Hari Sinor', 89, '2021-9-4-53', 'C')
('Hari Hajari', 49, '2051-2-9-34', 'D')
('Hari Newar', 70, '2020-4-26-35', 'A')
('Hari Silpakar', 29, '2018-0-7-127', 'C')
('Hari Bhatta', 59, '2026-4-9-157', 'B')
('Hari Bhattarai', 59, '2052-8-1-159', 'C')
('Bahadur Kaji', 20, '2054-2-6-127', 'D')
('Bahadur Thapa', 74, '2044-8-13-128', 'A')
('Bahadur Phuyal', 45, '2042-2-8-20', 'D')
('Bahadur Parajuli', 52, '2044-0-15-49', 'C')
('Bahadur Pokharel', 73, '2039-7-21-145', 'C')
('Bahadur Sharma', 27, '2028-9-1-111', 'B')
('Bahadur Bogati', 86, '2030-11-19-24', 'D')
('Bahadur Timilsina', 49, '2041-6-26-97', 'D')
('Bahadur Sinor', 62, '2020-3-3-154', 'C')
('Bahadur Hajari', 75, '2038-4-14-81', 'B')
('Bahadur Newar', 50, '2040-6-24-101', 'A')
('Bahadur Cena', 62, '2017-10-7-99', 'C')
('Bahadur Silpakar', 89, '2051-4-26-42', 'C')
('Bahadur Bhattarai', 78, '2051-7-17-113', 'C')
('Shayam Thapa', 86, '2040-5-12-99', 'A')
('Shayam Phuyal', 26, '2047-5-3-7', 'D')
('Shayam Lama', 62, '2036-8-18-107', 'C')
('Shayam Pokharel', 41, '2022-9-25-96', 'D')
('Shayam Timilsina', 81, '2046-8-6-113', 'B')
('Shayam Poudel', 53, '2030-4-0-20', 'A')
('Shayam Sinor', 35, '2049-9-25-134', 'B')
('Shayam Hajari', 51, '2038-1-24-86', 'A')
('Shayam Silpakar', 25, '2035-6-2-22', 'D')
('Shayam Bhatta', 75, '2059-10-18-112', 'A')
('Shayam Bhattarai', 50, '2043-5-28-88', 'A')
('Gita Kaji', 27, '2032-4-23-120', 'A')
('Gita Lama', 53, '2031-2-25-8', 'A')
('Gita Pokharel', 16, '2019-11-29-50', 'C')
('Gita Bogati', 47, '2041-7-13-14', 'D')
('Gita Timilsina', 71, '2024-2-25-133', 'A')
('Gita Syangbo', 43, '2038-10-24-84', 'C')
('Gita Poudel', 82, '2057-0-22-77', 'B')
('Gita Sinor', 69, '2023-11-2-67', 'A')
('Gita Newar', 56, '2044-5-21-58', 'B')
('Gita Silpakar', 56, '2029-3-6-3', 'D')
('Gita Bhatta', 31, '2022-6-23-55', 'B')
('Gita Bhattarai', 81, '2021-11-27-144', 'C')
('Chari Kaji', 78, '2043-8-15-115', 'C')
('Chari Thapa', 49, '2020-9-3-49', 'C')
('Chari Phuyal', 89, '2047-0-18-145', 'B')
('Chari Lama', 67, '2031-1-16-68', 'B')
('Chari Parajuli', 66, '2044-5-4-10', 'B')
('Chari Pokharel', 75, '2027-2-19-36', 'B')
('Chari Sharma', 88, '2041-8-19-23', 'C')
('Chari Bogati', 16, '2027-8-8-86', 'C')
('Chari Syangbo', 23, '2059-8-10-10', 'C')
('Chari Cena', 76, '2032-7-0-157', 'C')
('Chari Bhattarai', 70, '2016-6-8-47', 'D')
('Gauthali Thapa', 41, '2057-6-25-80', 'C')
('Gauthali Phuyal', 25, '2058-10-4-106', 'C')
('Gauthali Parajuli', 80, '2031-1-17-72', 'D')
('Gauthali Sharma', 35, '2037-0-29-114', 'B')
('Gauthali Bogati', 87, '2040-2-17-42', 'B')
('Gauthali Syangbo', 57, '2035-9-2-3', 'B')
('Gauthali Poudel', 50, '2036-1-11-26', 'B')
('Gauthali Sinor', 45, '2027-11-23-81', 'D')
('Gauthali Hajari', 20, '2059-2-8-98', 'C')
('Gauthali Cena', 26, '2042-1-21-46', 'B')
('Gauthali Silpakar', 49, '2017-9-27-59', 'D')
('Gauthali Bhatta', 89, '2041-5-23-25', 'A')
('Pankaj Kaji', 25, '2017-1-25-22', 'B')
('Pankaj Thapa', 56, '2033-4-6-103', 'B')
('Pankaj Lama', 47, '2040-9-5-133', 'C')
('Pankaj Parajuli', 35, '2019-0-13-11', 'C')
('Pankaj Sharma', 38, '2037-10-20-141', 'C')
('Pankaj Timilsina', 60, '2016-4-10-81', 'C')
('Pankaj Syangbo', 68, '2025-0-19-90', 'B')
('Pankaj Poudel', 39, '2034-9-22-121', 'B')
('Pankaj Sinor', 78, '2022-10-14-112', 'B')
('Pankaj Newar', 24, '2059-1-15-32', 'A')
('Pankaj Cena', 34, '2024-10-11-153', 'C')
('Pankaj Silpakar', 62, '2033-3-20-128', 'A')
('Pankaj Bhatta', 54, '2035-6-27-121', 'A')
('Pankaj Bhattarai', 49, '2049-4-5-68', 'D')
('Sita Kaji', 27, '2045-0-11-53', 'C')
('Sita Thapa', 30, '2028-5-5-75', 'A')
('Sita Phuyal', 85, '2024-6-14-136', 'A')
('Sita Lama', 89, '2059-4-5-105', 'C')
('Sita Parajuli', 20, '2029-7-18-1', 'B')
('Sita Pokharel', 23, '2059-6-25-113', 'C')
('Sita Sharma', 81, '2047-11-4-89', 'D')
('Sita Poudel', 66, '2048-8-19-51', 'B')
('Sita Hajari', 62, '2049-0-1-84', 'A')
('Sita Newar', 63, '2046-6-7-94', 'B')
('Sita Cena', 50, '2017-8-16-121', 'C')
('Sita Silpakar', 70, '2053-0-22-94', 'C')
('Sita Bhatta', 37, '2053-11-25-71', 'B')
('Sita Bhattarai', 19, '2017-0-2-28', 'B')
('Adesh Kaji', 74, '2054-5-2-42', 'D')
('Adesh Thapa', 32, '2041-3-12-74', 'B')
('Adesh Pokharel', 81, '2045-10-17-18', 'C')
('Adesh Sharma', 49, '2019-5-16-117', 'A')
('Adesh Bogati', 63, '2040-8-21-68', 'D')
('Adesh Timilsina', 55, '2058-10-4-60', 'C')
('Adesh Syangbo', 46, '2050-2-9-154', 'D')
('Adesh Newar', 44, '2029-5-7-9', 'A')
('Adesh Cena', 46, '2056-0-23-141', 'A')
('Adesh Bhattarai', 68, '2059-9-17-92', 'C')
('Durga Thapa', 60, '2040-3-22-136', 'B')
('Durga Lama', 71, '2054-7-10-133', 'D')
('Durga Pokharel', 54, '2038-4-17-64', 'A')
('Durga Sharma', 22, '2049-1-13-11', 'D')
('Durga Bogati', 43, '2043-4-6-20', 'C')
('Durga Syangbo', 76, '2047-9-22-111', 'B')
('Durga Poudel', 70, '2033-1-3-70', 'D')
('Durga Sinor', 44, '2057-1-5-4', 'A')
('Durga Hajari', 76, '2054-2-24-149', 'A')
('Durga Newar', 67, '2024-6-16-52', 'D')
('Durga Silpakar', 70, '2021-11-6-125', 'B')
('Durga Bhatta', 62, '2025-1-9-121', 'D')
('Durga Bhattarai', 26, '2043-9-19-45', 'D')
('Ramkumar Kaji', 65, '2050-9-17-123', 'B')
('Ramkumar Thapa', 41, '2029-7-18-156', 'A')
('Ramkumar Phuyal', 64, '2059-6-26-103', 'D')
('Ramkumar Lama', 54, '2040-8-1-132', 'A')
('Ramkumar Parajuli', 41, '2035-10-14-125', 'B')
('Ramkumar Pokharel', 16, '2037-0-1-50', 'B')
('Ramkumar Sharma', 47, '2045-7-1-61', 'B')
('Ramkumar Bogati', 88, '2040-4-20-151', 'A')
('Ramkumar Timilsina', 40, '2054-4-27-42', 'C')
('Ramkumar Syangbo', 45, '2059-5-12-108', 'B')
('Ramkumar Poudel', 17, '2030-11-14-40', 'D')
('Ramkumar Sinor', 16, '2029-6-9-124', 'C')
('Ramkumar Hajari', 80, '2058-0-8-68', 'D')
('Ramkumar Newar', 72, '2056-3-14-154', 'B')
('Ramkumar Bhatta', 54, '2032-7-0-115', 'D')
('Ramkumar Bhattarai', 29, '2034-7-23-10', 'D')
('Sailesh Kaji', 22, '2025-2-8-11', 'A')
('Sailesh Thapa', 70, '2029-1-5-8', 'D')
('Sailesh Phuyal', 68, '2042-8-21-18', 'A')
('Sailesh Lama', 20, '2053-4-9-25', 'A')
('Sailesh Sharma', 85, '2017-2-11-109', 'B')
('Sailesh Poudel', 24, '2046-11-27-19', 'B')
('Sailesh Sinor', 68, '2036-3-10-48', 'B')
('Sailesh Newar', 17, '2032-6-29-139', 'B')
('Sailesh Cena', 71, '2025-11-15-87', 'C')
('Sailesh Silpakar', 28, '2023-9-20-81', 'B')
('Sailesh Bhatta', 45, '2029-3-2-78', 'B')
('Johnny Thapa', 84, '2033-7-7-99', 'C')
('Johnny Lama', 83, '2045-10-10-118', 'D')
('Johnny Pokharel', 43, '2034-4-27-18', 'D')
('Johnny Sharma', 17, '2034-4-9-119', 'C')
('Johnny Timilsina', 75, '2030-0-28-43', 'B')
('Johnny Syangbo', 23, '2047-1-4-3', 'D')
('Johnny Poudel', 53, '2054-4-24-157', 'A')
('Johnny Sinor', 53, '2050-10-12-103', 'A')
('Johnny Hajari', 21, '2022-0-22-9', 'D')
('Johnny Newar', 74, '2026-4-18-49', 'C')
('Johnny Silpakar', 40, '2033-11-15-40', 'C')
('Jonisha Phuyal', 58, '2032-10-26-145', 'B')
('Jonisha Parajuli', 18, '2019-2-19-154', 'A')
('Jonisha Timilsina', 57, '2055-6-11-158', 'C')
('Jonisha Poudel', 36, '2037-11-3-19', 'A')
('Jonisha Sinor', 61, '2016-9-1-104', 'A')
('Jonisha Hajari', 36, '2040-10-22-17', 'D')
('Jonisha Newar', 71, '2035-10-12-60', 'C')
('Jonisha Cena', 80, '2034-9-26-18', 'A')
('Jonisha Silpakar', 24, '2036-9-22-115', 'D')
('Jonisha Bhatta', 51, '2059-6-16-19', 'B')
('Jonisha Bhattarai', 71, '2027-10-26-125', 'B')
('Aanish Phuyal', 64, '2056-10-25-86', 'C')
('Aanish Lama', 81, '2048-0-0-17', 'C')
('Aanish Parajuli', 74, '2027-4-6-23', 'C')
('Aanish Sharma', 82, '2032-5-20-46', 'D')
('Aanish Syangbo', 70, '2058-9-12-92', 'A')
('Aanish Sinor', 50, '2056-10-2-86', 'A')
('Aanish Newar', 24, '2037-5-1-105', 'B')
('Aanish Silpakar', 71, '2039-4-12-117', 'A')
Enter fullscreen mode Exit fullscreen mode

Code below is for Fraude data. Create table for fraud data.


cur = conn.cursor()
cur.execute('''DROP TABLE IF EXISTS Frauddata''')
cur.execute('''CREATE TABLE Frauddata (Id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
                Voter_Name TEXT, Age INTEGER,Citizen_no INTEGER,Parties TEXT)''')


for data in data2:
    cur.execute('''INSERT INTO Frauddata(Voter_Name,Age,Citizen_no,Parties)VALUES(?,?,?,?)''',(data[0],data[1],data[2],data[3]))

cur.execute('SELECT Voter_Name,Age,Citizen_no,Parties FROM Frauddata')
for row in cur:
    print(row)
conn.commit()

cur.close()
Enter fullscreen mode Exit fullscreen mode

When above code run we get following output

('Devi Kaji', 29, '2017-11-25-23', 'D')
('Devi Thapa', 78, '2059-2-0-144', 'D')
('Devi Phuyal', 46, '2047-1-24-24', 'D')
('Devi Lama', 39, '2058-10-19-158', 'D')
('Devi Parajuli', 60, '2042-1-26-1', 'A')
('Devi Parajuli', 60, '2042-1-26-1', 'A')
('Devi Parajuli', 60, '2042-1-26-1', 'A')
('Devi Parajuli', 60, '2042-1-26-1', 'A')
('Devi Parajuli', 60, '2042-1-26-1', 'A')
('Devi Parajuli', 60, '2042-1-26-1', 'A')
('Devi Parajuli', 60, '2042-1-26-1', 'A')
('Devi Parajuli', 60, '2042-1-26-1', 'A')
('Devi Parajuli', 60, '2042-1-26-1', 'A')
('Devi Syangbo', 77, '2025-5-22-34', 'C')
('Devi Poudel', 24, '2020-5-19-133', 'C')
('Devi Sinor', 18, '2050-6-20-156', 'D')
('Devi Hajari', 27, '2022-6-0-68', 'A')
('Devi Hajari', 27, '2022-6-0-68', 'A')
('Devi Hajari', 27, '2022-6-0-68', 'A')
('Devi Cena', 65, '2030-2-1-48', 'D')
('Devi Cena', 65, '2030-2-1-48', 'D')
('Devi Cena', 65, '2030-2-1-48', 'D')
('Devi Bhatta', 64, '2020-8-27-133', 'D')
('Devi Bhattarai', 61, '2018-4-2-77', 'A')
('Naran Kaji', 49, '2022-11-5-158', 'D')
('Naran Thapa', 45, '2044-10-4-122', 'B')
('Naran Phuyal', 24, '2029-3-29-70', 'C')
('Naran Lama', 69, '2037-10-19-14', 'D')
('Naran Parajuli', 87, '2050-7-14-39', 'A')
('Naran Pokharel', 27, '2031-8-21-142', 'A')
('Naran Pokharel', 27, '2031-8-21-142', 'A')
('Naran Pokharel', 27, '2031-8-21-142', 'A')
('Naran Bogati', 84, '2039-8-0-139', 'A')
('Naran Bogati', 84, '2039-8-0-139', 'A')
('Naran Bogati', 84, '2039-8-0-139', 'A')
('Naran Bogati', 84, '2039-8-0-139', 'A')
('Naran Bogati', 84, '2039-8-0-139', 'A')
('Naran Poudel', 21, '2035-11-0-137', 'A')
('Naran Sinor', 85, '2050-7-16-52', 'B')
('Naran Hajari', 28, '2030-2-28-66', 'A')
('Naran Newar', 33, '2026-7-17-99', 'A')
('Naran Cena', 18, '2017-4-13-15', 'B')
('Naran Silpakar', 26, '2036-8-24-137', 'C')
('Naran Bhatta', 60, '2051-0-20-132', 'C')
('Naran Bhattarai', 75, '2046-10-17-156', 'C')
('Naran Bhattarai', 75, '2046-10-17-156', 'C')
('Naran Bhattarai', 75, '2046-10-17-156', 'C')
('Naran Bhattarai', 75, '2046-10-17-156', 'C')
('Naran Bhattarai', 75, '2046-10-17-156', 'C')
('Shyam Bahadur Phuyal', 34, '2047-1-16-138', 'A')
('Shyam Bahadur Phuyal', 34, '2047-1-16-138', 'A')
('Shyam Bahadur Phuyal', 34, '2047-1-16-138', 'A')
('Shyam Bahadur Phuyal', 34, '2047-1-16-138', 'A')
('Shyam Bahadur Phuyal', 34, '2047-1-16-138', 'A')
('Shyam Bahadur Phuyal', 34, '2047-1-16-138', 'A')
('Shyam Bahadur Phuyal', 34, '2047-1-16-138', 'A')
('Shyam Bahadur Phuyal', 34, '2047-1-16-138', 'A')
('Shyam Bahadur Phuyal', 34, '2047-1-16-138', 'A')
('Shyam Bahadur Bogati', 89, '2035-6-11-159', 'A')
('Shyam Bahadur Timilsina', 57, '2057-6-2-94', 'B')
('Shyam Bahadur Syangbo', 89, '2042-11-29-157', 'C')
('Shyam Bahadur Poudel', 31, '2055-5-4-66', 'C')
('Shyam Bahadur Sinor', 27, '2042-2-24-120', 'C')
('Shyam Bahadur Hajari', 37, '2052-5-12-117', 'C')
('Shyam Bahadur Newar', 60, '2023-11-8-55', 'A')
('Shyam Bahadur Cena', 80, '2017-6-23-23', 'D')
('Shyam Bahadur Silpakar', 83, '2053-2-8-19', 'A')
('Shyam Bahadur Bhatta', 83, '2059-7-16-125', 'D')
('Shyam Bahadur Bhatta', 83, '2059-7-16-125', 'D')
('Shyam Bahadur Bhatta', 83, '2059-7-16-125', 'D')
('Torpe Kaji', 69, '2051-6-17-138', 'B')
('Torpe Thapa', 85, '2020-8-9-4', 'A')
('Torpe Phuyal', 68, '2043-8-26-79', 'B')
('Torpe Lama', 24, '2022-3-11-0', 'A')
('Torpe Parajuli', 36, '2022-9-16-80', 'D')
('Torpe Pokharel', 39, '2039-7-5-74', 'B')
('Torpe Sharma', 88, '2026-10-17-100', 'C')
('Torpe Bogati', 49, '2048-1-20-17', 'C')
('Torpe Timilsina', 79, '2018-3-3-130', 'A')
('Torpe Syangbo', 21, '2036-7-2-141', 'A')
('Torpe Syangbo', 21, '2036-7-2-141', 'A')
('Torpe Syangbo', 21, '2036-7-2-141', 'A')
('Torpe Syangbo', 21, '2036-7-2-141', 'A')
('Torpe Syangbo', 21, '2036-7-2-141', 'A')
('Torpe Syangbo', 21, '2036-7-2-141', 'A')
('Torpe Syangbo', 21, '2036-7-2-141', 'A')
('Torpe Syangbo', 21, '2036-7-2-141', 'A')
('Torpe Syangbo', 21, '2036-7-2-141', 'A')
('Torpe Syangbo', 21, '2036-7-2-141', 'A')
('Torpe Syangbo', 21, '2036-7-2-141', 'A')
('Torpe Silpakar', 57, '2045-1-7-144', 'C')
('Torpe Bhatta', 35, '2056-7-27-13', 'A')
('Torpe Bhattarai', 86, '2051-4-12-18', 'A')
('Ram Kaji', 61, '2049-0-2-68', 'A')
('Ram Thapa', 34, '2025-9-12-144', 'C')
('Ram Phuyal', 44, '2047-8-23-2', 'A')
('Ram Lama', 29, '2056-2-16-69', 'C')
('Ram Lama', 29, '2056-2-16-69', 'C')
('Ram Lama', 29, '2056-2-16-69', 'C')
('Ram Pokharel', 34, '2022-3-5-6', 'A')
('Ram Pokharel', 34, '2022-3-5-6', 'A')
('Ram Pokharel', 34, '2022-3-5-6', 'A')
('Ram Bogati', 37, '2031-0-29-32', 'C')
('Ram Timilsina', 60, '2033-10-22-82', 'B')
('Ram Timilsina', 60, '2033-10-22-82', 'B')
('Ram Timilsina', 60, '2033-10-22-82', 'B')
('Ram Timilsina', 60, '2033-10-22-82', 'B')
('Ram Timilsina', 60, '2033-10-22-82', 'B')
('Ram Timilsina', 60, '2033-10-22-82', 'B')
('Ram Timilsina', 60, '2033-10-22-82', 'B')
('Ram Timilsina', 60, '2033-10-22-82', 'B')
('Ram Timilsina', 60, '2033-10-22-82', 'B')
('Ram Newar', 59, '2021-8-1-146', 'D')
('Ram Cena', 63, '2042-3-11-108', 'B')
('Ram Silpakar', 88, '2029-4-11-65', 'B')
('Ram Bhatta', 18, '2026-9-13-132', 'D')
('Ram Bhatta', 18, '2026-9-13-132', 'D')
('Ram Bhatta', 18, '2026-9-13-132', 'D')
('Ram Bhatta', 18, '2026-9-13-132', 'D')
('Ram Bhatta', 18, '2026-9-13-132', 'D')
('Ram Bhatta', 18, '2026-9-13-132', 'D')
('Ram Bhatta', 18, '2026-9-13-132', 'D')
('Hari Phuyal', 25, '2050-8-13-35', 'B')
('Hari Lama', 31, '2053-5-11-139', 'C')
('Hari Parajuli', 65, '2044-10-15-27', 'B')
('Hari Parajuli', 65, '2044-10-15-27', 'B')
('Hari Parajuli', 65, '2044-10-15-27', 'B')
('Hari Sharma', 49, '2057-7-15-82', 'A')
('Hari Sharma', 49, '2057-7-15-82', 'A')
('Hari Sharma', 49, '2057-7-15-82', 'A')
('Hari Timilsina', 79, '2030-1-12-133', 'D')
('Hari Syangbo', 48, '2042-7-8-80', 'D')
('Hari Poudel', 89, '2017-5-24-102', 'D')
('Hari Sinor', 89, '2021-9-4-53', 'C')
('Hari Hajari', 49, '2051-2-9-34', 'D')
('Hari Newar', 70, '2020-4-26-35', 'A')
('Hari Newar', 70, '2020-4-26-35', 'A')
('Hari Newar', 70, '2020-4-26-35', 'A')
('Hari Silpakar', 29, '2018-0-7-127', 'C')
('Hari Bhatta', 59, '2026-4-9-157', 'B')
('Hari Bhattarai', 59, '2052-8-1-159', 'C')
('Bahadur Kaji', 20, '2054-2-6-127', 'D')
('Bahadur Thapa', 74, '2044-8-13-128', 'A')
('Bahadur Phuyal', 45, '2042-2-8-20', 'D')
('Bahadur Phuyal', 45, '2042-2-8-20', 'D')
('Bahadur Phuyal', 45, '2042-2-8-20', 'D')
('Bahadur Parajuli', 52, '2044-0-15-49', 'C')
('Bahadur Pokharel', 73, '2039-7-21-145', 'C')
('Bahadur Sharma', 27, '2028-9-1-111', 'B')
('Bahadur Bogati', 86, '2030-11-19-24', 'D')
('Bahadur Timilsina', 49, '2041-6-26-97', 'D')
('Bahadur Timilsina', 49, '2041-6-26-97', 'D')
('Bahadur Timilsina', 49, '2041-6-26-97', 'D')
('Bahadur Timilsina', 49, '2041-6-26-97', 'D')
('Bahadur Timilsina', 49, '2041-6-26-97', 'D')
('Bahadur Sinor', 62, '2020-3-3-154', 'C')
('Bahadur Hajari', 75, '2038-4-14-81', 'B')
('Bahadur Newar', 50, '2040-6-24-101', 'A')
('Bahadur Cena', 62, '2017-10-7-99', 'C')
('Bahadur Silpakar', 89, '2051-4-26-42', 'C')
('Bahadur Silpakar', 89, '2051-4-26-42', 'C')
('Bahadur Silpakar', 89, '2051-4-26-42', 'C')
('Bahadur Bhattarai', 78, '2051-7-17-113', 'C')
('Bahadur Bhattarai', 78, '2051-7-17-113', 'C')
('Bahadur Bhattarai', 78, '2051-7-17-113', 'C')
('Shayam Thapa', 86, '2040-5-12-99', 'A')
('Shayam Phuyal', 26, '2047-5-3-7', 'D')
('Shayam Lama', 62, '2036-8-18-107', 'C')
('Shayam Lama', 62, '2036-8-18-107', 'C')
('Shayam Lama', 62, '2036-8-18-107', 'C')
('Shayam Pokharel', 41, '2022-9-25-96', 'D')
('Shayam Pokharel', 41, '2022-9-25-96', 'D')
('Shayam Pokharel', 41, '2022-9-25-96', 'D')
('Shayam Pokharel', 41, '2022-9-25-96', 'D')
('Shayam Pokharel', 41, '2022-9-25-96', 'D')
('Shayam Timilsina', 81, '2046-8-6-113', 'B')
('Shayam Timilsina', 81, '2046-8-6-113', 'B')
('Shayam Timilsina', 81, '2046-8-6-113', 'B')
('Shayam Poudel', 53, '2030-4-0-20', 'A')
('Shayam Sinor', 35, '2049-9-25-134', 'B')
('Shayam Hajari', 51, '2038-1-24-86', 'A')
('Shayam Hajari', 51, '2038-1-24-86', 'A')
('Shayam Hajari', 51, '2038-1-24-86', 'A')
('Shayam Hajari', 51, '2038-1-24-86', 'A')
('Shayam Hajari', 51, '2038-1-24-86', 'A')
('Shayam Silpakar', 25, '2035-6-2-22', 'D')
('Shayam Bhatta', 75, '2059-10-18-112', 'A')
('Shayam Bhattarai', 50, '2043-5-28-88', 'A')
('Gita Kaji', 27, '2032-4-23-120', 'A')
('Gita Kaji', 27, '2032-4-23-120', 'A')
('Gita Kaji', 27, '2032-4-23-120', 'A')
('Gita Kaji', 27, '2032-4-23-120', 'A')
('Gita Kaji', 27, '2032-4-23-120', 'A')
('Gita Lama', 53, '2031-2-25-8', 'A')
('Gita Lama', 53, '2031-2-25-8', 'A')
('Gita Lama', 53, '2031-2-25-8', 'A')
('Gita Pokharel', 16, '2019-11-29-50', 'C')
('Gita Pokharel', 16, '2019-11-29-50', 'C')
('Gita Pokharel', 16, '2019-11-29-50', 'C')
('Gita Bogati', 47, '2041-7-13-14', 'D')
('Gita Timilsina', 71, '2024-2-25-133', 'A')
('Gita Syangbo', 43, '2038-10-24-84', 'C')
('Gita Poudel', 82, '2057-0-22-77', 'B')
('Gita Sinor', 69, '2023-11-2-67', 'A')
('Gita Sinor', 69, '2023-11-2-67', 'A')
('Gita Sinor', 69, '2023-11-2-67', 'A')
('Gita Newar', 56, '2044-5-21-58', 'B')
('Gita Newar', 56, '2044-5-21-58', 'B')
('Gita Newar', 56, '2044-5-21-58', 'B')
('Gita Silpakar', 56, '2029-3-6-3', 'D')
('Gita Bhatta', 31, '2022-6-23-55', 'B')
('Gita Bhattarai', 81, '2021-11-27-144', 'C')
('Chari Kaji', 78, '2043-8-15-115', 'C')
('Chari Thapa', 49, '2020-9-3-49', 'C')
('Chari Phuyal', 89, '2047-0-18-145', 'B')
('Chari Lama', 67, '2031-1-16-68', 'B')
('Chari Parajuli', 66, '2044-5-4-10', 'B')
('Chari Pokharel', 75, '2027-2-19-36', 'B')
('Chari Sharma', 88, '2041-8-19-23', 'C')
('Chari Bogati', 16, '2027-8-8-86', 'C')
('Chari Bogati', 16, '2027-8-8-86', 'C')
('Chari Bogati', 16, '2027-8-8-86', 'C')
('Chari Syangbo', 23, '2059-8-10-10', 'C')
('Chari Syangbo', 23, '2059-8-10-10', 'C')
('Chari Syangbo', 23, '2059-8-10-10', 'C')
('Chari Syangbo', 23, '2059-8-10-10', 'C')
('Chari Syangbo', 23, '2059-8-10-10', 'C')
('Chari Syangbo', 23, '2059-8-10-10', 'C')
('Chari Syangbo', 23, '2059-8-10-10', 'C')
('Chari Syangbo', 23, '2059-8-10-10', 'C')
('Chari Syangbo', 23, '2059-8-10-10', 'C')
('Chari Cena', 76, '2032-7-0-157', 'C')
('Chari Cena', 76, '2032-7-0-157', 'C')
('Chari Cena', 76, '2032-7-0-157', 'C')
('Chari Cena', 76, '2032-7-0-157', 'C')
('Chari Cena', 76, '2032-7-0-157', 'C')
('Chari Bhattarai', 70, '2016-6-8-47', 'D')
('Chari Bhattarai', 70, '2016-6-8-47', 'D')
('Chari Bhattarai', 70, '2016-6-8-47', 'D')
('Gauthali Thapa', 41, '2057-6-25-80', 'C')
('Gauthali Phuyal', 25, '2058-10-4-106', 'C')
('Gauthali Phuyal', 25, '2058-10-4-106', 'C')
('Gauthali Phuyal', 25, '2058-10-4-106', 'C')
('Gauthali Parajuli', 80, '2031-1-17-72', 'D')
('Gauthali Parajuli', 80, '2031-1-17-72', 'D')
('Gauthali Parajuli', 80, '2031-1-17-72', 'D')
('Gauthali Sharma', 35, '2037-0-29-114', 'B')
('Gauthali Bogati', 87, '2040-2-17-42', 'B')
('Gauthali Bogati', 87, '2040-2-17-42', 'B')
('Gauthali Bogati', 87, '2040-2-17-42', 'B')
('Gauthali Syangbo', 57, '2035-9-2-3', 'B')
('Gauthali Poudel', 50, '2036-1-11-26', 'B')
('Gauthali Sinor', 45, '2027-11-23-81', 'D')
('Gauthali Hajari', 20, '2059-2-8-98', 'C')
('Gauthali Hajari', 20, '2059-2-8-98', 'C')
('Gauthali Hajari', 20, '2059-2-8-98', 'C')
('Gauthali Cena', 26, '2042-1-21-46', 'B')
('Gauthali Silpakar', 49, '2017-9-27-59', 'D')
('Gauthali Bhatta', 89, '2041-5-23-25', 'A')
('Gauthali Bhatta', 89, '2041-5-23-25', 'A')
('Gauthali Bhatta', 89, '2041-5-23-25', 'A')
('Pankaj Kaji', 25, '2017-1-25-22', 'B')
('Pankaj Thapa', 56, '2033-4-6-103', 'B')
('Pankaj Thapa', 56, '2033-4-6-103', 'B')
('Pankaj Thapa', 56, '2033-4-6-103', 'B')
('Pankaj Lama', 47, '2040-9-5-133', 'C')
('Pankaj Parajuli', 35, '2019-0-13-11', 'C')
('Pankaj Parajuli', 35, '2019-0-13-11', 'C')
('Pankaj Parajuli', 35, '2019-0-13-11', 'C')
('Pankaj Sharma', 38, '2037-10-20-141', 'C')
('Pankaj Sharma', 38, '2037-10-20-141', 'C')
('Pankaj Sharma', 38, '2037-10-20-141', 'C')
('Pankaj Timilsina', 60, '2016-4-10-81', 'C')
('Pankaj Syangbo', 68, '2025-0-19-90', 'B')
('Pankaj Poudel', 39, '2034-9-22-121', 'B')
('Pankaj Sinor', 78, '2022-10-14-112', 'B')
('Pankaj Sinor', 78, '2022-10-14-112', 'B')
('Pankaj Sinor', 78, '2022-10-14-112', 'B')
('Pankaj Newar', 24, '2059-1-15-32', 'A')
('Pankaj Cena', 34, '2024-10-11-153', 'C')
('Pankaj Silpakar', 62, '2033-3-20-128', 'A')
('Pankaj Bhatta', 54, '2035-6-27-121', 'A')
('Pankaj Bhattarai', 49, '2049-4-5-68', 'D')
('Sita Kaji', 27, '2045-0-11-53', 'C')
('Sita Thapa', 30, '2028-5-5-75', 'A')
('Sita Phuyal', 85, '2024-6-14-136', 'A')
('Sita Lama', 89, '2059-4-5-105', 'C')
('Sita Parajuli', 20, '2029-7-18-1', 'B')
('Sita Pokharel', 23, '2059-6-25-113', 'C')
('Sita Sharma', 81, '2047-11-4-89', 'D')
('Sita Sharma', 81, '2047-11-4-89', 'D')
('Sita Sharma', 81, '2047-11-4-89', 'D')
('Sita Sharma', 81, '2047-11-4-89', 'D')
('Sita Sharma', 81, '2047-11-4-89', 'D')
('Sita Sharma', 81, '2047-11-4-89', 'D')
('Sita Sharma', 81, '2047-11-4-89', 'D')
('Sita Poudel', 66, '2048-8-19-51', 'B')
('Sita Poudel', 66, '2048-8-19-51', 'B')
('Sita Poudel', 66, '2048-8-19-51', 'B')
('Sita Hajari', 62, '2049-0-1-84', 'A')
('Sita Newar', 63, '2046-6-7-94', 'B')
('Sita Cena', 50, '2017-8-16-121', 'C')
('Sita Silpakar', 70, '2053-0-22-94', 'C')
('Sita Bhatta', 37, '2053-11-25-71', 'B')
('Sita Bhattarai', 19, '2017-0-2-28', 'B')
('Adesh Kaji', 74, '2054-5-2-42', 'D')
('Adesh Thapa', 32, '2041-3-12-74', 'B')
('Adesh Thapa', 32, '2041-3-12-74', 'B')
('Adesh Thapa', 32, '2041-3-12-74', 'B')
('Adesh Thapa', 32, '2041-3-12-74', 'B')
('Adesh Thapa', 32, '2041-3-12-74', 'B')
('Adesh Thapa', 32, '2041-3-12-74', 'B')
('Adesh Thapa', 32, '2041-3-12-74', 'B')
('Adesh Pokharel', 81, '2045-10-17-18', 'C')
('Adesh Sharma', 49, '2019-5-16-117', 'A')
('Adesh Bogati', 63, '2040-8-21-68', 'D')
('Adesh Timilsina', 55, '2058-10-4-60', 'C')
('Adesh Syangbo', 46, '2050-2-9-154', 'D')
('Adesh Syangbo', 46, '2050-2-9-154', 'D')
('Adesh Syangbo', 46, '2050-2-9-154', 'D')
('Adesh Syangbo', 46, '2050-2-9-154', 'D')
('Adesh Syangbo', 46, '2050-2-9-154', 'D')
('Adesh Syangbo', 46, '2050-2-9-154', 'D')
('Adesh Syangbo', 46, '2050-2-9-154', 'D')
('Adesh Newar', 44, '2029-5-7-9', 'A')
('Adesh Cena', 46, '2056-0-23-141', 'A')
('Adesh Cena', 46, '2056-0-23-141', 'A')
('Adesh Cena', 46, '2056-0-23-141', 'A')
('Adesh Cena', 46, '2056-0-23-141', 'A')
('Adesh Cena', 46, '2056-0-23-141', 'A')
('Adesh Bhattarai', 68, '2059-9-17-92', 'C')
('Adesh Bhattarai', 68, '2059-9-17-92', 'C')
('Adesh Bhattarai', 68, '2059-9-17-92', 'C')
('Durga Thapa', 60, '2040-3-22-136', 'B')
('Durga Thapa', 60, '2040-3-22-136', 'B')
('Durga Thapa', 60, '2040-3-22-136', 'B')
('Durga Lama', 71, '2054-7-10-133', 'D')
('Durga Lama', 71, '2054-7-10-133', 'D')
('Durga Lama', 71, '2054-7-10-133', 'D')
('Durga Pokharel', 54, '2038-4-17-64', 'A')
('Durga Sharma', 22, '2049-1-13-11', 'D')
('Durga Bogati', 43, '2043-4-6-20', 'C')
('Durga Bogati', 43, '2043-4-6-20', 'C')
('Durga Bogati', 43, '2043-4-6-20', 'C')
('Durga Syangbo', 76, '2047-9-22-111', 'B')
('Durga Poudel', 70, '2033-1-3-70', 'D')
('Durga Sinor', 44, '2057-1-5-4', 'A')
('Durga Hajari', 76, '2054-2-24-149', 'A')
('Durga Newar', 67, '2024-6-16-52', 'D')
('Durga Newar', 67, '2024-6-16-52', 'D')
('Durga Newar', 67, '2024-6-16-52', 'D')
('Durga Silpakar', 70, '2021-11-6-125', 'B')
('Durga Bhatta', 62, '2025-1-9-121', 'D')
('Durga Bhattarai', 26, '2043-9-19-45', 'D')
('Ramkumar Kaji', 65, '2050-9-17-123', 'B')
('Ramkumar Thapa', 41, '2029-7-18-156', 'A')
('Ramkumar Phuyal', 64, '2059-6-26-103', 'D')
('Ramkumar Lama', 54, '2040-8-1-132', 'A')
('Ramkumar Parajuli', 41, '2035-10-14-125', 'B')
('Ramkumar Pokharel', 16, '2037-0-1-50', 'B')
('Ramkumar Sharma', 47, '2045-7-1-61', 'B')
('Ramkumar Bogati', 88, '2040-4-20-151', 'A')
('Ramkumar Timilsina', 40, '2054-4-27-42', 'C')
('Ramkumar Syangbo', 45, '2059-5-12-108', 'B')
('Ramkumar Poudel', 17, '2030-11-14-40', 'D')
('Ramkumar Sinor', 16, '2029-6-9-124', 'C')
('Ramkumar Hajari', 80, '2058-0-8-68', 'D')
('Ramkumar Newar', 72, '2056-3-14-154', 'B')
('Ramkumar Newar', 72, '2056-3-14-154', 'B')
('Ramkumar Newar', 72, '2056-3-14-154', 'B')
('Ramkumar Newar', 72, '2056-3-14-154', 'B')
('Ramkumar Newar', 72, '2056-3-14-154', 'B')
('Ramkumar Bhatta', 54, '2032-7-0-115', 'D')
('Ramkumar Bhattarai', 29, '2034-7-23-10', 'D')
('Sailesh Kaji', 22, '2025-2-8-11', 'A')
('Sailesh Thapa', 70, '2029-1-5-8', 'D')
('Sailesh Phuyal', 68, '2042-8-21-18', 'A')
('Sailesh Lama', 20, '2053-4-9-25', 'A')
('Sailesh Lama', 20, '2053-4-9-25', 'A')
('Sailesh Lama', 20, '2053-4-9-25', 'A')
('Sailesh Lama', 20, '2053-4-9-25', 'A')
('Sailesh Lama', 20, '2053-4-9-25', 'A')
('Sailesh Sharma', 85, '2017-2-11-109', 'B')
('Sailesh Sharma', 85, '2017-2-11-109', 'B')
('Sailesh Sharma', 85, '2017-2-11-109', 'B')
('Sailesh Sharma', 85, '2017-2-11-109', 'B')
('Sailesh Sharma', 85, '2017-2-11-109', 'B')
('Sailesh Sharma', 85, '2017-2-11-109', 'B')
('Sailesh Sharma', 85, '2017-2-11-109', 'B')
('Sailesh Poudel', 24, '2046-11-27-19', 'B')
('Sailesh Sinor', 68, '2036-3-10-48', 'B')
('Sailesh Sinor', 68, '2036-3-10-48', 'B')
('Sailesh Sinor', 68, '2036-3-10-48', 'B')
('Sailesh Newar', 17, '2032-6-29-139', 'B')
('Sailesh Cena', 71, '2025-11-15-87', 'C')
('Sailesh Silpakar', 28, '2023-9-20-81', 'B')
('Sailesh Bhatta', 45, '2029-3-2-78', 'B')
('Sailesh Bhatta', 45, '2029-3-2-78', 'B')
('Sailesh Bhatta', 45, '2029-3-2-78', 'B')
('Sailesh Bhatta', 45, '2029-3-2-78', 'B')
('Sailesh Bhatta', 45, '2029-3-2-78', 'B')
('Johnny Thapa', 84, '2033-7-7-99', 'C')
('Johnny Thapa', 84, '2033-7-7-99', 'C')
('Johnny Thapa', 84, '2033-7-7-99', 'C')
('Johnny Lama', 83, '2045-10-10-118', 'D')
('Johnny Lama', 83, '2045-10-10-118', 'D')
('Johnny Lama', 83, '2045-10-10-118', 'D')
('Johnny Pokharel', 43, '2034-4-27-18', 'D')
('Johnny Sharma', 17, '2034-4-9-119', 'C')
('Johnny Sharma', 17, '2034-4-9-119', 'C')
('Johnny Sharma', 17, '2034-4-9-119', 'C')
('Johnny Timilsina', 75, '2030-0-28-43', 'B')
('Johnny Syangbo', 23, '2047-1-4-3', 'D')
('Johnny Poudel', 53, '2054-4-24-157', 'A')
('Johnny Sinor', 53, '2050-10-12-103', 'A')
('Johnny Hajari', 21, '2022-0-22-9', 'D')
('Johnny Newar', 74, '2026-4-18-49', 'C')
('Johnny Newar', 74, '2026-4-18-49', 'C')
('Johnny Newar', 74, '2026-4-18-49', 'C')
('Johnny Silpakar', 40, '2033-11-15-40', 'C')
('Johnny Silpakar', 40, '2033-11-15-40', 'C')
('Johnny Silpakar', 40, '2033-11-15-40', 'C')
('Johnny Silpakar', 40, '2033-11-15-40', 'C')
('Johnny Silpakar', 40, '2033-11-15-40', 'C')
('Johnny Silpakar', 40, '2033-11-15-40', 'C')
('Johnny Silpakar', 40, '2033-11-15-40', 'C')
('Johnny Silpakar', 40, '2033-11-15-40', 'C')
('Johnny Silpakar', 40, '2033-11-15-40', 'C')
('Jonisha Phuyal', 58, '2032-10-26-145', 'B')
('Jonisha Phuyal', 58, '2032-10-26-145', 'B')
('Jonisha Phuyal', 58, '2032-10-26-145', 'B')
('Jonisha Parajuli', 18, '2019-2-19-154', 'A')
('Jonisha Parajuli', 18, '2019-2-19-154', 'A')
('Jonisha Parajuli', 18, '2019-2-19-154', 'A')
('Jonisha Parajuli', 18, '2019-2-19-154', 'A')
('Jonisha Parajuli', 18, '2019-2-19-154', 'A')
('Jonisha Parajuli', 18, '2019-2-19-154', 'A')
('Jonisha Parajuli', 18, '2019-2-19-154', 'A')
('Jonisha Timilsina', 57, '2055-6-11-158', 'C')
('Jonisha Timilsina', 57, '2055-6-11-158', 'C')
('Jonisha Timilsina', 57, '2055-6-11-158', 'C')
('Jonisha Poudel', 36, '2037-11-3-19', 'A')
('Jonisha Sinor', 61, '2016-9-1-104', 'A')
('Jonisha Hajari', 36, '2040-10-22-17', 'D')
('Jonisha Newar', 71, '2035-10-12-60', 'C')
('Jonisha Cena', 80, '2034-9-26-18', 'A')
('Jonisha Silpakar', 24, '2036-9-22-115', 'D')
('Jonisha Bhatta', 51, '2059-6-16-19', 'B')
('Jonisha Bhattarai', 71, '2027-10-26-125', 'B')
('Jonisha Bhattarai', 71, '2027-10-26-125', 'B')
('Jonisha Bhattarai', 71, '2027-10-26-125', 'B')
('Jonisha Bhattarai', 71, '2027-10-26-125', 'B')
('Jonisha Bhattarai', 71, '2027-10-26-125', 'B')
('Aanish Phuyal', 64, '2056-10-25-86', 'C')
('Aanish Lama', 81, '2048-0-0-17', 'C')
('Aanish Parajuli', 74, '2027-4-6-23', 'C')
('Aanish Parajuli', 74, '2027-4-6-23', 'C')
('Aanish Parajuli', 74, '2027-4-6-23', 'C')
('Aanish Sharma', 82, '2032-5-20-46', 'D')
('Aanish Sharma', 82, '2032-5-20-46', 'D')
('Aanish Sharma', 82, '2032-5-20-46', 'D')
('Aanish Sharma', 82, '2032-5-20-46', 'D')
('Aanish Sharma', 82, '2032-5-20-46', 'D')
('Aanish Syangbo', 70, '2058-9-12-92', 'A')
('Aanish Syangbo', 70, '2058-9-12-92', 'A')
('Aanish Syangbo', 70, '2058-9-12-92', 'A')
('Aanish Sinor', 50, '2056-10-2-86', 'A')
('Aanish Sinor', 50, '2056-10-2-86', 'A')
('Aanish Sinor', 50, '2056-10-2-86', 'A')
('Aanish Newar', 24, '2037-5-1-105', 'B')
('Aanish Newar', 24, '2037-5-1-105', 'B')
('Aanish Newar', 24, '2037-5-1-105', 'B')
('Aanish Silpakar', 71, '2039-4-12-117', 'A')
('Aanish Silpakar', 71, '2039-4-12-117', 'A')
('Aanish Silpakar', 71, '2039-4-12-117', 'A')
('Aanish Silpakar', 71, '2039-4-12-117', 'A')
('Aanish Silpakar', 71, '2039-4-12-117', 'A')
Enter fullscreen mode Exit fullscreen mode

Pyhon code for how much vote had got by respective party

# Which party win the vote
cur = conn.cursor()
cur.execute('''DROP TABLE IF EXISTS Party''')
cur.execute('''CREATE TABLE Party (Id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
                Partyname TEXT, No_Of_Vote INTEGER)''')
parties = []
for party in data1:
    party = party[3]
    parties.append(party)
#print(parties)
d = {}
for key in parties:
    if d.get(key) is not None:
        d[key] += 1
    else:
        d[key] = 1
print(d)

list =[]
for key, value in d.items():
    temp = [key,value]
    list.append(temp)
print(list)

for data in list:



     cur.execute('''INSERT INTO Party(Partyname,No_Of_Vote)VALUES(?,?)''',(data[0],data[1]))


cur.execute('SELECT * FROM Party ORDER BY Partyname')
for row in cur:
    print(row)
conn.commit()

cur.close()

Enter fullscreen mode Exit fullscreen mode

Output is,

{'D': 55, 'A': 63, 'C': 65, 'B': 60}
[['D', 55], ['A', 63], ['C', 65], ['B', 60]]
(2, 'A', 63)
(4, 'B', 60)
(3, 'C', 65)
(1, 'D', 55)
Enter fullscreen mode Exit fullscreen mode

Discussion (0)