Untitled1.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "      id  customer_id account_type account_number  available_balance  \\\n",
      "0      1           19      savings       xxxx6302           21481.44   \n",
      "1      2           22      savings       xxxx4287            4923.48   \n",
      "2      3          251     checking       xxxx-X48                NaN   \n",
      "3      4          251      unknown       xxxx-X44                NaN   \n",
      "4      5          251     checking       xxxx-X49                NaN   \n",
      "5      6          251     checking       xxxx-X47                NaN   \n",
      "6      7          251      savings       xxxx-X48                NaN   \n",
      "7      8          251      savings       xxxx-X02                NaN   \n",
      "8      9          251      savings       xxxx-X44                NaN   \n",
      "9     10          583      savings       xxxx-X44          159674.54   \n",
      "10    11          583      savings       xxxx-X06           44176.48   \n",
      "11    12          979      savings       xxxx3916            1380.86   \n",
      "12    13         1066      savings       xxxx3243           15183.66   \n",
      "13    14         1103      savings       xxxx9330            2068.00   \n",
      "14    15         1112      savings       xxxx9330            2068.00   \n",
      "15    16         1138      savings       xxxx0154          658221.55   \n",
      "16    17         1151      savings       xxxx0154          658221.55   \n",
      "17    18         1179      savings       xxxx9330            5000.00   \n",
      "18    19         1216      savings       xxxx7855           26158.95   \n",
      "19    20         1216           CD       xxxx8223           18000.00   \n",
      "20    21         1216           CD       xxxx6449          100000.00   \n",
      "21    22         1216           CD       xxxx4034            5500.00   \n",
      "22    23         1216           CD       xxxx8633           62815.00   \n",
      "23    24         1216           CD       xxxx1669           14076.00   \n",
      "24    25         1233      savings       xxxx7855           26158.95   \n",
      "25    26         1233           CD       xxxx8223           18000.00   \n",
      "26    27         1233           CD       xxxx6449          100000.00   \n",
      "27    28         1233           CD       xxxx4034            5500.00   \n",
      "28    29         1233           CD       xxxx8633           62815.00   \n",
      "29    30         1233           CD       xxxx1669           14076.00   \n",
      "..   ...          ...          ...            ...                ...   \n",
      "508  508        44005      savings       xxxx8903             482.00   \n",
      "509  509        44005          ppf       xxxx7763          164082.00   \n",
      "510  510        44005      savings       xxxx9095             130.83   \n",
      "511  511        44010      savings       xxxx7165           20289.42   \n",
      "512  512        44016      savings       xxxx1805           62534.02   \n",
      "513  513        44016      savings       xxxx8903             482.00   \n",
      "514  514        44016          ppf       xxxx7763          164082.00   \n",
      "515  515        44016      savings       xxxx9095             130.83   \n",
      "516  516        44762      savings       xxxx4828         1202096.04   \n",
      "517  517        44911      savings       xxxx0660            2360.00   \n",
      "518  518        45254      savings       xxxx3292           18397.73   \n",
      "519  519        45254      savings       xxxx9779            5053.14   \n",
      "520  520        45260      unknown       xxxx-X28                NaN   \n",
      "521  521        45260      savings       xxxx-X29           39940.33   \n",
      "522  522        45480      savings       xxxx0084           47999.17   \n",
      "523  529        45757      savings       xxxx5500            7004.74   \n",
      "524  532        45774      savings       xxxx0440             172.36   \n",
      "525  537        46033      savings       xxxx2602              15.25   \n",
      "526  538        46083      savings       xxxx3254           59495.21   \n",
      "527  523        45524      savings       xxxx7711            6070.30   \n",
      "528  524        45527      savings       xxxx7711            6070.30   \n",
      "529  525        45527      savings       xxxx9117            2900.00   \n",
      "530  528        45573      savings       xxxx0361            3371.42   \n",
      "531  530        45767      savings       xxxx7711            6070.30   \n",
      "532  531        45767      savings       xxxx9117            2900.00   \n",
      "533  533        45786      savings       xxxx5104              32.82   \n",
      "534  534        45786      savings       xxxx4813           -7042.37   \n",
      "535  535        45786      savings       xxxx0440             172.36   \n",
      "536  536        45831      savings       xxxx-X17              38.27   \n",
      "537  527        45541           CD       xxxx2343           20059.00   \n",
      "\n",
      "     current_balance        maturity_date  \n",
      "0           21481.44                  NaN  \n",
      "1            4923.48                  NaN  \n",
      "2                NaN                  NaN  \n",
      "3          -66088.00                  NaN  \n",
      "4                NaN                  NaN  \n",
      "5                NaN                  NaN  \n",
      "6            7382.38                  NaN  \n",
      "7           24054.16                  NaN  \n",
      "8            3149.58                  NaN  \n",
      "9          159674.54                  NaN  \n",
      "10          44176.48                  NaN  \n",
      "11           1380.86                  NaN  \n",
      "12          15183.66                  NaN  \n",
      "13               NaN                  NaN  \n",
      "14               NaN                  NaN  \n",
      "15         658221.55                  NaN  \n",
      "16         658221.55                  NaN  \n",
      "17           5000.00                  NaN  \n",
      "18          26158.95                  NaN  \n",
      "19          21033.69  2016-05-15 00:00:00  \n",
      "20         107034.81  2016-05-09 00:00:00  \n",
      "21           6747.67  2018-10-29 00:00:00  \n",
      "22          77064.58  2018-10-29 00:00:00  \n",
      "23          14273.21  2017-04-22 00:00:00  \n",
      "24          26158.95                  NaN  \n",
      "25          21033.69  2016-05-15 00:00:00  \n",
      "26         107034.81  2016-05-09 00:00:00  \n",
      "27           6747.67  2018-10-29 00:00:00  \n",
      "28          77064.58  2018-10-29 00:00:00  \n",
      "29          14273.21  2017-04-22 00:00:00  \n",
      "..               ...                  ...  \n",
      "508           482.00                  NaN  \n",
      "509        164082.00                  NaN  \n",
      "510           130.83                  NaN  \n",
      "511              NaN                  NaN  \n",
      "512         62534.02                  NaN  \n",
      "513           482.00                  NaN  \n",
      "514        164082.00                  NaN  \n",
      "515           130.83                  NaN  \n",
      "516       1202096.04                  NaN  \n",
      "517          2360.00                  NaN  \n",
      "518         18397.73                  NaN  \n",
      "519          5053.14                  NaN  \n",
      "520              NaN                  NaN  \n",
      "521         39940.33                  NaN  \n",
      "522         47999.17                  NaN  \n",
      "523          7004.74                  NaN  \n",
      "524           172.36                  NaN  \n",
      "525              NaN                  NaN  \n",
      "526         59495.21                  NaN  \n",
      "527          6070.30                  NaN  \n",
      "528          6070.30                  NaN  \n",
      "529          2900.00                  NaN  \n",
      "530          3371.42                  NaN  \n",
      "531          6070.30                  NaN  \n",
      "532          2900.00                  NaN  \n",
      "533            32.82                  NaN  \n",
      "534              NaN                  NaN  \n",
      "535           172.36                  NaN  \n",
      "536            38.27                  NaN  \n",
      "537         20059.00  2018-03-04 00:00:00  \n",
      "\n",
      "[538 rows x 7 columns]\n",
      "****\n",
      "Do you want to replace value with something \n",
      "Record No  3 has  a problem\n",
      "Record No  4 has  a problem\n",
      "Record No  5 has  a problem\n",
      "Record No  6 has  a problem\n",
      "Record No  7 has  a problem\n",
      "Record No  8 has  a problem\n",
      "Record No  9 has  a problem\n",
      "Record No  34 has  a problem\n",
      "Record No  38 has  a problem\n",
      "Record No  41 has  a problem\n",
      "Record No  73 has  a problem\n",
      "Record No  90 has  a problem\n",
      "Record No  110 has  a problem\n",
      "Record No  111 has  a problem\n",
      "Record No  112 has  a problem\n",
      "Record No  113 has  a problem\n",
      "Record No  114 has  a problem\n",
      "Record No  115 has  a problem\n",
      "Record No  116 has  a problem\n",
      "Record No  117 has  a problem\n",
      "Record No  118 has  a problem\n",
      "Record No  122 has  a problem\n",
      "Record No  123 has  a problem\n",
      "Record No  124 has  a problem\n",
      "Record No  134 has  a problem\n",
      "Record No  135 has  a problem\n",
      "Record No  138 has  a problem\n",
      "Record No  139 has  a problem\n",
      "Record No  142 has  a problem\n",
      "Record No  143 has  a problem\n",
      "Record No  148 has  a problem\n",
      "Record No  168 has  a problem\n",
      "Record No  182 has  a problem\n",
      "Record No  186 has  a problem\n",
      "Record No  189 has  a problem\n",
      "Record No  210 has  a problem\n",
      "Record No  219 has  a problem\n",
      "Record No  220 has  a problem\n",
      "Record No  222 has  a problem\n",
      "Record No  225 has  a problem\n",
      "Record No  247 has  a problem\n",
      "Record No  270 has  a problem\n",
      "Record No  271 has  a problem\n",
      "Record No  272 has  a problem\n",
      "Record No  273 has  a problem\n",
      "Record No  274 has  a problem\n",
      "Record No  282 has  a problem\n",
      "Record No  283 has  a problem\n",
      "Record No  284 has  a problem\n",
      "Record No  285 has  a problem\n",
      "Record No  291 has  a problem\n",
      "Record No  299 has  a problem\n",
      "Record No  303 has  a problem\n",
      "Record No  307 has  a problem\n",
      "Record No  315 has  a problem\n",
      "Record No  348 has  a problem\n",
      "Record No  385 has  a problem\n",
      "Record No  387 has  a problem\n",
      "Record No  395 has  a problem\n",
      "Record No  396 has  a problem\n",
      "Record No  428 has  a problem\n",
      "Record No  473 has  a problem\n",
      "Record No  475 has  a problem\n",
      "Record No  483 has  a problem\n",
      "Record No  497 has  a problem\n",
      "Record No  498 has  a problem\n",
      "Record No  500 has  a problem\n",
      "Record No  502 has  a problem\n",
      "Record No  506 has  a problem\n",
      "Record No  521 has  a problem\n",
      "      id  customer_id account_type account_number  available_balance  \\\n",
      "0      1           19      savings       xxxx6302           21481.44   \n",
      "1      2           22      savings       xxxx4287            4923.48   \n",
      "2      3          251     checking       xxxx-X48               0.00   \n",
      "3      4          251      unknown       xxxx-X44               0.00   \n",
      "4      5          251     checking       xxxx-X49               0.00   \n",
      "5      6          251     checking       xxxx-X47               0.00   \n",
      "6      7          251      savings       xxxx-X48               0.00   \n",
      "7      8          251      savings       xxxx-X02               0.00   \n",
      "8      9          251      savings       xxxx-X44               0.00   \n",
      "9     10          583      savings       xxxx-X44          159674.54   \n",
      "10    11          583      savings       xxxx-X06           44176.48   \n",
      "11    12          979      savings       xxxx3916            1380.86   \n",
      "12    13         1066      savings       xxxx3243           15183.66   \n",
      "13    14         1103      savings       xxxx9330            2068.00   \n",
      "14    15         1112      savings       xxxx9330            2068.00   \n",
      "15    16         1138      savings       xxxx0154          658221.55   \n",
      "16    17         1151      savings       xxxx0154          658221.55   \n",
      "17    18         1179      savings       xxxx9330            5000.00   \n",
      "18    19         1216      savings       xxxx7855           26158.95   \n",
      "19    20         1216           CD       xxxx8223           18000.00   \n",
      "20    21         1216           CD       xxxx6449          100000.00   \n",
      "21    22         1216           CD       xxxx4034            5500.00   \n",
      "22    23         1216           CD       xxxx8633           62815.00   \n",
      "23    24         1216           CD       xxxx1669           14076.00   \n",
      "24    25         1233      savings       xxxx7855           26158.95   \n",
      "25    26         1233           CD       xxxx8223           18000.00   \n",
      "26    27         1233           CD       xxxx6449          100000.00   \n",
      "27    28         1233           CD       xxxx4034            5500.00   \n",
      "28    29         1233           CD       xxxx8633           62815.00   \n",
      "29    30         1233           CD       xxxx1669           14076.00   \n",
      "..   ...          ...          ...            ...                ...   \n",
      "508  508        44005      savings       xxxx8903             482.00   \n",
      "509  509        44005          ppf       xxxx7763          164082.00   \n",
      "510  510        44005      savings       xxxx9095             130.83   \n",
      "511  511        44010      savings       xxxx7165           20289.42   \n",
      "512  512        44016      savings       xxxx1805           62534.02   \n",
      "513  513        44016      savings       xxxx8903             482.00   \n",
      "514  514        44016          ppf       xxxx7763          164082.00   \n",
      "515  515        44016      savings       xxxx9095             130.83   \n",
      "516  516        44762      savings       xxxx4828         1202096.04   \n",
      "517  517        44911      savings       xxxx0660            2360.00   \n",
      "518  518        45254      savings       xxxx3292           18397.73   \n",
      "519  519        45254      savings       xxxx9779            5053.14   \n",
      "520  520        45260      unknown       xxxx-X28               0.00   \n",
      "521  521        45260      savings       xxxx-X29           39940.33   \n",
      "522  522        45480      savings       xxxx0084           47999.17   \n",
      "523  529        45757      savings       xxxx5500            7004.74   \n",
      "524  532        45774      savings       xxxx0440             172.36   \n",
      "525  537        46033      savings       xxxx2602              15.25   \n",
      "526  538        46083      savings       xxxx3254           59495.21   \n",
      "527  523        45524      savings       xxxx7711            6070.30   \n",
      "528  524        45527      savings       xxxx7711            6070.30   \n",
      "529  525        45527      savings       xxxx9117            2900.00   \n",
      "530  528        45573      savings       xxxx0361            3371.42   \n",
      "531  530        45767      savings       xxxx7711            6070.30   \n",
      "532  531        45767      savings       xxxx9117            2900.00   \n",
      "533  533        45786      savings       xxxx5104              32.82   \n",
      "534  534        45786      savings       xxxx4813           -7042.37   \n",
      "535  535        45786      savings       xxxx0440             172.36   \n",
      "536  536        45831      savings       xxxx-X17              38.27   \n",
      "537  527        45541           CD       xxxx2343           20059.00   \n",
      "\n",
      "     current_balance        maturity_date  \n",
      "0           21481.44                  NaN  \n",
      "1            4923.48                  NaN  \n",
      "2                NaN                  NaN  \n",
      "3          -66088.00                  NaN  \n",
      "4                NaN                  NaN  \n",
      "5                NaN                  NaN  \n",
      "6            7382.38                  NaN  \n",
      "7           24054.16                  NaN  \n",
      "8            3149.58                  NaN  \n",
      "9          159674.54                  NaN  \n",
      "10          44176.48                  NaN  \n",
      "11           1380.86                  NaN  \n",
      "12          15183.66                  NaN  \n",
      "13               NaN                  NaN  \n",
      "14               NaN                  NaN  \n",
      "15         658221.55                  NaN  \n",
      "16         658221.55                  NaN  \n",
      "17           5000.00                  NaN  \n",
      "18          26158.95                  NaN  \n",
      "19          21033.69  2016-05-15 00:00:00  \n",
      "20         107034.81  2016-05-09 00:00:00  \n",
      "21           6747.67  2018-10-29 00:00:00  \n",
      "22          77064.58  2018-10-29 00:00:00  \n",
      "23          14273.21  2017-04-22 00:00:00  \n",
      "24          26158.95                  NaN  \n",
      "25          21033.69  2016-05-15 00:00:00  \n",
      "26         107034.81  2016-05-09 00:00:00  \n",
      "27           6747.67  2018-10-29 00:00:00  \n",
      "28          77064.58  2018-10-29 00:00:00  \n",
      "29          14273.21  2017-04-22 00:00:00  \n",
      "..               ...                  ...  \n",
      "508           482.00                  NaN  \n",
      "509        164082.00                  NaN  \n",
      "510           130.83                  NaN  \n",
      "511              NaN                  NaN  \n",
      "512         62534.02                  NaN  \n",
      "513           482.00                  NaN  \n",
      "514        164082.00                  NaN  \n",
      "515           130.83                  NaN  \n",
      "516       1202096.04                  NaN  \n",
      "517          2360.00                  NaN  \n",
      "518         18397.73                  NaN  \n",
      "519          5053.14                  NaN  \n",
      "520              NaN                  NaN  \n",
      "521         39940.33                  NaN  \n",
      "522         47999.17                  NaN  \n",
      "523          7004.74                  NaN  \n",
      "524           172.36                  NaN  \n",
      "525              NaN                  NaN  \n",
      "526         59495.21                  NaN  \n",
      "527          6070.30                  NaN  \n",
      "528          6070.30                  NaN  \n",
      "529          2900.00                  NaN  \n",
      "530          3371.42                  NaN  \n",
      "531          6070.30                  NaN  \n",
      "532          2900.00                  NaN  \n",
      "533            32.82                  NaN  \n",
      "534              NaN                  NaN  \n",
      "535           172.36                  NaN  \n",
      "536            38.27                  NaN  \n",
      "537         20059.00  2018-03-04 00:00:00  \n",
      "\n",
      "[538 rows x 7 columns]\n"
     ]
    }
   ],
   "source": [
    "import pandas as pd \n",
    "from replace import rep\n",
    "a = pd.read_csv('user accounts.csv',delimiter=';')\n",
    "\n",
    "\n",
    "print a    \n",
    "a = rep(a,'available_balance',False,0)\n",
    "##timeoutlier(a,'available_balance')\n",
    "print a\n"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.11"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}