Actions

MAPREDUCE Elite: Difference between revisions

From NoSQLZoo

No edit summary
No edit summary
Line 17: Line 17:
There are two collections, <code>commodities</code> and <code>systems</code>. Inside <code>systems</code> there is are nested documents called <code>stations</code><br/>
There are two collections, <code>commodities</code> and <code>systems</code>. Inside <code>systems</code> there is are nested documents called <code>stations</code><br/>
A <b>system</b> has many <b>stations</b>, and a <b>station</b> has many trade <code>listings</code><br/><br/>
A <b>system</b> has many <b>stations</b>, and a <b>station</b> has many trade <code>listings</code><br/><br/>
Read more about the structure here: [[Elite_Document_Structure]]
Read more about the structure here: [[Elite Document Structure]]
<br/><br/>
<br/><br/>
==Questions==
==Questions==
<div class=q data-lang="py3">The <code>commodities</code> collection contains the name and average price of each commodity.<br/>
There are 99 commodities and 15 categories.
<p class="strong">Find the average price of each category</p>
<pre class=def>
from bson.code import Code
pp.pprint(
)
</pre>
<div class="ans">
</div>

Revision as of 13:43, 23 July 2015

#ENCODING
import io
import sys
sys.stdout = io.TextIOWrapper(sys.stdout.buffer, encoding='utf-16')
#MONGO
from pymongo import MongoClient
client = MongoClient()
client.progzoo.authenticate('scott','tiger')
db = client['progzoo']
#PRETTY
import pprint
pp = pprint.PrettyPrinter(indent=4)

Introducing the elite database **WORK IN PROGRESS

These questions will introduce the "elite" database, which contains data about the video game Elite Dangerous

There are two collections, commodities and systems. Inside systems there is are nested documents called stations
A system has many stations, and a station has many trade listings

Read more about the structure here: Elite Document Structure

Questions

The commodities collection contains the name and average price of each commodity.

There are 99 commodities and 15 categories.

Find the average price of each category

from bson.code import Code
pp.pprint(

)
  • You have been served by: dill