100日Softwcodeの日40:パイソンを使っているデータベースのダミープロジェクト

68931 ワード
codenewbie womenintech 100daysofcode beginners テキストリンク
これは私の40日目の100日目のSoftwareとChiang ' pythonです.昨日のように、今日も、私の古いコースをCourseraから改訂し続けました.そして、バブルソート、挿入ソート、選択ソート、ヒープソートについての詳細に取り組んだ.
最後に、Pythonを使ってデータベース内のダミープロジェクトを完成させました.voterファイルからデータを読み込むデータベースを準備しました.ここで、私はGeniueデータ、詐欺データとどのくらいの票を得るパーティーのためのデータベーステーブルを用意しました.

Pythonコード
SQLite 3ライブラリをインポートします.有権者データベースとデータベースを接続します.SQLiteこれが既に存在して、票テーブルを再現するならば、テーブルを落書きしてください.オープン有権者データ.次にテーブルに値を挿入します.

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(
これは管理テーブルのPythonコードです
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()
上記のコードを出すと、
(1, 'durga2021', 'durga@2021')
(2, 'krishna2020', 'krishna@2020')
ユーザーが有効なユーザー名とパスワードを入力した場合、彼らは他のデータにアクセスできません.本物のデータ
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.")
上記のコードを実行すると、次の出力を得ることができます.
Password and Username Matched.
これは詐欺データです.
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.')
以下は、本物の票データのためのコードです.正規データのテーブルを作成します.
#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()
上記のコードを実行すると、次の出力を得ることができます.
('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')
以下のコードは、Fraudデータです.詐欺データのテーブルを作成します.

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()
上のコードを実行すると、次の出力を得る
('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')
各党がどれくらいの票を得たか
# 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()
出力は
{'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)
データベースの40日目とダミープロジェクトを使用しています
Android常用コントロール
基本的な刺激WYSIWYG Markdownエディタ