File size: 1,826 Bytes
9d09bcd
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
# Importing the dependencies and connecting to SQLITE DataBase
import sqlite3
import random
connection = sqlite3.connect("./data/Student_Data.db")

# Creating a cursor object to create tables

cursor = connection.cursor()

# Basic college student information table
table_info = """ 
Create table STUDENT(
    NAME VARCHAR(25),
    YEAR INT,
    DEPARTMENT VARCHAR(25),
    SECTION VARCHAR(25),
    CGPA FLOAT,
    PROJECTS INT
);
"""

cursor.execute(table_info)

# Inserting some records

cursor.execute(''' Insert Into STUDENT values('Dhruv Pamneja', 3,'CSE','A',8.13,3)''')

names = [
    "Aarav", "Vihaan", "Advik", "Aadi", "Reyansh", "Mohammed", "Arnav", "Shaan", "Ayaan", "Krishna", 
    "Mitansh", "Atharva", "Vivaan", "Aaryan", "Ishaan", "Rudra", "Shaurya", "Darsh", "Rishabh", "Kabir",
    "Yuvan", "Ishan", "Vedant", "Sai", "Arush", "Aryan", "Aadi", "Viraj", "Advait", "Rishi",
    "Aarush", "Siddharth", "Rohan", "Aryan", "Aahan", "Vihaan", "Ayaan", "Dev", "Yuvraj", "Ritvik",
    "Tanish", "Veer", "Yash", "Samarth", "Rudransh", "Parth", "Ansh", "Vihan", "Kiaan"
]

def generate_random_data(names):
    random_data = []
    for _ in range(len(names)):
        # Ensuring to add unique names
        name = random.choice(names)
        names.remove(name)
        
        year = random.randint(1, 4)
        department = random.choice(['CSE', 'EE', 'CE', 'BE', 'PE', 'GE'])
        section = random.choice(['A', 'B', 'C', 'D', 'E'])
        cgpa = round(random.uniform(6.00, 10.00), 2)
        projects = random.randint(0, 10) 
        random_data.append((name, year, department, section, cgpa, projects))
    return random_data


random_data = generate_random_data(names)
for data in random_data:
    cursor.execute('''INSERT INTO STUDENT VALUES(?, ?, ?, ?, ?, ?)''', data)  
    
connection.commit()