devices.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# LineageOS devices"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import datetime\n",
    "\n",
    "from IPython.display import display, HTML\n",
    "import matplotlib.dates\n",
    "import matplotlib.pyplot as plt\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import seaborn as sns\n",
    "import shijian\n",
    "from sklearn.preprocessing import MinMaxScaler\n",
    "%matplotlib inline\n",
    "shijian.setup_Jupyter()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>LineageOS_compatible</th>\n",
       "      <th>manufacturer</th>\n",
       "      <th>nationality_device</th>\n",
       "      <th>name_device</th>\n",
       "      <th>datetime_release</th>\n",
       "      <th>codename_device</th>\n",
       "      <th>type_device</th>\n",
       "      <th>main_material_case</th>\n",
       "      <th>screen_diagonal_inches</th>\n",
       "      <th>screen_dimensions_inches</th>\n",
       "      <th>screen_aspect_ratio</th>\n",
       "      <th>screen_dimensions_dpi</th>\n",
       "      <th>screen_dimensions_pixels</th>\n",
       "      <th>screen_density</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>True</td>\n",
       "      <td>Asus</td>\n",
       "      <td>Taiwan</td>\n",
       "      <td>Zenfone Max Pro M1</td>\n",
       "      <td>2018-05</td>\n",
       "      <td>X00TD</td>\n",
       "      <td>Phone</td>\n",
       "      <td>metal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>403 dpi</td>\n",
       "      <td>2160 x 1080 px</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>True</td>\n",
       "      <td>Samsung</td>\n",
       "      <td>Korea</td>\n",
       "      <td>Galaxy S9</td>\n",
       "      <td>2018-03-11</td>\n",
       "      <td>starlte</td>\n",
       "      <td>Phone</td>\n",
       "      <td>glass</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>570 dpi</td>\n",
       "      <td>2960 x 1440 px</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>True</td>\n",
       "      <td>Samsung</td>\n",
       "      <td>Korea</td>\n",
       "      <td>Galaxy S9+</td>\n",
       "      <td>2018-03-11</td>\n",
       "      <td>star2lte</td>\n",
       "      <td>Phone</td>\n",
       "      <td>glass</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>True</td>\n",
       "      <td>Sony</td>\n",
       "      <td>Japan</td>\n",
       "      <td>Xperia XA2</td>\n",
       "      <td>2018-02</td>\n",
       "      <td>pioneer</td>\n",
       "      <td>Phone</td>\n",
       "      <td>plastic</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.59 x 2.76</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1080 x 1920 px</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>True</td>\n",
       "      <td>BQ</td>\n",
       "      <td>Spain</td>\n",
       "      <td>Aquaris X Pro</td>\n",
       "      <td>2017-06</td>\n",
       "      <td>bardockpro</td>\n",
       "      <td>Phone</td>\n",
       "      <td>glass</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>True</td>\n",
       "      <td>BQ</td>\n",
       "      <td>Spain</td>\n",
       "      <td>Aquaris X</td>\n",
       "      <td>2017-06</td>\n",
       "      <td>bardock</td>\n",
       "      <td>Phone</td>\n",
       "      <td>plastic</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>True</td>\n",
       "      <td>LG</td>\n",
       "      <td>Korea</td>\n",
       "      <td>G6 (US Unlocked)</td>\n",
       "      <td>2017-02</td>\n",
       "      <td>us997</td>\n",
       "      <td>Phone</td>\n",
       "      <td>plastic</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>True</td>\n",
       "      <td>LG</td>\n",
       "      <td>Korea</td>\n",
       "      <td>G6 (EU Unlocked)</td>\n",
       "      <td>2017-02</td>\n",
       "      <td>h870</td>\n",
       "      <td>Phone</td>\n",
       "      <td>glass</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>True</td>\n",
       "      <td>Samsung</td>\n",
       "      <td>Korea</td>\n",
       "      <td>Galaxy A5 (2017)</td>\n",
       "      <td>2017-01-02</td>\n",
       "      <td>a5y17lte</td>\n",
       "      <td>Phone</td>\n",
       "      <td>glass</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>True</td>\n",
       "      <td>Samsung</td>\n",
       "      <td>Korea</td>\n",
       "      <td>Galaxy A7 (2017)</td>\n",
       "      <td>2017-01-02</td>\n",
       "      <td>a7y17lte</td>\n",
       "      <td>Phone</td>\n",
       "      <td>glass</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>True</td>\n",
       "      <td>LG</td>\n",
       "      <td>Korea</td>\n",
       "      <td>V20 (T-Mobile)</td>\n",
       "      <td>2016-10</td>\n",
       "      <td>h918</td>\n",
       "      <td>Phone</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>True</td>\n",
       "      <td>LG</td>\n",
       "      <td>Korea</td>\n",
       "      <td>V20 (US Unlocked)</td>\n",
       "      <td>2016-10</td>\n",
       "      <td>us996</td>\n",
       "      <td>Phone</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>True</td>\n",
       "      <td>LG</td>\n",
       "      <td>Korea</td>\n",
       "      <td>V20 (Verizon)</td>\n",
       "      <td>2016-10</td>\n",
       "      <td>vs995</td>\n",
       "      <td>Phone</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>True</td>\n",
       "      <td>LG</td>\n",
       "      <td>Korea</td>\n",
       "      <td>V20 (Sprint)</td>\n",
       "      <td>2016-10</td>\n",
       "      <td>ls997</td>\n",
       "      <td>Phone</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>True</td>\n",
       "      <td>LG</td>\n",
       "      <td>Korea</td>\n",
       "      <td>V20 (AT&amp;T)</td>\n",
       "      <td>2016-10</td>\n",
       "      <td>h910</td>\n",
       "      <td>Phone</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>True</td>\n",
       "      <td>Samsung</td>\n",
       "      <td>Korea</td>\n",
       "      <td>Galaxy Tab 3 7.0 LTE</td>\n",
       "      <td>2016-09</td>\n",
       "      <td>lt02ltespr</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>True</td>\n",
       "      <td>LG</td>\n",
       "      <td>Korea</td>\n",
       "      <td>G Pad X (T-Mobile)</td>\n",
       "      <td>2016-06</td>\n",
       "      <td>v521</td>\n",
       "      <td>Tablet</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>True</td>\n",
       "      <td>HTC</td>\n",
       "      <td>Taiwan</td>\n",
       "      <td>10</td>\n",
       "      <td>2016-05</td>\n",
       "      <td>pme</td>\n",
       "      <td>Phone</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>True</td>\n",
       "      <td>Samsung</td>\n",
       "      <td>Korea</td>\n",
       "      <td>Galaxy S7</td>\n",
       "      <td>2016-03-18</td>\n",
       "      <td>herolte</td>\n",
       "      <td>Phone</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.1</td>\n",
       "      <td>2.5 x 4.4</td>\n",
       "      <td>16:9</td>\n",
       "      <td>360 x 640 dp</td>\n",
       "      <td>1440 x 2560 px</td>\n",
       "      <td>4.0 xxxhdpi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>True</td>\n",
       "      <td>Samsung</td>\n",
       "      <td>Korea</td>\n",
       "      <td>Galaxy S7 Edge</td>\n",
       "      <td>2016-03-18</td>\n",
       "      <td>hero2lte</td>\n",
       "      <td>Phone</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.5</td>\n",
       "      <td>2.7 x 4.8</td>\n",
       "      <td>16:9</td>\n",
       "      <td>360 x 640 dp</td>\n",
       "      <td>1440 x 2560 px</td>\n",
       "      <td>4.0 xxxhdpi</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "df = pd.read_csv(\"devices.csv\")\n",
    "blacklist_nationality_device = [\"China\", \"USA\"]\n",
    "df = df.query(\"nationality_device not in @blacklist_nationality_device\")\n",
    "df = df.sort_values(by=[\"nationality_device\"])\n",
    "df = df.sort_values(by=[\"datetime_release\"], ascending=False)\n",
    "display(HTML(df.head(20).to_html(index=False)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>LineageOS_compatible</th>\n",
       "      <th>manufacturer</th>\n",
       "      <th>nationality_device</th>\n",
       "      <th>name_device</th>\n",
       "      <th>datetime_release</th>\n",
       "      <th>codename_device</th>\n",
       "      <th>type_device</th>\n",
       "      <th>main_material_case</th>\n",
       "      <th>screen_diagonal_inches</th>\n",
       "      <th>screen_dimensions_inches</th>\n",
       "      <th>screen_aspect_ratio</th>\n",
       "      <th>screen_dimensions_dpi</th>\n",
       "      <th>screen_dimensions_pixels</th>\n",
       "      <th>screen_density</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>True</td>\n",
       "      <td>Asus</td>\n",
       "      <td>Taiwan</td>\n",
       "      <td>Zenfone Max Pro M1</td>\n",
       "      <td>2018-05</td>\n",
       "      <td>X00TD</td>\n",
       "      <td>Phone</td>\n",
       "      <td>metal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>403 dpi</td>\n",
       "      <td>2160 x 1080 px</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>True</td>\n",
       "      <td>BQ</td>\n",
       "      <td>Spain</td>\n",
       "      <td>Aquaris X5 Plus</td>\n",
       "      <td>2016</td>\n",
       "      <td>gohan</td>\n",
       "      <td>Phone</td>\n",
       "      <td>metal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>True</td>\n",
       "      <td>BQ</td>\n",
       "      <td>Spain</td>\n",
       "      <td>Aquaris U Plus</td>\n",
       "      <td>2016</td>\n",
       "      <td>tenshi</td>\n",
       "      <td>Phone</td>\n",
       "      <td>metal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>True</td>\n",
       "      <td>Wileyfox</td>\n",
       "      <td>UK</td>\n",
       "      <td>Swift</td>\n",
       "      <td>2015-10</td>\n",
       "      <td>crackling</td>\n",
       "      <td>Phone</td>\n",
       "      <td>metal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>True</td>\n",
       "      <td>BQ</td>\n",
       "      <td>Spain</td>\n",
       "      <td>Aquaris X5</td>\n",
       "      <td>2015-03</td>\n",
       "      <td>paella</td>\n",
       "      <td>Phone</td>\n",
       "      <td>metal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "_df = df.query(\"main_material_case == 'metal'\")\n",
    "display(HTML(_df.head(20).to_html(index=False)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "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
}