communities.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### This notebook constructs an asynchronous query to do a heavyduty calculation periodically and then store the resulting data (top 1000 tag categories) into a separate key-value DynamoDB data store for faster more efficient and performant retrieval for near real-time processing. \n",
    "#### This enables us to efficiently store semi-permanent data into an efficient key-value data store which is optimized for reads, and split the workload of the client facing component of the project. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pymongo\n",
    "from IPython.display import display\n",
    "from pymongo import MongoClient\n",
    "import pandas as pd\n",
    "from dotenv import dotenv_values\n",
    "\n",
    "\n",
    "config = dotenv_values(\".env.local\")\n",
    "\n",
    "# setup mongo connection\n",
    "client = MongoClient('mongodb+srv://' + config['MONGO_USER'] + ':' + config['MONGO_PASS'] + '@final-cluster.uucno.mongodb.net')\n",
    "db = client.final\n",
    "col = db.StackOverflowPosts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Aggregation pipeline - count of each tag\n",
    "pipeline = [\n",
    "    # Project only the 'Tags' field\n",
    "    {\n",
    "        \"$project\": {\n",
    "            \"Tags\": 1\n",
    "        }\n",
    "    },\n",
    "    # Filter out documents where 'Tags' is missing or is not an array\n",
    "    {\n",
    "        \"$match\": {\n",
    "            \"Tags\": {\"$exists\": True, \"$type\": \"array\"}\n",
    "        }\n",
    "    },\n",
    "    # Unwind the 'Tags' array to create a document for each tag\n",
    "    {\n",
    "        \"$unwind\": \"$Tags\"\n",
    "    },\n",
    "    # Group by tag and count occurrences\n",
    "    {\n",
    "        \"$group\": {\n",
    "            \"_id\": \"$Tags\",\n",
    "            \"count\": {\"$sum\": 1}\n",
    "        }\n",
    "    },\n",
    "    # Sort by count in descending order\n",
    "    {\n",
    "        \"$sort\": {\"count\": -1}\n",
    "    },\n",
    "    # Limit to the top 1000 tags\n",
    "    {\n",
    "        \"$limit\": 1000\n",
    "    }\n",
    "]\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Execute the aggregation query\n",
    "docs = list(col.aggregate(pipeline))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "import boto3\n",
    "from botocore.exceptions import ClientError\n",
    "\n",
    "# Initialize a DynamoDB client\n",
    "dynamodb = boto3.resource('dynamodb', aws_access_key_id = config['ACCESS_ID'], aws_secret_access_key=config['SECRET_KEY'],region_name='us-east-1')\n",
    "\n",
    "# Reference to your DynamoDB table\n",
    "table_name = \"final\"\n",
    "table = dynamodb.Table(table_name)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Careful running the AWS code, double check if the table is cleared when uploading the 1000 top tags"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# delete and recreate table - mimics clearing the data for new calculated content\n",
    "\n",
    "# Delete the table\n",
    "table.delete()\n",
    "print(f\"Table '{table_name}' deleted.\")\n",
    "\n",
    "# Wait for the table to be deleted\n",
    "table.wait_until_not_exists()\n",
    "\n",
    "# Recreate the table (example schema)\n",
    "new_table = dynamodb.create_table(\n",
    "    TableName=table_name,\n",
    "    KeySchema=[{'AttributeName': 'tag', 'KeyType': 'HASH'}],\n",
    "    AttributeDefinitions=[{'AttributeName': 'tag', 'AttributeType': 'S'}],\n",
    "    ProvisionedThroughput={'ReadCapacityUnits': 5, 'WriteCapacityUnits': 5}\n",
    ")\n",
    "\n",
    "# Wait for the table to be created\n",
    "new_table.wait_until_exists()\n",
    "print(f\"Table '{table_name}' recreated.\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1000\n",
      "[{'_id': 'javascript', 'count': 2496567}, {'_id': 'python', 'count': 2138942}, {'_id': 'java', 'count': 1898054}, {'_id': 'c#', 'count': 1592815}, {'_id': 'php', 'count': 1458812}, {'_id': 'android', 'count': 1404681}, {'_id': 'html', 'count': 1174530}, {'_id': 'jquery', 'count': 1033935}, {'_id': 'c++', 'count': 794407}, {'_id': 'css', 'count': 792766}, {'_id': 'ios', 'count': 681166}, {'_id': 'sql', 'count': 661392}, {'_id': 'mysql', 'count': 660061}, {'_id': 'r', 'count': 490741}, {'_id': 'node.js', 'count': 462679}, {'_id': 'reactjs', 'count': 456594}, {'_id': 'arrays', 'count': 413135}, {'_id': 'c', 'count': 396698}, {'_id': 'asp.net', 'count': 373010}, {'_id': 'json', 'count': 356195}, {'_id': 'python-3.x', 'count': 338362}, {'_id': 'ruby-on-rails', 'count': 336846}, {'_id': '.net', 'count': 331660}, {'_id': 'sql-server', 'count': 330256}, {'_id': 'swift', 'count': 327523}, {'_id': 'django', 'count': 306986}, {'_id': 'angular', 'count': 296194}, {'_id': 'objective-c', 'count': 292498}, {'_id': 'pandas', 'count': 279740}, {'_id': 'excel', 'count': 279248}, {'_id': 'angularjs', 'count': 262749}, {'_id': 'regex', 'count': 258051}, {'_id': 'ruby', 'count': 227954}, {'_id': 'linux', 'count': 224667}, {'_id': 'ajax', 'count': 221746}, {'_id': 'iphone', 'count': 221460}, {'_id': 'typescript', 'count': 216375}, {'_id': 'xml', 'count': 213133}, {'_id': 'vba', 'count': 209478}, {'_id': 'spring', 'count': 206982}, {'_id': 'laravel', 'count': 206199}, {'_id': 'asp.net-mvc', 'count': 200623}, {'_id': 'database', 'count': 193002}, {'_id': 'wordpress', 'count': 190601}, {'_id': 'string', 'count': 182644}, {'_id': 'mongodb', 'count': 173454}, {'_id': 'postgresql', 'count': 169838}, {'_id': 'wpf', 'count': 168432}, {'_id': 'windows', 'count': 165438}, {'_id': 'flutter', 'count': 162762}, {'_id': 'xcode', 'count': 158215}, {'_id': 'bash', 'count': 153018}, {'_id': 'amazon-web-services', 'count': 152395}, {'_id': 'oracle', 'count': 148847}, {'_id': 'git', 'count': 148820}, {'_id': 'dataframe', 'count': 141651}, {'_id': 'firebase', 'count': 139988}, {'_id': 'spring-boot', 'count': 139910}, {'_id': 'list', 'count': 139840}, {'_id': 'vb.net', 'count': 139438}, {'_id': 'multithreading', 'count': 138589}, {'_id': 'azure', 'count': 131741}, {'_id': 'react-native', 'count': 131567}, {'_id': 'docker', 'count': 130528}, {'_id': 'eclipse', 'count': 124584}, {'_id': 'algorithm', 'count': 118753}, {'_id': 'macos', 'count': 115693}, {'_id': 'visual-studio', 'count': 113217}, {'_id': 'image', 'count': 113069}, {'_id': 'powershell', 'count': 113003}, {'_id': 'forms', 'count': 112937}, {'_id': 'scala', 'count': 111447}, {'_id': 'numpy', 'count': 111419}, {'_id': 'function', 'count': 109727}, {'_id': 'api', 'count': 109220}, {'_id': 'vue.js', 'count': 103973}, {'_id': 'twitter-bootstrap', 'count': 102960}, {'_id': 'selenium', 'count': 102331}, {'_id': 'performance', 'count': 100600}, {'_id': 'winforms', 'count': 97967}, {'_id': 'loops', 'count': 95419}, {'_id': 'python-2.7', 'count': 95366}, {'_id': 'matlab', 'count': 94337}, {'_id': 'hibernate', 'count': 93807}, {'_id': 'sqlite', 'count': 93688}, {'_id': 'express', 'count': 93179}, {'_id': 'rest', 'count': 92215}, {'_id': 'apache', 'count': 92198}, {'_id': 'shell', 'count': 91490}, {'_id': 'entity-framework', 'count': 91181}, {'_id': 'android-studio', 'count': 89558}, {'_id': 'csv', 'count': 89149}, {'_id': 'kotlin', 'count': 88522}, {'_id': 'dart', 'count': 88252}, {'_id': 'maven', 'count': 87025}, {'_id': 'linq', 'count': 85897}, {'_id': 'facebook', 'count': 85662}, {'_id': 'qt', 'count': 85157}, {'_id': 'dictionary', 'count': 85089}, {'_id': 'unit-testing', 'count': 84303}, {'_id': 'tensorflow', 'count': 81855}, {'_id': 'file', 'count': 80891}, {'_id': 'swing', 'count': 80886}, {'_id': 'apache-spark', 'count': 80411}, {'_id': 'class', 'count': 79025}, {'_id': 'asp.net-core', 'count': 77676}, {'_id': 'sorting', 'count': 75913}, {'_id': 'date', 'count': 75822}, {'_id': 'authentication', 'count': 74273}, {'_id': 'unity-game-engine', 'count': 74178}, {'_id': 'symfony', 'count': 73222}, {'_id': '.htaccess', 'count': 72773}, {'_id': 'tsql', 'count': 72431}, {'_id': 'google-chrome', 'count': 71585}, {'_id': 'opencv', 'count': 71188}, {'_id': 'for-loop', 'count': 71040}, {'_id': 'matplotlib', 'count': 70830}, {'_id': 'datetime', 'count': 69909}, {'_id': 'codeigniter', 'count': 69489}, {'_id': 'go', 'count': 69269}, {'_id': 'perl', 'count': 67661}, {'_id': 'http', 'count': 67494}, {'_id': 'validation', 'count': 66865}, {'_id': 'sockets', 'count': 66103}, {'_id': 'google-maps', 'count': 65729}, {'_id': 'object', 'count': 64628}, {'_id': 'uitableview', 'count': 64428}, {'_id': 'xaml', 'count': 61647}, {'_id': 'cordova', 'count': 61570}, {'_id': 'oop', 'count': 61538}, {'_id': 'if-statement', 'count': 61284}, {'_id': 'ubuntu', 'count': 60237}, {'_id': 'web-services', 'count': 60167}, {'_id': 'android-layout', 'count': 59124}, {'_id': 'email', 'count': 59057}, {'_id': 'spring-mvc', 'count': 58133}, {'_id': 'elasticsearch', 'count': 57597}, {'_id': 'ms-access', 'count': 57055}, {'_id': 'parsing', 'count': 57034}, {'_id': 'user-interface', 'count': 56468}, {'_id': 'c++11', 'count': 56368}, {'_id': 'ruby-on-rails-3', 'count': 56107}, {'_id': 'kubernetes', 'count': 55963}, {'_id': 'pointers', 'count': 55902}, {'_id': 'security', 'count': 55892}, {'_id': 'github', 'count': 55880}, {'_id': 'visual-studio-code', 'count': 55062}, {'_id': 'machine-learning', 'count': 54582}, {'_id': 'templates', 'count': 54139}, {'_id': 'nginx', 'count': 54122}, {'_id': 'sql-server-2008', 'count': 53853}, {'_id': 'variables', 'count': 53631}, {'_id': 'ggplot2', 'count': 53547}, {'_id': 'batch-file', 'count': 53533}, {'_id': 'exception', 'count': 53209}, {'_id': 'flask', 'count': 53123}, {'_id': 'listview', 'count': 52522}, {'_id': 'selenium-webdriver', 'count': 52509}, {'_id': 'jsp', 'count': 52271}, {'_id': 'google-apps-script', 'count': 52189}, {'_id': 'google-sheets', 'count': 51635}, {'_id': 'debugging', 'count': 51445}, {'_id': 'jpa', 'count': 51126}, {'_id': 'delphi', 'count': 50953}, {'_id': 'wcf', 'count': 50820}, {'_id': 'haskell', 'count': 50656}, {'_id': 'pdf', 'count': 50603}, {'_id': 'tkinter', 'count': 50596}, {'_id': 'asynchronous', 'count': 50590}, {'_id': 'gradle', 'count': 50395}, {'_id': 'xamarin', 'count': 50342}, {'_id': 'ssl', 'count': 50313}, {'_id': 'jenkins', 'count': 50052}, {'_id': 'amazon-s3', 'count': 49384}, {'_id': 'testing', 'count': 49298}, {'_id': 'web-scraping', 'count': 48739}, {'_id': 'npm', 'count': 48734}, {'_id': 'generics', 'count': 48675}, {'_id': 'ionic-framework', 'count': 48228}, {'_id': 'web', 'count': 47440}, {'_id': 'unix', 'count': 47409}, {'_id': 'google-app-engine', 'count': 46899}, {'_id': 'visual-studio-2010', 'count': 46804}, {'_id': 'recursion', 'count': 46361}, {'_id': 'mongoose', 'count': 46282}, {'_id': 'google-cloud-platform', 'count': 45821}, {'_id': 'android-fragments', 'count': 45649}, {'_id': 'session', 'count': 44428}, {'_id': 'animation', 'count': 44295}, {'_id': 'hadoop', 'count': 44249}, {'_id': 'heroku', 'count': 43851}, {'_id': 'laravel-5', 'count': 43718}, {'_id': 'curl', 'count': 43557}, {'_id': 'math', 'count': 43406}, {'_id': 'url', 'count': 43317}, {'_id': '.net-core', 'count': 43228}, {'_id': 'svg', 'count': 43120}, {'_id': 'join', 'count': 43062}, {'_id': 'django-models', 'count': 43053}, {'_id': 'tomcat', 'count': 42923}, {'_id': 'assembly', 'count': 42843}, {'_id': 'intellij-idea', 'count': 42525}, {'_id': 'asp.net-mvc-4', 'count': 42399}, {'_id': 'redirect', 'count': 42353}, {'_id': 'webpack', 'count': 42266}, {'_id': 'keras', 'count': 42030}, {'_id': 'inheritance', 'count': 41997}, {'_id': 'winapi', 'count': 41909}, {'_id': 'image-processing', 'count': 41764}, {'_id': 'actionscript-3', 'count': 41268}, {'_id': 'dom', 'count': 41233}, {'_id': 'google-cloud-firestore', 'count': 40950}, {'_id': 'logging', 'count': 40749}, {'_id': 'matrix', 'count': 40616}, {'_id': 'post', 'count': 40597}, {'_id': 'gcc', 'count': 40572}, {'_id': 'button', 'count': 40190}, {'_id': 'firebase-realtime-database', 'count': 39883}, {'_id': 'jquery-ui', 'count': 39790}, {'_id': 'cocoa', 'count': 39604}, {'_id': 'd3.js', 'count': 39183}, {'_id': 'internet-explorer', 'count': 39146}, {'_id': 'xpath', 'count': 38924}, {'_id': 'iis', 'count': 38652}, {'_id': 'firefox', 'count': 38648}, {'_id': 'optimization', 'count': 38522}, {'_id': 'asp.net-mvc-3', 'count': 38520}, {'_id': 'select', 'count': 38345}, {'_id': 'pyspark', 'count': 38187}, {'_id': 'networking', 'count': 38127}, {'_id': 'xslt', 'count': 38070}, {'_id': 'opengl', 'count': 37887}, {'_id': 'magento', 'count': 37833}, {'_id': 'events', 'count': 37784}, {'_id': 'javafx', 'count': 37781}, {'_id': 'caching', 'count': 37735}, {'_id': 'asp.net-web-api', 'count': 37496}, {'_id': 'plot', 'count': 37288}, {'_id': 'search', 'count': 37117}, {'_id': 'rust', 'count': 36874}, {'_id': 'ruby-on-rails-4', 'count': 36777}, {'_id': 'encryption', 'count': 36700}, {'_id': 'stored-procedures', 'count': 36679}, {'_id': 'amazon-ec2', 'count': 36177}, {'_id': 'audio', 'count': 35807}, {'_id': 'canvas', 'count': 35768}, {'_id': 'jsf', 'count': 35728}, {'_id': 'memory', 'count': 35666}, {'_id': 'dplyr', 'count': 35388}, {'_id': 'redux', 'count': 35340}, {'_id': 'multidimensional-array', 'count': 35099}, {'_id': 'random', 'count': 35048}, {'_id': 'flash', 'count': 35039}, {'_id': 'facebook-graph-api', 'count': 34947}, {'_id': 'vector', 'count': 34846}, {'_id': 'input', 'count': 34738}, {'_id': 'ipad', 'count': 34724}, {'_id': 'cocoa-touch', 'count': 34599}, {'_id': 'cookies', 'count': 34584}, {'_id': 'arraylist', 'count': 34398}, {'_id': 'xamarin.forms', 'count': 34294}, {'_id': 'video', 'count': 33934}, {'_id': 'swiftui', 'count': 33882}, {'_id': 'indexing', 'count': 33747}, {'_id': 'model-view-controller', 'count': 33546}, {'_id': 'servlets', 'count': 33276}, {'_id': 'data-structures', 'count': 33242}, {'_id': 'mod-rewrite', 'count': 33012}, {'_id': 'serialization', 'count': 32997}, {'_id': 'jdbc', 'count': 32986}, {'_id': 'razor', 'count': 32885}, {'_id': 'routes', 'count': 32807}, {'_id': 'woocommerce', 'count': 32628}, {'_id': 'awk', 'count': 32527}, {'_id': 'iframe', 'count': 32526}, {'_id': 'beautifulsoup', 'count': 31976}, {'_id': 'design-patterns', 'count': 31860}, {'_id': 'filter', 'count': 31731}, {'_id': 'cakephp', 'count': 31703}, {'_id': 'text', 'count': 31594}, {'_id': 'next.js', 'count': 31427}, {'_id': 'visual-c++', 'count': 31263}, {'_id': 'apache-kafka', 'count': 31146}, {'_id': 'django-rest-framework', 'count': 31019}, {'_id': 'android-intent', 'count': 30884}, {'_id': 'mobile', 'count': 30329}, {'_id': 'methods', 'count': 30188}, {'_id': 'struct', 'count': 30033}, {'_id': 'aws-lambda', 'count': 29957}, {'_id': 'grails', 'count': 29876}, {'_id': 'ecmascript-6', 'count': 29850}, {'_id': 'mvvm', 'count': 29816}, {'_id': 'checkbox', 'count': 29738}, {'_id': 'groovy', 'count': 29707}, {'_id': 'ssh', 'count': 29707}, {'_id': 'excel-formula', 'count': 29691}, {'_id': 'docker-compose', 'count': 29676}, {'_id': 'lambda', 'count': 29575}, {'_id': 'time', 'count': 29555}, {'_id': 'jakarta-ee', 'count': 29459}, {'_id': 'azure-devops', 'count': 29454}, {'_id': 'android-recyclerview', 'count': 29128}, {'_id': 'installation', 'count': 29123}, {'_id': 'meteor', 'count': 29079}, {'_id': 'google-chrome-extension', 'count': 29030}, {'_id': 'core-data', 'count': 28994}, {'_id': 'sharepoint', 'count': 28961}, {'_id': 'android-activity', 'count': 28949}, {'_id': 'react-hooks', 'count': 28924}, {'_id': 'bootstrap-4', 'count': 28729}, {'_id': 'activerecord', 'count': 28613}, {'_id': 'graph', 'count': 28600}, {'_id': 'sed', 'count': 28401}, {'_id': 'plsql', 'count': 28359}, {'_id': 'types', 'count': 28147}, {'_id': 'shiny', 'count': 28034}, {'_id': 'file-upload', 'count': 27981}, {'_id': 'vim', 'count': 27901}, {'_id': 'spring-security', 'count': 27830}, {'_id': 'scikit-learn', 'count': 27793}, {'_id': 'replace', 'count': 27757}, {'_id': 'junit', 'count': 27651}, {'_id': 'websocket', 'count': 27634}, {'_id': 'soap', 'count': 27608}, {'_id': 'boost', 'count': 27408}, {'_id': 'silverlight', 'count': 27263}, {'_id': 'memory-management', 'count': 27178}, {'_id': 'group-by', 'count': 27158}, {'_id': 'dynamic', 'count': 27097}, {'_id': 'import', 'count': 27007}, {'_id': 'deep-learning', 'count': 26981}, {'_id': 'sass', 'count': 26972}, {'_id': 'cmake', 'count': 26959}, {'_id': 'eloquent', 'count': 26805}, {'_id': 'gridview', 'count': 26786}, {'_id': 'svn', 'count': 26711}, {'_id': 'layout', 'count': 26621}, {'_id': 'error-handling', 'count': 26598}, {'_id': 'browser', 'count': 26425}, {'_id': 'apache-spark-sql', 'count': 26298}, {'_id': 'cmd', 'count': 26279}, {'_id': 'charts', 'count': 26266}, {'_id': 'async-await', 'count': 26224}, {'_id': 'vuejs2', 'count': 26196}, {'_id': 'while-loop', 'count': 26141}, {'_id': 'dependency-injection', 'count': 26053}, {'_id': 'view', 'count': 25917}, {'_id': 'ffmpeg', 'count': 25898}, {'_id': 'c#-4.0', 'count': 25858}, {'_id': 'dll', 'count': 25719}, {'_id': 'highcharts', 'count': 25605}, {'_id': 'foreach', 'count': 25512}, {'_id': 'deployment', 'count': 25503}, {'_id': 'plugins', 'count': 25417}, {'_id': 'reporting-services', 'count': 25405}, {'_id': 'twitter', 'count': 25213}, {'_id': 'google-maps-api-3', 'count': 25023}, {'_id': 'mysqli', 'count': 24974}, {'_id': 'makefile', 'count': 24939}, {'_id': 'extjs', 'count': 24847}, {'_id': 'https', 'count': 24844}, {'_id': 'unicode', 'count': 24816}, {'_id': 'server', 'count': 24806}, {'_id': 'reflection', 'count': 24790}, {'_id': 'merge', 'count': 24757}, {'_id': 'redis', 'count': 24576}, {'_id': 'google-bigquery', 'count': 24545}, {'_id': 'jupyter-notebook', 'count': 24299}, {'_id': 'netbeans', 'count': 24153}, {'_id': 'split', 'count': 24132}, {'_id': 'encoding', 'count': 24055}, {'_id': 'apache-flex', 'count': 23968}, {'_id': 'database-design', 'count': 23952}, {'_id': 'ember.js', 'count': 23949}, {'_id': 'terminal', 'count': 23916}, {'_id': 'pdo', 'count': 23906}, {'_id': 'collections', 'count': 23871}, {'_id': 'hash', 'count': 23868}, {'_id': 'axios', 'count': 23808}, {'_id': 'django-views', 'count': 23808}, {'_id': 'data-binding', 'count': 23593}, {'_id': 'tcp', 'count': 23571}, {'_id': 'oauth-2.0', 'count': 23463}, {'_id': 'command-line', 'count': 23341}, {'_id': 'react-redux', 'count': 23272}, {'_id': 'automation', 'count': 23184}, {'_id': 'printing', 'count': 23100}, {'_id': 'service', 'count': 23064}, {'_id': 'visual-studio-2012', 'count': 22962}, {'_id': 'build', 'count': 22937}, {'_id': 'pip', 'count': 22884}, {'_id': 'java-8', 'count': 22874}, {'_id': 'html-table', 'count': 22839}, {'_id': 'sqlalchemy', 'count': 22701}, {'_id': 'ansible', 'count': 22689}, {'_id': 'jquery-mobile', 'count': 22618}, {'_id': 'parameters', 'count': 22560}, {'_id': 'neo4j', 'count': 22558}, {'_id': 'jestjs', 'count': 22501}, {'_id': 'web-applications', 'count': 22402}, {'_id': 'promise', 'count': 22385}, {'_id': 'webview', 'count': 22370}, {'_id': 'module', 'count': 22367}, {'_id': 'concurrency', 'count': 22298}, {'_id': 'uwp', 'count': 22161}, {'_id': 'enums', 'count': 22109}, {'_id': 'utf-8', 'count': 22098}, {'_id': 'datatable', 'count': 22095}, {'_id': 'spring-data-jpa', 'count': 22011}, {'_id': 'lua', 'count': 21958}, {'_id': 'drop-down-menu', 'count': 21784}, {'_id': 'hive', 'count': 21779}, {'_id': 'pytorch', 'count': 21749}, {'_id': 'tfs', 'count': 21742}, {'_id': 'outlook', 'count': 21714}, {'_id': 'material-ui', 'count': 21655}, {'_id': 'scroll', 'count': 21610}, {'_id': 'flexbox', 'count': 21569}, {'_id': 'colors', 'count': 21529}, {'_id': 'python-requests', 'count': 21484}, {'_id': 'twitter-bootstrap-3', 'count': 21472}, {'_id': 'count', 'count': 21374}, {'_id': 'syntax', 'count': 21322}, {'_id': 'firebase-authentication', 'count': 21289}, {'_id': 'parallel-processing', 'count': 21126}, {'_id': 'google-analytics', 'count': 21101}, {'_id': 'file-io', 'count': 21058}, {'_id': 'ssis', 'count': 21042}, {'_id': 'scipy', 'count': 20939}, {'_id': 'paypal', 'count': 20919}, {'_id': 'fonts', 'count': 20859}, {'_id': 'gwt', 'count': 20821}, {'_id': 'constructor', 'count': 20816}, {'_id': 'ms-word', 'count': 20691}, {'_id': 'backbone.js', 'count': 20633}, {'_id': 'three.js', 'count': 20611}, {'_id': 'entity-framework-core', 'count': 20577}, {'_id': 'socket.io', 'count': 20554}, {'_id': 'datatables', 'count': 20538}, {'_id': 'graphql', 'count': 20524}, {'_id': 'solr', 'count': 20509}, {'_id': 'cassandra', 'count': 20481}, {'_id': 'url-rewriting', 'count': 20445}, {'_id': 'zend-framework', 'count': 20421}, {'_id': 'graphics', 'count': 20409}, {'_id': 'rxjs', 'count': 20348}, {'_id': 'drupal', 'count': 20332}, {'_id': 'knockout.js', 'count': 20271}, {'_id': 'datagridview', 'count': 20258}, {'_id': 'oracle11g', 'count': 20237}, {'_id': 'discord', 'count': 20133}, {'_id': 'memory-leaks', 'count': 20076}, {'_id': 'oauth', 'count': 19987}, {'_id': 'compiler-errors', 'count': 19986}, {'_id': 'pygame', 'count': 19975}, {'_id': 'react-router', 'count': 19970}, {'_id': 'django-forms', 'count': 19920}, {'_id': 'neural-network', 'count': 19877}, {'_id': 'nlp', 'count': 19845}, {'_id': 'interface', 'count': 19831}, {'_id': 'windows-phone-7', 'count': 19682}, {'_id': 'parse-platform', 'count': 19680}, {'_id': 'visual-studio-2015', 'count': 19635}, {'_id': 'casting', 'count': 19623}, {'_id': 'linked-list', 'count': 19621}, {'_id': 'triggers', 'count': 19578}, {'_id': 'google-api', 'count': 19542}, {'_id': 'proxy', 'count': 19509}, {'_id': 'timer', 'count': 19500}, {'_id': 'directory', 'count': 19418}, {'_id': 'cron', 'count': 19334}, {'_id': 'django-templates', 'count': 19332}, {'_id': 'primefaces', 'count': 19274}, {'_id': 'path', 'count': 19271}, {'_id': 'orm', 'count': 19212}, {'_id': 'arduino', 'count': 19146}, {'_id': 'angular-material', 'count': 19041}, {'_id': 'push-notification', 'count': 19021}, {'_id': 'conditional-statements', 'count': 18934}, {'_id': 'model', 'count': 18907}, {'_id': 'jar', 'count': 18821}, {'_id': 'functional-programming', 'count': 18816}, {'_id': 'visual-studio-2013', 'count': 18777}, {'_id': 'xamarin.android', 'count': 18702}, {'_id': 'jmeter', 'count': 18700}, {'_id': 'uiview', 'count': 18696}, {'_id': 'vbscript', 'count': 18689}, {'_id': 'hyperlink', 'count': 18577}, {'_id': 'swift3', 'count': 18448}, {'_id': 'sql-server-2005', 'count': 18396}, {'_id': 'download', 'count': 18337}, {'_id': 'windows-phone-8', 'count': 18219}, {'_id': 'rspec', 'count': 18154}, {'_id': 'process', 'count': 18110}, {'_id': 'properties', 'count': 18056}, {'_id': 'combobox', 'count': 18008}, {'_id': 'callback', 'count': 17988}, {'_id': 'configuration', 'count': 17911}, {'_id': 'scrapy', 'count': 17654}, {'_id': 'powerbi', 'count': 17641}, {'_id': 'emacs', 'count': 17639}, {'_id': 'safari', 'count': 17627}, {'_id': 'pagination', 'count': 17588}, {'_id': 'scripting', 'count': 17581}, {'_id': 'clojure', 'count': 17566}, {'_id': 'angularjs-directive', 'count': 17526}, {'_id': 'nhibernate', 'count': 17501}, {'_id': 'permissions', 'count': 17470}, {'_id': 'io', 'count': 17445}, {'_id': 'scope', 'count': 17445}, {'_id': 'terraform', 'count': 17382}, {'_id': 'raspberry-pi', 'count': 17379}, {'_id': 'request', 'count': 17328}, {'_id': 'playframework', 'count': 17252}, {'_id': 'google-cloud-functions', 'count': 17228}, {'_id': 'responsive-design', 'count': 17197}, {'_id': 'linux-kernel', 'count': 17197}, {'_id': 'mongodb-query', 'count': 17190}, {'_id': 'dns', 'count': 17147}, {'_id': 'gitlab', 'count': 17139}, {'_id': 'doctrine-orm', 'count': 17139}, {'_id': 'azure-active-directory', 'count': 17118}, {'_id': 'binding', 'count': 17096}, {'_id': 'compilation', 'count': 17095}, {'_id': 'bluetooth', 'count': 17086}, {'_id': 'get', 'count': 17066}, {'_id': 'version-control', 'count': 17055}, {'_id': 'sql-server-2012', 'count': 17052}, {'_id': 'reference', 'count': 16976}, {'_id': 'jwt', 'count': 16957}, {'_id': 'architecture', 'count': 16953}, {'_id': '3d', 'count': 16946}, {'_id': 'discord.js', 'count': 16900}, {'_id': 'pyqt', 'count': 16872}, {'_id': 'rubygems', 'count': 16829}, {'_id': 'x86', 'count': 16806}, {'_id': 'f#', 'count': 16792}, {'_id': 'yii', 'count': 16777}, {'_id': 'kendo-ui', 'count': 16747}, {'_id': 'package', 'count': 16672}, {'_id': 'autocomplete', 'count': 16669}, {'_id': 'datepicker', 'count': 16656}, {'_id': 'tree', 'count': 16578}, {'_id': 'controller', 'count': 16545}, {'_id': 'xamarin.ios', 'count': 16530}, {'_id': 'pycharm', 'count': 16402}, {'_id': 'phpmyadmin', 'count': 16381}, {'_id': 'grep', 'count': 16369}, {'_id': 'jackson', 'count': 16286}, {'_id': 'static', 'count': 16285}, {'_id': 'nested', 'count': 16272}, {'_id': 'uiviewcontroller', 'count': 16268}, {'_id': 'datagrid', 'count': 16188}, {'_id': 'statistics', 'count': 16184}, {'_id': 'openssl', 'count': 16171}, {'_id': 'null', 'count': 16120}, {'_id': 'active-directory', 'count': 16049}, {'_id': 'webforms', 'count': 16030}, {'_id': 'transactions', 'count': 15997}, {'_id': 'nullpointerexception', 'count': 15937}, {'_id': 'notifications', 'count': 15888}, {'_id': 'youtube', 'count': 15852}, {'_id': 'jsf-2', 'count': 15768}, {'_id': 'menu', 'count': 15765}, {'_id': 'bitmap', 'count': 15691}, {'_id': 'duplicates', 'count': 15675}, {'_id': 'visual-studio-2008', 'count': 15674}, {'_id': 'asp.net-mvc-5', 'count': 15650}, {'_id': 'stream', 'count': 15635}, {'_id': 'android-listview', 'count': 15572}, {'_id': 'mocking', 'count': 15528}, {'_id': 'sas', 'count': 15476}, {'_id': 'computer-vision', 'count': 15449}, {'_id': 'yii2', 'count': 15431}, {'_id': 'ant', 'count': 15413}, {'_id': 'discord.py', 'count': 15410}, {'_id': 'stl', 'count': 15341}, {'_id': 'sum', 'count': 15279}, {'_id': 'hashmap', 'count': 15149}, {'_id': 'jboss', 'count': 15106}, {'_id': 'css-selectors', 'count': 15106}, {'_id': 'joomla', 'count': 15099}, {'_id': 'character-encoding', 'count': 15080}, {'_id': 'devise', 'count': 15010}, {'_id': 'yaml', 'count': 15007}, {'_id': 'time-series', 'count': 15004}, {'_id': 'electron', 'count': 14917}, {'_id': 'floating-point', 'count': 14895}, {'_id': 'msbuild', 'count': 14849}, {'_id': 'sdk', 'count': 14827}, {'_id': 'azure-functions', 'count': 14818}, {'_id': 'linq-to-sql', 'count': 14795}, {'_id': 'background', 'count': 14759}, {'_id': 'cryptography', 'count': 14757}, {'_id': 'dockerfile', 'count': 14749}, {'_id': 'ios7', 'count': 14693}, {'_id': 'binary', 'count': 14637}, {'_id': 'camera', 'count': 14602}, {'_id': 'google-drive-api', 'count': 14595}, {'_id': 'anaconda', 'count': 14559}, {'_id': 'onclick', 'count': 14552}, {'_id': 'android-asynctask', 'count': 14543}, {'_id': 'pyqt5', 'count': 14533}, {'_id': 'navigation', 'count': 14526}, {'_id': 'laravel-4', 'count': 14442}, {'_id': 'iterator', 'count': 14331}, {'_id': 'insert', 'count': 14314}, {'_id': 'frontend', 'count': 14313}, {'_id': 'uicollectionview', 'count': 14286}, {'_id': 'tabs', 'count': 14266}, {'_id': 'multiprocessing', 'count': 14200}, {'_id': 'ftp', 'count': 14190}, {'_id': 'cuda', 'count': 14172}, {'_id': 'textview', 'count': 14106}, {'_id': 'expo', 'count': 14084}, {'_id': 'upload', 'count': 14082}, {'_id': 'coldfusion', 'count': 14076}, {'_id': 'asp.net-core-mvc', 'count': 14072}, {'_id': 'rabbitmq', 'count': 14063}, {'_id': 'xsd', 'count': 14051}, {'_id': 'opengl-es', 'count': 14036}, {'_id': 'selenium-chromedriver', 'count': 14013}, {'_id': 'console', 'count': 13978}, {'_id': 'xml-parsing', 'count': 13814}, {'_id': 'leaflet', 'count': 13808}, {'_id': 'linker', 'count': 13779}, {'_id': 'mariadb', 'count': 13727}, {'_id': 'localization', 'count': 13628}, {'_id': 'plotly', 'count': 13618}, {'_id': 'calendar', 'count': 13590}, {'_id': 'continuous-integration', 'count': 13579}, {'_id': 'amazon-dynamodb', 'count': 13578}, {'_id': 'operating-system', 'count': 13555}, {'_id': 'formatting', 'count': 13528}, {'_id': 'json.net', 'count': 13523}, {'_id': 'android-ndk', 'count': 13500}, {'_id': 'kivy', 'count': 13498}, {'_id': 'timestamp', 'count': 13497}, {'_id': 'header', 'count': 13460}, {'_id': 'environment-variables', 'count': 13459}, {'_id': 'type-conversion', 'count': 13430}, {'_id': 'mockito', 'count': 13415}, {'_id': 'macros', 'count': 13389}, {'_id': 'integer', 'count': 13354}, {'_id': 'data.table', 'count': 13338}, {'_id': 'prolog', 'count': 13337}, {'_id': 'jasmine', 'count': 13277}, {'_id': 'segmentation-fault', 'count': 13269}, {'_id': 'drag-and-drop', 'count': 13241}, {'_id': 'char', 'count': 13217}, {'_id': 'sprite-kit', 'count': 13190}, {'_id': 'flutter-layout', 'count': 13177}, {'_id': 'cors', 'count': 13167}, {'_id': 'crash', 'count': 13165}, {'_id': 'jquery-plugins', 'count': 13094}, {'_id': 'itext', 'count': 13092}, {'_id': 'nosql', 'count': 13084}, {'_id': 'annotations', 'count': 12984}, {'_id': 'automated-tests', 'count': 12983}, {'_id': 'attributes', 'count': 12959}, {'_id': 'mfc', 'count': 12951}, {'_id': 'geometry', 'count': 12863}, {'_id': 'android-gradle-plugin', 'count': 12820}, {'_id': 'format', 'count': 12819}, {'_id': 'fortran', 'count': 12765}, {'_id': 'visual-studio-2017', 'count': 12686}, {'_id': 'gulp', 'count': 12681}, {'_id': 'dependencies', 'count': 12668}, {'_id': 'event-handling', 'count': 12655}, {'_id': 'microsoft-graph-api', 'count': 12642}, {'_id': 'textbox', 'count': 12638}, {'_id': 'db2', 'count': 12617}, {'_id': 'libgdx', 'count': 12587}, {'_id': 'xampp', 'count': 12557}, {'_id': 'keyboard', 'count': 12540}, {'_id': 'uiscrollview', 'count': 12497}, {'_id': 'centos', 'count': 12461}, {'_id': 'jenkins-pipeline', 'count': 12461}, {'_id': 'crystal-reports', 'count': 12443}, {'_id': 'dom-events', 'count': 12411}, {'_id': 'synchronization', 'count': 12404}, {'_id': 'odoo', 'count': 12359}, {'_id': 'firebase-cloud-messaging', 'count': 12352}, {'_id': 'geolocation', 'count': 12340}, {'_id': 'namespaces', 'count': 12292}, {'_id': 'sequelize.js', 'count': 12247}, {'_id': 'android-emulator', 'count': 12227}, {'_id': 'com', 'count': 12193}, {'_id': 'aggregation-framework', 'count': 12193}, {'_id': 'timezone', 'count': 12165}, {'_id': 'ionic2', 'count': 12140}, {'_id': 'mapreduce', 'count': 12139}, {'_id': 'webdriver', 'count': 12139}, {'_id': 'arm', 'count': 12120}, {'_id': 'windows-10', 'count': 12112}, {'_id': 'jvm', 'count': 12091}, {'_id': 'android-edittext', 'count': 12091}, {'_id': 'dialog', 'count': 12090}, {'_id': 'numbers', 'count': 12066}, {'_id': 'html5-canvas', 'count': 12056}, {'_id': 'subprocess', 'count': 12036}, {'_id': 'garbage-collection', 'count': 12021}, {'_id': 'postman', 'count': 12019}, {'_id': 'wso2', 'count': 12014}, {'_id': 'xmlhttprequest', 'count': 12007}, {'_id': 'lucene', 'count': 11987}, {'_id': 'rotation', 'count': 11979}, {'_id': 'fetch', 'count': 11967}, {'_id': 'julia', 'count': 11965}, {'_id': 'concatenation', 'count': 11963}, {'_id': 'set', 'count': 11962}, {'_id': 'sql-update', 'count': 11951}, {'_id': 'widget', 'count': 11936}, {'_id': 'radio-button', 'count': 11936}, {'_id': 'modal-dialog', 'count': 11923}, {'_id': 'chart.js', 'count': 11915}, {'_id': 'doctrine', 'count': 11892}, {'_id': 'tuples', 'count': 11876}, {'_id': 'smtp', 'count': 11854}, {'_id': 'ios5', 'count': 11810}, {'_id': 'grid', 'count': 11806}, {'_id': 'swagger', 'count': 11776}, {'_id': 'listbox', 'count': 11775}, {'_id': 'spring-data', 'count': 11771}, {'_id': 'http-headers', 'count': 11754}, {'_id': 'nuxt.js', 'count': 11747}, {'_id': 'sonarqube', 'count': 11734}, {'_id': 'blazor', 'count': 11648}, {'_id': 'switch-statement', 'count': 11639}, {'_id': 'frameworks', 'count': 11630}, {'_id': 'boolean', 'count': 11625}, {'_id': 'eclipse-plugin', 'count': 11614}, {'_id': 'qml', 'count': 11608}, {'_id': 'uikit', 'count': 11592}, {'_id': 'compiler-construction', 'count': 11581}, {'_id': 'ldap', 'count': 11570}, {'_id': 'initialization', 'count': 11565}, {'_id': 'internationalization', 'count': 11562}, {'_id': 'return', 'count': 11556}, {'_id': 'components', 'count': 11551}, {'_id': 'apache-camel', 'count': 11546}, {'_id': 'serial-port', 'count': 11526}, {'_id': 'nuget', 'count': 11494}, {'_id': 'google-play', 'count': 11483}, {'_id': 'asp-classic', 'count': 11460}, {'_id': 'tags', 'count': 11440}, {'_id': 'java-stream', 'count': 11397}, {'_id': 'azure-web-app-service', 'count': 11376}, {'_id': 'struts2', 'count': 11375}, {'_id': 'uinavigationcontroller', 'count': 11373}, {'_id': 'youtube-api', 'count': 11362}, {'_id': 'protractor', 'count': 11331}, {'_id': 'sql-server-2008-r2', 'count': 11323}, {'_id': 'dataset', 'count': 11308}, {'_id': 'delegates', 'count': 11289}, {'_id': 'subquery', 'count': 11262}, {'_id': 'stripe-payments', 'count': 11242}, {'_id': 'uibutton', 'count': 11241}, {'_id': 'network-programming', 'count': 11239}, {'_id': 'gdb', 'count': 11228}, {'_id': 'foreign-keys', 'count': 11224}, {'_id': 'copy', 'count': 11216}, {'_id': 'pivot', 'count': 11210}, {'_id': 'nestjs', 'count': 11201}, {'_id': 'label', 'count': 11199}, {'_id': 'find', 'count': 11167}, {'_id': 'append', 'count': 11094}, {'_id': 'base64', 'count': 11076}, {'_id': 'jaxb', 'count': 11055}, {'_id': 'queue', 'count': 11045}, {'_id': 'autolayout', 'count': 11042}, {'_id': 'arguments', 'count': 11030}, {'_id': 'containers', 'count': 11019}, {'_id': 'windows-7', 'count': 11015}, {'_id': 'azure-pipelines', 'count': 11012}, {'_id': 'latex', 'count': 11011}, {'_id': 'zip', 'count': 10981}, {'_id': 'composer-php', 'count': 10953}, {'_id': 'entity-framework-6', 'count': 10925}, {'_id': 'popup', 'count': 10896}, {'_id': 'migration', 'count': 10878}, {'_id': 'jqgrid', 'count': 10875}, {'_id': 'cucumber', 'count': 10865}, {'_id': 'stack', 'count': 10846}, {'_id': 'ide', 'count': 10843}, {'_id': 'android-viewpager', 'count': 10795}, {'_id': 'google-sheets-formula', 'count': 10793}, {'_id': 'vb6', 'count': 10779}, {'_id': 'iteration', 'count': 10725}, {'_id': 'uiwebview', 'count': 10709}, {'_id': 'ios4', 'count': 10693}, {'_id': 'passwords', 'count': 10663}, {'_id': 'google-cloud-storage', 'count': 10646}, {'_id': 'hover', 'count': 10634}, {'_id': 'command', 'count': 10627}, {'_id': 'uiimageview', 'count': 10617}, {'_id': 'udp', 'count': 10595}, {'_id': 'vuejs3', 'count': 10582}, {'_id': 'gmail', 'count': 10577}, {'_id': 'twig', 'count': 10572}, {'_id': 'conv-neural-network', 'count': 10475}, {'_id': 'range', 'count': 10470}, {'_id': 'c++17', 'count': 10466}, {'_id': 'ssl-certificate', 'count': 10436}, {'_id': 'vue-component', 'count': 10417}, {'_id': 'jersey', 'count': 10394}, {'_id': 'ionic3', 'count': 10391}, {'_id': 'angular-ui-router', 'count': 10381}, {'_id': 'g++', 'count': 10379}, {'_id': 'embedded', 'count': 10367}, {'_id': 'salesforce', 'count': 10348}, {'_id': 'r-markdown', 'count': 10299}, {'_id': 'windows-8', 'count': 10294}, {'_id': 'snowflake-cloud-data-platform', 'count': 10264}, {'_id': 'user-controls', 'count': 10263}, {'_id': 'gps', 'count': 10261}, {'_id': 'local-storage', 'count': 10249}, {'_id': 'constants', 'count': 10245}, {'_id': 'cocos2d-iphone', 'count': 10207}, {'_id': 'bots', 'count': 10206}, {'_id': 'wix', 'count': 10183}, {'_id': 'authorization', 'count': 10182}, {'_id': 'connection', 'count': 10181}, {'_id': 'compare', 'count': 10173}, {'_id': 'polymorphism', 'count': 10134}, {'_id': 'slider', 'count': 10113}, {'_id': 'django-admin', 'count': 10111}, {'_id': 'localhost', 'count': 10068}, {'_id': 'debian', 'count': 10066}, {'_id': 'ado.net', 'count': 10043}, {'_id': 'twilio', 'count': 10018}, {'_id': 'mono', 'count': 9991}, {'_id': 'time-complexity', 'count': 9983}, {'_id': 'save', 'count': 9980}, {'_id': 'clang', 'count': 9965}, {'_id': 'jframe', 'count': 9945}, {'_id': 'admob', 'count': 9937}, {'_id': 'phpunit', 'count': 9917}, {'_id': 'certificate', 'count': 9876}, {'_id': 'sbt', 'count': 9865}, {'_id': 'imageview', 'count': 9848}, {'_id': 'airflow', 'count': 9836}, {'_id': 'python-imaging-library', 'count': 9789}, {'_id': 'drupal-7', 'count': 9788}, {'_id': 'coffeescript', 'count': 9749}, {'_id': 'gson', 'count': 9744}, {'_id': 'output', 'count': 9739}, {'_id': 'pipe', 'count': 9729}, {'_id': 'include', 'count': 9700}, {'_id': 'cypher', 'count': 9675}, {'_id': 'int', 'count': 9674}, {'_id': 'fullcalendar', 'count': 9673}, {'_id': 'mapping', 'count': 9669}, {'_id': 'java-native-interface', 'count': 9664}, {'_id': 'babeljs', 'count': 9663}, {'_id': 'apache-poi', 'count': 9654}, {'_id': 'web-crawler', 'count': 9636}, {'_id': 'timeout', 'count': 9629}, {'_id': 'location', 'count': 9615}, {'_id': 'hex', 'count': 9587}, {'_id': 'tidyverse', 'count': 9568}, {'_id': 'erlang', 'count': 9567}, {'_id': 'log4j', 'count': 9566}, {'_id': 'pytest', 'count': 9520}, {'_id': 'filesystems', 'count': 9515}, {'_id': 'cypress', 'count': 9513}, {'_id': 'export', 'count': 9513}, {'_id': 'substring', 'count': 9509}, {'_id': 'runtime-error', 'count': 9507}, {'_id': 'iis-7', 'count': 9501}, {'_id': 'icons', 'count': 9499}, {'_id': 'google-oauth', 'count': 9477}, {'_id': 'observable', 'count': 9463}, {'_id': 'storyboard', 'count': 9449}, {'_id': 'azure-sql-database', 'count': 9435}, {'_id': 'window', 'count': 9432}, {'_id': 'regression', 'count': 9428}, {'_id': 'telerik', 'count': 9423}, {'_id': 'key', 'count': 9420}, {'_id': 'ruby-on-rails-5', 'count': 9414}, {'_id': 'elixir', 'count': 9404}, {'_id': 'odbc', 'count': 9397}, {'_id': 'maps', 'count': 9397}, {'_id': 'treeview', 'count': 9393}, {'_id': 'seaborn', 'count': 9374}, {'_id': 'syntax-error', 'count': 9368}, {'_id': 'click', 'count': 9368}, {'_id': 'printf', 'count': 9356}, {'_id': 'jinja2', 'count': 9335}, {'_id': 'typo3', 'count': 9320}, {'_id': 'realm', 'count': 9314}, {'_id': 'cocoapods', 'count': 9310}, {'_id': 'ios8', 'count': 9301}, {'_id': 'ip', 'count': 9287}, {'_id': 'wsdl', 'count': 9287}, {'_id': 'wordpress-theming', 'count': 9285}, {'_id': 'signalr', 'count': 9285}, {'_id': 'logic', 'count': 9282}, {'_id': 'resources', 'count': 9280}, {'_id': 'ckeditor', 'count': 9278}, {'_id': 'kernel', 'count': 9272}, {'_id': 'command-line-interface', 'count': 9269}, {'_id': 'thread-safety', 'count': 9259}, {'_id': 'dojo', 'count': 9248}, {'_id': 'bluetooth-lowenergy', 'count': 9235}, {'_id': 'botframework', 'count': 9234}, {'_id': 'uiimage', 'count': 9228}, {'_id': 'in-app-purchase', 'count': 9192}, {'_id': 'resize', 'count': 9183}, {'_id': 'position', 'count': 9177}, {'_id': 'amazon-elastic-beanstalk', 'count': 9161}, {'_id': 'styles', 'count': 9150}, {'_id': 'cloud', 'count': 9147}, {'_id': 'actionscript', 'count': 9141}, {'_id': 'imagemagick', 'count': 9135}, {'_id': 'android-jetpack-compose', 'count': 9134}, {'_id': 'compression', 'count': 9117}, {'_id': 'thymeleaf', 'count': 9108}, {'_id': 'gruntjs', 'count': 9084}, {'_id': 'malloc', 'count': 9084}, {'_id': 'angularjs-ng-repeat', 'count': 9074}, {'_id': 'cross-browser', 'count': 9053}, {'_id': 'repository', 'count': 9026}, {'_id': 'where-clause', 'count': 9014}, {'_id': 'state', 'count': 9010}, {'_id': 'google-visualization', 'count': 8984}, {'_id': 'pattern-matching', 'count': 8980}, {'_id': 'data-science', 'count': 8951}, {'_id': 'angularjs-scope', 'count': 8950}, {'_id': 'max', 'count': 8939}, {'_id': 'windows-services', 'count': 8937}, {'_id': 'build.gradle', 'count': 8899}, {'_id': 'microservices', 'count': 8892}, {'_id': 'android-actionbar', 'count': 8890}, {'_id': 'escaping', 'count': 8883}, {'_id': 'swift2', 'count': 8881}, {'_id': 'webrtc', 'count': 8875}, {'_id': 'celery', 'count': 8866}, {'_id': 'closures', 'count': 8848}, {'_id': 'pthreads', 'count': 8832}, {'_id': '.net-4.0', 'count': 8831}, {'_id': 'asp.net-identity', 'count': 8812}, {'_id': 'jquery-selectors', 'count': 8803}, {'_id': 'pandas-groupby', 'count': 8795}, {'_id': 'windows-installer', 'count': 8785}, {'_id': 'jsx', 'count': 8761}, {'_id': 'constraints', 'count': 8757}, {'_id': 'global-variables', 'count': 8743}, {'_id': 'locking', 'count': 8735}, {'_id': 'github-actions', 'count': 8723}, {'_id': 'ios6', 'count': 8695}, {'_id': 'gpu', 'count': 8694}, {'_id': 'applescript', 'count': 8692}, {'_id': 'try-catch', 'count': 8685}, {'_id': 'vuetify.js', 'count': 8683}, {'_id': 'office365', 'count': 8678}, {'_id': 'http-post', 'count': 8677}, {'_id': 'windows-runtime', 'count': 8677}, {'_id': 'zend-framework2', 'count': 8670}, {'_id': 'google-chrome-devtools', 'count': 8667}, {'_id': 'qt5', 'count': 8664}, {'_id': 'many-to-many', 'count': 8651}, {'_id': 'web-config', 'count': 8643}, {'_id': 'match', 'count': 8586}, {'_id': 'alignment', 'count': 8573}, {'_id': 'logstash', 'count': 8570}, {'_id': 'vagrant', 'count': 8555}, {'_id': 'retrofit', 'count': 8534}, {'_id': 'markdown', 'count': 8533}, {'_id': 'mocha.js', 'count': 8518}, {'_id': 'uitextfield', 'count': 8512}, {'_id': 'singleton', 'count': 8511}, {'_id': 'jtable', 'count': 8509}, {'_id': 'video-streaming', 'count': 8507}, {'_id': 'material-design', 'count': 8501}, {'_id': 'ef-code-first', 'count': 8500}, {'_id': 'internet-explorer-8', 'count': 8498}, {'_id': 'sharepoint-2010', 'count': 8494}, {'_id': 'shopify', 'count': 8471}, {'_id': 'jasper-reports', 'count': 8461}, {'_id': 'asp.net-mvc-2', 'count': 8452}, {'_id': 'gtk', 'count': 8426}, {'_id': 'testng', 'count': 8424}, {'_id': 'sh', 'count': 8424}, {'_id': 'c++14', 'count': 8421}, {'_id': 'amazon-redshift', 'count': 8421}, {'_id': 'operator-overloading', 'count': 8420}, {'_id': 'blackberry', 'count': 8404}, {'_id': 'task', 'count': 8399}, {'_id': 'controls', 'count': 8378}, {'_id': 'broadcastreceiver', 'count': 8368}, {'_id': 'react-navigation', 'count': 8326}, {'_id': 'language-agnostic', 'count': 8321}, {'_id': 'bitbucket', 'count': 8292}, {'_id': 'azure-blob-storage', 'count': 8287}, {'_id': 'artificial-intelligence', 'count': 8273}, {'_id': 'polymer', 'count': 8271}, {'_id': 'hdfs', 'count': 8270}, {'_id': 'double', 'count': 8270}, {'_id': 'mercurial', 'count': 8237}]\n",
      "Uploaded tag: javascript\n",
      "Uploaded tag: python\n",
      "Uploaded tag: java\n",
      "Uploaded tag: c#\n",
      "Uploaded tag: php\n",
      "Uploaded tag: android\n",
      "Uploaded tag: html\n",
      "Uploaded tag: jquery\n",
      "Uploaded tag: c++\n",
      "Uploaded tag: css\n",
      "Uploaded tag: ios\n",
      "Uploaded tag: sql\n",
      "Uploaded tag: mysql\n",
      "Uploaded tag: r\n",
      "Uploaded tag: node.js\n",
      "Uploaded tag: reactjs\n",
      "Uploaded tag: arrays\n",
      "Uploaded tag: c\n",
      "Uploaded tag: asp.net\n",
      "Uploaded tag: json\n",
      "Uploaded tag: python-3.x\n",
      "Uploaded tag: ruby-on-rails\n",
      "Uploaded tag: .net\n",
      "Uploaded tag: sql-server\n",
      "Uploaded tag: swift\n",
      "Uploaded tag: django\n",
      "Uploaded tag: angular\n",
      "Uploaded tag: objective-c\n",
      "Uploaded tag: pandas\n",
      "Uploaded tag: excel\n",
      "Uploaded tag: angularjs\n",
      "Uploaded tag: regex\n",
      "Uploaded tag: ruby\n",
      "Uploaded tag: linux\n",
      "Uploaded tag: ajax\n",
      "Uploaded tag: iphone\n",
      "Uploaded tag: typescript\n",
      "Uploaded tag: xml\n",
      "Uploaded tag: vba\n",
      "Uploaded tag: spring\n",
      "Uploaded tag: laravel\n",
      "Uploaded tag: asp.net-mvc\n",
      "Uploaded tag: database\n",
      "Uploaded tag: wordpress\n",
      "Uploaded tag: string\n",
      "Uploaded tag: mongodb\n",
      "Uploaded tag: postgresql\n",
      "Uploaded tag: wpf\n",
      "Uploaded tag: windows\n",
      "Uploaded tag: flutter\n",
      "Uploaded tag: xcode\n",
      "Uploaded tag: bash\n",
      "Uploaded tag: amazon-web-services\n",
      "Uploaded tag: oracle\n",
      "Uploaded tag: git\n",
      "Uploaded tag: dataframe\n",
      "Uploaded tag: firebase\n",
      "Uploaded tag: spring-boot\n",
      "Uploaded tag: list\n",
      "Uploaded tag: vb.net\n",
      "Uploaded tag: multithreading\n",
      "Uploaded tag: azure\n",
      "Uploaded tag: react-native\n",
      "Uploaded tag: docker\n",
      "Uploaded tag: eclipse\n",
      "Uploaded tag: algorithm\n",
      "Uploaded tag: macos\n",
      "Uploaded tag: visual-studio\n",
      "Uploaded tag: image\n",
      "Uploaded tag: powershell\n",
      "Uploaded tag: forms\n",
      "Uploaded tag: scala\n",
      "Uploaded tag: numpy\n",
      "Uploaded tag: function\n",
      "Uploaded tag: api\n",
      "Uploaded tag: vue.js\n",
      "Uploaded tag: twitter-bootstrap\n",
      "Uploaded tag: selenium\n",
      "Uploaded tag: performance\n",
      "Uploaded tag: winforms\n",
      "Uploaded tag: loops\n",
      "Uploaded tag: python-2.7\n",
      "Uploaded tag: matlab\n",
      "Uploaded tag: hibernate\n",
      "Uploaded tag: sqlite\n",
      "Uploaded tag: express\n",
      "Uploaded tag: rest\n",
      "Uploaded tag: apache\n",
      "Uploaded tag: shell\n",
      "Uploaded tag: entity-framework\n",
      "Uploaded tag: android-studio\n",
      "Uploaded tag: csv\n",
      "Uploaded tag: kotlin\n",
      "Uploaded tag: dart\n",
      "Uploaded tag: maven\n",
      "Uploaded tag: linq\n",
      "Uploaded tag: facebook\n",
      "Uploaded tag: qt\n",
      "Uploaded tag: dictionary\n",
      "Uploaded tag: unit-testing\n",
      "Uploaded tag: tensorflow\n",
      "Uploaded tag: file\n",
      "Uploaded tag: swing\n",
      "Uploaded tag: apache-spark\n",
      "Uploaded tag: class\n",
      "Uploaded tag: asp.net-core\n",
      "Uploaded tag: sorting\n",
      "Uploaded tag: date\n",
      "Uploaded tag: authentication\n",
      "Uploaded tag: unity-game-engine\n",
      "Uploaded tag: symfony\n",
      "Uploaded tag: .htaccess\n",
      "Uploaded tag: tsql\n",
      "Uploaded tag: google-chrome\n",
      "Uploaded tag: opencv\n",
      "Uploaded tag: for-loop\n",
      "Uploaded tag: matplotlib\n",
      "Uploaded tag: datetime\n",
      "Uploaded tag: codeigniter\n",
      "Uploaded tag: go\n",
      "Uploaded tag: perl\n",
      "Uploaded tag: http\n",
      "Uploaded tag: validation\n",
      "Uploaded tag: sockets\n",
      "Uploaded tag: google-maps\n",
      "Uploaded tag: object\n",
      "Uploaded tag: uitableview\n",
      "Uploaded tag: xaml\n",
      "Uploaded tag: cordova\n",
      "Uploaded tag: oop\n",
      "Uploaded tag: if-statement\n",
      "Uploaded tag: ubuntu\n",
      "Uploaded tag: web-services\n",
      "Uploaded tag: android-layout\n",
      "Uploaded tag: email\n",
      "Uploaded tag: spring-mvc\n",
      "Uploaded tag: elasticsearch\n",
      "Uploaded tag: ms-access\n",
      "Uploaded tag: parsing\n",
      "Uploaded tag: user-interface\n",
      "Uploaded tag: c++11\n",
      "Uploaded tag: ruby-on-rails-3\n",
      "Uploaded tag: kubernetes\n",
      "Uploaded tag: pointers\n",
      "Uploaded tag: security\n",
      "Uploaded tag: github\n",
      "Uploaded tag: visual-studio-code\n",
      "Uploaded tag: machine-learning\n",
      "Uploaded tag: templates\n",
      "Uploaded tag: nginx\n",
      "Uploaded tag: sql-server-2008\n",
      "Uploaded tag: variables\n",
      "Uploaded tag: ggplot2\n",
      "Uploaded tag: batch-file\n",
      "Uploaded tag: exception\n",
      "Uploaded tag: flask\n",
      "Uploaded tag: listview\n",
      "Uploaded tag: selenium-webdriver\n",
      "Uploaded tag: jsp\n",
      "Uploaded tag: google-apps-script\n",
      "Uploaded tag: google-sheets\n",
      "Uploaded tag: debugging\n",
      "Uploaded tag: jpa\n",
      "Uploaded tag: delphi\n",
      "Uploaded tag: wcf\n",
      "Uploaded tag: haskell\n",
      "Uploaded tag: pdf\n",
      "Uploaded tag: tkinter\n",
      "Uploaded tag: asynchronous\n",
      "Uploaded tag: gradle\n",
      "Uploaded tag: xamarin\n",
      "Uploaded tag: ssl\n",
      "Uploaded tag: jenkins\n",
      "Uploaded tag: amazon-s3\n",
      "Uploaded tag: testing\n",
      "Uploaded tag: web-scraping\n",
      "Uploaded tag: npm\n",
      "Uploaded tag: generics\n",
      "Uploaded tag: ionic-framework\n",
      "Uploaded tag: web\n",
      "Uploaded tag: unix\n",
      "Uploaded tag: google-app-engine\n",
      "Uploaded tag: visual-studio-2010\n",
      "Uploaded tag: recursion\n",
      "Uploaded tag: mongoose\n",
      "Uploaded tag: google-cloud-platform\n",
      "Uploaded tag: android-fragments\n",
      "Uploaded tag: session\n",
      "Uploaded tag: animation\n",
      "Uploaded tag: hadoop\n",
      "Uploaded tag: heroku\n",
      "Uploaded tag: laravel-5\n",
      "Uploaded tag: curl\n",
      "Uploaded tag: math\n",
      "Uploaded tag: url\n",
      "Uploaded tag: .net-core\n",
      "Uploaded tag: svg\n",
      "Uploaded tag: join\n",
      "Uploaded tag: django-models\n",
      "Uploaded tag: tomcat\n",
      "Uploaded tag: assembly\n",
      "Uploaded tag: intellij-idea\n",
      "Uploaded tag: asp.net-mvc-4\n",
      "Uploaded tag: redirect\n",
      "Uploaded tag: webpack\n",
      "Uploaded tag: keras\n",
      "Uploaded tag: inheritance\n",
      "Uploaded tag: winapi\n",
      "Uploaded tag: image-processing\n",
      "Uploaded tag: actionscript-3\n",
      "Uploaded tag: dom\n",
      "Uploaded tag: google-cloud-firestore\n",
      "Uploaded tag: logging\n",
      "Uploaded tag: matrix\n",
      "Uploaded tag: post\n",
      "Uploaded tag: gcc\n",
      "Uploaded tag: button\n",
      "Uploaded tag: firebase-realtime-database\n",
      "Uploaded tag: jquery-ui\n",
      "Uploaded tag: cocoa\n",
      "Uploaded tag: d3.js\n",
      "Uploaded tag: internet-explorer\n",
      "Uploaded tag: xpath\n",
      "Uploaded tag: iis\n",
      "Uploaded tag: firefox\n",
      "Uploaded tag: optimization\n",
      "Uploaded tag: asp.net-mvc-3\n",
      "Uploaded tag: select\n",
      "Uploaded tag: pyspark\n",
      "Uploaded tag: networking\n",
      "Uploaded tag: xslt\n",
      "Uploaded tag: opengl\n",
      "Uploaded tag: magento\n",
      "Uploaded tag: events\n",
      "Uploaded tag: javafx\n",
      "Uploaded tag: caching\n",
      "Uploaded tag: asp.net-web-api\n",
      "Uploaded tag: plot\n",
      "Uploaded tag: search\n",
      "Uploaded tag: rust\n",
      "Uploaded tag: ruby-on-rails-4\n",
      "Uploaded tag: encryption\n",
      "Uploaded tag: stored-procedures\n",
      "Uploaded tag: amazon-ec2\n",
      "Uploaded tag: audio\n",
      "Uploaded tag: canvas\n",
      "Uploaded tag: jsf\n",
      "Uploaded tag: memory\n",
      "Uploaded tag: dplyr\n",
      "Uploaded tag: redux\n",
      "Uploaded tag: multidimensional-array\n",
      "Uploaded tag: random\n",
      "Uploaded tag: flash\n",
      "Uploaded tag: facebook-graph-api\n",
      "Uploaded tag: vector\n",
      "Uploaded tag: input\n",
      "Uploaded tag: ipad\n",
      "Uploaded tag: cocoa-touch\n",
      "Uploaded tag: cookies\n",
      "Uploaded tag: arraylist\n",
      "Uploaded tag: xamarin.forms\n",
      "Uploaded tag: video\n",
      "Uploaded tag: swiftui\n",
      "Uploaded tag: indexing\n",
      "Uploaded tag: model-view-controller\n",
      "Uploaded tag: servlets\n",
      "Uploaded tag: data-structures\n",
      "Uploaded tag: mod-rewrite\n",
      "Uploaded tag: serialization\n",
      "Uploaded tag: jdbc\n",
      "Uploaded tag: razor\n",
      "Uploaded tag: routes\n",
      "Uploaded tag: woocommerce\n",
      "Uploaded tag: awk\n",
      "Uploaded tag: iframe\n",
      "Uploaded tag: beautifulsoup\n",
      "Uploaded tag: design-patterns\n",
      "Uploaded tag: filter\n",
      "Uploaded tag: cakephp\n",
      "Uploaded tag: text\n",
      "Uploaded tag: next.js\n",
      "Uploaded tag: visual-c++\n",
      "Uploaded tag: apache-kafka\n",
      "Uploaded tag: django-rest-framework\n",
      "Uploaded tag: android-intent\n",
      "Uploaded tag: mobile\n",
      "Uploaded tag: methods\n",
      "Uploaded tag: struct\n",
      "Uploaded tag: aws-lambda\n",
      "Uploaded tag: grails\n",
      "Uploaded tag: ecmascript-6\n",
      "Uploaded tag: mvvm\n",
      "Uploaded tag: checkbox\n",
      "Uploaded tag: groovy\n",
      "Uploaded tag: ssh\n",
      "Uploaded tag: excel-formula\n",
      "Uploaded tag: docker-compose\n",
      "Uploaded tag: lambda\n",
      "Uploaded tag: time\n",
      "Uploaded tag: jakarta-ee\n",
      "Uploaded tag: azure-devops\n",
      "Uploaded tag: android-recyclerview\n",
      "Uploaded tag: installation\n",
      "Uploaded tag: meteor\n",
      "Uploaded tag: google-chrome-extension\n",
      "Uploaded tag: core-data\n",
      "Uploaded tag: sharepoint\n",
      "Uploaded tag: android-activity\n",
      "Uploaded tag: react-hooks\n",
      "Uploaded tag: bootstrap-4\n",
      "Uploaded tag: activerecord\n",
      "Uploaded tag: graph\n",
      "Uploaded tag: sed\n",
      "Uploaded tag: plsql\n",
      "Uploaded tag: types\n",
      "Uploaded tag: shiny\n",
      "Uploaded tag: file-upload\n",
      "Uploaded tag: vim\n",
      "Uploaded tag: spring-security\n",
      "Uploaded tag: scikit-learn\n",
      "Uploaded tag: replace\n",
      "Uploaded tag: junit\n",
      "Uploaded tag: websocket\n",
      "Uploaded tag: soap\n",
      "Uploaded tag: boost\n",
      "Uploaded tag: silverlight\n",
      "Uploaded tag: memory-management\n",
      "Uploaded tag: group-by\n",
      "Uploaded tag: dynamic\n",
      "Uploaded tag: import\n",
      "Uploaded tag: deep-learning\n",
      "Uploaded tag: sass\n",
      "Uploaded tag: cmake\n",
      "Uploaded tag: eloquent\n",
      "Uploaded tag: gridview\n",
      "Uploaded tag: svn\n",
      "Uploaded tag: layout\n",
      "Uploaded tag: error-handling\n",
      "Uploaded tag: browser\n",
      "Uploaded tag: apache-spark-sql\n",
      "Uploaded tag: cmd\n",
      "Uploaded tag: charts\n",
      "Uploaded tag: async-await\n",
      "Uploaded tag: vuejs2\n",
      "Uploaded tag: while-loop\n",
      "Uploaded tag: dependency-injection\n",
      "Uploaded tag: view\n",
      "Uploaded tag: ffmpeg\n",
      "Uploaded tag: c#-4.0\n",
      "Uploaded tag: dll\n",
      "Uploaded tag: highcharts\n",
      "Uploaded tag: foreach\n",
      "Uploaded tag: deployment\n",
      "Uploaded tag: plugins\n",
      "Uploaded tag: reporting-services\n",
      "Uploaded tag: twitter\n",
      "Uploaded tag: google-maps-api-3\n",
      "Uploaded tag: mysqli\n",
      "Uploaded tag: makefile\n",
      "Uploaded tag: extjs\n",
      "Uploaded tag: https\n",
      "Uploaded tag: unicode\n",
      "Uploaded tag: server\n",
      "Uploaded tag: reflection\n",
      "Uploaded tag: merge\n",
      "Uploaded tag: redis\n",
      "Uploaded tag: google-bigquery\n",
      "Uploaded tag: jupyter-notebook\n",
      "Uploaded tag: netbeans\n",
      "Uploaded tag: split\n",
      "Uploaded tag: encoding\n",
      "Uploaded tag: apache-flex\n",
      "Uploaded tag: database-design\n",
      "Uploaded tag: ember.js\n",
      "Uploaded tag: terminal\n",
      "Uploaded tag: pdo\n",
      "Uploaded tag: collections\n",
      "Uploaded tag: hash\n",
      "Uploaded tag: axios\n",
      "Uploaded tag: django-views\n",
      "Uploaded tag: data-binding\n",
      "Uploaded tag: tcp\n",
      "Uploaded tag: oauth-2.0\n",
      "Uploaded tag: command-line\n",
      "Uploaded tag: react-redux\n",
      "Uploaded tag: automation\n",
      "Uploaded tag: printing\n",
      "Uploaded tag: service\n",
      "Uploaded tag: visual-studio-2012\n",
      "Uploaded tag: build\n",
      "Uploaded tag: pip\n",
      "Uploaded tag: java-8\n",
      "Uploaded tag: html-table\n",
      "Uploaded tag: sqlalchemy\n",
      "Uploaded tag: ansible\n",
      "Uploaded tag: jquery-mobile\n",
      "Uploaded tag: parameters\n",
      "Uploaded tag: neo4j\n",
      "Uploaded tag: jestjs\n",
      "Uploaded tag: web-applications\n",
      "Uploaded tag: promise\n",
      "Uploaded tag: webview\n",
      "Uploaded tag: module\n",
      "Uploaded tag: concurrency\n",
      "Uploaded tag: uwp\n",
      "Uploaded tag: enums\n",
      "Uploaded tag: utf-8\n",
      "Uploaded tag: datatable\n",
      "Uploaded tag: spring-data-jpa\n",
      "Uploaded tag: lua\n",
      "Uploaded tag: drop-down-menu\n",
      "Uploaded tag: hive\n",
      "Uploaded tag: pytorch\n",
      "Uploaded tag: tfs\n",
      "Uploaded tag: outlook\n",
      "Uploaded tag: material-ui\n",
      "Uploaded tag: scroll\n",
      "Uploaded tag: flexbox\n",
      "Uploaded tag: colors\n",
      "Uploaded tag: python-requests\n",
      "Uploaded tag: twitter-bootstrap-3\n",
      "Uploaded tag: count\n",
      "Uploaded tag: syntax\n",
      "Uploaded tag: firebase-authentication\n",
      "Uploaded tag: parallel-processing\n",
      "Uploaded tag: google-analytics\n",
      "Uploaded tag: file-io\n",
      "Uploaded tag: ssis\n",
      "Uploaded tag: scipy\n",
      "Uploaded tag: paypal\n",
      "Uploaded tag: fonts\n",
      "Uploaded tag: gwt\n",
      "Uploaded tag: constructor\n",
      "Uploaded tag: ms-word\n",
      "Uploaded tag: backbone.js\n",
      "Uploaded tag: three.js\n",
      "Uploaded tag: entity-framework-core\n",
      "Uploaded tag: socket.io\n",
      "Uploaded tag: datatables\n",
      "Uploaded tag: graphql\n",
      "Uploaded tag: solr\n",
      "Uploaded tag: cassandra\n",
      "Uploaded tag: url-rewriting\n",
      "Uploaded tag: zend-framework\n",
      "Uploaded tag: graphics\n",
      "Uploaded tag: rxjs\n",
      "Uploaded tag: drupal\n",
      "Uploaded tag: knockout.js\n",
      "Uploaded tag: datagridview\n",
      "Uploaded tag: oracle11g\n",
      "Uploaded tag: discord\n",
      "Uploaded tag: memory-leaks\n",
      "Uploaded tag: oauth\n",
      "Uploaded tag: compiler-errors\n",
      "Uploaded tag: pygame\n",
      "Uploaded tag: react-router\n",
      "Uploaded tag: django-forms\n",
      "Uploaded tag: neural-network\n",
      "Uploaded tag: nlp\n",
      "Uploaded tag: interface\n",
      "Uploaded tag: windows-phone-7\n",
      "Uploaded tag: parse-platform\n",
      "Uploaded tag: visual-studio-2015\n",
      "Uploaded tag: casting\n",
      "Uploaded tag: linked-list\n",
      "Uploaded tag: triggers\n",
      "Uploaded tag: google-api\n",
      "Uploaded tag: proxy\n",
      "Uploaded tag: timer\n",
      "Uploaded tag: directory\n",
      "Uploaded tag: cron\n",
      "Uploaded tag: django-templates\n",
      "Uploaded tag: primefaces\n",
      "Uploaded tag: path\n",
      "Uploaded tag: orm\n",
      "Uploaded tag: arduino\n",
      "Uploaded tag: angular-material\n",
      "Uploaded tag: push-notification\n",
      "Uploaded tag: conditional-statements\n",
      "Uploaded tag: model\n",
      "Uploaded tag: jar\n",
      "Uploaded tag: functional-programming\n",
      "Uploaded tag: visual-studio-2013\n",
      "Uploaded tag: xamarin.android\n",
      "Uploaded tag: jmeter\n",
      "Uploaded tag: uiview\n",
      "Uploaded tag: vbscript\n",
      "Uploaded tag: hyperlink\n",
      "Uploaded tag: swift3\n",
      "Uploaded tag: sql-server-2005\n",
      "Uploaded tag: download\n",
      "Uploaded tag: windows-phone-8\n",
      "Uploaded tag: rspec\n",
      "Uploaded tag: process\n",
      "Uploaded tag: properties\n",
      "Uploaded tag: combobox\n",
      "Uploaded tag: callback\n",
      "Uploaded tag: configuration\n",
      "Uploaded tag: scrapy\n",
      "Uploaded tag: powerbi\n",
      "Uploaded tag: emacs\n",
      "Uploaded tag: safari\n",
      "Uploaded tag: pagination\n",
      "Uploaded tag: scripting\n",
      "Uploaded tag: clojure\n",
      "Uploaded tag: angularjs-directive\n",
      "Uploaded tag: nhibernate\n",
      "Uploaded tag: permissions\n",
      "Uploaded tag: io\n",
      "Uploaded tag: scope\n",
      "Uploaded tag: terraform\n",
      "Uploaded tag: raspberry-pi\n",
      "Uploaded tag: request\n",
      "Uploaded tag: playframework\n",
      "Uploaded tag: google-cloud-functions\n",
      "Uploaded tag: responsive-design\n",
      "Uploaded tag: linux-kernel\n",
      "Uploaded tag: mongodb-query\n",
      "Uploaded tag: dns\n",
      "Uploaded tag: gitlab\n",
      "Uploaded tag: doctrine-orm\n",
      "Uploaded tag: azure-active-directory\n",
      "Uploaded tag: binding\n",
      "Uploaded tag: compilation\n",
      "Uploaded tag: bluetooth\n",
      "Uploaded tag: get\n",
      "Uploaded tag: version-control\n",
      "Uploaded tag: sql-server-2012\n",
      "Uploaded tag: reference\n",
      "Uploaded tag: jwt\n",
      "Uploaded tag: architecture\n",
      "Uploaded tag: 3d\n",
      "Uploaded tag: discord.js\n",
      "Uploaded tag: pyqt\n",
      "Uploaded tag: rubygems\n",
      "Uploaded tag: x86\n",
      "Uploaded tag: f#\n",
      "Uploaded tag: yii\n",
      "Uploaded tag: kendo-ui\n",
      "Uploaded tag: package\n",
      "Uploaded tag: autocomplete\n",
      "Uploaded tag: datepicker\n",
      "Uploaded tag: tree\n",
      "Uploaded tag: controller\n",
      "Uploaded tag: xamarin.ios\n",
      "Uploaded tag: pycharm\n",
      "Uploaded tag: phpmyadmin\n",
      "Uploaded tag: grep\n",
      "Uploaded tag: jackson\n",
      "Uploaded tag: static\n",
      "Uploaded tag: nested\n",
      "Uploaded tag: uiviewcontroller\n",
      "Uploaded tag: datagrid\n",
      "Uploaded tag: statistics\n",
      "Uploaded tag: openssl\n",
      "Uploaded tag: null\n",
      "Uploaded tag: active-directory\n",
      "Uploaded tag: webforms\n",
      "Uploaded tag: transactions\n",
      "Uploaded tag: nullpointerexception\n",
      "Uploaded tag: notifications\n",
      "Uploaded tag: youtube\n",
      "Uploaded tag: jsf-2\n",
      "Uploaded tag: menu\n",
      "Uploaded tag: bitmap\n",
      "Uploaded tag: duplicates\n",
      "Uploaded tag: visual-studio-2008\n",
      "Uploaded tag: asp.net-mvc-5\n",
      "Uploaded tag: stream\n",
      "Uploaded tag: android-listview\n",
      "Uploaded tag: mocking\n",
      "Uploaded tag: sas\n",
      "Uploaded tag: computer-vision\n",
      "Uploaded tag: yii2\n",
      "Uploaded tag: ant\n",
      "Uploaded tag: discord.py\n",
      "Uploaded tag: stl\n",
      "Uploaded tag: sum\n",
      "Uploaded tag: hashmap\n",
      "Uploaded tag: jboss\n",
      "Uploaded tag: css-selectors\n",
      "Uploaded tag: joomla\n",
      "Uploaded tag: character-encoding\n",
      "Uploaded tag: devise\n",
      "Uploaded tag: yaml\n",
      "Uploaded tag: time-series\n",
      "Uploaded tag: electron\n",
      "Uploaded tag: floating-point\n",
      "Uploaded tag: msbuild\n",
      "Uploaded tag: sdk\n",
      "Uploaded tag: azure-functions\n",
      "Uploaded tag: linq-to-sql\n",
      "Uploaded tag: background\n",
      "Uploaded tag: cryptography\n",
      "Uploaded tag: dockerfile\n",
      "Uploaded tag: ios7\n",
      "Uploaded tag: binary\n",
      "Uploaded tag: camera\n",
      "Uploaded tag: google-drive-api\n",
      "Uploaded tag: anaconda\n",
      "Uploaded tag: onclick\n",
      "Uploaded tag: android-asynctask\n",
      "Uploaded tag: pyqt5\n",
      "Uploaded tag: navigation\n",
      "Uploaded tag: laravel-4\n",
      "Uploaded tag: iterator\n",
      "Uploaded tag: insert\n",
      "Uploaded tag: frontend\n",
      "Uploaded tag: uicollectionview\n",
      "Uploaded tag: tabs\n",
      "Uploaded tag: multiprocessing\n",
      "Uploaded tag: ftp\n",
      "Uploaded tag: cuda\n",
      "Uploaded tag: textview\n",
      "Uploaded tag: expo\n",
      "Uploaded tag: upload\n",
      "Uploaded tag: coldfusion\n",
      "Uploaded tag: asp.net-core-mvc\n",
      "Uploaded tag: rabbitmq\n",
      "Uploaded tag: xsd\n",
      "Uploaded tag: opengl-es\n",
      "Uploaded tag: selenium-chromedriver\n",
      "Uploaded tag: console\n",
      "Uploaded tag: xml-parsing\n",
      "Uploaded tag: leaflet\n",
      "Uploaded tag: linker\n",
      "Uploaded tag: mariadb\n",
      "Uploaded tag: localization\n",
      "Uploaded tag: plotly\n",
      "Uploaded tag: calendar\n",
      "Uploaded tag: continuous-integration\n",
      "Uploaded tag: amazon-dynamodb\n",
      "Uploaded tag: operating-system\n",
      "Uploaded tag: formatting\n",
      "Uploaded tag: json.net\n",
      "Uploaded tag: android-ndk\n",
      "Uploaded tag: kivy\n",
      "Uploaded tag: timestamp\n",
      "Uploaded tag: header\n",
      "Uploaded tag: environment-variables\n",
      "Uploaded tag: type-conversion\n",
      "Uploaded tag: mockito\n",
      "Uploaded tag: macros\n",
      "Uploaded tag: integer\n",
      "Uploaded tag: data.table\n",
      "Uploaded tag: prolog\n",
      "Uploaded tag: jasmine\n",
      "Uploaded tag: segmentation-fault\n",
      "Uploaded tag: drag-and-drop\n",
      "Uploaded tag: char\n",
      "Uploaded tag: sprite-kit\n",
      "Uploaded tag: flutter-layout\n",
      "Uploaded tag: cors\n",
      "Uploaded tag: crash\n",
      "Uploaded tag: jquery-plugins\n",
      "Uploaded tag: itext\n",
      "Uploaded tag: nosql\n",
      "Uploaded tag: annotations\n",
      "Uploaded tag: automated-tests\n",
      "Uploaded tag: attributes\n",
      "Uploaded tag: mfc\n",
      "Uploaded tag: geometry\n",
      "Uploaded tag: android-gradle-plugin\n",
      "Uploaded tag: format\n",
      "Uploaded tag: fortran\n",
      "Uploaded tag: visual-studio-2017\n",
      "Uploaded tag: gulp\n",
      "Uploaded tag: dependencies\n",
      "Uploaded tag: event-handling\n",
      "Uploaded tag: microsoft-graph-api\n",
      "Uploaded tag: textbox\n",
      "Uploaded tag: db2\n",
      "Uploaded tag: libgdx\n",
      "Uploaded tag: xampp\n",
      "Uploaded tag: keyboard\n",
      "Uploaded tag: uiscrollview\n",
      "Uploaded tag: centos\n",
      "Uploaded tag: jenkins-pipeline\n",
      "Uploaded tag: crystal-reports\n",
      "Uploaded tag: dom-events\n",
      "Uploaded tag: synchronization\n",
      "Uploaded tag: odoo\n",
      "Uploaded tag: firebase-cloud-messaging\n",
      "Uploaded tag: geolocation\n",
      "Uploaded tag: namespaces\n",
      "Uploaded tag: sequelize.js\n",
      "Uploaded tag: android-emulator\n",
      "Uploaded tag: com\n",
      "Uploaded tag: aggregation-framework\n",
      "Uploaded tag: timezone\n",
      "Uploaded tag: ionic2\n",
      "Uploaded tag: mapreduce\n",
      "Uploaded tag: webdriver\n",
      "Uploaded tag: arm\n",
      "Uploaded tag: windows-10\n",
      "Uploaded tag: jvm\n",
      "Uploaded tag: android-edittext\n",
      "Uploaded tag: dialog\n",
      "Uploaded tag: numbers\n",
      "Uploaded tag: html5-canvas\n",
      "Uploaded tag: subprocess\n",
      "Uploaded tag: garbage-collection\n",
      "Uploaded tag: postman\n",
      "Uploaded tag: wso2\n",
      "Uploaded tag: xmlhttprequest\n",
      "Uploaded tag: lucene\n",
      "Uploaded tag: rotation\n",
      "Uploaded tag: fetch\n",
      "Uploaded tag: julia\n",
      "Uploaded tag: concatenation\n",
      "Uploaded tag: set\n",
      "Uploaded tag: sql-update\n",
      "Uploaded tag: widget\n",
      "Uploaded tag: radio-button\n",
      "Uploaded tag: modal-dialog\n",
      "Uploaded tag: chart.js\n",
      "Uploaded tag: doctrine\n",
      "Uploaded tag: tuples\n",
      "Uploaded tag: smtp\n",
      "Uploaded tag: ios5\n",
      "Uploaded tag: grid\n",
      "Uploaded tag: swagger\n",
      "Uploaded tag: listbox\n",
      "Uploaded tag: spring-data\n",
      "Uploaded tag: http-headers\n",
      "Uploaded tag: nuxt.js\n",
      "Uploaded tag: sonarqube\n",
      "Uploaded tag: blazor\n",
      "Uploaded tag: switch-statement\n",
      "Uploaded tag: frameworks\n",
      "Uploaded tag: boolean\n",
      "Uploaded tag: eclipse-plugin\n",
      "Uploaded tag: qml\n",
      "Uploaded tag: uikit\n",
      "Uploaded tag: compiler-construction\n",
      "Uploaded tag: ldap\n",
      "Uploaded tag: initialization\n",
      "Uploaded tag: internationalization\n",
      "Uploaded tag: return\n",
      "Uploaded tag: components\n",
      "Uploaded tag: apache-camel\n",
      "Uploaded tag: serial-port\n",
      "Uploaded tag: nuget\n",
      "Uploaded tag: google-play\n",
      "Uploaded tag: asp-classic\n",
      "Uploaded tag: tags\n",
      "Uploaded tag: java-stream\n",
      "Uploaded tag: azure-web-app-service\n",
      "Uploaded tag: struts2\n",
      "Uploaded tag: uinavigationcontroller\n",
      "Uploaded tag: youtube-api\n",
      "Uploaded tag: protractor\n",
      "Uploaded tag: sql-server-2008-r2\n",
      "Uploaded tag: dataset\n",
      "Uploaded tag: delegates\n",
      "Uploaded tag: subquery\n",
      "Uploaded tag: stripe-payments\n",
      "Uploaded tag: uibutton\n",
      "Uploaded tag: network-programming\n",
      "Uploaded tag: gdb\n",
      "Uploaded tag: foreign-keys\n",
      "Uploaded tag: copy\n",
      "Uploaded tag: pivot\n",
      "Uploaded tag: nestjs\n",
      "Uploaded tag: label\n",
      "Uploaded tag: find\n",
      "Uploaded tag: append\n",
      "Uploaded tag: base64\n",
      "Uploaded tag: jaxb\n",
      "Uploaded tag: queue\n",
      "Uploaded tag: autolayout\n",
      "Uploaded tag: arguments\n",
      "Uploaded tag: containers\n",
      "Uploaded tag: windows-7\n",
      "Uploaded tag: azure-pipelines\n",
      "Uploaded tag: latex\n",
      "Uploaded tag: zip\n",
      "Uploaded tag: composer-php\n",
      "Uploaded tag: entity-framework-6\n",
      "Uploaded tag: popup\n",
      "Uploaded tag: migration\n",
      "Uploaded tag: jqgrid\n",
      "Uploaded tag: cucumber\n",
      "Uploaded tag: stack\n",
      "Uploaded tag: ide\n",
      "Uploaded tag: android-viewpager\n",
      "Uploaded tag: google-sheets-formula\n",
      "Uploaded tag: vb6\n",
      "Uploaded tag: iteration\n",
      "Uploaded tag: uiwebview\n",
      "Uploaded tag: ios4\n",
      "Uploaded tag: passwords\n",
      "Uploaded tag: google-cloud-storage\n",
      "Uploaded tag: hover\n",
      "Uploaded tag: command\n",
      "Uploaded tag: uiimageview\n",
      "Uploaded tag: udp\n",
      "Uploaded tag: vuejs3\n",
      "Uploaded tag: gmail\n",
      "Uploaded tag: twig\n",
      "Uploaded tag: conv-neural-network\n",
      "Uploaded tag: range\n",
      "Uploaded tag: c++17\n",
      "Uploaded tag: ssl-certificate\n",
      "Uploaded tag: vue-component\n",
      "Uploaded tag: jersey\n",
      "Uploaded tag: ionic3\n",
      "Uploaded tag: angular-ui-router\n",
      "Uploaded tag: g++\n",
      "Uploaded tag: embedded\n",
      "Uploaded tag: salesforce\n",
      "Uploaded tag: r-markdown\n",
      "Uploaded tag: windows-8\n",
      "Uploaded tag: snowflake-cloud-data-platform\n",
      "Uploaded tag: user-controls\n",
      "Uploaded tag: gps\n",
      "Uploaded tag: local-storage\n",
      "Uploaded tag: constants\n",
      "Uploaded tag: cocos2d-iphone\n",
      "Uploaded tag: bots\n",
      "Uploaded tag: wix\n",
      "Uploaded tag: authorization\n",
      "Uploaded tag: connection\n",
      "Uploaded tag: compare\n",
      "Uploaded tag: polymorphism\n",
      "Uploaded tag: slider\n",
      "Uploaded tag: django-admin\n",
      "Uploaded tag: localhost\n",
      "Uploaded tag: debian\n",
      "Uploaded tag: ado.net\n",
      "Uploaded tag: twilio\n",
      "Uploaded tag: mono\n",
      "Uploaded tag: time-complexity\n",
      "Uploaded tag: save\n",
      "Uploaded tag: clang\n",
      "Uploaded tag: jframe\n",
      "Uploaded tag: admob\n",
      "Uploaded tag: phpunit\n",
      "Uploaded tag: certificate\n",
      "Uploaded tag: sbt\n",
      "Uploaded tag: imageview\n",
      "Uploaded tag: airflow\n",
      "Uploaded tag: python-imaging-library\n",
      "Uploaded tag: drupal-7\n",
      "Uploaded tag: coffeescript\n",
      "Uploaded tag: gson\n",
      "Uploaded tag: output\n",
      "Uploaded tag: pipe\n",
      "Uploaded tag: include\n",
      "Uploaded tag: cypher\n",
      "Uploaded tag: int\n",
      "Uploaded tag: fullcalendar\n",
      "Uploaded tag: mapping\n",
      "Uploaded tag: java-native-interface\n",
      "Uploaded tag: babeljs\n",
      "Uploaded tag: apache-poi\n",
      "Uploaded tag: web-crawler\n",
      "Uploaded tag: timeout\n",
      "Uploaded tag: location\n",
      "Uploaded tag: hex\n",
      "Uploaded tag: tidyverse\n",
      "Uploaded tag: erlang\n",
      "Uploaded tag: log4j\n",
      "Uploaded tag: pytest\n",
      "Uploaded tag: filesystems\n",
      "Uploaded tag: cypress\n",
      "Uploaded tag: export\n",
      "Uploaded tag: substring\n",
      "Uploaded tag: runtime-error\n",
      "Uploaded tag: iis-7\n",
      "Uploaded tag: icons\n",
      "Uploaded tag: google-oauth\n",
      "Uploaded tag: observable\n",
      "Uploaded tag: storyboard\n",
      "Uploaded tag: azure-sql-database\n",
      "Uploaded tag: window\n",
      "Uploaded tag: regression\n",
      "Uploaded tag: telerik\n",
      "Uploaded tag: key\n",
      "Uploaded tag: ruby-on-rails-5\n",
      "Uploaded tag: elixir\n",
      "Uploaded tag: odbc\n",
      "Uploaded tag: maps\n",
      "Uploaded tag: treeview\n",
      "Uploaded tag: seaborn\n",
      "Uploaded tag: syntax-error\n",
      "Uploaded tag: click\n",
      "Uploaded tag: printf\n",
      "Uploaded tag: jinja2\n",
      "Uploaded tag: typo3\n",
      "Uploaded tag: realm\n",
      "Uploaded tag: cocoapods\n",
      "Uploaded tag: ios8\n",
      "Uploaded tag: ip\n",
      "Uploaded tag: wsdl\n",
      "Uploaded tag: wordpress-theming\n",
      "Uploaded tag: signalr\n",
      "Uploaded tag: logic\n",
      "Uploaded tag: resources\n",
      "Uploaded tag: ckeditor\n",
      "Uploaded tag: kernel\n",
      "Uploaded tag: command-line-interface\n",
      "Uploaded tag: thread-safety\n",
      "Uploaded tag: dojo\n",
      "Uploaded tag: bluetooth-lowenergy\n",
      "Uploaded tag: botframework\n",
      "Uploaded tag: uiimage\n",
      "Uploaded tag: in-app-purchase\n",
      "Uploaded tag: resize\n",
      "Uploaded tag: position\n",
      "Uploaded tag: amazon-elastic-beanstalk\n",
      "Uploaded tag: styles\n",
      "Uploaded tag: cloud\n",
      "Uploaded tag: actionscript\n",
      "Uploaded tag: imagemagick\n",
      "Uploaded tag: android-jetpack-compose\n",
      "Uploaded tag: compression\n",
      "Uploaded tag: thymeleaf\n",
      "Uploaded tag: gruntjs\n",
      "Uploaded tag: malloc\n",
      "Uploaded tag: angularjs-ng-repeat\n",
      "Uploaded tag: cross-browser\n",
      "Uploaded tag: repository\n",
      "Uploaded tag: where-clause\n",
      "Uploaded tag: state\n",
      "Uploaded tag: google-visualization\n",
      "Uploaded tag: pattern-matching\n",
      "Uploaded tag: data-science\n",
      "Uploaded tag: angularjs-scope\n",
      "Uploaded tag: max\n",
      "Uploaded tag: windows-services\n",
      "Uploaded tag: build.gradle\n",
      "Uploaded tag: microservices\n",
      "Uploaded tag: android-actionbar\n",
      "Uploaded tag: escaping\n",
      "Uploaded tag: swift2\n",
      "Uploaded tag: webrtc\n",
      "Uploaded tag: celery\n",
      "Uploaded tag: closures\n",
      "Uploaded tag: pthreads\n",
      "Uploaded tag: .net-4.0\n",
      "Uploaded tag: asp.net-identity\n",
      "Uploaded tag: jquery-selectors\n",
      "Uploaded tag: pandas-groupby\n",
      "Uploaded tag: windows-installer\n",
      "Uploaded tag: jsx\n",
      "Uploaded tag: constraints\n",
      "Uploaded tag: global-variables\n",
      "Uploaded tag: locking\n",
      "Uploaded tag: github-actions\n",
      "Uploaded tag: ios6\n",
      "Uploaded tag: gpu\n",
      "Uploaded tag: applescript\n",
      "Uploaded tag: try-catch\n",
      "Uploaded tag: vuetify.js\n",
      "Uploaded tag: office365\n",
      "Uploaded tag: http-post\n",
      "Uploaded tag: windows-runtime\n",
      "Uploaded tag: zend-framework2\n",
      "Uploaded tag: google-chrome-devtools\n",
      "Uploaded tag: qt5\n",
      "Uploaded tag: many-to-many\n",
      "Uploaded tag: web-config\n",
      "Uploaded tag: match\n",
      "Uploaded tag: alignment\n",
      "Uploaded tag: logstash\n",
      "Uploaded tag: vagrant\n",
      "Uploaded tag: retrofit\n",
      "Uploaded tag: markdown\n",
      "Uploaded tag: mocha.js\n",
      "Uploaded tag: uitextfield\n",
      "Uploaded tag: singleton\n",
      "Uploaded tag: jtable\n",
      "Uploaded tag: video-streaming\n",
      "Uploaded tag: material-design\n",
      "Uploaded tag: ef-code-first\n",
      "Uploaded tag: internet-explorer-8\n",
      "Uploaded tag: sharepoint-2010\n",
      "Uploaded tag: shopify\n",
      "Uploaded tag: jasper-reports\n",
      "Uploaded tag: asp.net-mvc-2\n",
      "Uploaded tag: gtk\n",
      "Uploaded tag: testng\n",
      "Uploaded tag: sh\n",
      "Uploaded tag: c++14\n",
      "Uploaded tag: amazon-redshift\n",
      "Uploaded tag: operator-overloading\n",
      "Uploaded tag: blackberry\n",
      "Uploaded tag: task\n",
      "Uploaded tag: controls\n",
      "Uploaded tag: broadcastreceiver\n",
      "Uploaded tag: react-navigation\n",
      "Uploaded tag: language-agnostic\n",
      "Uploaded tag: bitbucket\n",
      "Uploaded tag: azure-blob-storage\n",
      "Uploaded tag: artificial-intelligence\n",
      "Uploaded tag: polymer\n",
      "Uploaded tag: hdfs\n",
      "Uploaded tag: double\n",
      "Uploaded tag: mercurial\n"
     ]
    }
   ],
   "source": [
    "print(len(docs))\n",
    "print(docs)\n",
    "# upload precalculated top 1000 records into dynamoDB\n",
    "for tag in docs:\n",
    "    tag_id = tag[\"_id\"]\n",
    "    tag_count = tag[\"count\"]\n",
    "    try:\n",
    "        table.put_item(Item={\"tag\": tag_id, \"count\": tag_count})\n",
    "        print(f\"Uploaded tag: {tag_id} with count: {tag_count}\")\n",
    "    except ClientError as e:\n",
    "        print(f\"Error uploading tag: {e}\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['export', 'angularjs-directive', 'ssis', 'windows-runtime', 'function', 'ffmpeg', 'stripe-payments', 'paypal', 'retrofit', 'global-variables', 'opencv', 'centos', 'drag-and-drop', 'sonarqube', 'codeigniter', 'winapi', 'binary', 'in-app-purchase', 'maps', 'android-listview', 'optimization', 'typescript', 'angularjs-ng-repeat', 'filesystems', 'uitextfield', 'webpack', 'sprite-kit', 'jsx', 'excel', 'gradle', 'nuget', 'pyqt5', 'terminal', 'active-directory', 'wordpress-theming', 'salesforce', 'mfc', 'repository', 'continuous-integration', 'location', 'textview', 'elasticsearch', 'vue.js', 'spring-data', 'calendar', 'ruby', 'cross-browser', 'https', 'web-config', 'uibutton', 'gpu', 'mockito', 'flutter-layout', 'android-fragments', 'xsd', 'collections', 'jpa', 'http', 'asp.net-mvc-2', 'thymeleaf', 'powerbi', 'variables', 'ef-code-first', 'heroku', 'ipad', 'timeout', 'kotlin', 'onclick', 'output', 'google-sheets-formula', 'soap', 'excel-formula', 'servlets', 'uiview', 'pagination', 'dependencies', 'floating-point', 'azure-web-app-service', 'pandas', 'gitlab', 'constructor', 'hyperlink', 'statistics', 'authentication', 'localization', 'syntax', 'ruby-on-rails', 'actionscript-3', 'uitableview', 'object', 'asp-classic', 'language-agnostic', 'angular-material', 'prolog', 'locking', 'treeview', 'performance', 'uiviewcontroller', 'joomla', 'concurrency', 'compiler-errors', 'react-router', 'apache-spark-sql', 'signalr', 'runtime-error', 'autolayout', 'ruby-on-rails-3', 'asynchronous', 'mongoose', 'uiimage', 'ssl-certificate', 'sockets', 'max', 'hive', 'multithreading', 'xslt', 'api', 'c++17', 'process', 'matplotlib', 'save', 'nlp', 'nuxt.js', 'forms', 'pyqt', 'macos', 'pycharm', 'github-actions', 'input', 'sorting', 'asp.net-core', 'jboss', 'jquery-ui', 'apache-poi', 'mongodb-query', 'expo', 'kubernetes', 'video', 'deployment', 'internet-explorer-8', 'google-drive-api', 'dictionary', 'ionic3', 'amazon-s3', 'nullpointerexception', 'machine-learning', 'xampp', 'task', 'wcf', 'build', 'jersey', 'serialization', 'callback', 'applescript', 'db2', 'modal-dialog', 'json', 'formatting', 'android-intent', 'file-io', 'file-upload', 'datepicker', 'c++11', 'containers', 'matlab', 'mod-rewrite', 'ios6', 'authorization', 'match', 'html5-canvas', 'asp.net', 'oracle11g', 'visual-studio-2013', 'debian', 'facebook', 'rabbitmq', 'initialization', 'http-post', 'debugging', 'datatable', 'phpmyadmin', 'sass', 'cmd', 'vba', 'qml', '.net-core', 'ansible', 'async-await', 'xpath', 'nginx', 'mapreduce', 'android-activity', 'windows', 'pip', 'activerecord', 'scroll', 'hash', 'rxjs', 'html-table', 'laravel-5', 'django-forms', 'position', 'responsive-design', 'utf-8', 'google-chrome-devtools', 'java-8', 'gwt', 'version-control', 'x86', 'dns', 'elixir', 'rotation', 'blazor', 'clojure', 'menu', 'dataset', 'facebook-graph-api', '.net', 'jasper-reports', 'socket.io', 'ionic-framework', 'firebase-realtime-database', 'nestjs', 'highcharts', 'jquery-mobile', 'xamarin.android', 'ado.net', 'fullcalendar', 'sql-server-2008', 'jsf-2', 'jquery-selectors', 'dll', 'url-rewriting', 'tidyverse', 'combobox', 'qt5', 'shiny', 'jwt', 'lambda', 'knockout.js', 'python-3.x', 'proxy', 'amazon-ec2', 'google-maps', 'text', 'google-chrome-extension', 'woocommerce', 'ide', 'transactions', 'import', 'datatables', 'django', 'checkbox', 'vuetify.js', 'android-ndk', 'typo3', 'dplyr', 'wsdl', 'c#', 'jdbc', 'validation', 'json.net', 'windows-services', 'encryption', 'memory-leaks', 'airflow', 'electron', 'connection', 'xcode', 'pointers', 'events', 'oracle', 'html', 'ubuntu', 'sql-server', 'session', 'timestamp', 'django-templates', 'core-data', 'styles', 'intellij-idea', 'solr', 'find', 'bots', 'ios7', 'firebase', 'visual-studio-2010', 'swift3', 'sql', 'safari', 'yii', '.htaccess', 'imageview', 'openssl', 'emacs', 'character-encoding', 'objective-c', 'templates', 'terraform', 'cucumber', 'controller', 'scikit-learn', 'where-clause', 'redirect', 'bitbucket', 'visual-studio-2017', 'database', 'spring-data-jpa', 'azure-pipelines', 'substring', 'hdfs', 'discord.js', 'pyspark', 'try-catch', 'format', 'sequelize.js', 'regex', 'linq-to-sql', 'autocomplete', 'ruby-on-rails-4', 'arraylist', 'smtp', 'ggplot2', 'indexing', 'rubygems', 'flutter', 'oauth-2.0', 'time-series', 'command-line-interface', 'closures', 'webrtc', 'malloc', 'backbone.js', 'pipe', 'include', 'uicollectionview', 'routes', 'python-requests', 'ios8', 'error-handling', 'oauth', 'ios', 'canvas', 'firebase-authentication', 'asp.net-web-api', 'svn', 'integer', 'coffeescript', 'triggers', 'attributes', 'sed', 'switch-statement', 'c++', 'nested', 'event-handling', 'linked-list', 'xaml', 'uiimageview', 'pytorch', 'time', 'compare', 'arm', 'csv', 'list', 'upload', 'css', 'cakephp', 'date', 'windows-10', 'android-jetpack-compose', 'join', 'scipy', 'git', 'ionic2', 'pygame', 'jar', 'azure-devops', 'user-controls', 'linux-kernel', 'nhibernate', 'rust', 'network-programming', 'jmeter', 'cocoa', 'drupal-7', 'tuples', 'jestjs', 'annotations', 'logstash', 'java-native-interface', 'dockerfile', 'image', 'bluetooth-lowenergy', 'google-cloud-storage', 'django-models', 'package', 'numbers', 'pdo', 'primefaces', 'android-actionbar', 'microsoft-graph-api', 'swift2', 'struts2', 'memory', 'append', 'queue', 'namespaces', 'drop-down-menu', 'command-line', 'database-design', 'jquery', 'g++', 'youtube-api', 'notifications', 'email', 'local-storage', 'react-redux', 'jvm', 'many-to-many', 'visual-studio-code', 'datetime', 'eclipse-plugin', 'youtube', 'wordpress', 'hashmap', 'range', 'log4j', 'header', 'npm', 'iis', 'post', 'google-analytics', 'data-structures', 'parsing', 'datagrid', 'nosql', 'visual-c++', 'hadoop', 'android-recyclerview', 'while-loop', 'methods', 'fetch', 'vb6', 'request', 'resize', 'lucene', 'data.table', 'delphi', 'cassandra', 'entity-framework-6', 'key', 'visual-studio-2008', 'coldfusion', 'logic', 'xamarin', 'iterator', 'gulp', 'controls', 'cocoapods', 'cypress', 'geolocation', 'azure-functions', 'automation', 'gmail', 'google-oauth', 'hibernate', 'composer-php', 'python-2.7', 'amazon-elastic-beanstalk', 'unix', 'wpf', 'tabs', 'model-view-controller', 'popup', 'grid', 'sbt', 'deep-learning', 'apache', 'jenkins', 'protractor', 'bootstrap-4', 'tags', 'return', 'opengl', 'int', 'stream', 'python-imaging-library', 'java-stream', 'count', 'doctrine', 'crystal-reports', 'bitmap', 'neo4j', 'android-edittext', 'wso2', 'visual-studio-2012', 'babeljs', 'amazon-redshift', 'apache-camel', 'interface', 'batch-file', 'plsql', 'unity-game-engine', 'gps', 'service', 'postgresql', 'razor', 'twitter-bootstrap', 'playframework', 'duplicates', 'android-layout', 'ecmascript-6', 'stl', 'google-app-engine', 'graphics', 'foreach', 'google-api', 'curl', 'mysql', 'data-science', 'insert', 'syntax-error', 'thread-safety', 'com', 'bash', 'f#', 'io', 'pivot', 'push-notification', 'ms-access', 'entity-framework', 'redis', 'grails', 'jinja2', 'localhost', 'react-navigation', 'math', 'keras', 'd3.js', 'web-crawler', 'radio-button', 'swift', 'arduino', 'data-binding', 'internet-explorer', 'angular', 'zend-framework2', 'sql-server-2005', 'twig', 'junit', 'logging', 'shopify', 'dom', 'bluetooth', 'windows-8', 'swagger', 'django-admin', 'for-loop', 'markdown', 'compiler-construction', 'axios', 'dataframe', 'mocking', 'networking', 'get', 'libgdx', 'web-services', 'arguments', 'memory-management', 'textbox', 'download', 'admob', 'drupal', 'cron', 'swiftui', 'groovy', 'frameworks', 'vb.net', 'udp', 'sqlalchemy', 'odbc', 'reporting-services', 'chart.js', 'cmake', 'anaconda', 'azure-blob-storage', 'split', 'lua', 'window', 'iis-7', 'reflection', 'android-gradle-plugin', 'scope', 'char', 'segmentation-fault', 'navigation', 'symfony', 'redux', 'vagrant', 'c', 'jenkins-pipeline', 'firefox', 'gcc', 'concatenation', 'webforms', 'selenium-chromedriver', 'architecture', 'flexbox', 'resources', 'subquery', 'file', 'plotly', 'makefile', 'environment-variables', 'vbscript', 'mercurial', 'properties', 'garbage-collection', 'blackberry', 'google-maps-api-3', 'sas', 'fortran', 'spring-boot', 'apache-flex', 'cypher', 'rest', 'xml-parsing', 'dialog', 'model', 'ruby-on-rails-5', 'jakarta-ee', 'widget', 'gdb', 'spring', 'parse-platform', 'mysqli', 'synchronization', 'crash', 'scripting', 'next.js', 'actionscript', 'view', 'uiscrollview', 'laravel', 'sdk', 'observable', 'cuda', 'http-headers', 'dojo', 'silverlight', 'flash', 'asp.net-mvc-3', 'material-ui', 'singleton', 'dart', 'cocoa-touch', 'timer', 'conv-neural-network', 'audio', 'jqgrid', 'entity-framework-core', 'alignment', 'escaping', 'julia', 'jframe', 'background', 'group-by', 'constraints', 'windows-7', 'winforms', 'xamarin.forms', 'phpunit', 'clang', 'neural-network', 'cocos2d-iphone', 'javascript', 'asp.net-mvc', 'operator-overloading', 'jasmine', 'google-play', 'timezone', 'angularjs-scope', 'plugins', 'laravel-4', 'sharepoint', 'xml', 'selenium-webdriver', 'constants', 'web-applications', 'jquery-plugins', 'vim', 'firebase-cloud-messaging', 'gridview', 'if-statement', 'magento', 'cors', 'yaml', 'discord.py', 'path', 'hex', 'asp.net-mvc-4', 'ip', 'erlang', 'jtable', 'c++14', 'tomcat', 'polymorphism', 'github', 'storyboard', 'binding', 'tkinter', 'azure-active-directory', 'grep', 'kernel', 'label', 'web-scraping', 'django-views', 'amazon-web-services', 'express', 'twitter-bootstrap-3', 'css-selectors', 'subprocess', 'botframework', 'asp.net-mvc-5', 'caching', 'ios4', 'tensorflow', 'django-rest-framework', 'printing', 'compilation', 'office365', 'android-asynctask', 'linq', 'dependency-injection', 'latex', 'computer-vision', 'postman', 'operating-system', 'php', 'colors', 'dom-events', 'reactjs', 'yii2', 'encoding', 'command', 'beautifulsoup', 'ant', 'vue-component', 'reference', 'imagemagick', 'javafx', 'ldap', 'ssl', 'sql-server-2012', 'angularjs', 'doctrine-orm', 'fonts', 'oop', 'qt', 'url', 'sh', 'meteor', 'click', 'matrix', 'odoo', 'powershell', 'raspberry-pi', 'directory', 'replace', 'eclipse', 'exception', 'migration', 'set', 'mongodb', 'serial-port', 'snowflake-cloud-data-platform', 'charts', '3d', 'node.js', 'cryptography', 'ios5', 'numpy', 'video-streaming', 'mariadb', 'layout', 'parallel-processing', 'sql-server-2008-r2', 'components', 'asp.net-core-mvc', 'zip', 'outlook', 'permissions', 'stack', 'android-emulator', 'ms-word', 'filter', 'loops', 'types', '.net-4.0', 'discord', 'module', 'google-cloud-firestore', 'web', 'certificate', 'jaxb', 'windows-phone-8', 'scala', 'sharepoint-2010', 'celery', 'promise', 'boost', 'graphql', 'react-hooks', 'pattern-matching', 'unicode', 'regression', 'telerik', 'macros', 'three.js', 'type-conversion', 'docker', 'visual-studio', 'msbuild', 'icons', 'functional-programming', 'extjs', 'conditional-statements', 'eloquent', 'browser', 'unit-testing', 'jsf', 'casting', 'wix', 'enums', 'twilio', 'build.gradle', 'xmlhttprequest', 'slider', 'broadcastreceiver', 'multiprocessing', 'seaborn', 'google-cloud-functions', 'go', 'stored-procedures', 'leaflet', 'pdf', 'select', 'google-bigquery', 'aggregation-framework', 'perl', 'itext', 'rspec', 'tfs', 'parameters', 'visual-studio-2015', 'haskell', 'sum', 'spring-security', 'microservices', 'vuejs3', 'google-sheets', 'opengl-es', 'pthreads', 'vector', 'assembly', 'search', 'multidimensional-array', 'windows-installer', 'frontend', 'image-processing', 'random', 'recursion', 'material-design', 'testng', 'xamarin.ios', 'graph', 'animation', 'cookies', 'internationalization', 'configuration', 'iteration', 'maven', 'linker', 'apache-kafka', 'apache-spark', 'google-apps-script', 'foreign-keys', 'azure', 'cordova', 'console', 'tree', 'realm', 'copy', 'delegates', 'uinavigationcontroller', 'state', 'gruntjs', 'tcp', 'ckeditor', 'react-native', 'aws-lambda', 'design-patterns', 'selenium', 'uikit', 'string', 'tsql', 'server', 'listview', 'user-interface', 'google-cloud-platform', 'button', 'android', 'automated-tests', 'boolean', 'python', 'mono', 'angular-ui-router', 'cloud', 'twitter', 'plot', 'orm', 'listbox', 'security', 'iframe', 'amazon-dynamodb', 'gtk', 'time-complexity', 'compression', 'ajax', 'webview', 'google-chrome', 'docker-compose', 'jsp', 'merge', 'android-studio', 'uwp', 'devise', 'camera', 'google-visualization', 'uiwebview', 'flask', 'testing', 'installation', 'r', 'azure-sql-database', 'double', 'vuejs2', 'kivy', 'ftp', 'class', 'kendo-ui', 'awk', 'null', 'struct', 'mobile', 'zend-framework', 'webdriver', 'ember.js', 'hover', 'embedded', 'ssh', 'scrapy', 'inheritance', 'spring-mvc', 'dynamic', 'r-markdown', 'algorithm', 'mocha.js', 'mapping', 'base64', 'geometry', 'passwords', 'c#-4.0', 'polymer', 'jackson', 'windows-phone-7', 'pytest', 'asp.net-identity', 'shell', 'gson', 'generics', 'android-viewpager', 'datagridview', 'netbeans', 'pandas-groupby', 'iphone', 'sql-update', 'jupyter-notebook', 'arrays', 'mvvm', 'java', 'svg', 'sqlite', 'swing', 'websocket', 'printf', 'static', 'keyboard', 'linux', 'artificial-intelligence']\n",
      "1000\n"
     ]
    }
   ],
   "source": [
    "# mockup of code to be used in javascript server query\n",
    "\n",
    "# retrieve list of tags from DynamoDB\n",
    "response = table.scan(ProjectionExpression='tag')\n",
    "tags_list = [item['tag'] for item in response['Items']]\n",
    "print(tags_list)\n",
    "print(len(tags_list))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "SON([('v', 2), ('key', SON([('_id', 1)])), ('name', '_id_')])\n",
      "SON([('v', 2), ('key', SON([('Tags', 1)])), ('name', 'Tags_1')])\n"
     ]
    }
   ],
   "source": [
    "# Create a sparse index on the 'Tags' field\n",
    "# col.create_index([('Tags', 1)], sparse=True)\n",
    "col.create_index(\n",
    "    [(\"Tags\", ASCENDING)],\n",
    "    partialFilterExpression={\"Tags\": {\"$type\": \"string\"}},\n",
    "    sparse=True\n",
    ")\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "# index verification\n",
    "# List all indexes on the collection \n",
    "indexes = col.list_indexes()\n",
    "for index in indexes:\n",
    "    print(index)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "ename": "AutoReconnect",
     "evalue": "final-cluster-shard-00-02.uucno.mongodb.net:27017: [WinError 10060] A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mTimeoutError\u001b[0m                              Traceback (most recent call last)",
      "File \u001b[1;32mc:\\Users\\aliu\\scoop\\apps\\python\\current\\lib\\site-packages\\pymongo\\pool.py:766\u001b[0m, in \u001b[0;36mSocketInfo.command\u001b[1;34m(self, dbname, spec, read_preference, codec_options, check, allowable_errors, read_concern, write_concern, parse_write_concern_error, collation, session, client, retryable_write, publish_events, user_fields, exhaust_allowed)\u001b[0m\n\u001b[0;32m    765\u001b[0m \u001b[38;5;28;01mtry\u001b[39;00m:\n\u001b[1;32m--> 766\u001b[0m     \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[43mcommand\u001b[49m\u001b[43m(\u001b[49m\n\u001b[0;32m    767\u001b[0m \u001b[43m        \u001b[49m\u001b[38;5;28;43mself\u001b[39;49m\u001b[43m,\u001b[49m\n\u001b[0;32m    768\u001b[0m \u001b[43m        \u001b[49m\u001b[43mdbname\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m    769\u001b[0m \u001b[43m        \u001b[49m\u001b[43mspec\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m    770\u001b[0m \u001b[43m        \u001b[49m\u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mis_mongos\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m    771\u001b[0m \u001b[43m        \u001b[49m\u001b[43mread_preference\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m    772\u001b[0m \u001b[43m        \u001b[49m\u001b[43mcodec_options\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m    773\u001b[0m \u001b[43m        \u001b[49m\u001b[43msession\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m    774\u001b[0m \u001b[43m        \u001b[49m\u001b[43mclient\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m    775\u001b[0m \u001b[43m        \u001b[49m\u001b[43mcheck\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m    776\u001b[0m \u001b[43m        \u001b[49m\u001b[43mallowable_errors\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m    777\u001b[0m \u001b[43m        \u001b[49m\u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43maddress\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m    778\u001b[0m \u001b[43m        \u001b[49m\u001b[43mlisteners\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m    779\u001b[0m \u001b[43m        \u001b[49m\u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mmax_bson_size\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m    780\u001b[0m \u001b[43m        \u001b[49m\u001b[43mread_concern\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m    781\u001b[0m \u001b[43m        \u001b[49m\u001b[43mparse_write_concern_error\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mparse_write_concern_error\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m    782\u001b[0m \u001b[43m        \u001b[49m\u001b[43mcollation\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mcollation\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m    783\u001b[0m \u001b[43m        \u001b[49m\u001b[43mcompression_ctx\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mcompression_context\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m    784\u001b[0m \u001b[43m        \u001b[49m\u001b[43muse_op_msg\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mop_msg_enabled\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m    785\u001b[0m \u001b[43m        \u001b[49m\u001b[43munacknowledged\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43munacknowledged\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m    786\u001b[0m \u001b[43m        \u001b[49m\u001b[43muser_fields\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43muser_fields\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m    787\u001b[0m \u001b[43m        \u001b[49m\u001b[43mexhaust_allowed\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mexhaust_allowed\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m    788\u001b[0m \u001b[43m        \u001b[49m\u001b[43mwrite_concern\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mwrite_concern\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m    789\u001b[0m \u001b[43m    \u001b[49m\u001b[43m)\u001b[49m\n\u001b[0;32m    790\u001b[0m \u001b[38;5;28;01mexcept\u001b[39;00m (OperationFailure, NotPrimaryError):\n",
      "File \u001b[1;32mc:\\Users\\aliu\\scoop\\apps\\python\\current\\lib\\site-packages\\pymongo\\network.py:156\u001b[0m, in \u001b[0;36mcommand\u001b[1;34m(sock_info, dbname, spec, is_mongos, read_preference, codec_options, session, client, check, allowable_errors, address, listeners, max_bson_size, read_concern, parse_write_concern_error, collation, compression_ctx, use_op_msg, unacknowledged, user_fields, exhaust_allowed, write_concern)\u001b[0m\n\u001b[0;32m    155\u001b[0m \u001b[38;5;28;01melse\u001b[39;00m:\n\u001b[1;32m--> 156\u001b[0m     reply \u001b[38;5;241m=\u001b[39m \u001b[43mreceive_message\u001b[49m\u001b[43m(\u001b[49m\u001b[43msock_info\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mrequest_id\u001b[49m\u001b[43m)\u001b[49m\n\u001b[0;32m    157\u001b[0m     sock_info\u001b[38;5;241m.\u001b[39mmore_to_come \u001b[38;5;241m=\u001b[39m reply\u001b[38;5;241m.\u001b[39mmore_to_come\n",
      "File \u001b[1;32mc:\\Users\\aliu\\scoop\\apps\\python\\current\\lib\\site-packages\\pymongo\\network.py:217\u001b[0m, in \u001b[0;36mreceive_message\u001b[1;34m(sock_info, request_id, max_message_size)\u001b[0m\n\u001b[0;32m    215\u001b[0m \u001b[38;5;66;03m# Ignore the response's request id.\u001b[39;00m\n\u001b[0;32m    216\u001b[0m length, _, response_to, op_code \u001b[38;5;241m=\u001b[39m _UNPACK_HEADER(\n\u001b[1;32m--> 217\u001b[0m     \u001b[43m_receive_data_on_socket\u001b[49m\u001b[43m(\u001b[49m\u001b[43msock_info\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[38;5;241;43m16\u001b[39;49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mdeadline\u001b[49m\u001b[43m)\u001b[49m\n\u001b[0;32m    218\u001b[0m )\n\u001b[0;32m    219\u001b[0m \u001b[38;5;66;03m# No request_id for exhaust cursor \"getMore\".\u001b[39;00m\n",
      "File \u001b[1;32mc:\\Users\\aliu\\scoop\\apps\\python\\current\\lib\\site-packages\\pymongo\\network.py:299\u001b[0m, in \u001b[0;36m_receive_data_on_socket\u001b[1;34m(sock_info, length, deadline)\u001b[0m\n\u001b[0;32m    298\u001b[0m         sock_info\u001b[38;5;241m.\u001b[39mset_socket_timeout(\u001b[38;5;28mmax\u001b[39m(deadline \u001b[38;5;241m-\u001b[39m time\u001b[38;5;241m.\u001b[39mmonotonic(), \u001b[38;5;241m0\u001b[39m))\n\u001b[1;32m--> 299\u001b[0m     chunk_length \u001b[38;5;241m=\u001b[39m \u001b[43msock_info\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43msock\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mrecv_into\u001b[49m\u001b[43m(\u001b[49m\u001b[43mmv\u001b[49m\u001b[43m[\u001b[49m\u001b[43mbytes_read\u001b[49m\u001b[43m:\u001b[49m\u001b[43m]\u001b[49m\u001b[43m)\u001b[49m\n\u001b[0;32m    300\u001b[0m \u001b[38;5;28;01mexcept\u001b[39;00m BLOCKING_IO_ERRORS:\n",
      "File \u001b[1;32mc:\\Users\\aliu\\scoop\\apps\\python\\current\\lib\\ssl.py:1241\u001b[0m, in \u001b[0;36mSSLSocket.recv_into\u001b[1;34m(self, buffer, nbytes, flags)\u001b[0m\n\u001b[0;32m   1238\u001b[0m         \u001b[38;5;28;01mraise\u001b[39;00m \u001b[38;5;167;01mValueError\u001b[39;00m(\n\u001b[0;32m   1239\u001b[0m           \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mnon-zero flags not allowed in calls to recv_into() on \u001b[39m\u001b[38;5;132;01m%s\u001b[39;00m\u001b[38;5;124m\"\u001b[39m \u001b[38;5;241m%\u001b[39m\n\u001b[0;32m   1240\u001b[0m           \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m\u001b[38;5;18m__class__\u001b[39m)\n\u001b[1;32m-> 1241\u001b[0m     \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mread\u001b[49m\u001b[43m(\u001b[49m\u001b[43mnbytes\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mbuffer\u001b[49m\u001b[43m)\u001b[49m\n\u001b[0;32m   1242\u001b[0m \u001b[38;5;28;01melse\u001b[39;00m:\n",
      "File \u001b[1;32mc:\\Users\\aliu\\scoop\\apps\\python\\current\\lib\\ssl.py:1099\u001b[0m, in \u001b[0;36mSSLSocket.read\u001b[1;34m(self, len, buffer)\u001b[0m\n\u001b[0;32m   1098\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m buffer \u001b[38;5;129;01mis\u001b[39;00m \u001b[38;5;129;01mnot\u001b[39;00m \u001b[38;5;28;01mNone\u001b[39;00m:\n\u001b[1;32m-> 1099\u001b[0m     \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_sslobj\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mread\u001b[49m\u001b[43m(\u001b[49m\u001b[38;5;28;43mlen\u001b[39;49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mbuffer\u001b[49m\u001b[43m)\u001b[49m\n\u001b[0;32m   1100\u001b[0m \u001b[38;5;28;01melse\u001b[39;00m:\n",
      "\u001b[1;31mTimeoutError\u001b[0m: [WinError 10060] A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond",
      "\nThe above exception was the direct cause of the following exception:\n",
      "\u001b[1;31mAutoReconnect\u001b[0m                             Traceback (most recent call last)",
      "Cell \u001b[1;32mIn[7], line 33\u001b[0m\n\u001b[0;32m      1\u001b[0m \u001b[38;5;66;03m# make mongo query, compare every document to see if tags are in the tags_set\u001b[39;00m\n\u001b[0;32m      2\u001b[0m \u001b[38;5;66;03m# including optimizations to increase performance and manage bandwidth:\u001b[39;00m\n\u001b[0;32m      3\u001b[0m \u001b[38;5;66;03m# projection of only necessary fields (tags)\u001b[39;00m\n\u001b[1;32m   (...)\u001b[0m\n\u001b[0;32m      8\u001b[0m \n\u001b[0;32m      9\u001b[0m \u001b[38;5;66;03m# Aggregation pipeline to count tags\u001b[39;00m\n\u001b[0;32m     10\u001b[0m pipeline \u001b[38;5;241m=\u001b[39m [\n\u001b[0;32m     11\u001b[0m     \u001b[38;5;66;03m# Project only the 'Tags' field\u001b[39;00m\n\u001b[0;32m     12\u001b[0m     {\n\u001b[1;32m   (...)\u001b[0m\n\u001b[0;32m     30\u001b[0m     }\n\u001b[0;32m     31\u001b[0m ]\n\u001b[1;32m---> 33\u001b[0m top_tags \u001b[38;5;241m=\u001b[39m \u001b[38;5;28mlist\u001b[39m(\u001b[43mcol\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43maggregate\u001b[49m\u001b[43m(\u001b[49m\u001b[43mpipeline\u001b[49m\u001b[43m)\u001b[49m)\n",
      "File \u001b[1;32mc:\\Users\\aliu\\scoop\\apps\\python\\current\\lib\\site-packages\\pymongo\\collection.py:2429\u001b[0m, in \u001b[0;36mCollection.aggregate\u001b[1;34m(self, pipeline, session, let, comment, **kwargs)\u001b[0m\n\u001b[0;32m   2351\u001b[0m \u001b[38;5;250m\u001b[39m\u001b[38;5;124;03m\"\"\"Perform an aggregation using the aggregation framework on this\u001b[39;00m\n\u001b[0;32m   2352\u001b[0m \u001b[38;5;124;03mcollection.\u001b[39;00m\n\u001b[0;32m   2353\u001b[0m \n\u001b[1;32m   (...)\u001b[0m\n\u001b[0;32m   2425\u001b[0m \u001b[38;5;124;03m    https://mongodb.com/docs/manual/reference/command/aggregate\u001b[39;00m\n\u001b[0;32m   2426\u001b[0m \u001b[38;5;124;03m\"\"\"\u001b[39;00m\n\u001b[0;32m   2428\u001b[0m \u001b[38;5;28;01mwith\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m__database\u001b[38;5;241m.\u001b[39mclient\u001b[38;5;241m.\u001b[39m_tmp_session(session, close\u001b[38;5;241m=\u001b[39m\u001b[38;5;28;01mFalse\u001b[39;00m) \u001b[38;5;28;01mas\u001b[39;00m s:\n\u001b[1;32m-> 2429\u001b[0m     \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_aggregate(\n\u001b[0;32m   2430\u001b[0m         _CollectionAggregationCommand,\n\u001b[0;32m   2431\u001b[0m         pipeline,\n\u001b[0;32m   2432\u001b[0m         CommandCursor,\n\u001b[0;32m   2433\u001b[0m         session\u001b[38;5;241m=\u001b[39ms,\n\u001b[0;32m   2434\u001b[0m         explicit_session\u001b[38;5;241m=\u001b[39msession \u001b[38;5;129;01mis\u001b[39;00m \u001b[38;5;129;01mnot\u001b[39;00m \u001b[38;5;28;01mNone\u001b[39;00m,\n\u001b[0;32m   2435\u001b[0m         let\u001b[38;5;241m=\u001b[39mlet,\n\u001b[0;32m   2436\u001b[0m         comment\u001b[38;5;241m=\u001b[39mcomment,\n\u001b[0;32m   2437\u001b[0m         \u001b[38;5;241m*\u001b[39m\u001b[38;5;241m*\u001b[39mkwargs,\n\u001b[0;32m   2438\u001b[0m     )\n",
      "File \u001b[1;32mc:\\Users\\aliu\\scoop\\apps\\python\\current\\lib\\site-packages\\pymongo\\_csot.py:105\u001b[0m, in \u001b[0;36mapply.<locals>.csot_wrapper\u001b[1;34m(self, *args, **kwargs)\u001b[0m\n\u001b[0;32m    103\u001b[0m         \u001b[38;5;28;01mwith\u001b[39;00m _TimeoutContext(timeout):\n\u001b[0;32m    104\u001b[0m             \u001b[38;5;28;01mreturn\u001b[39;00m func(\u001b[38;5;28mself\u001b[39m, \u001b[38;5;241m*\u001b[39margs, \u001b[38;5;241m*\u001b[39m\u001b[38;5;241m*\u001b[39mkwargs)\n\u001b[1;32m--> 105\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m func(\u001b[38;5;28mself\u001b[39m, \u001b[38;5;241m*\u001b[39margs, \u001b[38;5;241m*\u001b[39m\u001b[38;5;241m*\u001b[39mkwargs)\n",
      "File \u001b[1;32mc:\\Users\\aliu\\scoop\\apps\\python\\current\\lib\\site-packages\\pymongo\\collection.py:2336\u001b[0m, in \u001b[0;36mCollection._aggregate\u001b[1;34m(self, aggregation_command, pipeline, cursor_class, session, explicit_session, let, comment, **kwargs)\u001b[0m\n\u001b[0;32m   2325\u001b[0m     kwargs[\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mcomment\u001b[39m\u001b[38;5;124m\"\u001b[39m] \u001b[38;5;241m=\u001b[39m comment\n\u001b[0;32m   2326\u001b[0m cmd \u001b[38;5;241m=\u001b[39m aggregation_command(\n\u001b[0;32m   2327\u001b[0m     \u001b[38;5;28mself\u001b[39m,\n\u001b[0;32m   2328\u001b[0m     cursor_class,\n\u001b[1;32m   (...)\u001b[0m\n\u001b[0;32m   2333\u001b[0m     user_fields\u001b[38;5;241m=\u001b[39m{\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mcursor\u001b[39m\u001b[38;5;124m\"\u001b[39m: {\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mfirstBatch\u001b[39m\u001b[38;5;124m\"\u001b[39m: \u001b[38;5;241m1\u001b[39m}},\n\u001b[0;32m   2334\u001b[0m )\n\u001b[1;32m-> 2336\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m__database\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mclient\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_retryable_read\u001b[49m\u001b[43m(\u001b[49m\n\u001b[0;32m   2337\u001b[0m \u001b[43m    \u001b[49m\u001b[43mcmd\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mget_cursor\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m   2338\u001b[0m \u001b[43m    \u001b[49m\u001b[43mcmd\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mget_read_preference\u001b[49m\u001b[43m(\u001b[49m\u001b[43msession\u001b[49m\u001b[43m)\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m   2339\u001b[0m \u001b[43m    \u001b[49m\u001b[43msession\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m   2340\u001b[0m \u001b[43m    \u001b[49m\u001b[43mretryable\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[38;5;129;43;01mnot\u001b[39;49;00m\u001b[43m \u001b[49m\u001b[43mcmd\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_performs_write\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m   2341\u001b[0m \u001b[43m\u001b[49m\u001b[43m)\u001b[49m\n",
      "File \u001b[1;32mc:\\Users\\aliu\\scoop\\apps\\python\\current\\lib\\site-packages\\pymongo\\_csot.py:105\u001b[0m, in \u001b[0;36mapply.<locals>.csot_wrapper\u001b[1;34m(self, *args, **kwargs)\u001b[0m\n\u001b[0;32m    103\u001b[0m         \u001b[38;5;28;01mwith\u001b[39;00m _TimeoutContext(timeout):\n\u001b[0;32m    104\u001b[0m             \u001b[38;5;28;01mreturn\u001b[39;00m func(\u001b[38;5;28mself\u001b[39m, \u001b[38;5;241m*\u001b[39margs, \u001b[38;5;241m*\u001b[39m\u001b[38;5;241m*\u001b[39mkwargs)\n\u001b[1;32m--> 105\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m func(\u001b[38;5;28mself\u001b[39m, \u001b[38;5;241m*\u001b[39margs, \u001b[38;5;241m*\u001b[39m\u001b[38;5;241m*\u001b[39mkwargs)\n",
      "File \u001b[1;32mc:\\Users\\aliu\\scoop\\apps\\python\\current\\lib\\site-packages\\pymongo\\mongo_client.py:1420\u001b[0m, in \u001b[0;36mMongoClient._retryable_read\u001b[1;34m(self, func, read_pref, session, address, retryable)\u001b[0m\n\u001b[0;32m   1418\u001b[0m             \u001b[38;5;28;01massert\u001b[39;00m last_error \u001b[38;5;129;01mis\u001b[39;00m \u001b[38;5;129;01mnot\u001b[39;00m \u001b[38;5;28;01mNone\u001b[39;00m\n\u001b[0;32m   1419\u001b[0m             \u001b[38;5;28;01mraise\u001b[39;00m last_error\n\u001b[1;32m-> 1420\u001b[0m         \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[43mfunc\u001b[49m\u001b[43m(\u001b[49m\u001b[43msession\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mserver\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43msock_info\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mread_pref\u001b[49m\u001b[43m)\u001b[49m\n\u001b[0;32m   1421\u001b[0m \u001b[38;5;28;01mexcept\u001b[39;00m ServerSelectionTimeoutError:\n\u001b[0;32m   1422\u001b[0m     \u001b[38;5;28;01mif\u001b[39;00m retrying:\n\u001b[0;32m   1423\u001b[0m         \u001b[38;5;66;03m# The application may think the write was never attempted\u001b[39;00m\n\u001b[0;32m   1424\u001b[0m         \u001b[38;5;66;03m# if we raise ServerSelectionTimeoutError on the retry\u001b[39;00m\n\u001b[0;32m   1425\u001b[0m         \u001b[38;5;66;03m# attempt. Raise the original exception instead.\u001b[39;00m\n",
      "File \u001b[1;32mc:\\Users\\aliu\\scoop\\apps\\python\\current\\lib\\site-packages\\pymongo\\aggregation.py:140\u001b[0m, in \u001b[0;36m_AggregationCommand.get_cursor\u001b[1;34m(self, session, server, sock_info, read_preference)\u001b[0m\n\u001b[0;32m    137\u001b[0m     write_concern \u001b[38;5;241m=\u001b[39m \u001b[38;5;28;01mNone\u001b[39;00m\n\u001b[0;32m    139\u001b[0m \u001b[38;5;66;03m# Run command.\u001b[39;00m\n\u001b[1;32m--> 140\u001b[0m result \u001b[38;5;241m=\u001b[39m \u001b[43msock_info\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mcommand\u001b[49m\u001b[43m(\u001b[49m\n\u001b[0;32m    141\u001b[0m \u001b[43m    \u001b[49m\u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_database\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mname\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m    142\u001b[0m \u001b[43m    \u001b[49m\u001b[43mcmd\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m    143\u001b[0m \u001b[43m    \u001b[49m\u001b[43mread_preference\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m    144\u001b[0m \u001b[43m    \u001b[49m\u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_target\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mcodec_options\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m    145\u001b[0m \u001b[43m    \u001b[49m\u001b[43mparse_write_concern_error\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[38;5;28;43;01mTrue\u001b[39;49;00m\u001b[43m,\u001b[49m\n\u001b[0;32m    146\u001b[0m \u001b[43m    \u001b[49m\u001b[43mread_concern\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mread_concern\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m    147\u001b[0m \u001b[43m    \u001b[49m\u001b[43mwrite_concern\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mwrite_concern\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m    148\u001b[0m \u001b[43m    \u001b[49m\u001b[43mcollation\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_collation\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m    149\u001b[0m \u001b[43m    \u001b[49m\u001b[43msession\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43msession\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m    150\u001b[0m \u001b[43m    \u001b[49m\u001b[43mclient\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_database\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mclient\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m    151\u001b[0m \u001b[43m    \u001b[49m\u001b[43muser_fields\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_user_fields\u001b[49m\u001b[43m,\u001b[49m\n\u001b[0;32m    152\u001b[0m \u001b[43m\u001b[49m\u001b[43m)\u001b[49m\n\u001b[0;32m    154\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_result_processor:\n\u001b[0;32m    155\u001b[0m     \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_result_processor(result, sock_info)\n",
      "File \u001b[1;32mc:\\Users\\aliu\\scoop\\apps\\python\\current\\lib\\site-packages\\pymongo\\pool.py:794\u001b[0m, in \u001b[0;36mSocketInfo.command\u001b[1;34m(self, dbname, spec, read_preference, codec_options, check, allowable_errors, read_concern, write_concern, parse_write_concern_error, collation, session, client, retryable_write, publish_events, user_fields, exhaust_allowed)\u001b[0m\n\u001b[0;32m    792\u001b[0m \u001b[38;5;66;03m# Catch socket.error, KeyboardInterrupt, etc. and close ourselves.\u001b[39;00m\n\u001b[0;32m    793\u001b[0m \u001b[38;5;28;01mexcept\u001b[39;00m \u001b[38;5;167;01mBaseException\u001b[39;00m \u001b[38;5;28;01mas\u001b[39;00m error:\n\u001b[1;32m--> 794\u001b[0m     \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_raise_connection_failure\u001b[49m\u001b[43m(\u001b[49m\u001b[43merror\u001b[49m\u001b[43m)\u001b[49m\n",
      "File \u001b[1;32mc:\\Users\\aliu\\scoop\\apps\\python\\current\\lib\\site-packages\\pymongo\\pool.py:952\u001b[0m, in \u001b[0;36mSocketInfo._raise_connection_failure\u001b[1;34m(self, error)\u001b[0m\n\u001b[0;32m    950\u001b[0m \u001b[38;5;66;03m# SSLError from PyOpenSSL inherits directly from Exception.\u001b[39;00m\n\u001b[0;32m    951\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m \u001b[38;5;28misinstance\u001b[39m(error, (\u001b[38;5;167;01mIOError\u001b[39;00m, \u001b[38;5;167;01mOSError\u001b[39;00m, SSLError)):\n\u001b[1;32m--> 952\u001b[0m     \u001b[43m_raise_connection_failure\u001b[49m\u001b[43m(\u001b[49m\u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43maddress\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43merror\u001b[49m\u001b[43m)\u001b[49m\n\u001b[0;32m    953\u001b[0m \u001b[38;5;28;01melse\u001b[39;00m:\n\u001b[0;32m    954\u001b[0m     \u001b[38;5;28;01mraise\u001b[39;00m\n",
      "File \u001b[1;32mc:\\Users\\aliu\\scoop\\apps\\python\\current\\lib\\site-packages\\pymongo\\pool.py:261\u001b[0m, in \u001b[0;36m_raise_connection_failure\u001b[1;34m(address, error, msg_prefix)\u001b[0m\n\u001b[0;32m    259\u001b[0m     \u001b[38;5;28;01mraise\u001b[39;00m NetworkTimeout(msg) \u001b[38;5;28;01mfrom\u001b[39;00m \u001b[38;5;21;01merror\u001b[39;00m\n\u001b[0;32m    260\u001b[0m \u001b[38;5;28;01melse\u001b[39;00m:\n\u001b[1;32m--> 261\u001b[0m     \u001b[38;5;28;01mraise\u001b[39;00m AutoReconnect(msg) \u001b[38;5;28;01mfrom\u001b[39;00m \u001b[38;5;21;01merror\u001b[39;00m\n",
      "\u001b[1;31mAutoReconnect\u001b[0m: final-cluster-shard-00-02.uucno.mongodb.net:27017: [WinError 10060] A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond"
     ]
    }
   ],
   "source": [
    "# make mongo query, compare every document to see if tags are in the tags_set\n",
    "# including optimizations to increase performance and manage bandwidth:\n",
    "# projection of only necessary fields (tags)\n",
    "# cache dynamodb call?\n",
    "# index the tags field for efficient reading of tags\n",
    "\n",
    "# since our data is so large we want to ensure that we are offloading the bulk of the calculations onto the cluster rather than doing the calculations locally or on clientside. to do this we make use of MongoDB aggregations\n",
    "\n",
    "# Aggregation pipeline to count tags\n",
    "pipeline = [\n",
    "    # Project only the 'Tags' field\n",
    "    {\n",
    "        \"$project\": {\n",
    "            \"Tags\": 1\n",
    "        }\n",
    "    },\n",
    "    # Filter out documents where 'Tags' is missing or is not an array\n",
    "    {\n",
    "        \"$match\": {\n",
    "            \"Tags\": {\"$exists\": True, \"$type\": \"array\"}\n",
    "        }\n",
    "    },\n",
    "    # Unwind the 'Tags' array to create a document for each tag\n",
    "    {\n",
    "        \"$unwind\": \"$Tags\"\n",
    "    },\n",
    "    # Filter to include only documents with tags in the specified list\n",
    "    {\n",
    "        \"$match\": {\n",
    "            \"Tags\": {\"$in\": tags_list}\n",
    "        }\n",
    "    },\n",
    "    # Group by tag and count occurrences\n",
    "    {\n",
    "        \"$group\": {\n",
    "            \"_id\": \"$Tags\",\n",
    "            \"count\": {\"$sum\": 1}\n",
    "        }\n",
    "    },\n",
    "    # Sort by count in descending order\n",
    "    {\n",
    "        \"$sort\": {\"count\": -1}\n",
    "    },\n",
    "    # Limit to the top 1000 tags\n",
    "    {\n",
    "        \"$limit\": 1000\n",
    "    }\n",
    "]\n",
    "\n",
    "top_tags = list(col.aggregate(pipeline))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[]\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: []\n",
       "Index: []"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "print(list(top_tags))\n",
    "# pretty display the resulting docs using pandas (_id: tag name, count: number of posts with that tag)\n",
    "df = pd.DataFrame(top_tags)\n",
    "display(df)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}