Untitled.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "dest = pd.read_csv(\"dest.txt\", sep='\\t')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>srch_destination_id</th>\n",
       "      <th>srch_destination_name</th>\n",
       "      <th>srch_destination_type_id</th>\n",
       "      <th>srch_destination_latitude</th>\n",
       "      <th>srch_destination_longitude</th>\n",
       "      <th>popular_activity_adventure</th>\n",
       "      <th>popular_attraction_aquarium</th>\n",
       "      <th>popular_historical_archaeology</th>\n",
       "      <th>popular_architecture_architecture</th>\n",
       "      <th>popular_cultural_art</th>\n",
       "      <th>...</th>\n",
       "      <th>popular_naturalfeature_volcanoes</th>\n",
       "      <th>popular_activity_walking</th>\n",
       "      <th>popular_activity_waterskiing</th>\n",
       "      <th>popular_naturalfeature_waterfalls</th>\n",
       "      <th>popular_attraction_waterparks</th>\n",
       "      <th>popular_activity_whalewatching</th>\n",
       "      <th>popular_naturalfeature_wildlife</th>\n",
       "      <th>popular_activity_windsurfing</th>\n",
       "      <th>popular_attraction_wineries</th>\n",
       "      <th>popular_attraction_zoo</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7997</td>\n",
       "      <td>Annaba, Algeria</td>\n",
       "      <td>557</td>\n",
       "      <td>36.913930</td>\n",
       "      <td>7.741176</td>\n",
       "      <td>-2.181690</td>\n",
       "      <td>-2.181690</td>\n",
       "      <td>-2.181690</td>\n",
       "      <td>-2.082564</td>\n",
       "      <td>-2.181690</td>\n",
       "      <td>...</td>\n",
       "      <td>-2.181690</td>\n",
       "      <td>-2.181690</td>\n",
       "      <td>-2.165028</td>\n",
       "      <td>-2.181690</td>\n",
       "      <td>-2.165028</td>\n",
       "      <td>-2.181690</td>\n",
       "      <td>-2.181690</td>\n",
       "      <td>-2.165028</td>\n",
       "      <td>-2.181690</td>\n",
       "      <td>-2.181690</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>8090</td>\n",
       "      <td>Al Ain, United Arab Emirates</td>\n",
       "      <td>557</td>\n",
       "      <td>24.231660</td>\n",
       "      <td>55.740160</td>\n",
       "      <td>-2.183490</td>\n",
       "      <td>-2.224164</td>\n",
       "      <td>-2.224164</td>\n",
       "      <td>-2.189562</td>\n",
       "      <td>-2.105819</td>\n",
       "      <td>...</td>\n",
       "      <td>-2.186008</td>\n",
       "      <td>-2.191569</td>\n",
       "      <td>-2.224164</td>\n",
       "      <td>-2.224164</td>\n",
       "      <td>-2.196379</td>\n",
       "      <td>-2.224164</td>\n",
       "      <td>-2.192009</td>\n",
       "      <td>-2.224164</td>\n",
       "      <td>-2.224164</td>\n",
       "      <td>-2.057548</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>8121</td>\n",
       "      <td>Anapa, Russia</td>\n",
       "      <td>557</td>\n",
       "      <td>44.942840</td>\n",
       "      <td>37.292920</td>\n",
       "      <td>-2.177409</td>\n",
       "      <td>-2.177409</td>\n",
       "      <td>-2.177409</td>\n",
       "      <td>-2.177409</td>\n",
       "      <td>-2.177409</td>\n",
       "      <td>...</td>\n",
       "      <td>-2.177409</td>\n",
       "      <td>-2.161081</td>\n",
       "      <td>-2.161081</td>\n",
       "      <td>-2.177409</td>\n",
       "      <td>-2.177409</td>\n",
       "      <td>-2.177409</td>\n",
       "      <td>-2.177409</td>\n",
       "      <td>-2.177409</td>\n",
       "      <td>-2.177409</td>\n",
       "      <td>-2.177409</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>8152</td>\n",
       "      <td>Aarhus (and vicinity), Denmark</td>\n",
       "      <td>464</td>\n",
       "      <td>56.153090</td>\n",
       "      <td>10.205722</td>\n",
       "      <td>-2.189562</td>\n",
       "      <td>-2.187783</td>\n",
       "      <td>-2.194008</td>\n",
       "      <td>-2.171153</td>\n",
       "      <td>-2.152303</td>\n",
       "      <td>...</td>\n",
       "      <td>-2.194008</td>\n",
       "      <td>-2.163242</td>\n",
       "      <td>-2.187356</td>\n",
       "      <td>-2.194008</td>\n",
       "      <td>-2.191779</td>\n",
       "      <td>-2.194008</td>\n",
       "      <td>-2.194008</td>\n",
       "      <td>-2.185161</td>\n",
       "      <td>-2.194008</td>\n",
       "      <td>-2.188037</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>8369</td>\n",
       "      <td>Abilene (and vicinity), Texas, United States o...</td>\n",
       "      <td>464</td>\n",
       "      <td>32.412406</td>\n",
       "      <td>-99.764760</td>\n",
       "      <td>-2.201047</td>\n",
       "      <td>-2.201047</td>\n",
       "      <td>-2.201047</td>\n",
       "      <td>-2.150858</td>\n",
       "      <td>-2.150858</td>\n",
       "      <td>...</td>\n",
       "      <td>-2.201047</td>\n",
       "      <td>-2.106235</td>\n",
       "      <td>-2.201047</td>\n",
       "      <td>-2.201047</td>\n",
       "      <td>-2.201047</td>\n",
       "      <td>-2.201047</td>\n",
       "      <td>-2.201047</td>\n",
       "      <td>-2.201047</td>\n",
       "      <td>-2.201047</td>\n",
       "      <td>-2.144392</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 144 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   srch_destination_id                              srch_destination_name  \\\n",
       "0                 7997                                    Annaba, Algeria   \n",
       "1                 8090                       Al Ain, United Arab Emirates   \n",
       "2                 8121                                      Anapa, Russia   \n",
       "3                 8152                     Aarhus (and vicinity), Denmark   \n",
       "4                 8369  Abilene (and vicinity), Texas, United States o...   \n",
       "\n",
       "   srch_destination_type_id  srch_destination_latitude  \\\n",
       "0                       557                  36.913930   \n",
       "1                       557                  24.231660   \n",
       "2                       557                  44.942840   \n",
       "3                       464                  56.153090   \n",
       "4                       464                  32.412406   \n",
       "\n",
       "   srch_destination_longitude  popular_activity_adventure  \\\n",
       "0                    7.741176                   -2.181690   \n",
       "1                   55.740160                   -2.183490   \n",
       "2                   37.292920                   -2.177409   \n",
       "3                   10.205722                   -2.189562   \n",
       "4                  -99.764760                   -2.201047   \n",
       "\n",
       "   popular_attraction_aquarium  popular_historical_archaeology  \\\n",
       "0                    -2.181690                       -2.181690   \n",
       "1                    -2.224164                       -2.224164   \n",
       "2                    -2.177409                       -2.177409   \n",
       "3                    -2.187783                       -2.194008   \n",
       "4                    -2.201047                       -2.201047   \n",
       "\n",
       "   popular_architecture_architecture  popular_cultural_art  \\\n",
       "0                          -2.082564             -2.181690   \n",
       "1                          -2.189562             -2.105819   \n",
       "2                          -2.177409             -2.177409   \n",
       "3                          -2.171153             -2.152303   \n",
       "4                          -2.150858             -2.150858   \n",
       "\n",
       "            ...            popular_naturalfeature_volcanoes  \\\n",
       "0           ...                                   -2.181690   \n",
       "1           ...                                   -2.186008   \n",
       "2           ...                                   -2.177409   \n",
       "3           ...                                   -2.194008   \n",
       "4           ...                                   -2.201047   \n",
       "\n",
       "   popular_activity_walking  popular_activity_waterskiing  \\\n",
       "0                 -2.181690                     -2.165028   \n",
       "1                 -2.191569                     -2.224164   \n",
       "2                 -2.161081                     -2.161081   \n",
       "3                 -2.163242                     -2.187356   \n",
       "4                 -2.106235                     -2.201047   \n",
       "\n",
       "   popular_naturalfeature_waterfalls  popular_attraction_waterparks  \\\n",
       "0                          -2.181690                      -2.165028   \n",
       "1                          -2.224164                      -2.196379   \n",
       "2                          -2.177409                      -2.177409   \n",
       "3                          -2.194008                      -2.191779   \n",
       "4                          -2.201047                      -2.201047   \n",
       "\n",
       "   popular_activity_whalewatching  popular_naturalfeature_wildlife  \\\n",
       "0                       -2.181690                        -2.181690   \n",
       "1                       -2.224164                        -2.192009   \n",
       "2                       -2.177409                        -2.177409   \n",
       "3                       -2.194008                        -2.194008   \n",
       "4                       -2.201047                        -2.201047   \n",
       "\n",
       "   popular_activity_windsurfing  popular_attraction_wineries  \\\n",
       "0                     -2.165028                    -2.181690   \n",
       "1                     -2.224164                    -2.224164   \n",
       "2                     -2.177409                    -2.177409   \n",
       "3                     -2.185161                    -2.194008   \n",
       "4                     -2.201047                    -2.201047   \n",
       "\n",
       "   popular_attraction_zoo  \n",
       "0               -2.181690  \n",
       "1               -2.057548  \n",
       "2               -2.177409  \n",
       "3               -2.188037  \n",
       "4               -2.144392  \n",
       "\n",
       "[5 rows x 144 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dest.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "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.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}