<h1>Munger Examples</h1>
<p>The following examples are from the [[MungerData]] tutorial pages.</p>
<h2>Simple Example</h2>
<pre class="console">
result = AdAirings.find(:all)
report = Munger::Report.from_data(result).process
puts Munger::Render.to_text(report)
</pre>
<p>will result in:</p>
<pre>
|airtime | airdate | clicks | advert |
------------------------------------------
|15 | 2008-01-01 | 301 | spot 1 |
|30 | 2008-01-02 | 199 | spot 1 |
|30 | 2008-01-03 | 234 | spot 1 |
|15 | 2008-01-04 | 342 | spot 1 |
|30 | 2008-01-01 | 172 | spot 2 |
|15 | 2008-01-02 | 217 | spot 2 |
|90 | 2008-01-03 | 1023 | spot 2 |
|30 | 2008-01-04 | 321 | spot 2 |
|60 | 2008-01-01 | 512 | spot 3 |
|30 | 2008-01-02 | 813 | spot 3 |
|15 | 2008-01-03 | 333 | spot 3 |
</pre>
<h2>Simple Pivot</h2>
<pre class="console">
result = AdAirings.find(:all)
data = Munger::Data.load_data(result)
new_columns = data.pivot('airdate', 'advert', 'clicks')
report = Munger::Report.from_data(data).columns([:advert] + new_columns.sort).process
puts Munger::Render.to_text(report)
</pre>
<pre>
|advert | 2008-01-01 | 2008-01-02 | 2008-01-03 | 2008-01-04 |
--------------------------------------------------------------
|Spot 1 | 301 | 199 | 234 | 342 |
|Spot 2 | 172 | 217 | 1023 | 321 |
|Spot 3 | 512 | 813 | 333 | |
</pre>
<h2>More Complex Example</h2>
<pre class="console">
result = AdAirings.find(:all)
data = Munger::Data.load_data(result)
data.add_columns([:advert, :rate]) do |row|
rate = (row.clicks / row.airtime)
[row.advert.capitalize, rate]
end
report = Munger::Report.from_data(data)
report.sort('airtime').subgroup('airtime')
report.aggregate(Proc.new {|arr| arr.inject(0) {|total, i| i * i + (total - 30) }} => :airtime,
:sum => :rate)
puts Munger::Render.to_text(report)
</pre>
<pre>
|Spot | Rate | Air Date | Airtime |
----------------------------------------
|Spot 2 | 14 | 2008-01-02 | 15 |
|Spot 1 | 20 | 2008-01-01 | 15 |
|Spot 3 | 22 | 2008-01-03 | 15 |
|Spot 1 | 22 | 2008-01-04 | 15 |
| | 78 | | 780 |
|Spot 2 | 5 | 2008-01-01 | 30 |
|Spot 1 | 6 | 2008-01-02 | 30 |
|Spot 1 | 7 | 2008-01-03 | 30 |
|Spot 2 | 10 | 2008-01-04 | 30 |
|Spot 3 | 27 | 2008-01-02 | 30 |
| | 55 | | 4350 |
|Spot 3 | 8 | 2008-01-01 | 60 |
| | 8 | | 3570 |
|Spot 2 | 11 | 2008-01-03 | 90 |
| | 11 | | 8070 |
| | 152 | | 16770 |
</pre>
2008-04-16T15:31:30-07:00
11376
examples
10437
Examples
2008-04-18T07:12:08-07:00
70