data-use.ipynb

   1 {
   2  "metadata": {
   3   "name": ""
   4  },
   5  "nbformat": 3,
   6  "nbformat_minor": 0,
   7  "worksheets": [
   8   {
   9    "cells": [
  10     {
  11      "cell_type": "code",
  12      "collapsed": false,
  13      "input": [
  14       "import pymongo\n",
  15       "client = pymongo.MongoClient('mongodb://ogedei:27017/')"
  16      ],
  17      "language": "python",
  18      "metadata": {},
  19      "outputs": [],
  20      "prompt_number": 1
  21     },
  22     {
  23      "cell_type": "code",
  24      "collapsed": false,
  25      "input": [
  26       "db = client.accidents"
  27      ],
  28      "language": "python",
  29      "metadata": {},
  30      "outputs": [],
  31      "prompt_number": 4
  32     },
  33     {
  34      "cell_type": "code",
  35      "collapsed": false,
  36      "input": [
  37       "accidents.find().count()"
  38      ],
  39      "language": "python",
  40      "metadata": {},
  41      "outputs": [
  42       {
  43        "metadata": {},
  44        "output_type": "pyout",
  45        "prompt_number": 5,
  46        "text": [
  47         "1355615"
  48        ]
  49       }
  50      ],
  51      "prompt_number": 5
  52     },
  53     {
  54      "cell_type": "code",
  55      "collapsed": false,
  56      "input": [
  57       "[accidents.find_one({'Accident_Index':v['Acc_Index']}, ['Accident_Index', 'Date']) for v in vehicles.find(fields=['Acc_Index'], limit=10)]"
  58      ],
  59      "language": "python",
  60      "metadata": {},
  61      "outputs": [
  62       {
  63        "metadata": {},
  64        "output_type": "pyout",
  65        "prompt_number": 6,
  66        "text": [
  67         "[]"
  68        ]
  69       }
  70      ],
  71      "prompt_number": 6
  72     },
  73     {
  74      "cell_type": "code",
  75      "collapsed": false,
  76      "input": [
  77       "# Find all the vehicles that don't have an accident\n",
  78       "for v in vehicles.find(fields=['Acc_Index']):\n",
  79       "    if not accidents.find_one({'Accident_Index': v['Acc_Index']}):\n",
  80       "        print(v)"
  81      ],
  82      "language": "python",
  83      "metadata": {},
  84      "outputs": [],
  85      "prompt_number": 14
  86     },
  87     {
  88      "cell_type": "code",
  89      "collapsed": false,
  90      "input": [
  91       "for v in vehicles.find():\n",
  92       "    accidents.update({'Accident_Index': v['Acc_Index']}, {'$push' : {\"Involved_Vehicles\" : v}})"
  93      ],
  94      "language": "python",
  95      "metadata": {},
  96      "outputs": [],
  97      "prompt_number": 7
  98     },
  99     {
 100      "cell_type": "code",
 101      "collapsed": false,
 102      "input": [
 103       "for v in vehicles.find():\n",
 104       "    accidents.update({'Accident_Index': v['Acc_Index']}, {'$push' : {\"Vehicles\" : v}})"
 105      ],
 106      "language": "python",
 107      "metadata": {},
 108      "outputs": [],
 109      "prompt_number": 8
 110     },
 111     {
 112      "cell_type": "code",
 113      "collapsed": false,
 114      "input": [
 115       "for c in casualties.find():\n",
 116       "    accidents.update({'Accident_Index': c['Acc_Index']}, {'$push' : {\"Casualties\" : c}})"
 117      ],
 118      "language": "python",
 119      "metadata": {},
 120      "outputs": [],
 121      "prompt_number": 9
 122     },
 123     {
 124      "cell_type": "code",
 125      "collapsed": false,
 126      "input": [
 127       "accidents.update({\"$exists\": \"Involved_Vehicles\"}, {\"$unset\": {\"Involved_Vehicles\":1}})"
 128      ],
 129      "language": "python",
 130      "metadata": {},
 131      "outputs": [
 132       {
 133        "metadata": {},
 134        "output_type": "pyout",
 135        "prompt_number": 11,
 136        "text": [
 137         "{'connectionId': 20, 'err': None, 'n': 0, 'ok': 1.0, 'updatedExisting': False}"
 138        ]
 139       }
 140      ],
 141      "prompt_number": 11
 142     },
 143     {
 144      "cell_type": "code",
 145      "collapsed": false,
 146      "input": [
 147       "accidents.find({\"Involved_Vehicles\" : {\"$exists\" : 1}}).count()"
 148      ],
 149      "language": "python",
 150      "metadata": {},
 151      "outputs": [
 152       {
 153        "metadata": {},
 154        "output_type": "pyout",
 155        "prompt_number": 22,
 156        "text": [
 157         "0"
 158        ]
 159       }
 160      ],
 161      "prompt_number": 22
 162     },
 163     {
 164      "cell_type": "code",
 165      "collapsed": false,
 166      "input": [
 167       "accidents.update({\"Involved_Vehicles\" : {\"$exists\" : 1}}, {\"$unset\": {\"Involved_Vehicles\":1}}, multi=True)"
 168      ],
 169      "language": "python",
 170      "metadata": {},
 171      "outputs": [
 172       {
 173        "metadata": {},
 174        "output_type": "pyout",
 175        "prompt_number": 21,
 176        "text": [
 177         "{'connectionId': 20, 'err': None, 'n': 57, 'ok': 1.0, 'updatedExisting': True}"
 178        ]
 179       }
 180      ],
 181      "prompt_number": 21
 182     },
 183     {
 184      "cell_type": "code",
 185      "collapsed": false,
 186      "input": [],
 187      "language": "python",
 188      "metadata": {},
 189      "outputs": []
 190     }
 191    ],
 192    "metadata": {}
 193   }
 194  ]
 195 }