Ask Your Question

Revision history [back]

I am getting an Index out of range Error. I am retreiving the names from sqlite3 into a list. I think the retrieval is not proper. Please help

import cv2 from playsound import playsound import numpy as np import os import time,sys import sqlite3 from openpyxl import Workbook, load_workbook from openpyxl.utils import get_column_letter, cell,column_index_from_string

recognizer = cv2.face.LBPHFaceRecognizer_create() recognizer.read('C:/Users/ACER/Desktop/Project series/Face recognition/trainer/trainer.yml') faceCascade = cv2.CascadeClassifier("C:/Users/ACER/Desktop/Python/Face recognition/HaarCascade/haarcascade_frontalface_default.xml") connect = sqlite3.connect('C:/Users/ACER/Desktop/Project series/Face recognition/sqlite3/Studentdb.db') font = cv2.FONT_HERSHEY_SIMPLEX

iniciate id counter

id= 0

Get the currentdate

currentDate = time.strftime("%d_%m_%y")

get the excel file

print( "Subjects are 'BI','SIC','PGIS','SQA','ITSM") subject=input("Enter Subject:") a=['BI','SIC','PGIS','SQA','ITSM'] sc=subject+currentDate if subject in a: print("Success") wbook = load_workbook(filename = "C:/Users/ACER/Desktop/Project series/Face recognition/Attendance/"+subject+".xlsx") sheet = wbook.get_sheet_by_name('TYBSCIT'+subject) else: print("Invalid")

names related to Ids: example ==> Vignesh: id=101, etc

names=[] cursor = connect.execute("SELECT FULLNAME from Student") rows=cursor.fetchall() names=list(rows)

Initialize and start realtime video capture

cam = cv2.VideoCapture(0) cam.set(3, 640) # set video widht cam.set(4, 480) # set video height

def getDateColumns(): for i in range(1, len(sheet.rows[0]) + 1): cols = get_column_letter(i) if sheet.cell('%s%s'% (col,'1')).value == currentDate: return cols

Define min window size to be recognized as a face

minW = 0.1cam.get(3) minH = 0.1cam.get(4) while True: ret, img =cam.read() img = cv2.flip(img,1) # Flip vertically gray = cv2.cvtColor(img,cv2.COLOR_BGR2GRAY) faces = faceCascade.detectMultiScale( gray, scaleFactor = 1.2, minNeighbors = 5, minSize = (int(minW), int(minH)), )

for(x,y,w,h) in faces:
    cv2.rectangle(img, (x,y), (x+w,y+h), (0,255,0), 2)
    id, confidence = recognizer.predict(gray[y:y+h,x:x+w])
    # Check if confidence is less then 100 ==> "0" is perfect match 
    if (confidence < 100):
        id = names[id]
        confidence = "  {0}%".format(round(100 - confidence))
        playsound("images recognized.mp3")
    else:
        ids = "Unknown"
        confidence = "  {0}%".format(round(100 - confidence))
    cv2.putText(img, str(id), (x+5,y-5), font, 1, (255,255,255), 2)
    cv2.putText(img, str(confidence), (x+5,y+h-5), font, 1, (255,255,0), 1)  
cv2.imshow('camera',img) 
k = cv2.waitKey(10) & 0xff # Press 'ESC' for exiting video
if k == 27:
    break

for row in range(2, (list(sheet.columns[0]) + 1)): rowno = sheet.cell('A%s'% row).value if rowno is not None: rowno = rowno[-2:] if attend[int(rowno)] != 0: col = getDateColumns() sheet['%s%s' % (col, str(row))]=1 wbook.save(filename="C:/Users/ACER/Desktop/Project series/Face recognition/Attendance/"+subject+currentDate+".xlsx")

Do a bit of cleanup

print("\n [INFO] Exiting Program and cleanup stuff") cam.release() cv2.destroyAllWindows()

error: Traceback (most recent call last): File "C:\Users\ACER\Desktop\Project series\Face recognition\recognize.py", line 65, in <module> id = names[id] IndexError: list index out of range

click to hide/show revision 2
None

updated 2020-03-16 11:47:12 -0600

supra56 gravatar image

I am getting an Index out of range Error. I am retreiving the names from sqlite3 into a list. I think the retrieval is not proper. Please help

Code:

import cv2
from playsound import playsound
import numpy as np
import os 
import time,sys
import sqlite3
from openpyxl import Workbook, load_workbook
from openpyxl.utils import get_column_letter, cell,column_index_from_string
 
cell,column_index_from_string

recognizer = cv2.face.LBPHFaceRecognizer_create()
recognizer.read('C:/Users/ACER/Desktop/Project series/Face recognition/trainer/trainer.yml')
faceCascade = cv2.CascadeClassifier("C:/Users/ACER/Desktop/Python/Face recognition/HaarCascade/haarcascade_frontalface_default.xml")
connect = sqlite3.connect('C:/Users/ACER/Desktop/Project series/Face recognition/sqlite3/Studentdb.db')
font = cv2.FONT_HERSHEY_SIMPLEX
 
iniciate cv2.FONT_HERSHEY_SIMPLEX
#iniciate id counter
 
counter
id= 0
 
Get 0
#Get the currentdate
 
currentdate
currentDate = time.strftime("%d_%m_%y")
 
get time.strftime("%d_%m_%y")
#get the excel file
 
file
print( "Subjects are 'BI','SIC','PGIS','SQA','ITSM")
subject=input("Enter Subject:")
a=['BI','SIC','PGIS','SQA','ITSM']
sc=subject+currentDate
if subject in a:
    print("Success")
    wbook = load_workbook(filename = "C:/Users/ACER/Desktop/Project series/Face recognition/Attendance/"+subject+".xlsx")
    sheet = wbook.get_sheet_by_name('TYBSCIT'+subject)
else:
    print("Invalid")
 
print("Invalid")
# names related to Ids: example ==> Vignesh: id=101,  etc
 
etc
names=[]
cursor = connect.execute("SELECT FULLNAME from Student")
rows=cursor.fetchall()
names=list(rows)
 
names=list(rows)
# Initialize and start realtime video capture
 
capture
cam = cv2.VideoCapture(0)
cam.set(3, 640) # set video widht
cam.set(4, 480) # set video height
 
height

def getDateColumns():
    for i in range(1, len(sheet.rows[0]) + 1):
        cols = get_column_letter(i)
        if sheet.cell('%s%s'% (col,'1')).value == currentDate:
            return cols
 
cols

# Define min window size to be recognized as a face
 
face
minW = 0.1cam.get(3)
0.1*cam.get(3)
minH = 0.1cam.get(4)
0.1*cam.get(4)
while True:
    ret, img =cam.read()
    img = cv2.flip(img,1) # Flip vertically
    gray = cv2.cvtColor(img,cv2.COLOR_BGR2GRAY)
    faces = faceCascade.detectMultiScale( 
        gray,
        scaleFactor = 1.2,
        minNeighbors = 5,
        minSize = (int(minW), int(minH)),
       )
 
)

    for(x,y,w,h) in faces:
     cv2.rectangle(img, (x,y), (x+w,y+h), (0,255,0), 2)
     id, confidence = recognizer.predict(gray[y:y+h,x:x+w])
     # Check if confidence is less then 100 ==> "0" is perfect match 
     if (confidence < 100):
         id = names[id]
         confidence = "  {0}%".format(round(100 - confidence))
         playsound("images recognized.mp3")
     else:
         ids = "Unknown"
         confidence = "  {0}%".format(round(100 - confidence))
     cv2.putText(img, str(id), (x+5,y-5), font, 1, (255,255,255), 2)
     cv2.putText(img, str(confidence), (x+5,y+h-5), font, 1, (255,255,0), 1)  
 cv2.imshow('camera',img) 
 k = cv2.waitKey(10) & 0xff # Press 'ESC' for exiting video
 if k == 27:
     break

 
 for row in range(2, (list(sheet.columns[0]) + 1)):
rowno = sheet.cell('A%s'% row).value
if rowno is not None:
rowno = rowno[-2:]
if attend[int(rowno)] != 0:
col = getDateColumns()
sheet['%s%s' % (col, str(row))]=1
wbook.save(filename="C:/Users/ACER/Desktop/Project series/Face recognition/Attendance/"+subject+currentDate+".xlsx") 
 

# Do a bit of cleanup
 
cleanup
print("\n [INFO] Exiting Program and cleanup stuff")
cam.release()
cv2.destroyAllWindows()cv2.destroyAllWindows()

error:

error: 

Traceback (most recent call last):
File "C:\Users\ACER\Desktop\Project series\Face recognition\recognize.py", line 65, in <module>
id = names[id]
IndexError: list index out of range
 
 
 
 
 
 
 
range
Copyright OpenCV foundation, 2012-2018. Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
about | faq | help | privacy policy | terms of service
Powered by Askbot version 0.10.2