Guest User

Untitled

a guest
Jun 20th, 2018
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.72 KB | None | 0 0
  1. import pandas as pd
  2. import numpy as np
  3. df = pd.read_excel('resultados.xlsx')
  4. df
  5. Con b1 b2 b3 b4 b5 b6 b7 b8 b9 b10 b11 b12 b13 b14 b15
  6. 1 30 22 2 1 17 8 4 19 20 11 14 6 21 7 23 3
  7. 2 29 13 14 6 1 24 4 8 5 17 22 21 19 20 9 16
  8. 3 28 18 21 11 7 9 3 20 16 14 12 13 17 1 19 10
  9. 4 27 25 6 22 21 11 24 3 14 12 13 20 8 10 15 18
  10. 5 26 19 11 7 16 8 21 5 10 20 13 23 9 17 14 22
  11. 6 25 4 23 20 2 5 13 7 9 24 3 1 6 14 22 16
  12. 7 24 1 19 21 14 2 23 25 5 20 11 7 10 24 17 3
  13. 8 23 10 11 5 19 18 14 6 4 20 1 8 3 12 16 17
  14. 9 22 13 15 5 9 7 10 1 3 22 2 25 14 6 4 12
  15. 10 21 5 2 1 22 19 8 24 4 25 23 18 20 14 11 16
  16. 11 20 4 9 8 24 16 20 3 17 18 19 7 6 23 14 10
  17. df.set_index('Concurso',inplace= True)
  18. df
  19. Con b1 b2 b3 b4 b5 b6 b7 b8 b9 b10 b11 b12 b13 b14 b15
  20. 30 22 2 1 17 8 4 19 20 11 14 6 21 7 23 3
  21. 29 13 14 6 1 24 4 8 5 17 22 21 19 20 9 16
  22. 28 18 21 11 7 9 3 20 16 14 12 13 17 1 19 10
  23. 27 25 6 22 21 11 24 3 14 12 13 20 8 10 15 18
  24. 26 19 11 7 16 8 21 5 10 20 13 23 9 17 14 22
  25. 25 4 23 20 2 5 13 7 9 24 3 1 6 14 22 16
  26. 24 1 19 21 14 2 23 25 5 20 11 7 10 24 17 3
  27. 23 10 11 5 19 18 14 6 4 20 1 8 3 12 16 17
  28. 22 13 15 5 9 7 10 1 3 22 2 25 14 6 4 12
  29. 21 5 2 1 22 19 8 24 4 25 23 18 20 14 11 16
  30. 20 4 9 8 24 16 20 3 17 18 19 7 6 23 14 10
  31. 1662 rows × 15 columns
Add Comment
Please, Sign In to add comment