NoSQLZoo - User contributions [en-gb]

FIND from WORLD

2015-11-13T10:34:29Z

Cs66:

<pre class="setup">
#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)
</pre>

==Working with the <code>world</code> collection of countries==
<p>This tutorial introduces NoSQL using MonogDB and PyMongo under Python3.4. We will be using the <code>find()</code> command and comparison functions on the collection '''world''' which contains details of around 250 countries of the world:</p>
[[FIND examples]] are available.

<div class=q data-lang="py3">
Observe the result of running a simple mongoDB command.
<p class=strong>FIND name, continent, population FROM world</p>
<pre class=def>
pp.pprint(list(
db.world.find({},{
"name":1,
"continent":1,
"population":1,
"_id":0
})
))
</pre>
<div class=ans>
pp.pprint(list(db.world.find({},{"name":1,"continent":1,"population":1,"_id":0})))
</div>
</div>

<div class=q data-lang="py3">
<p class=strong>Show the name for the countries that have a population of at least 200 million. 200 million is 200000000, there are eight zeros.</p>
<pre class=def>
pp.pprint(list(
db.world.find(
{"population":{"$gt":200000000}},
{"name":1, "_id":0}
)
))
</pre>
<div class=ans>
pp.pprint(list(db.world.find({"population":{"$gt":200000000}},{"name":1, "_id":0})))
</div>
</div>

<div class=q data-lang="py3">
<p class=strong>Give the name and the per capita GDP for those countries with a population of at least 200 million.</p>
[[AGGREGATE examples]] are available.
<div class="hint" title="How to calculate per capita GDP">per capita GDP is the GDP divided by the population GDP/population</div>
<pre class=def>
pp.pprint(list(
db.world.aggregate([
{"$match":{"population":{"$gt":200000000}}},
{"$project":{"name":1, "per capita GDP":{"$divide":["$gdp","$population"]}, "_id":0}}
])
))
</pre>
</div>

<div class=q data-lang="py3">
<p class=strong>Show the name and population in millions for the countries of the continent 'South America'. Divide the population by 1000000 to get population in millions.</p>
<pre class=def>
pp.pprint(list(
db.world.aggregate([
{"$match":{"continent":{"$eq":"South America"}}},
{"$project":{"name":1, "population in millions":{"$divide":["$population",1000000]}, "_id":0}}
])
))
</pre>
<div class=ans>
pp.pprint(list(db.world.aggregate([{"$match":{"continent":{"$eq":"South America"}}},{"$project":{"name":1, "population in millions":{"$divide":["$population",1000000]}, "_id":0}}])))
</div>
</div>

<div class=q data-lang="py3">
<p class=strong>Show the name and population for France, Germany, Italy</p>
<pre class=def>
pp.pprint(list(
db.world.aggregate([
{"$match":{"name":{"$in":["France", "Germany", "Italy"]}}},
{"$project":{"name":1, "population":1, "_id":0}}
])
))
</pre>
<div class=ans>
pp.pprint(list(db.world.aggregate([{"$match":{"name":{"$in":["France", "Germany", "Italy"]}}},{"$project":{"name":1, "population":1, "_id":0}}])))
</div>
</div>

<div class=q data-lang="py3">
<p class=strong>Show the countries which have a name that includes the word 'United'</p>
<pre class=def>
pp.pprint(list(
db.world.find(
{"name":{"$regex":"\s?United\s?"}},
{"name":1, "_id":0}
)
))
</pre>
<div class=ans>
pp.pprint(list(db.world.find({"name":{"$regex":"\s?United\s?"}},{"name":1, "_id":0})))
</div>
</div>

<div class=q data-lang="py3">
Two ways to be big: A country is big if it has an area of more than 3 million sq km or it has a population of more than 250 million.
<p class=strong>Show the countries that are big by area or big by population. Show name, population and area</p>
<pre class=def>
pp.pprint(list(
db.world.find(
{"$or":[{"area":{"$gt":3000000}},{"population":{"$gt":250000000}}]},
{"name":1,"population":1,"area":1,"_id":0}
)
))
</pre>
<div class=ans>
pp.pprint(list(db.world.find({"$or":[{"area":{"$gt":3000000}},{"population":{"$gt":250000000}}]},{"name":1,"population":1,"area":1,"_id":0})))
</div>
</div>

<div class=q data-lang="py3">
USA and China are big in population <span class=strong>and</span> big by area. Exclude these countries.
<p class=strong>Show the countries that are big by area or big by population but not both. Show name, population and area.</p>
<pre class=def>
pp.pprint(list(
db.world.find(
{"$or":[
{"area":{"$gt":3000000},"population":{"$lt":250000000}},
{"area":{"$lt":3000000},"population":{"$gt":250000000}}
]},
{"name":1,"population":1,"area":1,"_id":0}
)
))
</pre>
<div class=ans>
pp.pprint(list(db.world.find({"$or":[{"area":{"$gt":3000000},"population":{"$lt":250000000}},{"area":{"$lt":3000000},"population":{"$gt":250000000}}]}, {"name":1,"population":1,"area":1,"_id":0})))
</div>
</div>

<div class=q data-lang="py3">
Show the name and population in millions and the GDP in billions for the countries of the continent 'South America'. Use the ROUND function to show the values to two decimal places.<br />
Introducing [[MapReduce]]
<div class=hint title='Millions and billions'>Divide by 1000000 (6 zeros) for millions. Divide by 1000000000 (9 zeros) for billions.</div>
<p class=strong>For South America show population in millions and GDP in billions to 2 decimal places.</p>
<pre class=def>
from bson.code import Code
temp = db.world.map_reduce(
query={"continent":"South America"},
map=Code("function(){emit(this.name,{'gdp':this.gdp,'pop':this.population});}"),
reduce=Code("""function(key, values){ return values} """),
finalize=Code("""function(k, v){
return {
'pop in millions':Math.round(v['pop']*1000000)/1000000,
'gdp in billions':Math.round(v['gdp']*1000000000)/1000000000
};
}
"""),
out={"inline":1}
)
pp.pprint(temp['results']);
</pre>
<div class=ans>
from bson.code import Code
temp = db.world.map_reduce(query={"continent":"South America"},map=Code("function(){emit(this.name, {'gdp':this.gdp,'pop':this.population});}"),reduce=Code("""function(key, values){ return values} """),finalize=Code("""function(k, v){return {'pop in millions':Math.round(v['pop']*1000000)/1000000,'gdp in billions':Math.round(v['gdp']*1000000000)/1000000000};}"""),out={"inline":1})
pp.pprint(temp['results']);
</div>
</div>

<div class=q data-lang="py3">
Show the per-capita GDP for those countries with a GDP of at least one trillion (1000000000000; that is 12 zeros). Round this value to the nearest 1000.
<p class=strong>Show per-capita GDP for the trillion dollar countries to the nearest $1000.</p>
<pre class=def>
from bson.code import Code
temp = db.world.map_reduce(
map=Code("function(){if(this.gdp > 1000000000000)emit(this.name,{'gdp':this.gdp,'pop':this.population});}"),
reduce=Code("""function(key, values){ return values} """),
finalize=Code("""function(k, v){
return {'per-capita GDP':Math.round((v['gdp']/v['pop'])/1000)*1000};
}
"""),
out={"inline":1}
)
pp.pprint(temp['results']);
</pre>
<div class=ans>
from bson.code import Code
temp = db.world.map_reduce(map=Code("function(){if(this.gdp > 1000000000000)emit(this.name,{'gdp':this.gdp,'pop':this.population});}"),reduce=Code("""function(key, values){ return values} """),finalize=Code("""function(k, v){
return {'per-capita GDP':Math.round((v['gdp']/v['pop'])/1000)*1000};}"""),out={"inline":1})
pp.pprint(temp['results']);
</div>
</div>

== Harder Questions ==

<div class=q data-lang="py3">
Find out more about <code>$cond</code> at [[AGGREGATE_examples]]
<p class=strong>Show the name and the continent - but substitute Australasia for Oceania - for countries beginning with N.</p>
<pre class=def>
pp.pprint(list(
db.world.aggregate([
{"$match":{"name":{"$regex":"^N"}}},
{"$project":{
"name":1,
"continent":{"$cond":[{"$eq":["$continent","Oceania"]},"Australasia","$continent"]},
"_id":0
}}
])
))
</pre>
<div class=ans>
pp.pprint(list(db.world.aggregate([{"$match":{"name":{"$regex":"^N"}}},{"$project":{"_id":0,"name":1,"continent":{"$cond":[{"$eq":["$continent","Oceania"]},"Australasia","$continent"]}}}])))
</div>
</div>

<div class=q data-lang="py3">
Show the <b>name</b> and the <b>continent</b> but:<br/><br/>
    substitute <b>Eurasia</b> for <b>Europe</b> and <b>Asia</b>.<br/>
    substitute <b>America</b> - for each country in <b>North America</b> or <b>South America</b> or <b>Caribbean</b>.<br/><br/>Only show countries beginning with <b>A</b> or <b>B</b><br/>
If you're struggling you may want to experiment with <code>$and</code>,<code>$or</code>, etc.
<pre class=def>
pp.pprint(list(
db.world.aggregate([
{"$match":{
"name":{"$regex":"^A|^B"}
}},
{"$project":{
"_id":0,
"name":1,
"continent": {
"$cond": [{
"$or":[
{"$eq":["$continent","Europe"]},
{"$eq":["$continent","Asia"]}
]},"Eurasia",{
"$cond": [
{"$or":[
{"$eq":["$continent","North America"]},
{"$eq":["$continent","South America"]},
{"$eq":["$continent","Caribbean"]}
]},"America","$continent"]}
]}
}}
])
))
</pre>
<div class=ans>
pp.pprint(list(
db.world.aggregate([
{"$match":{
"name":{"$regex":"^A|^B"}
}},
{"$project":{
"_id":0,
"name":1,
"continent": {
"$cond": [{
"$or":[
{"$eq":["$continent","Europe"]},
{"$eq":["$continent","Asia"]}
]},"Eurasia",{
"$cond": [
{"$or":[
{"$eq":["$continent","North America"]},
{"$eq":["$continent","South America"]},
{"$eq":["$continent","Caribbean"]}
]},"America","$continent"]}
]}
}}
])
))
</div>
</div>

<div class=q data-lang="py3">
Put the continents right...
<br/><br/>
    <b>Oceania</b> becomes <b>Australasia</b><br/>
    Countries in <b>Eurasia</b> and <b>Turkey</b> go to <b>Europe/Asia</b><br/>
    <b>Caribbean</b> islands starting with '<b>B</b>' go to <b>North America</b>, other Caribbean islands go to <b>South America</b><br/>
<br/><br/>
<b>Show the name, the original continent and the new continent of all countries.</b>
<pre class=def>
pp.pprint(list(
db.world.aggregate([
{"$project":{
"_id":0,
"name":1,
"original": "$continent",
"new": {
"$cond": [
{"$or":[
{"$eq":["$continent","Eurasia"]},
{"$eq":["$name","Turkey"]}
]},"Europe/Asia",{
"$cond":[
{"$eq":["$continent","Oceania"]},"Australasia",{
"$cond":[
{"$and":[
{"$eq":["$continent","Caribbean"]},
{"$eq":[{"$substr":["$name",0,1]}, "B"]}
]},"North America",{
"$cond":[
{"$and":[
{"$eq":["$continent","Caribbean"]},
{"$ne":[{"$substr":["$name",0,1]}, "B"]}
]},"South America","$continent"
]
}
]
}
]
}
]
}
}}
])
))
</pre>
<div class=ans>
pp.pprint(list(
db.world.aggregate([
{"$project":{
"_id":0,
"name":1,
"original": "$continent",
"new": {
"$cond": [
{"$or":[
{"$eq":["$continent","Eurasia"]},
{"$eq":["$name","Turkey"]}
]},"Europe/Asia",{
"$cond":[
{"$eq":["$continent","Oceania"]},"Australasia",{
"$cond":[
{"$and":[
{"$eq":["$continent","Caribbean"]},
{"$eq":[{"$substr":["$name",0,1]}, "B"]}
]},"North America",{
"$cond":[
{"$and":[
{"$eq":["$continent","Caribbean"]},
{"$ne":[{"$substr":["$name",0,1]}, "B"]}
]},"South America","$continent"
]
}
]
}
]
}
]
}
}}
])
))
</div>
</div>

FIND Tutorial

2015-11-13T10:19:58Z

Cs66:

==Working with the <code>world</code> collection of countries==
<p>This tutorial introduces NoSQL using MonogDB and PyMongo under Python3.4. We will be using the <code>find()</code> command and comparison functions on the collection '''world''' which contains details of around 250 countries of the world:</p>
[[FIND examples]] are available.
<div class='extra_space' style='width:1em; height:6em;'></div>
<div class=q data-lang="mongo">
Use <code>find()</code> to show the details of Germany
<p class=strong>Show Germany instead of France</p>
<pre class=def>
db.world.find({name:'France'})
</pre>
<div class=ans>
db.world.find({name:'Germany'})
</div>
</div>

<div class=q data-lang="mongo">
You can use .pretty() to make the output more readable.
<p class=strong>List all the countries in the continent of "Eurasia"</p>
<pre class=def>
db.world.find({name:'Germany'}).pretty()
</pre>
<div class=ans>
db.world.find({"continent":"Eurasia"}).pretty()
</div>
</div>

<div class=q data-lang="mongo">
You can test numbers as well as strings
<p class=strong>Find the country with an area of exactly 43094</p>
<pre class=def>
db.world.find({gdp:3425956000000}).pretty()
</pre>
<div class=ans>
db.world.find({"area":43094}).pretty()
</div>
</div>

<div class=q data-lang="mongo">
You can use $gt and $lt to compare numbers and strings ('''$gt''' is greater than, '''$lt''' is less than)
<p class=strong>Show each country with a population of over 250000000</p>
<pre class=def>
db.world.find(
{"area":{"$gt":9000000}},
{name:1,_id:0}
).pretty()
</pre>
<div class=ans>
db.world.find({"population":{"$gt":250000000}},{name:1,_id:0}).pretty()
</div>
</div>

<div class=q data-lang=mongo">
<p class=strong>List the countries in Europe that start with the letter "S"</p>
<pre class=def>
</pre>
<div class=ans>
db.world.find({"name":{'$regex':"^S"},
"continent":"Europe"},{"name":1, "_id":0})
</div>
</div>

<div class=q data-lang="py3">
<p class=strong>Find the capital cities for countries with a population of over 70 million</p>
<pre class=def>
</pre>
<div class=ans>
pp.pprint(list(db.world.find({"population":{"$gt":70000000}},{"capital":1,"_id":0})))
</div>
</div>

<div class=q data-lang="py3">
<p class=strong>Find the countries that have a population of over 100 million or less than a million</p>
<pre class=def>
</pre>
<div class=ans>
pp.pprint(list(db.world.find({"$or":[{"population":{"$lt":1000000}},{"population":{"$gt":100000000}}]}, {"name":1, "_id":0})))
</div>
</div>

<div class=q data-lang="py3">
<p class=strong>Find the names of countries beginning with "U" that are outside of Europe and North America</p>
<pre class=def>
</pre>
<div class=ans>
pp.pprint(list(db.world.find({"$and":[{"name":{'$regex':"^U"}},{"continent":{"$nin":["Europe", "North America"]}}]},{"name":1,"_id":0})))
</div>
</div>

<div class=q data-lang="py3">
<p class=strong>Find the names of all countries that contain a white space </p>
<pre class=def>
</pre>
<div class=ans>
pp.pprint(list(db.world.find({"name":{"$regex":"^.*\s.*$"}},{"name":1,"_id":0})))
</div>
</div>

<div class=q data-lang="py3">
<p class=strong>Which country out of China, Russia, and the United States has the largest population.</p>
You might want to use [[Sort]] and limit to get the answer.
<pre class=def>
</pre>
<div class=ans>
pp.pprint(list(db.world.find({"name":{"$in":["China", "Russia", "United States"]}}).sort("population",-1).limit(1)))
</div>
</div>

<div class=q data-lang="py3">
Use [[Sort]] to find the last document in world
<p class=strong>Show the last document of world</p>
<pre class=def>
</pre>
<div class=ans>
pp.pprint(list(db.world.find().sort("$natural", -1))[0])
</div>
</div>

<div class=q data-lang="py3">
<p class=strong>Show capital and population for the top 5 capital cities starting with the letter "M" that have a population of less than 3 million </p>
<pre class=def>
</pre>
<div class=ans>
pp.pprint(list(db.world.find({"$and":[{"capital":{"$regex":"^M"}},{"population":{"$lt":3000000}}]}, {"_id":0, "capital":1, "population":1}).sort("population",-1).limit(5)))
</div>
</div>

<div class=q data-lang="py3">
<p class=strong>Show all the capitals for countries that start with the same letter as their continent</p>
<div class=hint title="Using $where with find" >
find({"$where": " boolean expression "})
</div>
<pre class=def>
</pre>
<div class=ans>
pp.pprint(list(
db.world.find(
{"$where":"this.name[0]==this.continent[0]"},
{"_id":0, "capital":1})
))
</div>
</div>

FIND Tutorial

2015-11-13T10:19:00Z

Cs66:

==Working with the <code>world</code> collection of countries==
<p>This tutorial introduces NoSQL using MonogDB and PyMongo under Python3.4. We will be using the <code>find()</code> command and comparison functions on the collection '''world''' which contains details of around 250 countries of the world:</p>
[[FIND examples]] are available.
<div class='extra_space' style='width:1em; height:6em;'></div>
<div class=q data-lang="mongo">
Use <code>find()</code> to show the details of Germany
<p class=strong>Show Germany instead of France</p>
<pre class=def>
db.world.find({name:'France'})
</pre>
<div class=ans>
db.world.find({name:'Germany'})
</div>
</div>

<div class=q data-lang="mongo">
You can use .pretty() to make the output more readable.
<p class=strong>List all the countries in the continent of "Eurasia"</p>
<pre class=def>
db.world.find({name:'Germany'}).pretty()
</pre>
<div class=ans>
db.world.find({"continent":"Eurasia"}).pretty()
</div>
</div>

<div class=q data-lang="mongo">
You can test numbers as well as strings
<p class=strong>Find the country with an area of exactly 43094</p>
<pre class=def>
db.world.find({gdp:3425956000000}).pretty()
</pre>
<div class=ans>
db.world.find({"area":43094}).pretty()
</div>
</div>

<div class=q data-lang="mongo">
You can use $gt and $lt to compare numbers and strings (greater than and less than)
<p class=strong>Show each country with a population of over 250000000</p>
<pre class=def>
db.world.find(
{"area":{"$gt":90000000}},
{name:1,_id:0}
).pretty()
</pre>
<div class=ans>
db.world.find({"population":{"$gt":250000000}},{name:1,_id:0}).pretty()
</div>
</div>

<div class=q data-lang=mongo">
<p class=strong>List the countries in Europe that start with the letter "S"</p>
<pre class=def>
</pre>
<div class=ans>
db.world.find({"name":{'$regex':"^S"},
"continent":"Europe"},{"name":1, "_id":0})
</div>
</div>

<div class=q data-lang="py3">
<p class=strong>Find the capital cities for countries with a population of over 70 million</p>
<pre class=def>
</pre>
<div class=ans>
pp.pprint(list(db.world.find({"population":{"$gt":70000000}},{"capital":1,"_id":0})))
</div>
</div>

<div class=q data-lang="py3">
<p class=strong>Find the countries that have a population of over 100 million or less than a million</p>
<pre class=def>
</pre>
<div class=ans>
pp.pprint(list(db.world.find({"$or":[{"population":{"$lt":1000000}},{"population":{"$gt":100000000}}]}, {"name":1, "_id":0})))
</div>
</div>

<div class=q data-lang="py3">
<p class=strong>Find the names of countries beginning with "U" that are outside of Europe and North America</p>
<pre class=def>
</pre>
<div class=ans>
pp.pprint(list(db.world.find({"$and":[{"name":{'$regex':"^U"}},{"continent":{"$nin":["Europe", "North America"]}}]},{"name":1,"_id":0})))
</div>
</div>

<div class=q data-lang="py3">
<p class=strong>Find the names of all countries that contain a white space </p>
<pre class=def>
</pre>
<div class=ans>
pp.pprint(list(db.world.find({"name":{"$regex":"^.*\s.*$"}},{"name":1,"_id":0})))
</div>
</div>

<div class=q data-lang="py3">
<p class=strong>Which country out of China, Russia, and the United States has the largest population.</p>
You might want to use [[Sort]] and limit to get the answer.
<pre class=def>
</pre>
<div class=ans>
pp.pprint(list(db.world.find({"name":{"$in":["China", "Russia", "United States"]}}).sort("population",-1).limit(1)))
</div>
</div>

<div class=q data-lang="py3">
Use [[Sort]] to find the last document in world
<p class=strong>Show the last document of world</p>
<pre class=def>
</pre>
<div class=ans>
pp.pprint(list(db.world.find().sort("$natural", -1))[0])
</div>
</div>

<div class=q data-lang="py3">
<p class=strong>Show capital and population for the top 5 capital cities starting with the letter "M" that have a population of less than 3 million </p>
<pre class=def>
</pre>
<div class=ans>
pp.pprint(list(db.world.find({"$and":[{"capital":{"$regex":"^M"}},{"population":{"$lt":3000000}}]}, {"_id":0, "capital":1, "population":1}).sort("population",-1).limit(5)))
</div>
</div>

<div class=q data-lang="py3">
<p class=strong>Show all the capitals for countries that start with the same letter as their continent</p>
<div class=hint title="Using $where with find" >
find({"$where": " boolean expression "})
</div>
<pre class=def>
</pre>
<div class=ans>
pp.pprint(list(
db.world.find(
{"$where":"this.name[0]==this.continent[0]"},
{"_id":0, "capital":1})
))
</div>
</div>

FIND Tutorial

2015-11-13T10:02:41Z

Cs66:

==Working with the <code>world</code> collection of countries==
<p>This tutorial introduces NoSQL using MonogDB and PyMongo under Python3.4. We will be using the <code>find()</code> command and comparison functions on the collection '''world''' which contains details of around 250 countries of the world:</p>
[[FIND examples]] are available.
<div class='extra_space' style='width:1em; height:6em;'></div>
<div class=q data-lang="mongo">
Use <code>find()</code> to show the details of Germany
<p class=strong>Show Germany instead of France</p>
<pre class=def>
db.world.find({name:'France'})
</pre>
<div class=ans>
db.world.find({name:'Germany'})
</div>
</div>

<div class=q data-lang="mongo">
You can use .pretty() to make the output more readable.
<p class=strong>List all the countries in the continent of "Eurasia"</p>
<pre class=def>
db.world.find({name:'Germany'}).pretty()
</pre>
<div class=ans>
db.world.find({"continent":"Eurasia"}).pretty()
</div>
</div>

<div class=q data-lang="mongo">
You can test numbers as well as strings
<p class=strong>Find the country with an area of exactly 43094</p>
<pre class=def>
db.world.find({gdp:3425956000000}).pretty()
</pre>
<div class=ans>
db.world.find({"area":43094}).pretty()
</div>
</div>

<div class=q data-lang="mongo">
You can use $gt and $lt to compare numbers and strings (greater than and less than)
<p class=strong>Show each country with a population of over 250000000</p>
<pre class=def>
db.world.find(
{"name":{"$gt":"Z"}},
{name:1,_id:0}
).pretty()
</pre>
<div class=ans>
db.world.find({"population":{"$gt":250000000}},{name:1,_id:0}).pretty()
</div>
</div>

<div class=q data-lang=mongo">
<p class=strong>List the countries in Europe that start with the letter "S"</p>
<pre class=def>
</pre>
<div class=ans>
db.world.find({"name":{'$regex':"^S"},
"continent":"Europe"},{"name":1, "_id":0})
</div>
</div>

<div class=q data-lang="py3">
<p class=strong>Find the capital cities for countries with a population of over 70 million</p>
<pre class=def>
</pre>
<div class=ans>
pp.pprint(list(db.world.find({"population":{"$gt":70000000}},{"capital":1,"_id":0})))
</div>
</div>

<div class=q data-lang="py3">
<p class=strong>Find the countries that have a population of over 100 million or less than a million</p>
<pre class=def>
</pre>
<div class=ans>
pp.pprint(list(db.world.find({"$or":[{"population":{"$lt":1000000}},{"population":{"$gt":100000000}}]}, {"name":1, "_id":0})))
</div>
</div>

<div class=q data-lang="py3">
<p class=strong>Find the names of countries beginning with "U" that are outside of Europe and North America</p>
<pre class=def>
</pre>
<div class=ans>
pp.pprint(list(db.world.find({"$and":[{"name":{'$regex':"^U"}},{"continent":{"$nin":["Europe", "North America"]}}]},{"name":1,"_id":0})))
</div>
</div>

<div class=q data-lang="py3">
<p class=strong>Find the names of all countries that contain a white space </p>
<pre class=def>
</pre>
<div class=ans>
pp.pprint(list(db.world.find({"name":{"$regex":"^.*\s.*$"}},{"name":1,"_id":0})))
</div>
</div>

<div class=q data-lang="py3">
<p class=strong>Which country out of China, Russia, and the United States has the largest population.</p>
You might want to use [[Sort]] and limit to get the answer.
<pre class=def>
</pre>
<div class=ans>
pp.pprint(list(db.world.find({"name":{"$in":["China", "Russia", "United States"]}}).sort("population",-1).limit(1)))
</div>
</div>

<div class=q data-lang="py3">
Use [[Sort]] to find the last document in world
<p class=strong>Show the last document of world</p>
<pre class=def>
</pre>
<div class=ans>
pp.pprint(list(db.world.find().sort("$natural", -1))[0])
</div>
</div>

<div class=q data-lang="py3">
<p class=strong>Show capital and population for the top 5 capital cities starting with the letter "M" that have a population of less than 3 million </p>
<pre class=def>
</pre>
<div class=ans>
pp.pprint(list(db.world.find({"$and":[{"capital":{"$regex":"^M"}},{"population":{"$lt":3000000}}]}, {"_id":0, "capital":1, "population":1}).sort("population",-1).limit(5)))
</div>
</div>

<div class=q data-lang="py3">
<p class=strong>Show all the capitals for countries that start with the same letter as their continent</p>
<div class=hint title="Using $where with find" >
find({"$where": " boolean expression "})
</div>
<pre class=def>
</pre>
<div class=ans>
pp.pprint(list(
db.world.find(
{"$where":"this.name[0]==this.continent[0]"},
{"_id":0, "capital":1})
))
</div>
</div>

FIND Tutorial

2015-11-13T10:00:19Z

Cs66:

==Working with the <code>world</code> collection of countries==
<p>This tutorial introduces NoSQL using MonogDB and PyMongo under Python3.4. We will be using the <code>find()</code> command and comparison functions on the collection '''world''' which contains details of around 250 countries of the world:</p>
[[FIND examples]] are available.
<div class='extra_space' style='width:1em; height:6em;'></div>
<div class=q data-lang="mongo">
Use <code>find()</code> to show the details of Germany
<p class=strong>Show Germany instead of France</p>
<pre class=def>
db.world.find({name:'France'})
</pre>
<div class=ans>
db.world.find({name:'Germany'})
</div>
</div>

<div class=q data-lang="mongo">
You can use .pretty() to make the output more readable.
<p class=strong>List all the countries in the continent of "Eurasia"</p>
<pre class=def>
db.world.find({name:'Germany'}).pretty()
</pre>
<div class=ans>
db.world.find({"continent":"Eurasia"}).pretty()
</div>
</div>

<div class=q data-lang="mongo">
You can test numbers as well as strings
<p class=strong>Find the country with an area of exactly 43094</p>
<pre class=def>
db.world.find({gdp:3425956000000}).pretty()
</pre>
<div class=ans>
db.world.find({"area":43094}).pretty()
</div>
</div>

<div class=q data-lang="mongo">
You can use $gt and $lt to compare numbers and strings (greater than and less than)
<p class=strong>Show each country with a population of over 250000000</p>
<pre class=def>
db.world.find(
{"continent":"Europe"},
{name:1,_id:0
).pretty()
</pre>
<div class=ans>
db.world.find({"population":250000000},{name:1,_id:0}).pretty()
</div>
</div>

<div class=q data-lang=mongo">
<p class=strong>List the countries in Europe that start with the letter "S"</p>
<pre class=def>
</pre>
<div class=ans>
db.world.find({"name":{'$regex':"^S"},
"continent":"Europe"},{"name":1, "_id":0})
</div>
</div>

<div class=q data-lang="py3">
<p class=strong>Find the capital cities for countries with a population of over 70 million</p>
<pre class=def>
</pre>
<div class=ans>
pp.pprint(list(db.world.find({"population":{"$gt":70000000}},{"capital":1,"_id":0})))
</div>
</div>

<div class=q data-lang="py3">
<p class=strong>Find the countries that have a population of over 100 million or less than a million</p>
<pre class=def>
</pre>
<div class=ans>
pp.pprint(list(db.world.find({"$or":[{"population":{"$lt":1000000}},{"population":{"$gt":100000000}}]}, {"name":1, "_id":0})))
</div>
</div>

<div class=q data-lang="py3">
<p class=strong>Find the names of countries beginning with "U" that are outside of Europe and North America</p>
<pre class=def>
</pre>
<div class=ans>
pp.pprint(list(db.world.find({"$and":[{"name":{'$regex':"^U"}},{"continent":{"$nin":["Europe", "North America"]}}]},{"name":1,"_id":0})))
</div>
</div>

<div class=q data-lang="py3">
<p class=strong>Find the names of all countries that contain a white space </p>
<pre class=def>
</pre>
<div class=ans>
pp.pprint(list(db.world.find({"name":{"$regex":"^.*\s.*$"}},{"name":1,"_id":0})))
</div>
</div>

<div class=q data-lang="py3">
<p class=strong>Which country out of China, Russia, and the United States has the largest population.</p>
You might want to use [[Sort]] and limit to get the answer.
<pre class=def>
</pre>
<div class=ans>
pp.pprint(list(db.world.find({"name":{"$in":["China", "Russia", "United States"]}}).sort("population",-1).limit(1)))
</div>
</div>

<div class=q data-lang="py3">
Use [[Sort]] to find the last document in world
<p class=strong>Show the last document of world</p>
<pre class=def>
</pre>
<div class=ans>
pp.pprint(list(db.world.find().sort("$natural", -1))[0])
</div>
</div>

<div class=q data-lang="py3">
<p class=strong>Show capital and population for the top 5 capital cities starting with the letter "M" that have a population of less than 3 million </p>
<pre class=def>
</pre>
<div class=ans>
pp.pprint(list(db.world.find({"$and":[{"capital":{"$regex":"^M"}},{"population":{"$lt":3000000}}]}, {"_id":0, "capital":1, "population":1}).sort("population",-1).limit(5)))
</div>
</div>

<div class=q data-lang="py3">
<p class=strong>Show all the capitals for countries that start with the same letter as their continent</p>
<div class=hint title="Using $where with find" >
find({"$where": " boolean expression "})
</div>
<pre class=def>
</pre>
<div class=ans>
pp.pprint(list(
db.world.find(
{"$where":"this.name[0]==this.continent[0]"},
{"_id":0, "capital":1})
))
</div>
</div>