Advertisement
Guest User

Untitled

a guest
Apr 18th, 2014
39
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.31 KB | None | 0 0
  1. PanelData.major_xs('A')
  2. PanelData.minor_xs('zTwo')
  3.  
  4. import pandas as pd
  5.  
  6. ListLetter = ['A', 'B', 'C', 'D']
  7. ListCode = [2, 1, 1, 0]
  8. ListZone = ['zOne', 'zTwo', 'zThree', 'zFour']
  9. ListRegion = ['USA', 'CH', 'NZ', 'CH']
  10. index = pd.MultiIndex.from_arrays([ListLetter, ListCode], names=['letter', 'code'])
  11. columns = pd.MultiIndex.from_arrays([ListZone, ListRegion], names=['zone', 'region'])
  12.  
  13. PanelData = pd.Panel({'2010-01-01': pd.DataFrame(index=index, columns=columns)})
  14. PanelData['2010-01-02'] = pd.DataFrame(index=index, columns=columns)
  15. PanelData['2010-01-03'] = pd.DataFrame(index=index, columns=columns)
  16. PanelData
  17.  
  18. <class 'pandas.core.panel.Panel'>
  19. Dimensions: 3 (items) x 4 (major_axis) x 4 (minor_axis)
  20. Items axis: 2010-01-01 to 2010-01-03
  21. Major_axis axis: (A, 2) to (D, 0)
  22. Minor_axis axis: (zOne, USA) to (zFour, CH)
  23.  
  24. In [67]:
  25.  
  26. PanelData.swapaxes(0,1).xs('A', 0)
  27. Out[67]:
  28. <class 'pandas.core.panel.Panel'>
  29. Dimensions: 1 (items) x 3 (major_axis) x 4 (minor_axis)
  30. Items axis: 2 to 2
  31. Major_axis axis: 2010-01-01 to 2010-01-03
  32. Minor_axis axis: (zOne, USA) to (zFour, CH)
  33.  
  34. In [68]:
  35.  
  36. print PanelData.swapaxes(0,1).loc[('A',2),]
  37. zone zOne zTwo zThree zFour
  38. region USA CH NZ CH
  39. 2010-01-01 NaN NaN NaN NaN
  40. 2010-01-02 NaN NaN NaN NaN
  41. 2010-01-03 NaN NaN NaN NaN
  42.  
  43. [3 rows x 4 columns]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement