Advertisement
Guest User

Untitled

a guest
Jul 23rd, 2014
195
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.95 KB | None | 0 0
  1. row_to_add = pd.MultiIndex.from_tuples()
  2. df.ix[row_to_add] = my_row
  3.  
  4. >>> df = pd.DataFrame({'Time': [dt.datetime(2013,2,3,9,0,1), dt.datetime(2013,2,3,9,0,1)], 'hsec': [1,25], 'vals': [45,46]})
  5. >>> df
  6. Time hsec vals
  7. 0 2013-02-03 09:00:01 1 45
  8. 1 2013-02-03 09:00:01 25 46
  9.  
  10. [2 rows x 3 columns]
  11. >>> df.set_index(['Time','hsec'],inplace=True)
  12. >>> ind = pd.MultiIndex.from_tuples([(dt.datetime(2013,2,3,9,0,2),0)],names=['Time','hsec'])
  13. >>> df.ix[ind] = 5
  14.  
  15. Traceback (most recent call last):
  16. File "<pyshell#201>", line 1, in <module>
  17. df.ix[ind] = 5
  18. File "C:Program FilesPython27libsite-packagespandascoreindexing.py", line 96, in __setitem__
  19. indexer = self._convert_to_indexer(key, is_setter=True)
  20. File "C:Program FilesPython27libsite-packagespandascoreindexing.py", line 967, in _convert_to_indexer
  21. raise KeyError('%s not in index' % objarr[mask])
  22. KeyError: "[(Timestamp('2013-02-03 09:00:02', tz=None), 0L)] not in index"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement