could not convert string to float: C

[JamesW]

Recently I have been working on a code and got stuck for days on this error. Basically the program takes a students HTML Transcript and converts it into a table created using DJANGO. The program used to work with no problems but after recent school changes in the students HTML Transcript file for students it keeps shooting out a error:

Exception Value: "Could not convert string to float:C ExceptionLocation C:\Users\CMPS\Desktop\AdvisementSystem\program\src\myproject\myproject\myapp\extractData.py in splitTR, line 14

The course numbers for all Courses switched for example, CMPS190 has changed to CMPS190B and ENG201 is now ENG201B.

How can I change the code to read that "B" in with the course number? Code is below:

 
from bs4 import BeautifulSoup
from CourseGrade import *

def splitTr(tr, grade):
    grade.department = tr.find_all('td')[0].text.lstrip()
    grade.course_num = tr.find_all('td')[1].text
    if tr.find_all('td')[2].text == "UG" or tr.find_all('td')[2].text == "GR":
        grade.course_title = tr.find_all('td')[3].text
        grade.grade = tr.find_all('td')[4].text.lstrip()
        grade.creditHour = int(float(tr.find_all('td')[5].text.lstrip()))
    else :
        grade.course_title = tr.find_all('td')[2].text
        grade.grade = tr.find_all('td')[3].text.lstrip()
        grade.creditHour = int(float(tr.find_all('td')[4].text.lstrip()))

def getDataList(student, fileName="Academic Transcript.html"):
    file = open(fileName,'r')
    soup = BeautifulSoup(file,"html.parser")

    studentName = soup.find("a", {"name":"Student Address"})
    if studentName != None:
        student.name = studentName.contents[0]
    else:
        studentName = soup.find("div","staticheaders").contents[0]
        student.name = studentName.split()[1]+ " " + studentName.split()[2]
    print(soup.find('td',attrs={'class':'dddefault','colspan':6}).contents[0])

    table = soup.find('table',attrs={'class':'datadisplaytable'})
    # print(table)
    # table_body = table.findAll('tbody')
    # print(table_body)
    trs = table.find_all('tr')
    count = 0
    term = ''
    department = ''
    course_title = ''
    grade = ''
    for tr in trs:
        if tr.find('span',attrs={'class':'fieldOrangetextbold'}):
            term = tr.span.text
            term = term.replace(":", "")
            term = term.replace("Term", "").lstrip()
            continue
        if tr.find('td',attrs={'class':'dddefault','colspan':4}) or tr.find('td',attrs={'class':'dddefault','colspan':5}):
            grade = CourseGrade()
            splitTr(tr, grade)
            grade.semester_completed = term
            appendValidData(student, grade) 
            count = count + 1

def appendValidData(student, grade):
    if grade.grade == 'A':
        student.gradeList.append(grade)
    if grade.grade == 'B':
        student.gradeList.append(grade)
    if grade.grade == 'C':
        student.gradeList.append(grade)
    if grade.grade == 'P':
        student.gradeList.append(grade)
    if grade.grade == 'TA':
        student.gradeList.append(grade)
    if grade.grade == 'TB':
        student.gradeList.append(grade)
    if grade.grade == 'TC':
        student.gradeList.append(grade)
    if grade.grade == 'TP':
        student.gradeList.append(grade)

def fillData(student,courseT):
    for grade in student.gradeList:
        gradeId = grade.department + grade.course_num
        if gradeId == courseT.courseId :
                courseT.grade = grade.grade
                if grade.semester_completed != "":
                    strList = grade.semester_completed.split(' ',3)
                    courseT.semester = strList[0]
                    if len(strList)>1:
                        courseT.year = strList[1]
                    else :
                        courseT.year = strList[0]
                    grade.isListed = True

[Marbelous]

In line 14 you are using the .lstrip() on the table data (td) from a certain table row (tr). The lstrip() function strips characters to the left of its edit point so you end up with what WAS just numbers from the right side of the data. But now, you added a 'B' to the right side. Since you can't convert a string with letters into a number you get that error. Change that line to use slicing, regular expressions or whatever you prefer for string manipulation and chop off the appended 'B'.

EDIT: BTW, your appendValidData() function is a bit repetitive. A more pythonic version would be:

def appendValidData(student, grade):
    if grade.grade in ['A', 'B', 'C', 'P', 'TA', 'TB', 'TC', 'TP']:
        student.gradeList.append(grade)

[JamesW]

The Code actually needs to incorporate B in order for the html file to be read