Advertisement
Guest User

Untitled

a guest
Feb 21st, 2019
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 KB | None | 0 0
  1. values_list = []
  2.  
  3. for row in b:
  4. values_list.append(row[1])
  5.  
  6. 1,2,3,4,5
  7. 1,2,3,4,5
  8. 1,2,3,4,5
  9. 1,2,3,4,5
  10. 0,1,2,3,4
  11. 2,3,4,5,6
  12.  
  13. #!/bin/env python
  14.  
  15. col = 2
  16.  
  17. values = []
  18. with open('csv.csv', 'r') as csv:
  19. for line in csv.readlines():
  20. elements = line.strip().split(',')
  21. values.append(int(elements[col]))
  22.  
  23. csum = sum(values)
  24. cavg = sum(values)/len(values)
  25. print("Sum of column %d: %f" % (col, csum))
  26. print("Avg of column %d: %f" % (col, cavg))
  27.  
  28. $ python parsecsv.py
  29. Sum of column 0: 6.000000
  30. Avg of column 0: 1.000000
  31.  
  32. $ python parsecsv.py
  33. Sum of column 2: 18.000000
  34. Avg of column 2: 3.000000
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement