PersonalityDB_API_Wrapper.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "class PersonalityDatabase:\n",
    "\n",
    "    def __init__(self):\n",
    "\n",
    "        self.host = \"https://api.personality-database.com/api/v1/\"\n",
    "        self.payload = {\n",
    "            \"query\": \"\",\n",
    "            \"is_web\": False,\n",
    "            \"type_filter\": \"\",\n",
    "            \"cat_id\": \"\",\n",
    "            \"list_type\": \"4LETTER\",\n",
    "            \"per_page\": 1,\n",
    "            \"next_offset\": 0,\n",
    "            \"new_search\": True}\n",
    "\n",
    "    @staticmethod\n",
    "    def get_info(r, i):\n",
    "        raw = r.json()\n",
    "        id = raw['items'][i]['id']\n",
    "        user_id = raw['items'][i]['user_id']\n",
    "        mbti_profile = raw['items'][i]['mbti_profile']\n",
    "        wiki_description = raw['items'][i]['wiki_description']\n",
    "        category = raw['items'][i]['category']\n",
    "        mostCommonValue = raw['items'][i]['mostCommonValue']\n",
    "        subcategory = raw['items'][i]['subcategory']\n",
    "        profile_image_url = raw['items'][i]['profile_image_url']\n",
    "\n",
    "        return_dict = {'id': id, 'name': mbti_profile, 'desc': wiki_description, 'category': category,\n",
    "                       'sub_category': subcategory}\n",
    "\n",
    "        if wiki_description is '':\n",
    "            return_dict['desc'] = \"This persona does not have any description available.\"\n",
    "        if raw['items'][i]['image_exists']:\n",
    "            return_dict['avatar'] = profile_image_url\n",
    "        try:\n",
    "            mbti, enneagram = mostCommonValue.split()\n",
    "            return_dict['mbti'] = mbti\n",
    "            return_dict['enneagram'] = enneagram\n",
    "        except:\n",
    "            if mostCommonValue != '':\n",
    "                return_dict['mbti'] = mostCommonValue\n",
    "            else:\n",
    "                return_dict['type'] = None\n",
    "                print('MBTI type is empty!')\n",
    "\n",
    "\n",
    "        return return_dict\n",
    "\n",
    "    def search(self, query, i=0, cat_id=None, type_filter=None, list_type=\"ENNEATYPE\", clean=True):\n",
    "        self.payload['query'] = query\n",
    "        self.payload['cat_id'] = cat_id\n",
    "        self.payload['type_filter'] = type_filter\n",
    "        self.payload['list_type'] = list_type\n",
    "\n",
    "        req = requests.post(self.host + 'search', json=self.payload)\n",
    "        if clean:\n",
    "            return self.get_info(req, i=i)\n",
    "        else:\n",
    "            return req\n",
    "\n",
    "    def get_profile(self, id):\n",
    "        req = requests.post(self.host + 'profile/{}'.format(id))\n",
    "        return req"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Usage\n",
    "You can use this wrapper in two ways: clean (all essential variables are already parsed) and just raw request. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "db = PersonalityDatabase()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Return Request"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'profile_count': 0,\n",
       " 'items': [{'id': 165716,\n",
       "   'user_id': 6216,\n",
       "   'sub_cat_id': 10628,\n",
       "   'mbti_profile': 'Noriaki Kakyoin',\n",
       "   'wiki_description': '',\n",
       "   'theCount': 0,\n",
       "   'vote_count_enneagram': 0,\n",
       "   'watch_count': 0,\n",
       "   'chatCount': 0,\n",
       "   'allow_voting': 1,\n",
       "   'subcategory': \"Jojo's Copyright Free Adventures\",\n",
       "   'category': 'Television',\n",
       "   'is_watching': None,\n",
       "   'user_profile_id': '',\n",
       "   'enneagram_vote_id': '',\n",
       "   'profile_image_url': 'https://api.personality-database.com/profile_images/165716.png',\n",
       "   'mostCommonValue': '',\n",
       "   'image_exists': False},\n",
       "  {'id': 5209,\n",
       "   'user_id': 1887,\n",
       "   'sub_cat_id': 638,\n",
       "   'mbti_profile': 'Noriaki Kakyoin',\n",
       "   'wiki_description': 'レロレロ',\n",
       "   'theCount': 208,\n",
       "   'vote_count_enneagram': 105,\n",
       "   'watch_count': 119,\n",
       "   'chatCount': 98,\n",
       "   'allow_voting': 1,\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'category': 'Anime',\n",
       "   'is_watching': None,\n",
       "   'user_profile_id': '',\n",
       "   'enneagram_vote_id': '',\n",
       "   'profile_image_url': 'https://api.personality-database.com/profile_images/5209.png?credit_id=85711',\n",
       "   'mostCommonValue': 'INTP 5w4',\n",
       "   'image_exists': True},\n",
       "  {'id': 132778,\n",
       "   'user_id': 30732,\n",
       "   'sub_cat_id': 638,\n",
       "   'mbti_profile': 'Jouta Kujo',\n",
       "   'wiki_description': 'ｋａｋｙｏｉｎ\\u3000ｄｉｄ\\u3000ｙｏｕ\\u3000ｌａｙ\\u3000ｔｈｉｓ\\u3000ｅｇｇ\\u3000？？？',\n",
       "   'theCount': 13,\n",
       "   'vote_count_enneagram': 9,\n",
       "   'watch_count': 3,\n",
       "   'chatCount': 10,\n",
       "   'allow_voting': 1,\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'category': 'Anime',\n",
       "   'is_watching': None,\n",
       "   'user_profile_id': '',\n",
       "   'enneagram_vote_id': '',\n",
       "   'profile_image_url': 'https://api.personality-database.com/profile_images/132778.png?credit_id=66741',\n",
       "   'mostCommonValue': 'ESFJ 5w4',\n",
       "   'image_exists': True}],\n",
       " 'type_search': False}"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "req = db.search('Kakyoin', i=1, clean=False)\n",
    "req.json()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Return Cleaned Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'id': 5209,\n",
       " 'name': 'Noriaki Kakyoin',\n",
       " 'desc': 'レロレロ',\n",
       " 'category': 'Anime',\n",
       " 'sub_category': 'JoJo no Kimyou na Bouken',\n",
       " 'avatar': 'https://api.personality-database.com/profile_images/5209.png?credit_id=85711',\n",
       " 'mbti': 'INTP',\n",
       " 'enneagram': '5w4'}"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "req = db.search('Kakyoin', i=1, clean=True)\n",
    "req"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Limitations\n",
    "Due to limitation from PersonalityDatabase API you have to use `get_profile(id)` to get every information besides MBTI and Enneagram."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'id': 5209,\n",
       " 'sub_cat_id': 638,\n",
       " 'user_id': 1887,\n",
       " 'is_active': 1,\n",
       " 'is_approved': 1,\n",
       " 'edit_lock': 1,\n",
       " 'edit_lock_picture': 1,\n",
       " 'display_order': 1987,\n",
       " 'is_featured': 0,\n",
       " 'vote_count': 208,\n",
       " 'vote_count_enneagram': 105,\n",
       " 'watch_count': 119,\n",
       " 'comment_count': 98,\n",
       " 'allow_voting': 1,\n",
       " 'allow_commenting': 1,\n",
       " 'mbti_profile': 'Noriaki Kakyoin',\n",
       " 'profile_name_searchable': 'noriakikakyoin',\n",
       " 'featured_title': '',\n",
       " 'linked_with': '',\n",
       " 'wiki_description': 'レロレロ',\n",
       " 'mbti_type': 'INTP 5w4',\n",
       " 'category': 'Anime',\n",
       " 'subcategory': 'JoJo no Kimyou na Bouken',\n",
       " 'alt_subcategory': \"JoJo's Bizarre Adventure\",\n",
       " 'image_exists': True,\n",
       " 'user_vote': '',\n",
       " 'enneagram_vote': '',\n",
       " 'user_profile_id': 0,\n",
       " 'enneagram_vote_id': 0,\n",
       " 'is_watching': 0,\n",
       " 'profile_image_credit_type': 0,\n",
       " 'profile_image_credit_url': '',\n",
       " 'profile_image_credit_id': '85711',\n",
       " 'profile_image_credit': '',\n",
       " 'profile_image_url': 'https://api.personality-database.com/profile_images/5209.png?credit_id=85711',\n",
       " 'contributor': 'luger2000',\n",
       " 'contributor_create_date': '2017-01-07 10:56:08',\n",
       " 'category_is_fictional': '1',\n",
       " 'related_subcategories': '',\n",
       " 'pdb_page_owner': 0,\n",
       " 'pdb_comment_access': 1,\n",
       " 'pdb_public_access': 1,\n",
       " 'related_profiles': [{'id': '5489',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Jonathan Joestar',\n",
       "   'user_id': '2041',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '5488',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Joseph Joestar',\n",
       "   'user_id': '2041',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '5206',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Jotaro Kujo',\n",
       "   'user_id': '1887',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '5208',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Josuke Higashikata',\n",
       "   'user_id': '1887',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '14646',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Giorno Giovanna',\n",
       "   'user_id': '5188',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '26929',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Jolyne Cujoh',\n",
       "   'user_id': '9688',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30298',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Johnny Joestar',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '38225',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Josuke Higashikata (Part 8)',\n",
       "   'user_id': '5599',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '9037',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Dio Brando',\n",
       "   'user_id': '3861',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '5490',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Robert E. O. Speedwagon',\n",
       "   'user_id': '2041',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '34140',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Baron Will A. Zeppeli',\n",
       "   'user_id': '12060',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '5491',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Caesar Anthonio Zeppeli',\n",
       "   'user_id': '2041',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '14645',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Kars',\n",
       "   'user_id': '5188',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '19091',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Lisa Lisa',\n",
       "   'user_id': '6642',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '5209',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Noriaki Kakyoin',\n",
       "   'user_id': '1887',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '28455',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Jean Pierre Polnareff',\n",
       "   'user_id': '10183',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '28456',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Muhammad Avdol',\n",
       "   'user_id': '10183',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '9038',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Iggy',\n",
       "   'user_id': '3861',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '5207',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Yoshikage Kira',\n",
       "   'user_id': '1887',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '9040',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Koichi Hirose',\n",
       "   'user_id': '3861',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '29270',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Okuyasu Nijimura',\n",
       "   'user_id': '10705',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '9039',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Rohan Kishibe',\n",
       "   'user_id': '3861',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41058',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Yukako Yamagishi',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '21191',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Bruno Bucciarati',\n",
       "   'user_id': '6642',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '21192',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Leone Abbacchio',\n",
       "   'user_id': '6642',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '19548',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Guido Mista',\n",
       "   'user_id': '7217',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '14865',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Pannacotta Fugo',\n",
       "   'user_id': '5917',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '21193',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Narancia Ghirga',\n",
       "   'user_id': '6642',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '29269',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Trish Una',\n",
       "   'user_id': '10705',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30313',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Diavolo',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30314',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Vinegar Doppio',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '14647',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Enrico Pucci',\n",
       "   'user_id': '5188',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30618',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Ermes Costello',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30299',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Gyro Zeppeli',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30300',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Funny Valentine',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '29660',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Diego Brando',\n",
       "   'user_id': '10565',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '38228',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Yasuho Hirose',\n",
       "   'user_id': '5599',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '71065',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': '『 Anubis 』',\n",
       "   'user_id': '6332',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '71207',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': '『 Wonder of U 』(Satoru Akefu)',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '53909',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Aisho Dainenjiyama',\n",
       "   'user_id': '12251',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41048',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Akira Otoishi',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41028',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Alessi',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '151164',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Anakiss',\n",
       "   'user_id': '15697',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '151893',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Andre Boom Boom',\n",
       "   'user_id': '15697',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '71742',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Angelica Attanasio',\n",
       "   'user_id': '19295',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41052',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Angelo Katagiri',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '32948',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Anne',\n",
       "   'user_id': '7306',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '62566',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Axl RO',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41059',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Aya Tsuji',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '71127',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Baby Face (Junior)',\n",
       "   'user_id': '10705',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '151894',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Benjamin Boom Boom',\n",
       "   'user_id': '15697',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '53915',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Blackmore',\n",
       "   'user_id': '12251',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30619',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Boingo',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '131014',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Bruford',\n",
       "   'user_id': '15697',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41023',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Cameo',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '71746',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Cannolo Murolo',\n",
       "   'user_id': '19295',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41064',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Carne',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '155709',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Chaka',\n",
       "   'user_id': '15697',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '71064',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Cheap Trick',\n",
       "   'user_id': '6332',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30311',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Cioccolata',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '150930',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Coco Jumbo',\n",
       "   'user_id': '15697',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41797',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'D an G',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '53913',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'D-I-S-C-O',\n",
       "   'user_id': '12251',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '40340',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Daiya Higashikata',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41043',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Daniel J. D’Arby',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '130399',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Dario Brando',\n",
       "   'user_id': '23315',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41038',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Devo',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '73658',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Diego Brando From Another World',\n",
       "   'user_id': '10565',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '129250',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Dire',\n",
       "   'user_id': '22348',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '62571',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Dolomité',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '84248',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Donatella Una',\n",
       "   'user_id': '22348',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41068',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Donatello Versus',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '149043',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Donovan',\n",
       "   'user_id': '15697',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '62567',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Dr. Ferdinand',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30303',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Emporio Alniño',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30296',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Enyaba the Hag',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '19081',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Erina Pendleton',\n",
       "   'user_id': '6642',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30297',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Esidisi',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '9036',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Foo Fighters',\n",
       "   'user_id': '3861',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41036',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Forever',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30288',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Formaggio',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '155832',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Fortuneteller',\n",
       "   'user_id': '34628',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '175247',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Fritz Von Stroheim',\n",
       "   'user_id': '15697',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '175835',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Gaucho',\n",
       "   'user_id': '15697',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '98845',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Gelato',\n",
       "   'user_id': '22348',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '67056',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'George Joestar (Part 1)',\n",
       "   'user_id': '6216',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '160915',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'George Joestar (Part 7)',\n",
       "   'user_id': '80050',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '71747',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'George Joestar II',\n",
       "   'user_id': '19295',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30293',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Ghiaccio',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '152224',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': \"Giorno's Mother\",\n",
       "   'user_id': '17471',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41024',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Gray Fly',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '151901',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Green Baby',\n",
       "   'user_id': '15697',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '156018',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Gregorio Zeppeli',\n",
       "   'user_id': '22299',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41798',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Guccio',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41799',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Gwess',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '40342',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Hato Higashikata',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30295',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Hayato Kawajiri',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30294',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Hol Horse',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '170181',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Holy Joestar-Kira',\n",
       "   'user_id': '74515',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41047',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Holy Kujo',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30301',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Hot Pants',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30289',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Illuso',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41025',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Imposter Captain Tennille',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '151158',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Irene',\n",
       "   'user_id': '15697',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41026',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'J. Geil / Centerfold',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '129595',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Jack the Ripper',\n",
       "   'user_id': '22348',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '151336',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Jesus Christ',\n",
       "   'user_id': '34628',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '40344',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Jobin Higashikata',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41800',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Johngalli A',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '134867',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Jorge \"Joji\" Joestar',\n",
       "   'user_id': '15412',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '46690',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Josefumi Kujo',\n",
       "   'user_id': '11203',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '40341',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Joshu Higashikata',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '132778',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Jouta Kujo',\n",
       "   'user_id': '30732',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '53910',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Kaato Higashikata',\n",
       "   'user_id': '12251',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '104062',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Karera Sakunami',\n",
       "   'user_id': '22348',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '14648',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Keicho Nijimura',\n",
       "   'user_id': '5188',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41053',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Ken Oyanagi',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41801',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Kenzou',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '155725',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Khan',\n",
       "   'user_id': '15697',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '40343',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Kyo Nijimura',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '177661',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Kyoka Izumi',\n",
       "   'user_id': '6216',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '151895',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'L. A. Boom Boom',\n",
       "   'user_id': '15697',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41802',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Lang Wrangler',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '53714',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Leaky-Eye Luca',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '172027',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Loccobarocco',\n",
       "   'user_id': '15697',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '149040',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Loggins',\n",
       "   'user_id': '15697',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30304',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Lucy Steel',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30309',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Magenta Magenta',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '156680',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Malèna',\n",
       "   'user_id': '15697',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41027',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Mannish Boy',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '175245',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Marco',\n",
       "   'user_id': '15697',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41042',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Mariah',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30315',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Mario Zucchero',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '156686',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Mark',\n",
       "   'user_id': '15697',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '150939',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Mary Joestar',\n",
       "   'user_id': '15697',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '69228',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Masazo Kinoto',\n",
       "   'user_id': '18243',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '71741',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Massimo Volpe',\n",
       "   'user_id': '19295',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30292',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Melone',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '149041',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Messina',\n",
       "   'user_id': '15697',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41030',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Midler',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '62568',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Mike O.',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41054',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Mikitaka Hazekura',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41803',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Miraschon',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '112971',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Mitsuba Higashikata',\n",
       "   'user_id': '18635',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41804',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Miuccia Miuller',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30307',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Mountain Tim',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '173969',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Mrs. Robinson',\n",
       "   'user_id': '15697',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41035',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'N’Doul',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '177472',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Nanase Fujikura',\n",
       "   'user_id': '6216',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30302',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Narciso Anasui',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41045',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Nena',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '40339',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Norisuke Higashikata IV',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '61296',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Nukesaku',\n",
       "   'user_id': '11620',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '70392',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Number 5',\n",
       "   'user_id': '13650',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41039',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Oingo',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '49158',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Ojiro Sasame',\n",
       "   'user_id': '12251',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '53914',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Oyecomova',\n",
       "   'user_id': '12251',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '46875',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Pericolo',\n",
       "   'user_id': '11620',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30291',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Pesci',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41031',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Pet Shop',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '150935',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Poco',\n",
       "   'user_id': '15697',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '150938',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': \"Poco's Sister\",\n",
       "   'user_id': '15697',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30306',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Pocoloco',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30287',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Polpo',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '62572',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Poor Tom',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '62570',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Pork Pie Hat Kid',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30290',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Prosciutto',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '54796',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Rai Mamezuku',\n",
       "   'user_id': '12251',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '35634',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Reimi Sugimoto',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41067',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Rikiel',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30310',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Ringo Roadagain',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30060',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Risotto Nero',\n",
       "   'user_id': '9711',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '173900',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Romeo Jisso',\n",
       "   'user_id': '15697',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '162768',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Roses',\n",
       "   'user_id': '15697',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41032',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Rubber Soul',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '19084',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Rudol von Stroheim',\n",
       "   'user_id': '6642',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30316',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Sale',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30305',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Sandman / Soundman',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '82635',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Santana',\n",
       "   'user_id': '7596',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '135516',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Scarlet Valentine',\n",
       "   'user_id': '14294',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41065',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Scolippi',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30312',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Secco',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '71745',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Sheila E',\n",
       "   'user_id': '19295',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41056',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Shigekiyo “Shigechi” Yangu',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '58456',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Shinobu Kawajiri',\n",
       "   'user_id': '13175',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '155742',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Shizuka Joestar',\n",
       "   'user_id': '15697',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '138485',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Slow Dancer',\n",
       "   'user_id': '65008',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41658',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Smokey Brown',\n",
       "   'user_id': '8964',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '98844',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Sorbet',\n",
       "   'user_id': '22348',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41069',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Sports Maxx',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41062',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Squalo',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41033',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Steely Dan',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '54534',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Steven Steel',\n",
       "   'user_id': '9646',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '84095',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Straizo',\n",
       "   'user_id': '18747',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '178131',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Sugar Mountain',\n",
       "   'user_id': '15697',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '34143',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Suzi Q',\n",
       "   'user_id': '12060',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '151334',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Takuma Hasumi',\n",
       "   'user_id': '34628',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '40345',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Tamaki Damo',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41057',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Tamami Kobayashi',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '131067',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Tarkus',\n",
       "   'user_id': '15697',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41044',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Telence T. D’Arby',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41049',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Terunosuke Miyamoto',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41805',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Thunder McQueen',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41063',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Tiziano',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '60827',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Tomoko Higashikata',\n",
       "   'user_id': '11620',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41051',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Tonio Trussardi',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '128871',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Tonpetty',\n",
       "   'user_id': '22348',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '121360',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Tooru',\n",
       "   'user_id': '18635',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41055',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Toshikazu Hazamada',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '59676',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Toyohiro Kanedaichi',\n",
       "   'user_id': '10705',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '40347',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Tsurugi Higashikata',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41066',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Ungalo',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '62573',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Urban Guerilla',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '175799',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Urmd Abdul',\n",
       "   'user_id': '15697',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '138482',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Valkyrie',\n",
       "   'user_id': '65008',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41029',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Vanilla Ice',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '71744',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Vittorio Cataldi',\n",
       "   'user_id': '19295',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41806',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Viviano Westwood',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '71743',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Vladimir Kocaqi',\n",
       "   'user_id': '19295',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '19085',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Wamuu',\n",
       "   'user_id': '6642',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '28142',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Weather Report',\n",
       "   'user_id': '9480',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '30308',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Wekapipo',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '62574',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Wu Tomoki',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '120445',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Yoma Hashimoto',\n",
       "   'user_id': '3278',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41060',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Yoshihiro Kira',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '46221',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Yoshikage Kira (Part 8)',\n",
       "   'user_id': '11203',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '40346',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Yotsuyu Yagiyama',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41050',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'Yuya Fungami',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'},\n",
       "  {'id': '41046',\n",
       "   'sub_cat_id': '638',\n",
       "   'mbti_profile': 'ZZ',\n",
       "   'user_id': '9581',\n",
       "   'subcategory': 'JoJo no Kimyou na Bouken',\n",
       "   'group_name': 'Supernatural'}],\n",
       " 'personality_types': {'1': ['ISTJ',\n",
       "   'ESTJ',\n",
       "   'ISFJ',\n",
       "   'ESFJ',\n",
       "   'ESFP',\n",
       "   'ISFP',\n",
       "   'ESTP',\n",
       "   'ISTP',\n",
       "   'INFJ',\n",
       "   'ENFJ',\n",
       "   'INFP',\n",
       "   'ENFP',\n",
       "   'INTP',\n",
       "   'ENTP',\n",
       "   'INTJ',\n",
       "   'ENTJ'],\n",
       "  '2': ['1w2',\n",
       "   '1w9',\n",
       "   '2w1',\n",
       "   '2w3',\n",
       "   '3w2',\n",
       "   '3w4',\n",
       "   '4w3',\n",
       "   '4w5',\n",
       "   '5w4',\n",
       "   '5w6',\n",
       "   '6w5',\n",
       "   '6w7',\n",
       "   '7w6',\n",
       "   '7w8',\n",
       "   '8w7',\n",
       "   '8w9',\n",
       "   '9w1',\n",
       "   '9w8'],\n",
       "  '3': ['ESE',\n",
       "   'SEI',\n",
       "   'ILE',\n",
       "   'LII',\n",
       "   'EIE',\n",
       "   'IEI',\n",
       "   'SLE',\n",
       "   'LSI',\n",
       "   'SEE',\n",
       "   'ESI',\n",
       "   'LIE',\n",
       "   'ILI',\n",
       "   'IEE',\n",
       "   'EII',\n",
       "   'LSE',\n",
       "   'SLI'],\n",
       "  '4': ['Lawful Good',\n",
       "   'Neutral Good',\n",
       "   'Chaotic Good',\n",
       "   'Lawful Neutral',\n",
       "   'True Neutral',\n",
       "   'Chaotic Neutral',\n",
       "   'Lawful Evil',\n",
       "   'Neutral Evil',\n",
       "   'Chaotic Evil'],\n",
       "  '5': ['so/sp', 'so/sx', 'sp/so', 'sp/sx', 'sx/so', 'sx/sp'],\n",
       "  '6': ['125',\n",
       "   '126',\n",
       "   '127',\n",
       "   '135',\n",
       "   '136',\n",
       "   '137',\n",
       "   '145',\n",
       "   '146',\n",
       "   '147',\n",
       "   '152',\n",
       "   '153',\n",
       "   '154',\n",
       "   '162',\n",
       "   '163',\n",
       "   '164',\n",
       "   '172',\n",
       "   '173',\n",
       "   '174',\n",
       "   '215',\n",
       "   '216',\n",
       "   '217',\n",
       "   '251',\n",
       "   '258',\n",
       "   '259',\n",
       "   '261',\n",
       "   '268',\n",
       "   '269',\n",
       "   '271',\n",
       "   '278',\n",
       "   '279',\n",
       "   '285',\n",
       "   '286',\n",
       "   '287',\n",
       "   '295',\n",
       "   '296',\n",
       "   '297',\n",
       "   '315',\n",
       "   '316',\n",
       "   '317',\n",
       "   '351',\n",
       "   '358',\n",
       "   '359',\n",
       "   '361',\n",
       "   '368',\n",
       "   '369',\n",
       "   '371',\n",
       "   '378',\n",
       "   '379',\n",
       "   '385',\n",
       "   '386',\n",
       "   '387',\n",
       "   '395',\n",
       "   '396',\n",
       "   '397',\n",
       "   '415',\n",
       "   '416',\n",
       "   '417',\n",
       "   '451',\n",
       "   '458',\n",
       "   '459',\n",
       "   '461',\n",
       "   '468',\n",
       "   '469',\n",
       "   '471',\n",
       "   '478',\n",
       "   '479',\n",
       "   '485',\n",
       "   '486',\n",
       "   '487',\n",
       "   '495',\n",
       "   '496',\n",
       "   '497',\n",
       "   '512',\n",
       "   '513',\n",
       "   '514',\n",
       "   '521',\n",
       "   '528',\n",
       "   '529',\n",
       "   '531',\n",
       "   '538',\n",
       "   '539',\n",
       "   '541',\n",
       "   '548',\n",
       "   '549',\n",
       "   '582',\n",
       "   '583',\n",
       "   '584',\n",
       "   '592',\n",
       "   '593',\n",
       "   '594',\n",
       "   '612',\n",
       "   '613',\n",
       "   '614',\n",
       "   '621',\n",
       "   '628',\n",
       "   '629',\n",
       "   '631',\n",
       "   '638',\n",
       "   '639',\n",
       "   '641',\n",
       "   '648',\n",
       "   '649',\n",
       "   '682',\n",
       "   '683',\n",
       "   '684',\n",
       "   '692',\n",
       "   '693',\n",
       "   '694',\n",
       "   '712',\n",
       "   '713',\n",
       "   '714',\n",
       "   '721',\n",
       "   '728',\n",
       "   '729',\n",
       "   '731',\n",
       "   '738',\n",
       "   '739',\n",
       "   '741',\n",
       "   '748',\n",
       "   '749',\n",
       "   '782',\n",
       "   '783',\n",
       "   '784',\n",
       "   '792',\n",
       "   '793',\n",
       "   '794',\n",
       "   '825',\n",
       "   '826',\n",
       "   '827',\n",
       "   '835',\n",
       "   '836',\n",
       "   '837',\n",
       "   '845',\n",
       "   '846',\n",
       "   '847',\n",
       "   '852',\n",
       "   '853',\n",
       "   '854',\n",
       "   '862',\n",
       "   '863',\n",
       "   '864',\n",
       "   '872',\n",
       "   '873',\n",
       "   '874',\n",
       "   '925',\n",
       "   '926',\n",
       "   '927',\n",
       "   '935',\n",
       "   '936',\n",
       "   '937',\n",
       "   '945',\n",
       "   '946',\n",
       "   '947',\n",
       "   '952',\n",
       "   '953',\n",
       "   '954',\n",
       "   '962',\n",
       "   '963',\n",
       "   '964',\n",
       "   '972',\n",
       "   '973',\n",
       "   '974'],\n",
       "  '7': ['Choleric [Dominant]',\n",
       "   'Melancholic [Dominant]',\n",
       "   'Phlegmatic [Dominant]',\n",
       "   'Sanguine [Dominant]',\n",
       "   'Choleric-Melancholic',\n",
       "   'Choleric-Phlegmatic',\n",
       "   'Choleric-Sanguine',\n",
       "   'Melancholic-Choleric',\n",
       "   'Melancholic-Phlegmatic',\n",
       "   'Melancholic-Sanguine',\n",
       "   'Phlegmatic-Choleric',\n",
       "   'Phlegmatic-Melancholic',\n",
       "   'Phlegmatic-Sanguine',\n",
       "   'Sanguine-Choleric',\n",
       "   'Sanguine-Melancholic',\n",
       "   'Sanguine-Phlegmatic']},\n",
       " 'breakdown_systems': {'1': [{'myValue': 'INTP', 'theCount': '183'},\n",
       "   {'myValue': 'INTJ', 'theCount': '6'},\n",
       "   {'myValue': 'INFP', 'theCount': '5'},\n",
       "   {'myValue': 'ISFJ', 'theCount': '5'},\n",
       "   {'myValue': 'ISFP', 'theCount': '4'},\n",
       "   {'myValue': 'INFJ', 'theCount': '3'},\n",
       "   {'myValue': 'ENTP', 'theCount': '1'},\n",
       "   {'myValue': 'ESFJ', 'theCount': '1'}],\n",
       "  '2': [{'myValue': '5w4', 'theCount': '93'},\n",
       "   {'myValue': '4w5', 'theCount': '4'},\n",
       "   {'myValue': '5w6', 'theCount': '3'},\n",
       "   {'myValue': '6w5', 'theCount': '3'},\n",
       "   {'myValue': '1w2', 'theCount': '1'},\n",
       "   {'myValue': '7w6', 'theCount': '1'}],\n",
       "  '5': [{'myValue': 'sp/sx', 'theCount': '11'},\n",
       "   {'myValue': 'sp/so', 'theCount': '7'},\n",
       "   {'myValue': 'so/sp', 'theCount': '2'},\n",
       "   {'myValue': 'so/sx', 'theCount': '1'}],\n",
       "  '6': [{'myValue': '594', 'theCount': '13'},\n",
       "   {'myValue': '317', 'theCount': '1'}],\n",
       "  '3': [{'myValue': 'ILI', 'theCount': '14'},\n",
       "   {'myValue': 'LII', 'theCount': '1'}],\n",
       "  '4': [{'myValue': 'Neutral Good', 'theCount': '31'},\n",
       "   {'myValue': 'Lawful Neutral', 'theCount': '2'}],\n",
       "  '7': [{'myValue': 'Phlegmatic [Dominant]', 'theCount': '11'},\n",
       "   {'myValue': 'Melancholic [Dominant]', 'theCount': '1'},\n",
       "   {'myValue': 'Melancholic-Sanguine', 'theCount': '1'},\n",
       "   {'myValue': 'Phlegmatic-Melancholic', 'theCount': '1'},\n",
       "   {'myValue': 'Sanguine-Choleric', 'theCount': '1'}]},\n",
       " 'systems': [{'id': '1',\n",
       "   'system_name': 'Four Letter',\n",
       "   'hex_color': '#888888',\n",
       "   'personality_type': 'XXXX',\n",
       "   'vote_id': '0'},\n",
       "  {'id': '2',\n",
       "   'system_name': 'Enneagram',\n",
       "   'hex_color': '#006775',\n",
       "   'personality_type': 'XXXX',\n",
       "   'vote_id': '0'},\n",
       "  {'id': '5',\n",
       "   'system_name': 'Instinctual Variant',\n",
       "   'hex_color': '#006775',\n",
       "   'personality_type': 'XXXX',\n",
       "   'vote_id': '0'},\n",
       "  {'id': '6',\n",
       "   'system_name': 'Tritype',\n",
       "   'hex_color': '#006775',\n",
       "   'personality_type': 'XXXX',\n",
       "   'vote_id': '0'},\n",
       "  {'id': '3',\n",
       "   'system_name': 'Socionics',\n",
       "   'hex_color': '#888888',\n",
       "   'personality_type': 'XXXX',\n",
       "   'vote_id': '0'},\n",
       "  {'id': '4',\n",
       "   'system_name': 'Alignment',\n",
       "   'hex_color': '#888888',\n",
       "   'personality_type': 'XXXX',\n",
       "   'vote_id': '0'},\n",
       "  {'id': '7',\n",
       "   'system_name': 'Temperaments',\n",
       "   'hex_color': '#888888',\n",
       "   'personality_type': 'XXXX',\n",
       "   'vote_id': '0'}],\n",
       " 'breakdown': [{'myValue': 'INTP', 'theCount': '183'},\n",
       "  {'myValue': 'INTJ', 'theCount': '6'},\n",
       "  {'myValue': 'INFP', 'theCount': '5'},\n",
       "  {'myValue': 'ISFJ', 'theCount': '5'},\n",
       "  {'myValue': 'ISFP', 'theCount': '4'},\n",
       "  {'myValue': 'INFJ', 'theCount': '3'},\n",
       "  {'myValue': 'ENTP', 'theCount': '1'},\n",
       "  {'myValue': 'ESFJ', 'theCount': '1'}],\n",
       " 'stats': [{'type': 'I', 'percentage': '99%'},\n",
       "  {'type': 'N', 'percentage': '95%'},\n",
       "  {'type': 'T', 'percentage': '91%'},\n",
       "  {'type': 'P', 'percentage': '93%'}],\n",
       " 'functions': ['Ti', 'Ne', 'Si', 'Fe', 'INTP']}"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "req = db.get_profile(5209)\n",
    "req.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python [conda env:tensorflow] *",
   "language": "python",
   "name": "conda-env-tensorflow-py"
  },
  "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.7.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}