Advertisement
Guest User

Untitled

a guest
Feb 21st, 2017
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 KB | None | 0 0
  1. import csv
  2. try:
  3. # read the file,split it and take the values into list
  4. fileObj = open('dataset.csv')
  5. fileReader = csv.reader(fileObj)
  6. fileData = list(fileReader)
  7.  
  8. # average calculation
  9. total = 0
  10. entries = len(fileData)
  11.  
  12. for row in fileData:
  13. total+=float(row[1])
  14.  
  15. avg = total / entries
  16. print(total)
  17. print(avg)
  18.  
  19. # list of higher income people (higher > average)
  20. higherIncome = []
  21. for row in fileData:
  22. if (float(row[1])>avg):
  23. higherIncome+=str(row)
  24.  
  25. # writing a text file
  26. output = open('income.txt','w')
  27. for item in higherIncome:
  28. output.write(item)
  29. output.close()
  30.  
  31. except:
  32. print 'Something\'s wrong'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement