Advertisement
Guest User

Untitled

a guest
Aug 4th, 2015
165
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.90 KB | None | 0 0
  1. User 95 94 97 101 99 87 98 86 103 105 106 100 92 89 91 96
  2. 27669 15 19 2 1
  3. 27670 12 9 61 51 69 30 32 30 10
  4. 27671 49 7 29
  5. 27672 11 73 43 47 12 6
  6. 27673 8 14 11 11
  7. 27674 1 55
  8. 27675 9 9 10 30 29 11
  9. 27676 29 50 50
  10. 27677 31 25 28
  11. 27678 9 9 27 7 49 7
  12. 27679 28 27 7
  13. 27680 52 47 40 55 52
  14. 27681 11 9 15
  15. 27682 28 50 27 49
  16. 27683 9 9 10 8 12 9 10 8
  17.  
  18. import csv
  19. reader= csv.DictReader(open('test_23.csv'))
  20. next(reader)
  21. users = {}
  22. for row in reader:
  23. key=row.pop('User')
  24. if key in users:
  25. pass
  26. users[key]=row
  27. print users
  28.  
  29. {'31550': {'91': '', '88': '', '89': '', '97': '', '103': '', '100': '', '86': '', '87': '', '101': '', '95': '', '105': '', '99': '', '98': '', '102': '69', '90': '', '93': '', '92': '', '106': '', '94': '', '104': '', '96': ''}, '29443': {'91': '90', '88': '', '89': '69', '97': '', '103': '65', '100': '', '86': '', '87': '74', '101': '', '95': '', '105': '68', '99': '', '98': '', '102': '', '90': '', '93': '', '92': '', '106': '70', '94': '', '104': '74', '96': ''}, '32103': {'91': '', '88': '', '89': '', '97': '', '103': '', '100': '3', '86': '', '87': '', '101': '28', '95': '', '105': '65', '99': '', '98': '4', '102': '', '90': '', '93': '', '92': '', '106': '69', '94': '', '104': '68', '96': ''}, '29687': {'91': '', '88': '9', '89': '7', '97': '', '103': '8', '100': '', '86': '', '87': '', '101': '', '95': '', '105': '', '99': '', '98': '', '102': '9', '90': '25', '93': '', '92': '', '106': '27', '94': '', '104': '9', '96': ''}, '29444': {'91': '69', '88': '60', '89': '71', '97': '', '103': '', '100': '', '86': '51', '87': '', '101': '', '95': '19', '105': '', '99': '', '98': '', '102': '', '90': '', '93': '', '92': '', '106': '', '94': '35', '104': '', '96': '18'}, '28224': {'91': '', '88': '18', '89': '18', '97': '', '103': '', '100': '', '86': '', '87': '17', '101': '', '95': '17', '105': '', '99': '', '98': '', '102': '', '90': '17', '93': '', '92': '19', '106': '', '94': '19', '104': '', '96': '17'}, '31783': {'91': '', '88': '', '89': '', '97': '', '103': '50', '100': '', '86': '', '87': '', '101': '47', '95': '55', '105': '', '99': '', '98': '54', '102': '', '90': '', '93': '', '92': '', '106': '', '94': '', '104': '53', '96': ''},
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement