{
 "metadata": {
  "name": "",
  "signature": "sha256:2902481748d35de3b4537a4a855327a2b960d178c0e1803e2217aece3146796b"
 },
 "nbformat": 3,
 "nbformat_minor": 0,
 "worksheets": [
  {
   "cells": [
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "#Create DataFrame\n",
      "import pandas as pd\n",
      "import numpy as np\n",
      "from pandas import DataFrame, Series\n",
      "df = DataFrame(\n",
      "    {'integer':[1,2,3,6,7,23,8,3],\n",
      "     'float':[2,3.4,5,6,2,4.7,4,8],\n",
      "     'string':['saya',None,'aku','cinta','kamu','a','b','jika']}\n",
      ")"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 1
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "#Show DataFrame\n",
      "df"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>float</th>\n",
        "      <th>integer</th>\n",
        "      <th>string</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td> 2.0</td>\n",
        "      <td>  1</td>\n",
        "      <td>  saya</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1</th>\n",
        "      <td> 3.4</td>\n",
        "      <td>  2</td>\n",
        "      <td>  None</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2</th>\n",
        "      <td> 5.0</td>\n",
        "      <td>  3</td>\n",
        "      <td>   aku</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3</th>\n",
        "      <td> 6.0</td>\n",
        "      <td>  6</td>\n",
        "      <td> cinta</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4</th>\n",
        "      <td> 2.0</td>\n",
        "      <td>  7</td>\n",
        "      <td>  kamu</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5</th>\n",
        "      <td> 4.7</td>\n",
        "      <td> 23</td>\n",
        "      <td>     a</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6</th>\n",
        "      <td> 4.0</td>\n",
        "      <td>  8</td>\n",
        "      <td>     b</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>7</th>\n",
        "      <td> 8.0</td>\n",
        "      <td>  3</td>\n",
        "      <td>  jika</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 2,
       "text": [
        "   float  integer string\n",
        "0    2.0        1   saya\n",
        "1    3.4        2   None\n",
        "2    5.0        3    aku\n",
        "3    6.0        6  cinta\n",
        "4    2.0        7   kamu\n",
        "5    4.7       23      a\n",
        "6    4.0        8      b\n",
        "7    8.0        3   jika"
       ]
      }
     ],
     "prompt_number": 2
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "#Drop Na Value from DataFrame and then change the value using map\n",
      "df['string'].dropna().map(lambda x : 'rischan_' + x)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 3,
       "text": [
        "0     rischan_saya\n",
        "2      rischan_aku\n",
        "3    rischan_cinta\n",
        "4     rischan_kamu\n",
        "5        rischan_a\n",
        "6        rischan_b\n",
        "7     rischan_jika\n",
        "Name: string, dtype: object"
       ]
      }
     ],
     "prompt_number": 3
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "#Apply function for all rows in dataframe\n",
      "df.ix[:,['float','integer']].apply(np.sqrt)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>float</th>\n",
        "      <th>integer</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td> 1.414214</td>\n",
        "      <td> 1.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1</th>\n",
        "      <td> 1.843909</td>\n",
        "      <td> 1.414214</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2</th>\n",
        "      <td> 2.236068</td>\n",
        "      <td> 1.732051</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3</th>\n",
        "      <td> 2.449490</td>\n",
        "      <td> 2.449490</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4</th>\n",
        "      <td> 1.414214</td>\n",
        "      <td> 2.645751</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5</th>\n",
        "      <td> 2.167948</td>\n",
        "      <td> 4.795832</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6</th>\n",
        "      <td> 2.000000</td>\n",
        "      <td> 2.828427</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>7</th>\n",
        "      <td> 2.828427</td>\n",
        "      <td> 1.732051</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 5,
       "text": [
        "      float   integer\n",
        "0  1.414214  1.000000\n",
        "1  1.843909  1.414214\n",
        "2  2.236068  1.732051\n",
        "3  2.449490  2.449490\n",
        "4  1.414214  2.645751\n",
        "5  2.167948  4.795832\n",
        "6  2.000000  2.828427\n",
        "7  2.828427  1.732051"
       ]
      }
     ],
     "prompt_number": 5
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "#Apply map function example\n",
      "def applymap_function(x):\n",
      "    if type(x) is str:\n",
      "        return 'applymap_' +x\n",
      "    elif x:\n",
      "        return 100 * x\n",
      "    else:\n",
      "        return\n",
      "\n",
      "#DataFrame after function excecution\n",
      "df.applymap(applymap_function)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>float</th>\n",
        "      <th>integer</th>\n",
        "      <th>string</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td> 200</td>\n",
        "      <td>  100</td>\n",
        "      <td>  applymap_saya</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1</th>\n",
        "      <td> 340</td>\n",
        "      <td>  200</td>\n",
        "      <td>           None</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2</th>\n",
        "      <td> 500</td>\n",
        "      <td>  300</td>\n",
        "      <td>   applymap_aku</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3</th>\n",
        "      <td> 600</td>\n",
        "      <td>  600</td>\n",
        "      <td> applymap_cinta</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4</th>\n",
        "      <td> 200</td>\n",
        "      <td>  700</td>\n",
        "      <td>  applymap_kamu</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5</th>\n",
        "      <td> 470</td>\n",
        "      <td> 2300</td>\n",
        "      <td>     applymap_a</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6</th>\n",
        "      <td> 400</td>\n",
        "      <td>  800</td>\n",
        "      <td>     applymap_b</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>7</th>\n",
        "      <td> 800</td>\n",
        "      <td>  300</td>\n",
        "      <td>  applymap_jika</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 6,
       "text": [
        "   float  integer          string\n",
        "0    200      100   applymap_saya\n",
        "1    340      200            None\n",
        "2    500      300    applymap_aku\n",
        "3    600      600  applymap_cinta\n",
        "4    200      700   applymap_kamu\n",
        "5    470     2300      applymap_a\n",
        "6    400      800      applymap_b\n",
        "7    800      300   applymap_jika"
       ]
      }
     ],
     "prompt_number": 6
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "#Columns opereration in DataFrame\n",
      "df[\"total\"] = df[\"float\"]+df[\"integer\"]\n",
      "df"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>float</th>\n",
        "      <th>integer</th>\n",
        "      <th>string</th>\n",
        "      <th>total</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td> 2.0</td>\n",
        "      <td>  1</td>\n",
        "      <td>  saya</td>\n",
        "      <td>  3.0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1</th>\n",
        "      <td> 3.4</td>\n",
        "      <td>  2</td>\n",
        "      <td>  None</td>\n",
        "      <td>  5.4</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2</th>\n",
        "      <td> 5.0</td>\n",
        "      <td>  3</td>\n",
        "      <td>   aku</td>\n",
        "      <td>  8.0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3</th>\n",
        "      <td> 6.0</td>\n",
        "      <td>  6</td>\n",
        "      <td> cinta</td>\n",
        "      <td> 12.0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4</th>\n",
        "      <td> 2.0</td>\n",
        "      <td>  7</td>\n",
        "      <td>  kamu</td>\n",
        "      <td>  9.0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5</th>\n",
        "      <td> 4.7</td>\n",
        "      <td> 23</td>\n",
        "      <td>     a</td>\n",
        "      <td> 27.7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6</th>\n",
        "      <td> 4.0</td>\n",
        "      <td>  8</td>\n",
        "      <td>     b</td>\n",
        "      <td> 12.0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>7</th>\n",
        "      <td> 8.0</td>\n",
        "      <td>  3</td>\n",
        "      <td>  jika</td>\n",
        "      <td> 11.0</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 8,
       "text": [
        "   float  integer string  total\n",
        "0    2.0        1   saya    3.0\n",
        "1    3.4        2   None    5.4\n",
        "2    5.0        3    aku    8.0\n",
        "3    6.0        6  cinta   12.0\n",
        "4    2.0        7   kamu    9.0\n",
        "5    4.7       23      a   27.7\n",
        "6    4.0        8      b   12.0\n",
        "7    8.0        3   jika   11.0"
       ]
      }
     ],
     "prompt_number": 8
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "#String operation in DataFrame\n",
      "df[\"upper\"] = df[\"string\"].str.upper()\n",
      "df"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>float</th>\n",
        "      <th>integer</th>\n",
        "      <th>string</th>\n",
        "      <th>total</th>\n",
        "      <th>upper</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td> 2.0</td>\n",
        "      <td>  1</td>\n",
        "      <td>  saya</td>\n",
        "      <td>  3.0</td>\n",
        "      <td>  SAYA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1</th>\n",
        "      <td> 3.4</td>\n",
        "      <td>  2</td>\n",
        "      <td>  None</td>\n",
        "      <td>  5.4</td>\n",
        "      <td>  None</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2</th>\n",
        "      <td> 5.0</td>\n",
        "      <td>  3</td>\n",
        "      <td>   aku</td>\n",
        "      <td>  8.0</td>\n",
        "      <td>   AKU</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3</th>\n",
        "      <td> 6.0</td>\n",
        "      <td>  6</td>\n",
        "      <td> cinta</td>\n",
        "      <td> 12.0</td>\n",
        "      <td> CINTA</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4</th>\n",
        "      <td> 2.0</td>\n",
        "      <td>  7</td>\n",
        "      <td>  kamu</td>\n",
        "      <td>  9.0</td>\n",
        "      <td>  KAMU</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5</th>\n",
        "      <td> 4.7</td>\n",
        "      <td> 23</td>\n",
        "      <td>     a</td>\n",
        "      <td> 27.7</td>\n",
        "      <td>     A</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6</th>\n",
        "      <td> 4.0</td>\n",
        "      <td>  8</td>\n",
        "      <td>     b</td>\n",
        "      <td> 12.0</td>\n",
        "      <td>     B</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>7</th>\n",
        "      <td> 8.0</td>\n",
        "      <td>  3</td>\n",
        "      <td>  jika</td>\n",
        "      <td> 11.0</td>\n",
        "      <td>  JIKA</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 9,
       "text": [
        "   float  integer string  total  upper\n",
        "0    2.0        1   saya    3.0   SAYA\n",
        "1    3.4        2   None    5.4   None\n",
        "2    5.0        3    aku    8.0    AKU\n",
        "3    6.0        6  cinta   12.0  CINTA\n",
        "4    2.0        7   kamu    9.0   KAMU\n",
        "5    4.7       23      a   27.7      A\n",
        "6    4.0        8      b   12.0      B\n",
        "7    8.0        3   jika   11.0   JIKA"
       ]
      }
     ],
     "prompt_number": 9
    }
   ],
   "metadata": {}
  }
 ]
}