打印集合中的项目时，此额外行来自何处？（CSV）文件，使用Python和Spyder4

results = get_data("employeestest.csv") payrollSummaryReport(results) def get_data(fname): Function returns the dictionary with following format: { 0 : { "fname": "...", "lname": "...", "gross": "...", }, 1 : { ...., ,,,, }, }

for line in f.readlines()[1:]: result[i] = {} tmp = line.split(",") # list of values from file # access file values by their index, e.g. # tmp[0] -> first name # tmp[1] -> last name # tmp[2] -> hours # tmp[3] -> pay rate employeeRegularHours, employeeOvertimeHours = calculateRegularHours(tmp[2]) employeeOvertimeHours = calculateOvertimeHours(tmp[2]) employeeTotalHours = calculateTotalHours(employeeRegularHours, employeeOvertimeHours) print(tmp[3]) This is were I print the item but it comes out to "10 " I don't know why it skips a line. I found this error through this "TypeError:can't multiply sequence by non-int of type 'float'" at line 132 #print(employeeRegularHours) regularPayAmount = calculateRegularPay(tmp[3], employeeRegularHours) overtimePayAmount = calculateOvertimePay(tmp[3], employeeOvertimeHours) grossPayAmount = calculateGrossPay(regularPayAmount, overtimePayAmount) federalTaxWithheld = calculateFederalTax(grossPayAmount) stateTaxWithheld = calculateStateTax(grossPayAmount) medicareTaxWithheld = calculateMedicareTax(grossPayAmount) socSecTaxWithheld = calculateSocSecTax(grossPayAmount) totalTaxesWithheld = calculateTotalTaxes(federalTaxWithheld, stateTaxWithheld, medicareTaxWithheld, socSecTaxWithheld) netPayAmount = calculateNetPay(grossPayAmount, totalTaxesWithheld) #(calculateOvertimePay, calculateTotalHours) = #etc.) and store the results in dictionary # e.g: result[i]["fname"] = tmp[0] result[i]["lname"] = tmp[1] result[i]["hours"] = tmp[2] result[i]["payrate"] = tmp[3] # ... # do calculations for report # ... result[i]["regular"] = employeeRegularHours result[i]["overtime"] = employeeOvertimeHours result[i]["totalhours"] = employeeTotalHours result[i]["regPay"] = regularPayAmount result[i]["overPay"] = overtimePayAmount result[i]["gross"] = grossPayAmount result[i]["fedtax"] = federalTaxWithheld result[i]["stateTax"] = stateTaxWithheld result[i]["medTax"] = medicareTaxWithheld result[i]["socsectax"] = socSecTaxWithheld result[i]["totaltax"] = totalTaxesWithheld result[i]["netpay"] = netPayAmount i += 1 return result def calculateRegularHours(employeeHoursWorked) : #print(employeeHoursWorked) if float(employeeHoursWorked) < 40.0 : employeeRegularHours = employeeHoursWorked employeeOvertimeHours = 0.0 else: employeeRegularHours = 40.0 employeeOvertimeHours = 0.0 #employeeOvertimeHours = employeeHoursWorked - 40.0 return employeeRegularHours, employeeOvertimeHours def calculateOvertimeHours(employeeHoursWorked) : if float(employeeHoursWorked) > 40 : #float(employeeOvertimeHours) = employeeHoursWorked - 40 #print(employeeHoursWorked) employeeOvertimeHours = 0.0 else : employeeOvertimeHours = 0 return employeeOvertimeHours def calculateTotalHours(employeeRegularHours, employeeOvertimeHours) : employeeTotalHours = employeeRegularHours #+ employeeOvertimeHours return employeeTotalHours def calculateRegularPay(employeePayRate, employeeHoursWorked) : regularPayAmount = employeePayRate * employeeHoursWorked return regularPayAmount def calculateOvertimePay(employeePayRate, employeeOvertimeHours) : overtimePayRate = 1.5 overtimePayAmount = (employeePayRate * employeeOvertimeHours) * overtimePayRate return overtimePayAmount def calculateGrossPay(regularPayAmount, overtimePayAmount) : grossPayAmount = regularPayAmount + overtimePayAmount return grossPayAmount def calculateFederalTax(grossPayAmount) : federalTaxRate = 0.151 federalTaxWithheld = grossPayAmount * federalTaxRate return federalTaxWithheld def calculateStateTax(grossPayAmount) : stateTaxRate = 0.055 stateTaxWithheld = grossPayAmount * stateTaxRate return stateTaxWithheld def calculateMedicareTax(grossPayAmount) : medicareTaxRate = 0.012 medicareTaxWithheld = grossPayAmount * medicareTaxRate return medicareTaxWithheld def calculateSocSecTax(grossPayAmount) : socSecTaxRate = 0.048 socSecTaxWithheld = grossPayAmount * socSecTaxRate return socSecTaxWithheld def calculateTotalTaxes(federalTaxWithheld, stateTaxWithheld, medicareTaxWithheld, socSecTaxWithheld) : totalTaxesWithheld = federalTaxWithheld + stateTaxWithheld + medicareTaxWithheld + socSecTaxWithheld return totalTaxesWithheld def calculateNetPay(grossPayAmount, totalTaxesWithheld) : netPayAmount = grossPayAmount - totalTaxesWithheld return netPayAmount def payrollSummaryReport(vals): print() print("\t\t\t\t\t\tPayroll Summary Report") print("%-12s%-12s%-8s%-10s%-10s%-12s%-10s%-11s%-13s%-10s" %\ ("LastName", "FirstName", "Hours", "RegHours", "OTHours", "RegPay", "OTPay", "GrossPay", "Deductions", "NetPay")) for i in vals: print("%-12s%-12s%-8.2f%-10.2f%-10.2f$%-11.2f$%-9.2f$%-10.2f$%-12.2f$%-10.2f" %\ (vals[i]["fname"], vals[i]["lname"], vals[i]["gross"]))

1条回答

网友

1楼 · 发布于 2024-09-29 18:36:57

f.readlines的输出包括行尾（EOL）字符，因此，如果使用逗号拆分行并打印最后一项，它将打印值和行尾字符。如果您执行print(repr(tmp[3]))，您将看到类似'10\n'的内容

您可以像这样从生产线中剥离EOL：

tmp = line.strip().split(",")

但是，由于您正在处理csv文件，因此可以使用Python内置的csv模块，它将为您处理一些细节

import csv

# Do stuff

with open(fname, 'r', newline='') as f:
    reader = csv.reader(f)
    # Skip header row
    next(reader)

    # reader yield lists, but since we know each list will have
    # the same number of elements we can unpack them into
    # four separate variables - this is more readable than 
    # referencing by index.
    for first_name, last_name, hours, pay_rate in reader:

        employeeRegularHours, employeeOvertimeHours = calculateRegularHours(hours)
        employeeOvertimeHours = calculateOvertimeHours(hours)
        employeeTotalHours = calculateTotalHours(employeeRegularHours, employeeOvertimeHours)

        # Do more stuff

请注意，从文件读取时hours和pay_rate是字符串。如果要将它们用作数字，则需要使用int或float转换它们，具体取决于所需的数字类型

相关问题更多 >

编程相关推荐

热门问题

热门文章