scrapping_images.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Pre-procesamiento"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Importación de conjuntos de datos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import glob\n",
    "import numpy as np\n",
    "from sklearn.preprocessing import LabelEncoder\n",
    "from pandas import Series\n",
    "import math"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'C:\\\\Users\\\\ALONSO'"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import os\n",
    "os.getcwd()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "os.chdir('D:/TTT/DB/2019/')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " El volumen de la unidad D es Datos\n",
      " El n£mero de serie del volumen es: 4A9A-69E5\n",
      "\n",
      " Directorio de D:\\TTT\\DB\\2019\n",
      "\n",
      "22/07/2019  22:56    <DIR>          .\n",
      "22/07/2019  22:56    <DIR>          ..\n",
      "22/07/2019  22:58    <DIR>          2019-06-13\n",
      "30/07/2019  23:01    <DIR>          2019-07-18\n",
      "               0 archivos              0 bytes\n",
      "               4 dirs  156,108,099,584 bytes libres\n"
     ]
    }
   ],
   "source": [
    "ls"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "os.chdir('D:/TTT/DB/2019/201908')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Las siguientes líneas son para combinar todos los archivos .csv dentro de la carpeta\n",
    "#extension = '.csv'\n",
    "#all_filenames = [i for i in glob.glob('*'.format(extension))]\n",
    "\n",
    "#combine all files in the list\n",
    "#data_combinada_20190718 = pd.concat([pd.read_csv(f) for f in all_filenames ])\n",
    "#export to csv\n",
    "#data_combinada_20190718.to_csv( \"data_combinada_20190718.csv\", index=False, encoding='utf-8-sig')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "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",
       "      <th>backers_count</th>\n",
       "      <th>blurb</th>\n",
       "      <th>category</th>\n",
       "      <th>converted_pledged_amount</th>\n",
       "      <th>country</th>\n",
       "      <th>created_at</th>\n",
       "      <th>creator</th>\n",
       "      <th>currency</th>\n",
       "      <th>currency_symbol</th>\n",
       "      <th>currency_trailing_code</th>\n",
       "      <th>...</th>\n",
       "      <th>slug</th>\n",
       "      <th>source_url</th>\n",
       "      <th>spotlight</th>\n",
       "      <th>staff_pick</th>\n",
       "      <th>state</th>\n",
       "      <th>state_changed_at</th>\n",
       "      <th>static_usd_rate</th>\n",
       "      <th>urls</th>\n",
       "      <th>usd_pledged</th>\n",
       "      <th>usd_type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>48</td>\n",
       "      <td>Citizen Carpentry is building community around...</td>\n",
       "      <td>{\"id\":356,\"name\":\"Woodworking\",\"slug\":\"crafts/...</td>\n",
       "      <td>5528</td>\n",
       "      <td>US</td>\n",
       "      <td>1479389359</td>\n",
       "      <td>{\"id\":2044486203,\"name\":\"Marcis Curtis\",\"is_re...</td>\n",
       "      <td>USD</td>\n",
       "      <td>$</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>citizen-carpentry-community-workshop-and-tool-...</td>\n",
       "      <td>https://www.kickstarter.com/discover/categorie...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>canceled</td>\n",
       "      <td>1485878182</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>{\"web\":{\"project\":\"https://www.kickstarter.com...</td>\n",
       "      <td>5528.0</td>\n",
       "      <td>domestic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>El buscador sostenible para gente responsable</td>\n",
       "      <td>{\"id\":260,\"name\":\"Interactive Design\",\"slug\":\"...</td>\n",
       "      <td>0</td>\n",
       "      <td>ES</td>\n",
       "      <td>1469258234</td>\n",
       "      <td>{\"id\":1498616534,\"name\":\"Raül Gómez Freixa\",\"i...</td>\n",
       "      <td>EUR</td>\n",
       "      <td>€</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>simbin</td>\n",
       "      <td>https://www.kickstarter.com/discover/categorie...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>failed</td>\n",
       "      <td>1473524887</td>\n",
       "      <td>1.098901</td>\n",
       "      <td>{\"web\":{\"project\":\"https://www.kickstarter.com...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>domestic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>Would love to show everyone the beauty Eastern...</td>\n",
       "      <td>{\"id\":277,\"name\":\"Nature\",\"slug\":\"photography/...</td>\n",
       "      <td>0</td>\n",
       "      <td>US</td>\n",
       "      <td>1427808788</td>\n",
       "      <td>{\"id\":2019826059,\"name\":\"Carmen\",\"is_registere...</td>\n",
       "      <td>USD</td>\n",
       "      <td>$</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>photographing-places-i-love-mountains-of-easte...</td>\n",
       "      <td>https://www.kickstarter.com/discover/categorie...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>canceled</td>\n",
       "      <td>1429360155</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>{\"web\":{\"project\":\"https://www.kickstarter.com...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>domestic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>44</td>\n",
       "      <td>A surrealist's guide to navigating the dark de...</td>\n",
       "      <td>{\"id\":42,\"name\":\"Pop\",\"slug\":\"music/pop\",\"posi...</td>\n",
       "      <td>1782</td>\n",
       "      <td>US</td>\n",
       "      <td>1457626762</td>\n",
       "      <td>{\"id\":184955320,\"name\":\"T.S. Woodward\",\"is_reg...</td>\n",
       "      <td>USD</td>\n",
       "      <td>$</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>how-to-breathe-underwater-in-the-black-box-deb...</td>\n",
       "      <td>https://www.kickstarter.com/discover/categorie...</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>successful</td>\n",
       "      <td>1467648766</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>{\"web\":{\"project\":\"https://www.kickstarter.com...</td>\n",
       "      <td>1782.0</td>\n",
       "      <td>domestic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3</td>\n",
       "      <td>Continue to develop a user friendly one-person...</td>\n",
       "      <td>{\"id\":336,\"name\":\"Flight\",\"slug\":\"technology/f...</td>\n",
       "      <td>100</td>\n",
       "      <td>US</td>\n",
       "      <td>1396014888</td>\n",
       "      <td>{\"id\":760226815,\"name\":\"Chris Thomas\",\"is_regi...</td>\n",
       "      <td>USD</td>\n",
       "      <td>$</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>backpackable-high-resolution-uav-habitat-mappi...</td>\n",
       "      <td>https://www.kickstarter.com/discover/categorie...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>failed</td>\n",
       "      <td>1399697848</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>{\"web\":{\"project\":\"https://www.kickstarter.com...</td>\n",
       "      <td>100.0</td>\n",
       "      <td>domestic</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 37 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   backers_count                                              blurb  \\\n",
       "0             48  Citizen Carpentry is building community around...   \n",
       "1              0      El buscador sostenible para gente responsable   \n",
       "2              0  Would love to show everyone the beauty Eastern...   \n",
       "3             44  A surrealist's guide to navigating the dark de...   \n",
       "4              3  Continue to develop a user friendly one-person...   \n",
       "\n",
       "                                            category  \\\n",
       "0  {\"id\":356,\"name\":\"Woodworking\",\"slug\":\"crafts/...   \n",
       "1  {\"id\":260,\"name\":\"Interactive Design\",\"slug\":\"...   \n",
       "2  {\"id\":277,\"name\":\"Nature\",\"slug\":\"photography/...   \n",
       "3  {\"id\":42,\"name\":\"Pop\",\"slug\":\"music/pop\",\"posi...   \n",
       "4  {\"id\":336,\"name\":\"Flight\",\"slug\":\"technology/f...   \n",
       "\n",
       "   converted_pledged_amount country  created_at  \\\n",
       "0                      5528      US  1479389359   \n",
       "1                         0      ES  1469258234   \n",
       "2                         0      US  1427808788   \n",
       "3                      1782      US  1457626762   \n",
       "4                       100      US  1396014888   \n",
       "\n",
       "                                             creator currency currency_symbol  \\\n",
       "0  {\"id\":2044486203,\"name\":\"Marcis Curtis\",\"is_re...      USD               $   \n",
       "1  {\"id\":1498616534,\"name\":\"Raül Gómez Freixa\",\"i...      EUR               €   \n",
       "2  {\"id\":2019826059,\"name\":\"Carmen\",\"is_registere...      USD               $   \n",
       "3  {\"id\":184955320,\"name\":\"T.S. Woodward\",\"is_reg...      USD               $   \n",
       "4  {\"id\":760226815,\"name\":\"Chris Thomas\",\"is_regi...      USD               $   \n",
       "\n",
       "   currency_trailing_code  ...  \\\n",
       "0                    True  ...   \n",
       "1                   False  ...   \n",
       "2                    True  ...   \n",
       "3                    True  ...   \n",
       "4                    True  ...   \n",
       "\n",
       "                                                slug  \\\n",
       "0  citizen-carpentry-community-workshop-and-tool-...   \n",
       "1                                             simbin   \n",
       "2  photographing-places-i-love-mountains-of-easte...   \n",
       "3  how-to-breathe-underwater-in-the-black-box-deb...   \n",
       "4  backpackable-high-resolution-uav-habitat-mappi...   \n",
       "\n",
       "                                          source_url  spotlight staff_pick  \\\n",
       "0  https://www.kickstarter.com/discover/categorie...      False      False   \n",
       "1  https://www.kickstarter.com/discover/categorie...      False      False   \n",
       "2  https://www.kickstarter.com/discover/categorie...      False      False   \n",
       "3  https://www.kickstarter.com/discover/categorie...       True      False   \n",
       "4  https://www.kickstarter.com/discover/categorie...      False      False   \n",
       "\n",
       "        state  state_changed_at  static_usd_rate  \\\n",
       "0    canceled        1485878182         1.000000   \n",
       "1      failed        1473524887         1.098901   \n",
       "2    canceled        1429360155         1.000000   \n",
       "3  successful        1467648766         1.000000   \n",
       "4      failed        1399697848         1.000000   \n",
       "\n",
       "                                                urls  usd_pledged  usd_type  \n",
       "0  {\"web\":{\"project\":\"https://www.kickstarter.com...       5528.0  domestic  \n",
       "1  {\"web\":{\"project\":\"https://www.kickstarter.com...          0.0  domestic  \n",
       "2  {\"web\":{\"project\":\"https://www.kickstarter.com...          0.0  domestic  \n",
       "3  {\"web\":{\"project\":\"https://www.kickstarter.com...       1782.0  domestic  \n",
       "4  {\"web\":{\"project\":\"https://www.kickstarter.com...        100.0  domestic  \n",
       "\n",
       "[5 rows x 37 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_combinada_201907 = pd.read_csv(\"data_combinada_201907.csv\",sep = ',')\n",
    "data_combinada_201907.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(212378, 37)"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_combinada_201907.shape   ##Originalmente habían 212,378 registros de todos los proyectos en Kickstarter"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['backers_count', 'blurb', 'category', 'converted_pledged_amount',\n",
       "       'country', 'created_at', 'creator', 'currency', 'currency_symbol',\n",
       "       'currency_trailing_code', 'current_currency', 'deadline',\n",
       "       'disable_communication', 'friends', 'fx_rate', 'goal', 'id',\n",
       "       'is_backing', 'is_starrable', 'is_starred', 'launched_at', 'location',\n",
       "       'name', 'permissions', 'photo', 'pledged', 'profile', 'slug',\n",
       "       'source_url', 'spotlight', 'staff_pick', 'state', 'state_changed_at',\n",
       "       'static_usd_rate', 'urls', 'usd_pledged', 'usd_type'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_combinada_201907.columns"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Filtrando datasets"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{\"id\":28,\"name\":\"Product Design\",\"slug\":\"design/product design\",\"position\":5,\"parent_id\":7,\"color\":2577151,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/design/product%20design\"}}}                       4387\n",
       "{\"id\":34,\"name\":\"Tabletop Games\",\"slug\":\"games/tabletop games\",\"position\":6,\"parent_id\":12,\"color\":51627,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/games/tabletop%20games\"}}}                          4066\n",
       "{\"id\":262,\"name\":\"Accessories\",\"slug\":\"fashion/accessories\",\"position\":1,\"parent_id\":9,\"color\":16752598,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/fashion/accessories\"}}}                              3633\n",
       "{\"id\":250,\"name\":\"Comic Books\",\"slug\":\"comics/comic books\",\"position\":2,\"parent_id\":3,\"color\":16776056,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/comics/comic%20books\"}}}                              3479\n",
       "{\"id\":22,\"name\":\"Illustration\",\"slug\":\"art/illustration\",\"position\":4,\"parent_id\":1,\"color\":16760235,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/art/illustration\"}}}                                    3042\n",
       "{\"id\":252,\"name\":\"Graphic Novels\",\"slug\":\"comics/graphic novels\",\"position\":4,\"parent_id\":3,\"color\":16776056,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/comics/graphic%20novels\"}}}                     2998\n",
       "{\"id\":46,\"name\":\"Children's Books\",\"slug\":\"publishing/children's books\",\"position\":5,\"parent_id\":18,\"color\":14867664,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/publishing/children's%20books\"}}}       2980\n",
       "{\"id\":337,\"name\":\"Gadgets\",\"slug\":\"technology/gadgets\",\"position\":7,\"parent_id\":16,\"color\":6526716,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/technology/gadgets\"}}}                                    2936\n",
       "{\"id\":263,\"name\":\"Apparel\",\"slug\":\"fashion/apparel\",\"position\":2,\"parent_id\":9,\"color\":16752598,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/fashion/apparel\"}}}                                          2936\n",
       "{\"id\":30,\"name\":\"Documentary\",\"slug\":\"film & video/documentary\",\"position\":4,\"parent_id\":11,\"color\":16734574,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/film%20&%20video/documentary\"}}}                2907\n",
       "{\"id\":280,\"name\":\"Photobooks\",\"slug\":\"photography/photobooks\",\"position\":5,\"parent_id\":15,\"color\":58341,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/photography/photobooks\"}}}                           2845\n",
       "{\"id\":307,\"name\":\"Drinks\",\"slug\":\"food/drinks\",\"position\":4,\"parent_id\":10,\"color\":16725570,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/food/drinks\"}}}                                                  2841\n",
       "{\"id\":32,\"name\":\"Shorts\",\"slug\":\"film & video/shorts\",\"position\":16,\"parent_id\":11,\"color\":16734574,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/film%20&%20video/shorts\"}}}                              2821\n",
       "{\"id\":312,\"name\":\"Restaurants\",\"slug\":\"food/restaurants\",\"position\":9,\"parent_id\":10,\"color\":16725570,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/food/restaurants\"}}}                                   2733\n",
       "{\"id\":47,\"name\":\"Fiction\",\"slug\":\"publishing/fiction\",\"position\":7,\"parent_id\":18,\"color\":14867664,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/publishing/fiction\"}}}                                    2721\n",
       "{\"id\":35,\"name\":\"Video Games\",\"slug\":\"games/video games\",\"position\":7,\"parent_id\":12,\"color\":51627,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/games/video%20games\"}}}                                   2716\n",
       "{\"id\":48,\"name\":\"Nonfiction\",\"slug\":\"publishing/nonfiction\",\"position\":9,\"parent_id\":18,\"color\":14867664,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/publishing/nonfiction\"}}}                           2714\n",
       "{\"id\":37,\"name\":\"Country & Folk\",\"slug\":\"music/country & folk\",\"position\":5,\"parent_id\":14,\"color\":10878931,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/music/country%20&%20folk\"}}}                     2700\n",
       "{\"id\":45,\"name\":\"Art Books\",\"slug\":\"publishing/art books\",\"position\":3,\"parent_id\":18,\"color\":14867664,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/publishing/art%20books\"}}}                            2649\n",
       "{\"id\":273,\"name\":\"Playing Cards\",\"slug\":\"games/playing cards\",\"position\":4,\"parent_id\":12,\"color\":51627,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/games/playing%20cards\"}}}                            2645\n",
       "{\"id\":52,\"name\":\"Hardware\",\"slug\":\"technology/hardware\",\"position\":8,\"parent_id\":16,\"color\":6526716,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/technology/hardware\"}}}                                  2643\n",
       "{\"id\":332,\"name\":\"Apps\",\"slug\":\"technology/apps\",\"position\":2,\"parent_id\":16,\"color\":6526716,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/technology/apps\"}}}                                             2638\n",
       "{\"id\":293,\"name\":\"Drama\",\"slug\":\"film & video/drama\",\"position\":5,\"parent_id\":11,\"color\":16734574,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/film%20&%20video/drama\"}}}                                 2617\n",
       "{\"id\":43,\"name\":\"Rock\",\"slug\":\"music/rock\",\"position\":17,\"parent_id\":14,\"color\":10878931,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/music/rock\"}}}                                                      2592\n",
       "{\"id\":40,\"name\":\"Indie Rock\",\"slug\":\"music/indie rock\",\"position\":9,\"parent_id\":14,\"color\":10878931,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/music/indie%20rock\"}}}                                   2585\n",
       "{\"id\":292,\"name\":\"Comedy\",\"slug\":\"film & video/comedy\",\"position\":3,\"parent_id\":11,\"color\":16734574,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/film%20&%20video/comedy\"}}}                              2569\n",
       "{\"id\":54,\"name\":\"Mixed Media\",\"slug\":\"art/mixed media\",\"position\":6,\"parent_id\":1,\"color\":16760235,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/art/mixed%20media\"}}}                                     2544\n",
       "{\"id\":42,\"name\":\"Pop\",\"slug\":\"music/pop\",\"position\":14,\"parent_id\":14,\"color\":10878931,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/music/pop\"}}}                                                         2525\n",
       "{\"id\":36,\"name\":\"Classical Music\",\"slug\":\"music/classical music\",\"position\":3,\"parent_id\":14,\"color\":10878931,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/music/classical%20music\"}}}                    2522\n",
       "{\"id\":31,\"name\":\"Narrative Film\",\"slug\":\"film & video/narrative film\",\"position\":13,\"parent_id\":11,\"color\":16734574,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/film%20&%20video/narrative%20film\"}}}    2521\n",
       "                                                                                                                                                                                                                                       ... \n",
       "{\"id\":358,\"name\":\"Photo\",\"slug\":\"journalism/photo\",\"position\":2,\"parent_id\":13,\"color\":1228010,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/journalism/photo\"}}}                                           316\n",
       "{\"id\":18,\"name\":\"Publishing\",\"slug\":\"publishing\",\"position\":13,\"color\":14867664,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/publishing\"}}}                                                                311\n",
       "{\"id\":286,\"name\":\"Spaces\",\"slug\":\"theater/spaces\",\"position\":7,\"parent_id\":17,\"color\":16743775,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/theater/spaces\"}}}                                             308\n",
       "{\"id\":362,\"name\":\"Makerspaces\",\"slug\":\"technology/makerspaces\",\"position\":9,\"parent_id\":16,\"color\":6526716,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/technology/makerspaces\"}}}                         295\n",
       "{\"id\":11,\"name\":\"Film & Video\",\"slug\":\"film & video\",\"position\":7,\"color\":16734574,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/film%20&%20video\"}}}                                                       264\n",
       "{\"id\":290,\"name\":\"Video Art\",\"slug\":\"art/video art\",\"position\":12,\"parent_id\":1,\"color\":16760235,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/art/video%20art\"}}}                                          262\n",
       "{\"id\":300,\"name\":\"Romance\",\"slug\":\"film & video/romance\",\"position\":14,\"parent_id\":11,\"color\":16734574,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/film%20&%20video/romance\"}}}                           249\n",
       "{\"id\":7,\"name\":\"Design\",\"slug\":\"design\",\"position\":5,\"color\":2577151,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/design\"}}}                                                                               245\n",
       "{\"id\":257,\"name\":\"Workshops\",\"slug\":\"dance/workshops\",\"position\":4,\"parent_id\":6,\"color\":10917369,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/dance/workshops\"}}}                                         244\n",
       "{\"id\":344,\"name\":\"Crochet\",\"slug\":\"crafts/crochet\",\"position\":2,\"parent_id\":26,\"color\":16744876,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/crafts/crochet\"}}}                                            237\n",
       "{\"id\":304,\"name\":\"Bacon\",\"slug\":\"food/bacon\",\"position\":1,\"parent_id\":10,\"color\":16725570,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/food/bacon\"}}}                                                      231\n",
       "{\"id\":251,\"name\":\"Events\",\"slug\":\"comics/events\",\"position\":3,\"parent_id\":3,\"color\":16776056,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/comics/events\"}}}                                                227\n",
       "{\"id\":350,\"name\":\"Pottery\",\"slug\":\"crafts/pottery\",\"position\":8,\"parent_id\":26,\"color\":16744876,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/crafts/pottery\"}}}                                            223\n",
       "{\"id\":9,\"name\":\"Fashion\",\"slug\":\"fashion\",\"position\":6,\"color\":16752598,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/fashion\"}}}                                                                           200\n",
       "{\"id\":347,\"name\":\"Glass\",\"slug\":\"crafts/glass\",\"position\":5,\"parent_id\":26,\"color\":16744876,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/crafts/glass\"}}}                                                  199\n",
       "{\"id\":320,\"name\":\"Latin\",\"slug\":\"music/latin\",\"position\":12,\"parent_id\":14,\"color\":10878931,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/music/latin\"}}}                                                   192\n",
       "{\"id\":387,\"name\":\"Comedy\",\"slug\":\"publishing/comedy\",\"position\":6,\"parent_id\":18,\"color\":14867664,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/publishing/comedy\"}}}                                       191\n",
       "{\"id\":327,\"name\":\"Translations\",\"slug\":\"publishing/translations\",\"position\":13,\"parent_id\":18,\"color\":14867664,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/publishing/translations\"}}}                    190\n",
       "{\"id\":268,\"name\":\"Pet Fashion\",\"slug\":\"fashion/pet fashion\",\"position\":7,\"parent_id\":9,\"color\":16752598,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/fashion/pet%20fashion\"}}}                             179\n",
       "{\"id\":346,\"name\":\"Embroidery\",\"slug\":\"crafts/embroidery\",\"position\":4,\"parent_id\":26,\"color\":16744876,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/crafts/embroidery\"}}}                                   171\n",
       "{\"id\":261,\"name\":\"Typography\",\"slug\":\"design/typography\",\"position\":6,\"parent_id\":7,\"color\":2577151,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/design/typography\"}}}                                     147\n",
       "{\"id\":355,\"name\":\"Weaving\",\"slug\":\"crafts/weaving\",\"position\":13,\"parent_id\":26,\"color\":16744876,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/crafts/weaving\"}}}                                           143\n",
       "{\"id\":389,\"name\":\"Literary Spaces\",\"slug\":\"publishing/literary spaces\",\"position\":16,\"parent_id\":18,\"color\":14867664,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/publishing/literary%20spaces\"}}}         141\n",
       "{\"id\":255,\"name\":\"Residencies\",\"slug\":\"dance/residencies\",\"position\":2,\"parent_id\":6,\"color\":10917369,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/dance/residencies\"}}}                                   140\n",
       "{\"id\":352,\"name\":\"Quilts\",\"slug\":\"crafts/quilts\",\"position\":10,\"parent_id\":26,\"color\":16744876,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/crafts/quilts\"}}}                                              109\n",
       "{\"id\":12,\"name\":\"Games\",\"slug\":\"games\",\"position\":9,\"color\":51627,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/games\"}}}                                                                                    92\n",
       "{\"id\":386,\"name\":\"Comedy\",\"slug\":\"music/comedy\",\"position\":4,\"parent_id\":14,\"color\":10878931,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/music/comedy\"}}}                                                  77\n",
       "{\"id\":349,\"name\":\"Letterpress\",\"slug\":\"publishing/letterpress\",\"position\":7,\"parent_id\":18,\"color\":14867664,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/publishing/letterpress\"}}}                         68\n",
       "{\"id\":317,\"name\":\"Chiptune\",\"slug\":\"music/chiptune\",\"position\":2,\"parent_id\":14,\"color\":10878931,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/music/chiptune\"}}}                                            46\n",
       "{\"id\":354,\"name\":\"Taxidermy\",\"slug\":\"crafts/taxidermy\",\"position\":12,\"parent_id\":26,\"color\":16744876,\"urls\":{\"web\":{\"discover\":\"http://www.kickstarter.com/discover/categories/crafts/taxidermy\"}}}                                      18\n",
       "Name: category, Length: 169, dtype: int64"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_combinada_201907[\"category\"].value_counts()      ##Por ahora no ayuda mucho esta variable para filtrar"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "https://www.kickstarter.com/discover/categories/comics                          2400\n",
       "https://www.kickstarter.com/discover/categories/music/classical%20music         2400\n",
       "https://www.kickstarter.com/discover/categories/film%20&%20video/documentary    2400\n",
       "https://www.kickstarter.com/discover/categories/technology/hardware             2400\n",
       "https://www.kickstarter.com/discover/categories/music/rock                      2400\n",
       "https://www.kickstarter.com/discover/categories/film%20&%20video/animation      2400\n",
       "https://www.kickstarter.com/discover/categories/comics/graphic%20novels         2400\n",
       "https://www.kickstarter.com/discover/categories/crafts                          2400\n",
       "https://www.kickstarter.com/discover/categories/music/pop                       2400\n",
       "https://www.kickstarter.com/discover/categories/music/country%20&%20folk        2400\n",
       "https://www.kickstarter.com/discover/categories/art/mixed%20media               2400\n",
       "https://www.kickstarter.com/discover/categories/technology/web                  2400\n",
       "https://www.kickstarter.com/discover/categories/publishing                      2400\n",
       "https://www.kickstarter.com/discover/categories/music                           2400\n",
       "https://www.kickstarter.com/discover/categories/publishing/fiction              2400\n",
       "https://www.kickstarter.com/discover/categories/music/electronic%20music        2400\n",
       "https://www.kickstarter.com/discover/categories/photography                     2400\n",
       "https://www.kickstarter.com/discover/categories/games/playing%20cards           2400\n",
       "https://www.kickstarter.com/discover/categories/film%20&%20video/webseries      2400\n",
       "https://www.kickstarter.com/discover/categories/comics/comic%20books            2400\n",
       "https://www.kickstarter.com/discover/categories/film%20&%20video                2400\n",
       "https://www.kickstarter.com/discover/categories/film%20&%20video/comedy         2400\n",
       "https://www.kickstarter.com/discover/categories/art/illustration                2400\n",
       "https://www.kickstarter.com/discover/categories/art/painting                    2400\n",
       "https://www.kickstarter.com/discover/categories/design/product%20design         2400\n",
       "https://www.kickstarter.com/discover/categories/fashion/apparel                 2400\n",
       "https://www.kickstarter.com/discover/categories/music/indie%20rock              2400\n",
       "https://www.kickstarter.com/discover/categories/technology/apps                 2400\n",
       "https://www.kickstarter.com/discover/categories/technology/software             2400\n",
       "https://www.kickstarter.com/discover/categories/journalism                      2400\n",
       "                                                                                ... \n",
       "https://www.kickstarter.com/discover/categories/photography/animals              291\n",
       "https://www.kickstarter.com/discover/categories/crafts/printing                  289\n",
       "https://www.kickstarter.com/discover/categories/technology/makerspaces           278\n",
       "https://www.kickstarter.com/discover/categories/art/video%20art                  244\n",
       "https://www.kickstarter.com/discover/categories/dance/spaces                     240\n",
       "https://www.kickstarter.com/discover/categories/theater/spaces                   237\n",
       "https://www.kickstarter.com/discover/categories/film%20&%20video/romance         237\n",
       "https://www.kickstarter.com/discover/categories/food/bacon                       227\n",
       "https://www.kickstarter.com/discover/categories/crafts/knitting                  225\n",
       "https://www.kickstarter.com/discover/categories/journalism/photo                 223\n",
       "https://www.kickstarter.com/discover/categories/theater/comedy                   217\n",
       "https://www.kickstarter.com/discover/categories/comics/events                    205\n",
       "https://www.kickstarter.com/discover/categories/crafts/crochet                   197\n",
       "https://www.kickstarter.com/discover/categories/publishing/translations          185\n",
       "https://www.kickstarter.com/discover/categories/music/latin                      185\n",
       "https://www.kickstarter.com/discover/categories/dance/workshops                  184\n",
       "https://www.kickstarter.com/discover/categories/fashion/pet%20fashion            171\n",
       "https://www.kickstarter.com/discover/categories/publishing/comedy                162\n",
       "https://www.kickstarter.com/discover/categories/crafts/glass                     161\n",
       "https://www.kickstarter.com/discover/categories/crafts/pottery                   154\n",
       "https://www.kickstarter.com/discover/categories/crafts/embroidery                142\n",
       "https://www.kickstarter.com/discover/categories/design/typography                136\n",
       "https://www.kickstarter.com/discover/categories/crafts/weaving                   110\n",
       "https://www.kickstarter.com/discover/categories/publishing/literary%20spaces     109\n",
       "https://www.kickstarter.com/discover/categories/crafts/quilts                     91\n",
       "https://www.kickstarter.com/discover/categories/dance/residencies                 81\n",
       "https://www.kickstarter.com/discover/categories/publishing/letterpress            63\n",
       "https://www.kickstarter.com/discover/categories/music/comedy                      57\n",
       "https://www.kickstarter.com/discover/categories/music/chiptune                    43\n",
       "https://www.kickstarter.com/discover/categories/crafts/taxidermy                  13\n",
       "Name: source_url, Length: 169, dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_combinada_201907[\"source_url\"].value_counts()     ##Esta variable servirá para filtrar los proyectos tecnológicos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "solo_proy_tecnologicos = []\n",
    "\n",
    "for i in data_combinada_201907[\"source_url\"]:\n",
    "    if i.__contains__(\"https://www.kickstarter.com/discover/categories/technology\"):\n",
    "        solo_proy_tecnologicos.append(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "21398"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(solo_proy_tecnologicos)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/fabrication%20tools',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/makerspaces',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/makerspaces',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/makerspaces',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/makerspaces',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/sound',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/sound',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/sound',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/sound',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/sound',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/camera%20equipment',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/sound',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/fabrication%20tools',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/sound',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/fabrication%20tools',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/sound',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/sound',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/sound',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/sound',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/sound',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/camera%20equipment',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/sound',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/camera%20equipment',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/sound',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/fabrication%20tools',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/sound',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/sound',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/camera%20equipment',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/fabrication%20tools',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/camera%20equipment',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/sound',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/camera%20equipment',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/sound',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/camera%20equipment',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/sound',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/sound',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/camera%20equipment',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/sound',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/camera%20equipment',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/sound',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/sound',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/sound',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/sound',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/sound',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/fabrication%20tools',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/sound',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/sound',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/camera%20equipment',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/wearables',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/wearables',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/wearables',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/wearables',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/wearables',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/wearables',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/wearables',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/wearables',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/wearables',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/wearables',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/wearables',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/wearables',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/wearables',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/wearables',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/wearables',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/wearables',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/wearables',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/wearables',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/wearables',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/wearables',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/wearables',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/wearables',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/wearables',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/wearables',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/wearables',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/wearables',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/wearables',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/wearables',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/wearables',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/wearables',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/fabrication%20tools',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/fabrication%20tools',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/fabrication%20tools',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/makerspaces',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/makerspaces',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/makerspaces',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/makerspaces',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/makerspaces',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/makerspaces',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/makerspaces',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/makerspaces',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/makerspaces',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/makerspaces',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/makerspaces',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/makerspaces',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/makerspaces',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " ...]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "solo_proy_tecnologicos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['https://www.kickstarter.com/discover/categories/technology/web',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/apps',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/wearables',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/3d%20printing',\n",
       " 'https://www.kickstarter.com/discover/categories/technology',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/camera%20equipment',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/software',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/makerspaces',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/sound',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/fabrication%20tools',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/diy%20electronics',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/hardware',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/space%20exploration',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/robots',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/gadgets',\n",
       " 'https://www.kickstarter.com/discover/categories/technology/flight']"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cat_tecnologico = list(set(solo_proy_tecnologicos))       ##Acá podemos ver los registros únicos de la categoría tecnología\n",
    "cat_tecnologico                                           ##Funciona como un 'distinct'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "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",
       "      <th>backers_count</th>\n",
       "      <th>blurb</th>\n",
       "      <th>category</th>\n",
       "      <th>converted_pledged_amount</th>\n",
       "      <th>country</th>\n",
       "      <th>created_at</th>\n",
       "      <th>creator</th>\n",
       "      <th>currency</th>\n",
       "      <th>currency_symbol</th>\n",
       "      <th>currency_trailing_code</th>\n",
       "      <th>...</th>\n",
       "      <th>slug</th>\n",
       "      <th>source_url</th>\n",
       "      <th>spotlight</th>\n",
       "      <th>staff_pick</th>\n",
       "      <th>state</th>\n",
       "      <th>state_changed_at</th>\n",
       "      <th>static_usd_rate</th>\n",
       "      <th>urls</th>\n",
       "      <th>usd_pledged</th>\n",
       "      <th>usd_type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3</td>\n",
       "      <td>Continue to develop a user friendly one-person...</td>\n",
       "      <td>{\"id\":336,\"name\":\"Flight\",\"slug\":\"technology/f...</td>\n",
       "      <td>100</td>\n",
       "      <td>US</td>\n",
       "      <td>1396014888</td>\n",
       "      <td>{\"id\":760226815,\"name\":\"Chris Thomas\",\"is_regi...</td>\n",
       "      <td>USD</td>\n",
       "      <td>$</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>backpackable-high-resolution-uav-habitat-mappi...</td>\n",
       "      <td>https://www.kickstarter.com/discover/categorie...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>failed</td>\n",
       "      <td>1399697848</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>{\"web\":{\"project\":\"https://www.kickstarter.com...</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>domestic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0</td>\n",
       "      <td>Help fund my life long dream of becoming a Bus...</td>\n",
       "      <td>{\"id\":336,\"name\":\"Flight\",\"slug\":\"technology/f...</td>\n",
       "      <td>0</td>\n",
       "      <td>US</td>\n",
       "      <td>1421357956</td>\n",
       "      <td>{\"id\":291975465,\"name\":\"Rob Keith\",\"is_registe...</td>\n",
       "      <td>USD</td>\n",
       "      <td>$</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>bush-pilot</td>\n",
       "      <td>https://www.kickstarter.com/discover/categorie...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>suspended</td>\n",
       "      <td>1422045322</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>{\"web\":{\"project\":\"https://www.kickstarter.com...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>domestic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1045</td>\n",
       "      <td>We're starting a new era of open space access,...</td>\n",
       "      <td>{\"id\":340,\"name\":\"Space Exploration\",\"slug\":\"t...</td>\n",
       "      <td>121890</td>\n",
       "      <td>GB</td>\n",
       "      <td>1429961560</td>\n",
       "      <td>{\"id\":1674077282,\"name\":\"Moonspike Limited\",\"s...</td>\n",
       "      <td>GBP</td>\n",
       "      <td>£</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>moonspike-the-worlds-first-crowdfunded-moon-ro...</td>\n",
       "      <td>https://www.kickstarter.com/discover/categorie...</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>failed</td>\n",
       "      <td>1446415216</td>\n",
       "      <td>1.515586</td>\n",
       "      <td>{\"web\":{\"project\":\"https://www.kickstarter.com...</td>\n",
       "      <td>119674.800519</td>\n",
       "      <td>domestic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>62</td>\n",
       "      <td>We have designed an antimatter thruster capabl...</td>\n",
       "      <td>{\"id\":340,\"name\":\"Space Exploration\",\"slug\":\"t...</td>\n",
       "      <td>2280</td>\n",
       "      <td>US</td>\n",
       "      <td>1478990568</td>\n",
       "      <td>{\"id\":2114765394,\"name\":\"Gerald Jackson\",\"is_r...</td>\n",
       "      <td>USD</td>\n",
       "      <td>$</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>antimatter-fuel-production</td>\n",
       "      <td>https://www.kickstarter.com/discover/categorie...</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>successful</td>\n",
       "      <td>1480658968</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>{\"web\":{\"project\":\"https://www.kickstarter.com...</td>\n",
       "      <td>2280.000000</td>\n",
       "      <td>domestic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>5</td>\n",
       "      <td>A UAV for Humanitarian Aid and Environmental R...</td>\n",
       "      <td>{\"id\":336,\"name\":\"Flight\",\"slug\":\"technology/f...</td>\n",
       "      <td>93</td>\n",
       "      <td>US</td>\n",
       "      <td>1398022759</td>\n",
       "      <td>{\"id\":215756405,\"name\":\"Patrick W. Coleman\",\"i...</td>\n",
       "      <td>USD</td>\n",
       "      <td>$</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>uav-for-humanitarian-aid-and-environmental-res...</td>\n",
       "      <td>https://www.kickstarter.com/discover/categorie...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>failed</td>\n",
       "      <td>1426227924</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>{\"web\":{\"project\":\"https://www.kickstarter.com...</td>\n",
       "      <td>93.000000</td>\n",
       "      <td>domestic</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 37 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    backers_count                                              blurb  \\\n",
       "4               3  Continue to develop a user friendly one-person...   \n",
       "14              0  Help fund my life long dream of becoming a Bus...   \n",
       "22           1045  We're starting a new era of open space access,...   \n",
       "28             62  We have designed an antimatter thruster capabl...   \n",
       "35              5  A UAV for Humanitarian Aid and Environmental R...   \n",
       "\n",
       "                                             category  \\\n",
       "4   {\"id\":336,\"name\":\"Flight\",\"slug\":\"technology/f...   \n",
       "14  {\"id\":336,\"name\":\"Flight\",\"slug\":\"technology/f...   \n",
       "22  {\"id\":340,\"name\":\"Space Exploration\",\"slug\":\"t...   \n",
       "28  {\"id\":340,\"name\":\"Space Exploration\",\"slug\":\"t...   \n",
       "35  {\"id\":336,\"name\":\"Flight\",\"slug\":\"technology/f...   \n",
       "\n",
       "    converted_pledged_amount country  created_at  \\\n",
       "4                        100      US  1396014888   \n",
       "14                         0      US  1421357956   \n",
       "22                    121890      GB  1429961560   \n",
       "28                      2280      US  1478990568   \n",
       "35                        93      US  1398022759   \n",
       "\n",
       "                                              creator currency  \\\n",
       "4   {\"id\":760226815,\"name\":\"Chris Thomas\",\"is_regi...      USD   \n",
       "14  {\"id\":291975465,\"name\":\"Rob Keith\",\"is_registe...      USD   \n",
       "22  {\"id\":1674077282,\"name\":\"Moonspike Limited\",\"s...      GBP   \n",
       "28  {\"id\":2114765394,\"name\":\"Gerald Jackson\",\"is_r...      USD   \n",
       "35  {\"id\":215756405,\"name\":\"Patrick W. Coleman\",\"i...      USD   \n",
       "\n",
       "   currency_symbol  currency_trailing_code  ...  \\\n",
       "4                $                    True  ...   \n",
       "14               $                    True  ...   \n",
       "22               £                   False  ...   \n",
       "28               $                    True  ...   \n",
       "35               $                    True  ...   \n",
       "\n",
       "                                                 slug  \\\n",
       "4   backpackable-high-resolution-uav-habitat-mappi...   \n",
       "14                                         bush-pilot   \n",
       "22  moonspike-the-worlds-first-crowdfunded-moon-ro...   \n",
       "28                         antimatter-fuel-production   \n",
       "35  uav-for-humanitarian-aid-and-environmental-res...   \n",
       "\n",
       "                                           source_url  spotlight staff_pick  \\\n",
       "4   https://www.kickstarter.com/discover/categorie...      False      False   \n",
       "14  https://www.kickstarter.com/discover/categorie...      False      False   \n",
       "22  https://www.kickstarter.com/discover/categorie...      False       True   \n",
       "28  https://www.kickstarter.com/discover/categorie...       True      False   \n",
       "35  https://www.kickstarter.com/discover/categorie...      False      False   \n",
       "\n",
       "         state  state_changed_at  static_usd_rate  \\\n",
       "4       failed        1399697848         1.000000   \n",
       "14   suspended        1422045322         1.000000   \n",
       "22      failed        1446415216         1.515586   \n",
       "28  successful        1480658968         1.000000   \n",
       "35      failed        1426227924         1.000000   \n",
       "\n",
       "                                                 urls    usd_pledged  usd_type  \n",
       "4   {\"web\":{\"project\":\"https://www.kickstarter.com...     100.000000  domestic  \n",
       "14  {\"web\":{\"project\":\"https://www.kickstarter.com...       0.000000  domestic  \n",
       "22  {\"web\":{\"project\":\"https://www.kickstarter.com...  119674.800519  domestic  \n",
       "28  {\"web\":{\"project\":\"https://www.kickstarter.com...    2280.000000  domestic  \n",
       "35  {\"web\":{\"project\":\"https://www.kickstarter.com...      93.000000  domestic  \n",
       "\n",
       "[5 rows x 37 columns]"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_201907_filtrada = data_combinada_201907[data_combinada_201907['source_url'].isin (cat_tecnologico)]\n",
    "df_201907_filtrada.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(21398, 37)"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_201907_filtrada.shape                    ##Al final solo queda aproximadamente el 10%"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": [
    "#exporta a csv (pesa el 10% ahora, es decir, 110 MB aprox)\n",
    "df_201907_filtrada.to_csv( \"df_201907_filtrada.csv\", index=False, encoding='utf-8-sig')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "--> Repetir el mismo proceso para el resto de dataframes y borrar los anteriores .csv para ahorrar espacio.<br>\n",
    "--> Fuente del último paso del filtrado: https://codeday.me/es/qa/20181211/6697.html<br>\n",
    "--> Cambiar código a partir de la siguiente línea."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "os.chdir('D:/TTT/DB/2015/201510')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "extension = '.csv'\n",
    "all_filenames = [i for i in glob.glob('*'.format(extension))]\n",
    "\n",
    "#combine all files in the list\n",
    "data_combinada_201908 = pd.concat([pd.read_csv(f) for f in all_filenames ])\n",
    "#export to csv\n",
    "data_combinada_201908.to_csv( \"data_combinada_201908.csv\", index=False, encoding='utf-8-sig')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['backers_count', 'blurb', 'category', 'converted_pledged_amount',\n",
       "       'country', 'created_at', 'creator', 'currency', 'currency_symbol',\n",
       "       'currency_trailing_code', 'current_currency', 'deadline',\n",
       "       'disable_communication', 'friends', 'fx_rate', 'goal', 'id',\n",
       "       'is_backing', 'is_starrable', 'is_starred', 'launched_at', 'location',\n",
       "       'name', 'permissions', 'photo', 'pledged', 'profile', 'slug',\n",
       "       'source_url', 'spotlight', 'staff_pick', 'state', 'state_changed_at',\n",
       "       'static_usd_rate', 'urls', 'usd_pledged', 'usd_type'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_combinada_201908 = pd.read_csv(\"data_combinada_201908.csv\",sep = ',')\n",
    "data_combinada_201908.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "solo_proy_tecnologicos = []\n",
    "\n",
    "for i in data_combinada_201908[\"source_url\"]:\n",
    "    if i.__contains__(\"https://www.kickstarter.com/discover/categories/technology\"):\n",
    "        solo_proy_tecnologicos.append(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(21467, 37)"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_201908_filtrada = data_combinada_201908[data_combinada_201908['source_url'].isin (solo_proy_tecnologicos)]\n",
    "df_201908_filtrada.to_csv( \"df_201908_filtrada.csv\", index=False, encoding='utf-8-sig')\n",
    "df_201908_filtrada.shape"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Continuando el pre-procesamiento luego del filtrado de cada .csv"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Descargando imágenes de cada proyecto"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "os.chdir('D:/TTT/DB/')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "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",
       "      <th>id</th>\n",
       "      <th>backers_count</th>\n",
       "      <th>name</th>\n",
       "      <th>blurb</th>\n",
       "      <th>category</th>\n",
       "      <th>photo</th>\n",
       "      <th>urls</th>\n",
       "      <th>city</th>\n",
       "      <th>country</th>\n",
       "      <th>goal</th>\n",
       "      <th>pledged</th>\n",
       "      <th>currency</th>\n",
       "      <th>usd_pledged</th>\n",
       "      <th>created_at</th>\n",
       "      <th>launched_at</th>\n",
       "      <th>deadline</th>\n",
       "      <th>duration</th>\n",
       "      <th>spotlight</th>\n",
       "      <th>state</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1000245024</td>\n",
       "      <td>0</td>\n",
       "      <td>Safer Home</td>\n",
       "      <td>Placing furniture against traditional plugs is...</td>\n",
       "      <td>Hardware</td>\n",
       "      <td>https://ksr-ugc.imgix.net/assets/011/663/874/0...</td>\n",
       "      <td>https://www.kickstarter.com/projects/homesafet...</td>\n",
       "      <td>Kamloops</td>\n",
       "      <td>CA</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>CAD</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>March 09, 2014</td>\n",
       "      <td>June 03, 2015</td>\n",
       "      <td>July 03, 2015</td>\n",
       "      <td>30</td>\n",
       "      <td>False</td>\n",
       "      <td>failed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1000256230</td>\n",
       "      <td>0</td>\n",
       "      <td>Shreddit - Privacy on Reddit</td>\n",
       "      <td>Shreddit, a Reddit privacy tool I created and ...</td>\n",
       "      <td>Software</td>\n",
       "      <td>https://ksr-ugc.imgix.net/assets/013/466/903/0...</td>\n",
       "      <td>https://www.kickstarter.com/projects/466914929...</td>\n",
       "      <td>Edinburgh</td>\n",
       "      <td>GB</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>GBP</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>August 23, 2016</td>\n",
       "      <td>June 02, 2017</td>\n",
       "      <td>July 02, 2017</td>\n",
       "      <td>30</td>\n",
       "      <td>False</td>\n",
       "      <td>failed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1000261018</td>\n",
       "      <td>3</td>\n",
       "      <td>Diposta - liberating people from their postal ...</td>\n",
       "      <td>The problem of mail: it is physical! Diposta c...</td>\n",
       "      <td>Web</td>\n",
       "      <td>https://ksr-ugc.imgix.net/assets/012/071/808/1...</td>\n",
       "      <td>https://www.kickstarter.com/projects/105350477...</td>\n",
       "      <td>Raleigh</td>\n",
       "      <td>US</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>141.0</td>\n",
       "      <td>USD</td>\n",
       "      <td>141.000000</td>\n",
       "      <td>March 17, 2015</td>\n",
       "      <td>July 24, 2016</td>\n",
       "      <td>August 23, 2016</td>\n",
       "      <td>30</td>\n",
       "      <td>False</td>\n",
       "      <td>failed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>100039820</td>\n",
       "      <td>3</td>\n",
       "      <td>Best Spray Bottle Ever - SureShot</td>\n",
       "      <td>Ever had a spray bottle that has a little bit ...</td>\n",
       "      <td>Gadgets</td>\n",
       "      <td>https://ksr-ugc.imgix.net/assets/012/009/461/3...</td>\n",
       "      <td>https://www.kickstarter.com/projects/110136848...</td>\n",
       "      <td>Edmonton</td>\n",
       "      <td>CA</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>CAD</td>\n",
       "      <td>2.411101</td>\n",
       "      <td>January 22, 2015</td>\n",
       "      <td>February 05, 2015</td>\n",
       "      <td>March 07, 2015</td>\n",
       "      <td>30</td>\n",
       "      <td>False</td>\n",
       "      <td>failed</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1000468345</td>\n",
       "      <td>6</td>\n",
       "      <td>The iRNinja - Simplify your TV with a wireless...</td>\n",
       "      <td>Control your TV &amp; Audio/Video components by pr...</td>\n",
       "      <td>Gadgets</td>\n",
       "      <td>https://ksr-ugc.imgix.net/assets/016/561/251/1...</td>\n",
       "      <td>https://www.kickstarter.com/projects/5877985/i...</td>\n",
       "      <td>Jupiter</td>\n",
       "      <td>US</td>\n",
       "      <td>500.0</td>\n",
       "      <td>74.0</td>\n",
       "      <td>USD</td>\n",
       "      <td>74.000000</td>\n",
       "      <td>April 27, 2017</td>\n",
       "      <td>May 10, 2017</td>\n",
       "      <td>June 14, 2017</td>\n",
       "      <td>35</td>\n",
       "      <td>False</td>\n",
       "      <td>failed</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           id  backers_count  \\\n",
       "0  1000245024              0   \n",
       "1  1000256230              0   \n",
       "2  1000261018              3   \n",
       "3   100039820              3   \n",
       "4  1000468345              6   \n",
       "\n",
       "                                                name  \\\n",
       "0                                         Safer Home   \n",
       "1                       Shreddit - Privacy on Reddit   \n",
       "2  Diposta - liberating people from their postal ...   \n",
       "3                  Best Spray Bottle Ever - SureShot   \n",
       "4  The iRNinja - Simplify your TV with a wireless...   \n",
       "\n",
       "                                               blurb  category  \\\n",
       "0  Placing furniture against traditional plugs is...  Hardware   \n",
       "1  Shreddit, a Reddit privacy tool I created and ...  Software   \n",
       "2  The problem of mail: it is physical! Diposta c...       Web   \n",
       "3  Ever had a spray bottle that has a little bit ...   Gadgets   \n",
       "4  Control your TV & Audio/Video components by pr...   Gadgets   \n",
       "\n",
       "                                               photo  \\\n",
       "0  https://ksr-ugc.imgix.net/assets/011/663/874/0...   \n",
       "1  https://ksr-ugc.imgix.net/assets/013/466/903/0...   \n",
       "2  https://ksr-ugc.imgix.net/assets/012/071/808/1...   \n",
       "3  https://ksr-ugc.imgix.net/assets/012/009/461/3...   \n",
       "4  https://ksr-ugc.imgix.net/assets/016/561/251/1...   \n",
       "\n",
       "                                                urls       city country  \\\n",
       "0  https://www.kickstarter.com/projects/homesafet...   Kamloops      CA   \n",
       "1  https://www.kickstarter.com/projects/466914929...  Edinburgh      GB   \n",
       "2  https://www.kickstarter.com/projects/105350477...    Raleigh      US   \n",
       "3  https://www.kickstarter.com/projects/110136848...   Edmonton      CA   \n",
       "4  https://www.kickstarter.com/projects/5877985/i...    Jupiter      US   \n",
       "\n",
       "       goal  pledged currency  usd_pledged        created_at  \\\n",
       "0   50000.0      0.0      CAD     0.000000    March 09, 2014   \n",
       "1    2000.0      0.0      GBP     0.000000   August 23, 2016   \n",
       "2  100000.0    141.0      USD   141.000000    March 17, 2015   \n",
       "3   25000.0      3.0      CAD     2.411101  January 22, 2015   \n",
       "4     500.0     74.0      USD    74.000000    April 27, 2017   \n",
       "\n",
       "         launched_at         deadline  duration  spotlight   state  \n",
       "0      June 03, 2015    July 03, 2015        30      False  failed  \n",
       "1      June 02, 2017    July 02, 2017        30      False  failed  \n",
       "2      July 24, 2016  August 23, 2016        30      False  failed  \n",
       "3  February 05, 2015   March 07, 2015        30      False  failed  \n",
       "4       May 10, 2017    June 14, 2017        35      False  failed  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_final = pd.read_csv(\"Data final limpia.csv\",sep = ',')\n",
    "data_final.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['https://ksr-ugc.imgix.net/assets/011/663/874/0d51c93f003e10b7fa539040ad0d7a21_original.gif?crop=faces&w=560&h=315&fit=crop&v=1463686456&auto=format&frame=1&q=92&s=94efc5fc020b904d6e694dfee6657a43',\n",
       "       'https://ksr-ugc.imgix.net/assets/013/466/903/048a5685f8b72627381bcd365d08a162_original.png?ixlib=rb-2.1.0&crop=faces&w=560&h=315&fit=crop&v=1471958861&auto=format&frame=1&q=92&s=2f02370a252f4ceb926c38f72771c195',\n",
       "       'https://ksr-ugc.imgix.net/assets/012/071/808/109c2837de24229820849e9336054aba_original.jpg?ixlib=rb-2.1.0&crop=faces&w=560&h=315&fit=crop&v=1463729488&auto=format&frame=1&q=92&s=5ffd09ac5359c1287977ea759965253d',\n",
       "       ...,\n",
       "       'https://ksr-ugc.imgix.net/assets/019/523/430/a95248819bb74ffc7d07fdb5264ae999_original.png?ixlib=rb-2.1.0&crop=faces&w=560&h=315&fit=crop&v=1517361436&auto=format&frame=1&q=92&s=5e154a9c3e2d9973d468962d84068f52',\n",
       "       'https://ksr-ugc.imgix.net/assets/014/434/409/8fe438ae4c374927b1758ca356247967_original.png?crop=faces&w=560&h=315&fit=crop&v=1478598051&auto=format&q=92&s=7a72d10c862089456b3b17ede27c6138',\n",
       "       'https://ksr-ugc.imgix.net/assets/013/185/745/e67196b71e89af5a6845f4fc0935eeca_original.jpg?crop=faces&w=560&h=315&fit=crop&v=1469587518&auto=format&q=92&s=4ba205fdbd5f019f37a50f27182e094c'],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "images_list = data_final[\"photo\"].unique()\n",
    "images_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "100%|██████████████████████████████████████████████████████████████████████████| 27248/27248 [9:19:58<00:00,  1.14s/it]\n"
     ]
    }
   ],
   "source": [
    "import urllib.request\n",
    "from tqdm import tqdm\n",
    "current_path = os.getcwd()\n",
    "try: os.mkdir(current_path + \"\\\\images\\\\\")\n",
    "except:pass\n",
    "\n",
    "os.chdir(current_path + \"\\\\images\\\\\")\n",
    "\n",
    "##descargar imágenes\n",
    "count = 0\n",
    "for img in tqdm(images_list):\n",
    "    file_name = str(data_final[\"id\"][count]) + \".png\"\n",
    "    urllib.request.urlretrieve(img, file_name)\n",
    "    count += 1"
   ]
  }
 ],
 "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.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}