Question

I have a python problem almost done with the problem..but still have a few more question :( will fan

Answer 1

def povertyLevel():

inFile = open('program10.txt', 'r')
outFile = open('program10-out.txt', 'w')

outFile.write(str("%12s %12s %15s\n" % ("Account #", "Income", "Members")))

lineRead = inFile.readline() # Read first record
while lineRead != '': # While there are more records

words = lineRead.split() # Split the records into substrings
acctNum = int(words[0]) # Convert first substring to integer
annualIncome = float(words[1]) # Convert second substring to float
members = int(words[2]) # Convert third substring to integer

outFile.write(str("%10d %15.2f %10d\n" % (acctNum, annualIncome, members)))

lineRead = inFile.readline() # Read next record


# Close the file.
inFile.close() # Close file

# Call the main function.
povertyLevel()

I am trying to find the average of annualIncome and what i tried to do was

avgIncome = (sum(annualIncome)/len(annualIncome))
outFile.write(avgIncome)

i did this inside the while lineRead. however it gave me an error saying

avgIncome = (sum(annualIncome)/len(annualIncome))
TypeError: 'float' object is not iterable

Answer 2

@e.mccormick

Answer 3

First, I am not sure why you are goint to an outfile. You want to read in the data, work on it, print out the results.

Answer 4

we need an output file that gives the result for the assignment

Answer 5

Ah, OK. It also needs at least 5 functions.

Answer 6

The avereage household income would be the sum of all the household incomes divided by the number of housholds. So you need to keep track of bot of those things.

Answer 7

this is my updated code

def povertyLevel():

inFile = open('program10.txt', 'r')
outFile = open('program10-out.txt', 'w')

outFile.write(str("%12s %12s %15s\n" % ("Account #", "Income", "Members")))

allIncomes = []
lineRead = inFile.readline() # Read first record
while lineRead != '': # While there are more records

words = lineRead.split() # Split the records into substrings
acctNum = int(words[0]) # Convert first substring to integer
annualIncome = float(words[1]) # Convert second substring to float
members = int(words[2]) # Convert third substring to integer

allIncomes.append(annualIncome)

outFile.write(str("%10d %15.2f %10d\n" % (acctNum, annualIncome, members)))

lineRead = inFile.readline() # Read next record

averageInc = avgIncome(allIncomes)
outFile.write(str(averageInc))



# Close the file.
inFile.close() # Close file

def avgIncome(income):
avgInc = (sum(income)/len(income))


# Call the main function.
povertyLevel()

however right now i get NONE as the output for outFile.write(str(averageInc))

Answer 8

this is my input file

Answer 9

"Write a program to read the survey results into three lists and perform the following analysis."

You need to read everything into the three lists firsts, then do the analysis. It does look like you will output everything into the Program10-out.txt file... though the program is a bit vague on some of the output.

Answer 10

See, "Count the number of households included in the survey and print it in a three-column format." Ummm... the count of the number will be just a number, so how would a number be a 3 column format? That is the vague part.

Answer 11

i got the 3 column part done for my program. now im trying to finish the average income and families above average income and poverty level

Answer 12

OK, well, for the average income you need to sum all incomes and divide by the number of households.

Lets see... hmm... so the problem is it is returning none. Wellm have you tried printing what is passed to it? See if you are actually seinding something to it. Then, see what it is getting.

Answer 13

when i print
print(averageInc)
i also get non

Answer 14

OK, so it is not getting anything back from the function... do you see why?

Answer 15

Have you been taught about the scope of a function?

Answer 16

yeah. the local and global variables right?

Answer 17

i know if i print inside def avgIncome(income) i will get the answer. however i got stuck when i tried to do
def avgIncome(income):
avgInc = (sum(income)/len(income))
outFile = open('program10-out.txt', 'w')
outFile.write("average income is " + str(avgInc))
as this wont do anything

Answer 18

Had a browser lockup, wheee...

Yes, in that case the outfile is not open in that function. So it knows nothing about the file.

Now, here is another thing to think about:

```
allincome = [12180, 13240, 19800]

def avgIncome1(input):
average = sum(input)/len(input)

def avgIncome2(input):
return sum(input)/len(input)

avg1 = avgIncome1(allincome)
avg2 = avgIncome2(allincome)

print(avg1)
print(avg2)
```
Try that code.

Answer 19

avg1 came up none
avg 2 gave solution

Answer 20

omg you're a genius! instead of doing average =
i had to change the code to
def avgIncome(income):
return(sum(income)/len(income))

Answer 21

Yah, you were not returning anything, which is wat the whole none was about. Your scope restrictions caused you to get none because you never used return to pass it back.

Answer 22

If you do things in another funtion, they need to have no need for a return (AKA: A void function/method that just outputs something) or have it return what is needed.

You could return a list, a tuple of lists, etc. You could try to do something and return true for if it worked and false for if it failed, which is used in error handling.

Answer 23

now i need to make an if statement to find each household that exceeds the average.
so would this make sense?

def povertyLevel():
inFile = open('program10.txt', 'r')
outFile = open('program10-out.txt', 'w')


outFile.write(str("%12s %12s %15s\n" % ("Account #", "Income", "Members")))

allIncomes = []
lineRead = inFile.readline() # Read first record
while lineRead != '': # While there are more records

words = lineRead.split() # Split the records into substrings
acctNum = int(words[0]) # Convert first substring to integer
annualIncome = float(words[1]) # Convert second substring to float
members = int(words[2]) # Convert third substring to integer

allIncomes.append(annualIncome)

outFile.write(str("%10d %15.2f %10d\n" % (acctNum, annualIncome, members)))

lineRead = inFile.readline() # Read next record

averageInc = (avgIncome(allIncomes))
outFile.write("average income is " + str(averageInc))
if annualIncome > averageInc :
print(acctNum, annualIncome, members)


# Close the file.
inFile.close() # Close file

def avgIncome(income):
return(sum(income)/len(income))

# Call the main function.
povertyLevel()

Answer 24

this is the solution for the program.

Answer 25

See, if you load everyting into lists, you can loop through them again and again as needed. This is important because you need all the incomes to find the average, Once you have the average you can use it to print out who is above that.

Answer 26

if i try
if annualIncome > averageInc :
print(acctNum, annualIncome, members)
i will only get the very last one
and if i try
if allIncomes > averageInc :
print(acctNum, annualIncome, members)
i get an error :(

Answer 27

Like I said, you missed one of the original instructions which is why you can't do it.

Answer 28

T_T not quite getting it :(

Answer 29

One way to solve these type of problems is to diagram out something that will satisfy the instructions given. For example:

```
main:
list_of_lists = readin(filename)
average = findAvg(list_of_lists[1])
output3col(list_of_lists, filename)
outputAbobeAvg(list_of_lists, average, filename)
outputBelowPoverty(list_of_lists, filename)

readin(fn):
reds in a file
parses it
returns a list of the lists you need

average(list)
takes in a list
returns average of that list

etc...
```

Then you just need to make code that does those actual things.

In your instructions, one of the key concepts that made me organize it this way is at the top. "Write a program to read the survey results into three lists and perform the following analysis."

So I must have three lists. Now, I can deal with these as a list of lists, or because this is Python, I think you can actually return it to three seperate lists.

Answer 30

Heck,, if you only wanted one output, you could also pass around a string to output, or make a global, keep adding to it and when it is done, push the string to a file.

Answer 31

You have made only one list. A list of the incomes. You can cycle through that list, but it does not let you access the other information. You do not have the ID numbers or the number of people in the household. You need two more lists to have all of those.

Once you have all three lists made, you can do the other evaluations. So you need to build them while you are reding in the file.

Answer 32

:D gotcha.... I'll try to grasp everything you just told me! i think im getting it! (My 3rd month doing programming)

Answer 33

Nother example for you to thiink about:
```
allIDNum = [1234, 1235, 1236]
allincome = [12180, 13240, 19800]
allHeadcount = [2, 3, 7]

for i in range(0, len(allIDNum)):
print(str(allIDNum[i]) + " " + str(allincome[i]) + " " + str(allHeadcount[i]) )
```

I do not know what loops you have done yet, but you should be able to see a path with that. I am going to head out now. Need to get home!

Answer 34

@e.mccormick thank you very much for helping me so far! i couldn't have gotten this far without you! thanks

Answer 35

np. Don't have too much fun. And I think as long as you remember the stuff about returns, that plus doing multiple lists will let you finish this.

Answer 36

thanks! i'll keep that in my mind

Answer 37

i'm overwhelmed by this problem.. i have no idea how to figure it out :(

Answer 38

What are you stuck on?

Answer 39

Like I said, you have one list and you need three. If you make three lists when you are loading stuff from the file, then you can do the rest.

Answer 40

def povertyLevel():
inFile = open('program10.txt', 'r')
outFile = open('program10-out.txt', 'w')


outFile.write(str("%12s %12s %15s\n" % ("Account #", "Income", "Members")))

allIncomes = []
numMembers = []
accountNum = []
lineRead = inFile.readline() # Read first record
while lineRead != '': # While there are more records

words = lineRead.split() # Split the records into substrings
acctNum = int(words[0]) # Convert first substring to integer
annualIncome = float(words[1]) # Convert second substring to float
members = int(words[2]) # Convert third substring to integer

allIncomes.append(annualIncome)
numMembers.append(members)
accountNum.append(acctNum)
outFile.write(str("%10d %15.2f %10d\n" % (acctNum, annualIncome, members)))

lineRead = inFile.readline() # Read next record
outFile.write('---------------------------------------------''\n''\n')
averageInc = (avgIncome(allIncomes))
outFile.write("Families above the average income of " + str(averageInc) + '\n')
aboveAverage = aboveAvg(allIncomes,[averageInc])
outFile.write(str(aboveAverage))
for length in range(len(allIncomes)):
return(str(allIncomes[length]) + str(numMembers[length]) + str(accountNum[length]))



#povertyLevel = povLevel(numMembers)
#outFile.write(povertyLevel)
# Close the file.
inFile.close() # Close file

def avgIncome(income):
return(sum(income)/len(income))

def aboveAvg(income,avg):
average = avg
return income > average

def povLevel(family):
poevrtLevel = 15730.00+ 4060.00 *((family) - 2)

# Call the main function.
povertyLevel()



this is my updated code list.... i have three lists... but idk how to continue from there. anything below that for loop doesn't work in the outputfile. and I'm mentally tired :'(

Answer 41

aboveAverage = aboveAvg(allIncomes)
outFile.write("\n" + str(aboveAverage))

def aboveAvg(income):
avg = avgIncome(income)
return [inc for inc in income if inc > avg]

this only prints the income. what can i do to print both income, membercount , accountnumber?

Answer 42

i'm also getting a type error for povLevel (which calculates the poverty level)

Answer 43

Can you attach program10.txt

Answer 44

this is my updated povLevel

def povLevel(income,family):
fam1 = [mem - 2 for mem in family]
fam2 = [fam * 4060.00 for fam in fam1]
fam = [fami + 15730.00 for fami in fam2]
poverty = [a- b for(a,b) in zip (fam, income)]
return [inc for inc in income if inc > poverty]

Answer 45

Nevermind, you already did.

Answer 46

Paste the entire up to date version of the program you currently have and I'll try to help you solve your problems.

Answer 47

def povertyLevel():
inFile = open('program10.txt', 'r')
outFile = open('program10-out.txt', 'w')


outFile.write(str("%12s %12s %15s\n" % ("Account #", "Income", "Members")))

allIncomes = []
numMembers = []
accountNum = []
lineRead = inFile.readline() # Read first record
while lineRead != '': # While there are more records

words = lineRead.split() # Split the records into substrings
acctNum = int(words[0]) # Convert first substring to integer
annualIncome = float(words[1]) # Convert second substring to float
members = int(words[2]) # Convert third substring to integer

allIncomes.append(annualIncome)
numMembers.append(members)
accountNum.append(acctNum)
outFile.write(str("%10d %15.2f %10d\n" % (acctNum, annualIncome, members)))

lineRead = inFile.readline() # Read next record
outFile.write('---------------------------------------------''\n''\n')
averageInc = (avgIncome(allIncomes))
outFile.write("Families above the average income of " + str(averageInc) + '\n')
aboveAverage = aboveAvg(allIncomes)
outFile.write("\n" + str(aboveAverage)+ '\n')




povertyLevel = povLevel(allIncomes,numMembers)
outFile.write("\n" + str(povertyLevel))
# Close the file.
inFile.close() # Close file

def avgIncome(income):
return(sum(income)/len(income))

def aboveAvg(income):
avg = avgIncome(income)
return [inc for inc in income if inc > avg]


def povLevel(income,family):
fam1 = [mem - 2 for mem in family]
fam2 = [fam * 4060.00 for fam in fam1]
fam = [fami + 15730.00 for fami in fam2]
poverty = [a- b for(a,b) in zip (fam, income)]
return [inc for inc in income if inc > poverty]

# Call the main function.
povertyLevel()

Answer 48

def povLevel wont work right now.

Answer 49

my solution is supposed to look something like this

Answer 50

From the PDF it doesn't seem like he requires it to be sorted, and yet the sample solution is indeed sorted. Do you know anything about this?

Answer 51

it doesn't need to be sorted. my professor just did the solution like that

Answer 52

So start by defining a function that returns the poverty level based on the number of family members.

Answer 53

You've misunderstood the PDF. You iterate over each household and based on the number of members check to see if it is below the poverty level.

Answer 54

if(allIncomes[i] < povertyLevel(numMembers[i])) append household i to the list

Answer 55

Don't you see?

Answer 56

Still here?

Answer 57

this is the first time i'm writing to a file.. which had me confused on a lot of part

Answer 58

yep :(

Answer 59

povertyLevel = povLevel(allIncomes,numMembers)
if(allIncomes[i] < povertyLevel(numMembers[i])):
numMembers.append(members)
something like that?

Answer 60

sorry my open study crashed :(

Answer 61

Look at the sample output

Answer 62

You need to list the members below the poverty level. So you need to return the list below the poverty level.

Answer 63

man.. coding is soo hard :(

Answer 64

for some reason this one is not clicking to me

Answer 65

do i need to make another list for members?

Answer 66

Have you worked with dictionaries yet?

Answer 67

i've seen it.. but have not used it in my codes yet

Answer 68

other than append and a few ones

Answer 69

dictionaries lets you have anything in your list right?

Answer 70

i just wanna give up :(

Answer 71

can you give me another hint plz ;(

Answer 72

Just use it as a reference, you should still write your own.

Answer 73

Thanks man...I'll definitely use this as a reference..I don't know some of your functions..but thank you

Answer 74

If you are fairly new to Python my style might be a bit confusing.

Answer 75

Sorry

Answer 76

I'm new to coding itself... I'll figure it out once I have a reference :) thanks @Alchemista

Answer 77

@Alchemista i had a few questions about the program which you gave me

Answer 78

Sure

Answer 79

what does lambda do?

Answer 80

allIncomes = []
numMembers = []
accountNum = []

def main():
database()
#userinfo()

def database():
inFile = open('program10.txt', 'r')
outFile = open('program10-out.txt', 'w')


outFile.write(str("%15s %12s %12s\n\n" % ("Account #", "Members", "Income")))


lineRead = inFile.readline() # Read first record
while lineRead != '': # While there are more records

words = lineRead.split() # Split the records into substrings
acctNum = int(words[0]) # Convert first substring to integer
annualIncome = float(words[1]) # Convert second substring to float
members = int(words[2]) # Convert third substring to integer

allIncomes.append(annualIncome)
numMembers.append(members)
accountNum.append(acctNum)
outFile.write(str("%12d %12d %15.2f\n" % (acctNum, members, annualIncome )))

lineRead = inFile.readline() # Read next record
outFile.write('---------------------------------------------''\n''\n')
averageInc = (avgIncome(allIncomes))
outFile.write("Families above the average income of " + str(averageInc) + '\n'+'\n')
householdsAboveAvg(outFile,accountNum,numMembers,allIncomes,averageInc)
poverty_level(outFile)


# Close the file.
inFile.close() # Close file

def avgIncome(income):
return(sum(income)/len(income))

def householdsAboveAvg(outFile,accountNum,members,annualIncome,average):
for idx in range(len(accountNum)):
if annualIncome[idx] > average:
outFile.write('\t'+ str(accountNum[idx]) + '\t''\t' + str(members[idx])+ '\t''\t'+ str(annualIncome[idx])+'\n')




def poverty_level(outFile):
account = 0
headCount =0
for mem in numMembers:
povLv = (15730.00 + 4060.00 * (mem - 2))
headCount+=1
for inc in allIncomes:
if inc < povLv:
account+= 1

avgPoverty = account / headCount
outFile.write("\nPercentage of Households below the 2014 poverty level is: " + str(avgPoverty*100))

This is my final code!... thanks man! i couldn;t have done this without you!!

Answer 81

So all working now, eh?

Answer 82

yeah! :D @e.mccormick i just have starting trouble T_T if you believe in such thing lol....

Answer 83

People tend to wall at some point. They miss one or two concepts and now everything starts to need to work together. In programming, nothing works if one thing fails. So you have people with their frustration levels suddenly going up.