Create Student Dataset CSV File

import csv
import os
import random
import names
delimiter = ','

myCSVFileName = input('Enter a CSV Filename: ')

fileExists = os.path.isfile(myCSVFileName)

#Open the CSV File in append mode for creating the header when file does not exist,

with open(myCSVFileName,'a',newline='') as appendInToCSVFile:
csvHeader = ['REGISTRATION_NUMBER','STUDENT_NAME','STUDENT_GENDER','STUDENT_DEPARTMENT','STUDENT_CGPA','STUDENT_EMAILID','STUDENT_CONTACT_NUMBER']
MyHeader = csv.DictWriter(appendInToCSVFile,fieldnames=csvHeader)
print(MyHeader)
if not fileExists:
MyHeader.writeheader()

ID = 1
while (ID <= 3):
studentId = ID
appendInToCSVFile.write(str(studentId))
appendInToCSVFile.write(delimiter)
firstName = names.get_first_name()
lastName = names.get_last_name()
studentName = firstName+' '+lastName
appendInToCSVFile.write(studentName)
appendInToCSVFile.write(delimiter)
studentGender = random.choice(['Male','Female'])
appendInToCSVFile.write(studentGender)
appendInToCSVFile.write(delimiter)
studentDepartment = random.choice(['CSE','ECE','EEE','Mechanical','Civil','EIE'])
appendInToCSVFile.write(studentDepartment)
appendInToCSVFile.write(delimiter)
studentCGPA = round((random.uniform(5.00,10.00)),2)
appendInToCSVFile.write(str(studentCGPA))
appendInToCSVFile.write(delimiter)
emailTag = random.choice(['@gmail.com','@yahoo.co.in','@rediffmail.com','@hotmail.com'])
studentEmailId = firstName+lastName+emailTag
appendInToCSVFile.write(studentEmailId)
appendInToCSVFile.write(delimiter)
studentContactNum = random.randint(9986000000,9986999999)
appendInToCSVFile.write(str(studentContactNum))
appendInToCSVFile.write('\n')
ID+=1

Comments

Post a Comment

Popular posts from this blog

Swayamvar Program In Python

 n= int(input()) groom= input() brid=input() c_r = brid.count('r') c_m = brid.count('m') lst = [i for i in groom] for i in groom:     if i == 'r':         if c_r==0:             print(len(lst), end='')             break         c_r-=1         lst.pop(0)     elif i == 'm':         if c_m==0:             print(len(lst),end='')             break         c_m-=1         lst.pop(0) else:     print(0,end='')
Read more

VALDATION IN JAVASCRIPT

 <!DOCTYPE html> <html> </html>  <head>     <title>         Simple HTML webpage with CSS style     </title> <script> function validation() { var name=document.form["regform"]["name"]; if(name.value==null||name.value=="") {  alert("name cant be blank");  return false; } </script>       <!-- Stylesheet of web page -->     <style>         body {             text-align: center;         }           h1 {             color: green;         }     </style> </head>   <body>     <h1><form name="regform" onsubmit="return validation()" method="post"> name:<input type="text" name="name"> <input type="submit"> </form></h1>       <p>A computer science portal for geeks</p> </body>   </html>
Read more