title: Query nested documents mongodb with python pymongo
body: <p>My data look like this:</p>
  <pre><code>{'_id': ObjectId('6068da8878fa2e568c42c7f1'),
   'first': datetime.datetime(2018, 1, 24, 14, 5),
   'last': datetime.datetime(2018, 1, 24, 15, 5),
   'maxid13': 12.5,
   'minid13': 7.5,
   'nsamples': 13,
   'samples': [{'c14': 'C',
                'id1': 3758.0,
                'id10': 0.0,
                'id11': 274.0,
                'id12': 0.0,
                'id13': 7.5,
                'id15': 0.0,
                'id16': 73.0,
                'id17': 0.0,
                'id18': 0.342,
                'id19': 6.3,
                'id20': 1206.0,
                'id21': 0.0,
                'id22': 0.87,
                'id23': 0.0,
                'id6': 2.0,
                'id7': -79.09,
                'id8': 35.97,
                'id9': 5.8,
                'timestamp1': datetime.datetime(2018, 1, 24, 14, 5),
                'timestamp2': datetime.datetime(2018, 1, 24, 9, 5)},
               {'c14': 'C',
                'id1': 3758.0,
                'id10': 0.0,
                'id11': 288.0,
                'id12': 0.0,
                'id13': 8.4,
                'id15': 0.0,
                'id16': 71.0,
                'id17': 0.0,
                'id18': 0.342,
                'id19': 6.3,
                'id20': 1207.0,
                'id21': 0.0,
                'id22': 0.69,
                'id23': 0.0,
                'id6': 2.0,
                'id7': -79.09,
                'id8': 35.97,
                'id9': 6.2,
                'timestamp1': datetime.datetime(2018, 1, 24, 14, 10),
                'timestamp2': datetime.datetime(2018, 1, 24, 9, 10)},
                 .
                 .
                 .
                 .
  </code></pre>
  <p>Can someone help on how to find for example the <code>id13</code> when <code>timestamp1</code> is equals to
  <code> datetime.datetime(2018, 1, 24, 14, 5)</code>
  <code>Samples</code> is an <code>array</code>.
  This is what i have wrote.</p>
  <pre><code>cursor = mydb1.mongodbbucket.aggregate(
            [
                {
                  &quot;$match&quot;: {
                     &quot;samples.timestamp1&quot;: {&quot;$eq&quot;: datetime.strptime(&quot;2018-01-24 14:10:00&quot;, &quot;%Y-%m-%d %H:%M:%S&quot;)}
                  }
                },
  
                {
                    &quot;$project&quot;: {
  
                        &quot;samples.id13&quot;: 1
                    }
                },
              ]
          )   )
  </code></pre>
  <p>The ideal output would be <code>id13</code>:7.5</p>