Database Assignment

Assignment database for a json dataset.

Disclaimer

This assignment is use 10,000 rows of a json data, cause machine was not capable of processing whole file. Answers of query may differ from actual answers.

Getting Started

Start a mongo client using command.

$mongo

create a database using command.

$use traffic

create a collection

$db.createCollection(providedfile)

Prerequisites

Need following libraries:

  1. ijson
  2. pymongo
  3. pandas

Author

Hammad Ali Khan