8-PresentorAbsentformultiple.py

import pandas as pd 
import datetime
import csv 
current_date_and_time = datetime.date.today()
current_date_and_time_string = str(current_date_and_time)
subject=input("enter the subject or subject code- for this class")
extension = ".csv"
file_name =  current_date_and_time_string+"_"+subject+ extension
df = pd.read_csv('FinalAttendance_syntax.csv')
df.drop(df.index[0:], inplace = True)
df.to_csv(file_name, index = False)
my_csv = pd.read_csv("Dataforattendance.csv")
column_Name = my_csv.Name
column_Time= my_csv.timeinseconds
column_Id=my_csv.Id
N=len(column_Name)
i=0
if((N/2)%2==0):
    while i<N-((N/2)):
        j=1
        while j<N:
            if(column_Name[i]==column_Name[j])and(column_Id[i]==column_Id[j]):
                if(column_Time[i]<column_Time[j]):
                    entry_time=(column_Time[i])
                    exit_time=(column_Time[j])
                else:
                    entry_time=(column_Time[i])
                    exit_time=(column_Time[j])
                total_time=exit_time - entry_time
                if(total_time >= 6):
                    with open(file_name,'r+') as f:
                        myDatalist = f.readlines()
                        namelist=[]
                        for line in myDatalist:
                            entry=line.split(',')
                            namelist.append(entry[0])
                            current_date = datetime.date.today()
                        f.writelines(f'\n{column_Id[i]},{column_Name[i]},{current_date},{"Present"}')      
                elif(total_time==0):
                    j=j+1
                    continue           
                elif(total_time<6):
                    with open(file_name,'r+') as f:
                        myDatalist = f.readlines()
                        namelist=[]
                        for line in myDatalist:
                            entry=line.split(',')
                            namelist.append(entry[0])
                            current_date = datetime.date.today()
                        f.writelines(f'\n{column_Id[i]},{column_Name[i]},{current_date},{"Absent"}')              
            j=j+1
        i=i+1
elif((N/2)%2==1):
    while i<N-((N/2)):
        j=1
        while j<N:
            if(column_Name[i]==column_Name[j])and(column_Id[i]==column_Id[j]):
                if(column_Time[i]<column_Time[j]):
                    entry_time=(column_Time[i])
                    exit_time=(column_Time[j])
                else:
                    entry_time=(column_Time[i])
                    exit_time=(column_Time[j])
                total_time=exit_time - entry_time
                if(total_time >= 600):
                    with open(file_name,'r+') as f:
                        myDatalist = f.readlines()
                        namelist=[]
                        for line in myDatalist:
                            entry=line.split(',')
                            namelist.append(entry[0])
                            current_date = datetime.date.today()
                        f.writelines(f'\n{column_Id[i]},{column_Name[i]},{current_date},{"Present"}')      
                elif(total_time==0):
                    j=j+1
                    continue           
                elif(total_time<600):
                    with open(file_name,'r+') as f:
                        myDatalist = f.readlines()
                        namelist=[]
                        for line in myDatalist:
                            entry=line.split(',')
                            namelist.append(entry[0])
                            current_date = datetime.date.today()
                        f.writelines(f'\n{column_Id[i]},{column_Name[i]},{current_date},{"Absent"}')              
            j=j+1
        i=i+1
print("[INFO:THE ATTENDANCE FILE HAS BEEN UPDATED FOR TODAY]")
print("[Erasing the Datforattendance file")
print(".....")
print(".....")
df = pd.read_csv('Dataforattendance.csv')
df.drop(df.index[0:], inplace = True)
df.to_csv('Dataforattendance.csv', index = False)
print("[Erased the data]")