Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import csv
- try:
- # read the file,split it and take the values into list
- fileObj = open('dataset.csv')
- fileReader = csv.reader(fileObj)
- fileData = list(fileReader)
- # average calculation
- total = 0
- entries = len(fileData)
- for row in fileData:
- total+=float(row[1])
- avg = total / entries
- print(total)
- print(avg)
- # list of higher income people (higher > average)
- higherIncome = []
- for row in fileData:
- if (float(row[1])>avg):
- higherIncome+=str(row)
- # writing a text file
- output = open('income.txt','w')
- for item in higherIncome:
- output.write(item)
- output.close()
- except:
- print 'Something\'s wrong'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement