Skip to content

Instantly share code, notes, and snippets.

@psychemedia

psychemedia/pivotTable_demo.ipynb

Last active August 29, 2015 14:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save psychemedia/9c54721e853403b43d21 to your computer and use it in GitHub Desktop.
Save psychemedia/9c54721e853403b43d21 to your computer and use it in GitHub Desktop.
Download ZIP
Demo of using pivot table widget by https://github.com/nicolaskruchten/pivottable in IPython notebook with pandas
Display the source blob
Display the rendered blob
Raw
pivotTable_demo.ipynb
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Raw
tmp.html
<html>
<head>
<title>Pivot Demo</title>
<link rel="stylesheet" type="text/css" href="http://nicolas.kruchten.com/pivottable/dist/pivot.css">
<script type="text/javascript" src="http://nicolas.kruchten.com/pivottable/examples/ext/jquery-1.8.3.min.js"></script>
<script type="text/javascript" src="http://nicolas.kruchten.com/pivottable/examples/ext/jquery-ui-1.9.2.custom.min.js"></script>
<script type="text/javascript" src="http://nicolas.kruchten.com/pivottable/dist/pivot.js"></script>
</head>
<style>
* {font-family: Verdana;}
</style>
<body>
<script type="text/javascript">
$(function(){
var input = $("#input")
$("#output").pivotUI(input);
});
</script>
<div id="output" style="margin: 10px;"></div>
<br /><br /><br />
<table id="input" style="display:none" border="1" class="dataframe">
<thead>
<tr style="text-align: right;">
<th>Capital or Revenue</th>
<th>Directorate</th>
<th>Amount</th>
</tr>
</thead>
<tbody>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 120.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 120.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 695.89</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 695.89</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 695.89</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 695.89</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 695.89</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 2250.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 668.96</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 126.63</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 200.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Childrens Services</td>
<td> 208.50</td>
</tr>
<tr>
<td> Revenue</td>
<td> Childrens Services</td>
<td> 206.70</td>
</tr>
<tr>
<td> Revenue</td>
<td> Childrens Services</td>
<td> 240.40</td>
</tr>
<tr>
<td> Revenue</td>
<td> Childrens Services</td>
<td> 450.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Childrens Services</td>
<td> 375.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Childrens Services</td>
<td> 150.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Childrens Services</td>
<td> 150.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Economy &amp; Environment</td>
<td> 120.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Economy &amp; Environment</td>
<td> 120.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Economy &amp; Environment</td>
<td> 15.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Economy &amp; Environment</td>
<td> 310.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Economy &amp; Environment</td>
<td> 155.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Economy &amp; Environment</td>
<td> 310.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Economy &amp; Environment</td>
<td> 680.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Childrens Services</td>
<td> 15.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 120.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Resources</td>
<td> 276.90</td>
</tr>
<tr>
<td> Revenue</td>
<td> Resources</td>
<td> 319.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 632.40</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 35.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 210.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 210.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 210.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Childrens Services</td>
<td> 40.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 128.01</td>
</tr>
<tr>
<td> Revenue</td>
<td> Childrens Services</td>
<td> 231.30</td>
</tr>
<tr>
<td> Revenue</td>
<td> Economy &amp; Environment</td>
<td> 48.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Economy &amp; Environment</td>
<td> 5000.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Economy &amp; Environment</td>
<td> 2475.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Economy &amp; Environment</td>
<td> 500.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Childrens Services</td>
<td> 4523.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 850.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Resources</td>
<td> 200.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Childrens Services</td>
<td> 350.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Childrens Services</td>
<td> 227.50</td>
</tr>
<tr>
<td> Revenue</td>
<td> Childrens Services</td>
<td> 1455.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Childrens Services</td>
<td> 1440.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Childrens Services</td>
<td> 675.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Childrens Services</td>
<td> 300.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Childrens Services</td>
<td> 400.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Childrens Services</td>
<td> 150.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 2492.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 345.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Childrens Services</td>
<td> 8.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Childrens Services</td>
<td> 210.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Economy &amp; Environment</td>
<td> 100.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 120.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 600.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 532.50</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 120.00</td>
</tr>
<tr>
<td> Revenue</td>
<td> Childrens Services</td>
<td> 118.80</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 866.67</td>
</tr>
<tr>
<td> Revenue</td>
<td> Economy &amp; Environment</td>
<td> 648.09</td>
</tr>
<tr>
<td> Revenue</td>
<td> Economy &amp; Environment</td>
<td> 274.96</td>
</tr>
<tr>
<td> Revenue</td>
<td> Economy &amp; Environment</td>
<td> 387.53</td>
</tr>
<tr>
<td> Revenue</td>
<td> Economy &amp; Environment</td>
<td> 471.89</td>
</tr>
<tr>
<td> Revenue</td>
<td> Economy &amp; Environment</td>
<td> 357.33</td>
</tr>
<tr>
<td> Revenue</td>
<td> Economy &amp; Environment</td>
<td> 17.99</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 39.90</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 116.97</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 459.60</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 127.61</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 210.86</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 32.83</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 167.01</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 100.11</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 124.89</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 54.04</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 35.68</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 183.04</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 88.23</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 26.94</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 39.90</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 188.68</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 17.99</td>
</tr>
<tr>
<td> Revenue</td>
<td> Community Wellbeing &amp; Social Care</td>
<td> 311.82</td>
</tr>
<tr>
<td> Revenue</td>
<td> Economy &amp; Environment</td>
<td> 263.74</td>
</tr>
<tr>
<td> Revenue</td>
<td> Childrens Services</td>
<td> 310.75</td>
</tr>
<tr>
<td> Revenue</td>
<td> Childrens Services</td>
<td> 48.60</td>
</tr>
<tr>
<td> Revenue</td>
<td> Economy &amp; Environment</td>
<td> 107.60</td>
</tr>
<tr>
<td> Revenue</td>
<td> Economy &amp; Environment</td>
<td> 56.49</td>
</tr>
<tr>
<td> Revenue</td>
<td> Economy &amp; Environment</td>
<td> 27.26</td>
</tr>
<tr>
<td> Revenue</td>
<td> Economy &amp; Environment</td>
<td> 67.78</td>
</tr>
<tr>
<td> Revenue</td>
<td> Economy &amp; Environment</td>
<td> 144.60</td>
</tr>
<tr>
<td> Revenue</td>
<td> Economy &amp; Environment</td>
<td> 403.54</td>
</tr>
<tr>
<td> Revenue</td>
<td> Economy &amp; Environment</td>
<td> 12.50</td>
</tr>
<tr>
<td> Revenue</td>
<td> Economy &amp; Environment</td>
<td> 211.50</td>
</tr>
<tr>
<td> Revenue</td>
<td> Economy &amp; Environment</td>
<td> 70.81</td>
</tr>
<tr>
<td> Revenue</td>
<td> Economy &amp; Environment</td>
<td> 212.93</td>
</tr>
</tbody>
</table>
</body>
</html>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment