so this is homework project in which we have to open a file from excel and take the values the numbers in each line and do an operation to find a final value, however the values are all in one cell. I am struggling with just extracting each number after I append them to their respective lists. I was hoping for some guidance, thanks (code is below).
Net Cash Change,33.73,45.59,28.76,138.8,-31.34,330,564.2
import matplotlib as plt import string import numpy listfile =  yearlist =  totalrev =  opincome =  netincome =  totalassets =  totalequity =  totallib =  operating =  investing =  financing =  netchange =  filename = raw_input('Enter the name of the file:') try: fd = open(filename, "r") except IOError: print 'Bad file name, try again' # filename = raw_input('Enter the name of the file:') for line in fd: line_str = line.strip() line_str = line_str.split(',') listfile.append(line_str) yearlist.append(listfile) totalrev.append(listfile) opincome.append(listfile) netincome.append(listfile) totalassets.append(listfile) totalequity.append(listfile) totallib.append(listfile) operating.append(listfile) investing.append(listfile) financing.append(listfile) netchange.append(listfile) #ROE = netincome/totalequity #ROE = (netincome/sales)*(sales/totalassets)*(totalassests/averageequity)