Advertisement
Guest User

Untitled

a guest
Apr 24th, 2014
33
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.57 KB | None | 0 0
  1. df = DataFrame(data = {'col1':[1,2,3,4],'col2':[1,2,3,4]}, index =MultiIndex.from_tuples([('a','b'),('a','c'),('a','b'),('a','d')]))
  2. df.sort_index(inplace=True)
  3. df
  4. col1 col2
  5. a b 1 1
  6. b 3 3
  7. c 2 2
  8. d 4 4
  9.  
  10. df.ix['a','b']
  11.  
  12. col1 col2
  13. a b 1 1
  14. b 3 3
  15.  
  16. df.reset_index(inplace=True)
  17. df.set_index(['level_0','level_1','col1'])
  18.  
  19. col2
  20. level_0 level_1 col1
  21. a b 1 1
  22. 3 3
  23. c 2 2
  24. d 4 4
  25.  
  26. df.ix['a','b',1,'col2'] = 3
  27. IndexingError: only tuples of length <= 2 supported
  28.  
  29. In [12]: df.ix[('a','b'),'col2'] = 3
  30.  
  31. In [13]: df
  32. Out[13]:
  33. col1 col2
  34. a b 1 3
  35. b 3 3
  36. c 2 2
  37. d 4 4
  38.  
  39. [4 rows x 2 columns]
  40.  
  41. df.ix['a','b']
  42.  
  43. In [19]: df.reset_index()
  44. Out[19]:
  45. level_0 level_1 col1 col2
  46. 0 a b 1 1
  47. 1 a c 2 2
  48. 2 a b 3 3
  49. 3 a d 4 4
  50.  
  51. [4 rows x 4 columns]
  52.  
  53. In [20]: df.reset_index().set_index(['level_0','level_1','col1'])
  54. Out[20]:
  55. col2
  56. level_0 level_1 col1
  57. a b 1 1
  58. c 2 2
  59. b 3 3
  60. d 4 4
  61.  
  62. [4 rows x 1 columns]
  63.  
  64. In [21]: df2 = df.reset_index().set_index(['level_0','level_1','col1'])
  65.  
  66. In [22]: df2.ix[('a','b',1)] = 10
  67.  
  68. In [23]: df2
  69. Out[23]:
  70. col2
  71. level_0 level_1 col1
  72. a b 1 10
  73. c 2 2
  74. b 3 3
  75. d 4 4
  76.  
  77. [4 rows x 1 columns]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement