Read_txt_files.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#Read txt files line by line"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "It's nice, when we can import data from ASCII file with some nice tool like `pandas`, however there are many cases, when you have to parse data line by line by yourself."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Let's open some file that is already familiar:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "f = open('./Ham_tmin.txt')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "`f` is now just a file handler:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<open file './Ham_tmin.txt', mode 'r' at 0x103811540>"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "f"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Read lines to list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "lines = f.readlines()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['1891-01-01,-132\\n',\n",
       " '1891-01-02,-119\\n',\n",
       " '1891-01-03,-116\\n',\n",
       " '1891-01-04,-108\\n',\n",
       " '1891-01-05,-37\\n',\n",
       " '1891-01-06,-58\\n',\n",
       " '1891-01-07,-58\\n',\n",
       " '1891-01-08,-128\\n',\n",
       " '1891-01-09,-110\\n',\n",
       " '1891-01-10,-131\\n',\n",
       " '1891-01-11,-129\\n',\n",
       " '1891-01-12,-105\\n',\n",
       " '1891-01-13,10\\n',\n",
       " '1891-01-14,-3\\n',\n",
       " '1891-01-15,-47\\n',\n",
       " '1891-01-16,-117\\n',\n",
       " '1891-01-17,-128\\n',\n",
       " '1891-01-18,-81\\n',\n",
       " '1891-01-19,-86\\n',\n",
       " '1891-01-20,-70\\n',\n",
       " '1891-01-21,-40\\n',\n",
       " '1891-01-22,-61\\n',\n",
       " '1891-01-23,-60\\n',\n",
       " '1891-01-24,-32\\n',\n",
       " '1891-01-25,17\\n',\n",
       " '1891-01-26,8\\n',\n",
       " '1891-01-27,1\\n',\n",
       " '1891-01-28,19\\n',\n",
       " '1891-01-29,20\\n',\n",
       " '1891-01-30,26\\n',\n",
       " '1891-01-31,27\\n',\n",
       " '1891-02-01,32\\n',\n",
       " '1891-02-02,2\\n',\n",
       " '1891-02-03,7\\n',\n",
       " '1891-02-04,11\\n',\n",
       " '1891-02-05,-27\\n',\n",
       " '1891-02-06,-5\\n',\n",
       " '1891-02-07,2\\n',\n",
       " '1891-02-08,-28\\n',\n",
       " '1891-02-09,-31\\n',\n",
       " '1891-02-10,-44\\n',\n",
       " '1891-02-11,-21\\n',\n",
       " '1891-02-12,13\\n',\n",
       " '1891-02-13,-24\\n',\n",
       " '1891-02-14,-89\\n',\n",
       " '1891-02-15,-7\\n',\n",
       " '1891-02-16,18\\n',\n",
       " '1891-02-17,9\\n',\n",
       " '1891-02-18,11\\n',\n",
       " '1891-02-19,1\\n',\n",
       " '1891-02-20,-4\\n',\n",
       " '1891-02-21,-14\\n',\n",
       " '1891-02-22,-16\\n',\n",
       " '1891-02-23,-25\\n',\n",
       " '1891-02-24,-47\\n',\n",
       " '1891-02-25,-9\\n',\n",
       " '1891-02-26,6\\n',\n",
       " '1891-02-27,2\\n',\n",
       " '1891-02-28,-18\\n',\n",
       " '1891-03-01,22\\n',\n",
       " '1891-03-02,58\\n',\n",
       " '1891-03-03,22\\n',\n",
       " '1891-03-04,-1\\n',\n",
       " '1891-03-05,32\\n',\n",
       " '1891-03-06,53\\n',\n",
       " '1891-03-07,1\\n',\n",
       " '1891-03-08,1\\n',\n",
       " '1891-03-09,8\\n',\n",
       " '1891-03-10,-14\\n',\n",
       " '1891-03-11,6\\n',\n",
       " '1891-03-12,16\\n',\n",
       " '1891-03-13,-14\\n',\n",
       " '1891-03-14,8\\n',\n",
       " '1891-03-15,8\\n',\n",
       " '1891-03-16,11\\n',\n",
       " '1891-03-17,37\\n',\n",
       " '1891-03-18,9\\n',\n",
       " '1891-03-19,3\\n',\n",
       " '1891-03-20,-31\\n',\n",
       " '1891-03-21,-31\\n',\n",
       " '1891-03-22,-49\\n',\n",
       " '1891-03-23,-37\\n',\n",
       " '1891-03-24,-38\\n',\n",
       " '1891-03-25,1\\n',\n",
       " '1891-03-26,37\\n',\n",
       " '1891-03-27,5\\n',\n",
       " '1891-03-28,4\\n',\n",
       " '1891-03-29,6\\n',\n",
       " '1891-03-30,-15\\n',\n",
       " '1891-03-31,-9\\n',\n",
       " '1891-04-01,-26\\n',\n",
       " '1891-04-02,-16\\n',\n",
       " '1891-04-03,-7\\n',\n",
       " '1891-04-04,-10\\n',\n",
       " '1891-04-05,1\\n',\n",
       " '1891-04-06,13\\n',\n",
       " '1891-04-07,21\\n',\n",
       " '1891-04-08,60\\n',\n",
       " '1891-04-09,46\\n',\n",
       " '1891-04-10,36\\n',\n",
       " '1891-04-11,14\\n',\n",
       " '1891-04-12,21\\n',\n",
       " '1891-04-13,12\\n',\n",
       " '1891-04-14,15\\n',\n",
       " '1891-04-15,30\\n',\n",
       " '1891-04-16,32\\n',\n",
       " '1891-04-17,34\\n',\n",
       " '1891-04-18,6\\n',\n",
       " '1891-04-19,25\\n',\n",
       " '1891-04-20,19\\n',\n",
       " '1891-04-21,50\\n',\n",
       " '1891-04-22,31\\n',\n",
       " '1891-04-23,26\\n',\n",
       " '1891-04-24,31\\n',\n",
       " '1891-04-25,27\\n',\n",
       " '1891-04-26,22\\n',\n",
       " '1891-04-27,33\\n',\n",
       " '1891-04-28,61\\n',\n",
       " '1891-04-29,60\\n',\n",
       " '1891-04-30,70\\n',\n",
       " '1891-05-01,107\\n',\n",
       " '1891-05-02,101\\n',\n",
       " '1891-05-03,79\\n',\n",
       " '1891-05-04,64\\n',\n",
       " '1891-05-05,40\\n',\n",
       " '1891-05-06,64\\n',\n",
       " '1891-05-07,72\\n',\n",
       " '1891-05-08,86\\n',\n",
       " '1891-05-09,93\\n',\n",
       " '1891-05-10,92\\n',\n",
       " '1891-05-11,91\\n',\n",
       " '1891-05-12,67\\n',\n",
       " '1891-05-13,66\\n',\n",
       " '1891-05-14,90\\n',\n",
       " '1891-05-15,66\\n',\n",
       " '1891-05-16,47\\n',\n",
       " '1891-05-17,14\\n',\n",
       " '1891-05-18,23\\n',\n",
       " '1891-05-19,70\\n',\n",
       " '1891-05-20,57\\n',\n",
       " '1891-05-21,95\\n',\n",
       " '1891-05-22,122\\n',\n",
       " '1891-05-23,80\\n',\n",
       " '1891-05-24,102\\n',\n",
       " '1891-05-25,101\\n',\n",
       " '1891-05-26,112\\n',\n",
       " '1891-05-27,83\\n',\n",
       " '1891-05-28,85\\n',\n",
       " '1891-05-29,91\\n',\n",
       " '1891-05-30,123\\n',\n",
       " '1891-05-31,131\\n',\n",
       " '1891-06-01,113\\n',\n",
       " '1891-06-02,111\\n',\n",
       " '1891-06-03,97\\n',\n",
       " '1891-06-04,68\\n',\n",
       " '1891-06-05,60\\n',\n",
       " '1891-06-06,78\\n',\n",
       " '1891-06-07,65\\n',\n",
       " '1891-06-08,104\\n',\n",
       " '1891-06-09,95\\n',\n",
       " '1891-06-10,101\\n',\n",
       " '1891-06-11,93\\n',\n",
       " '1891-06-12,77\\n',\n",
       " '1891-06-13,65\\n',\n",
       " '1891-06-14,97\\n',\n",
       " '1891-06-15,85\\n',\n",
       " '1891-06-16,83\\n',\n",
       " '1891-06-17,77\\n',\n",
       " '1891-06-18,81\\n',\n",
       " '1891-06-19,129\\n',\n",
       " '1891-06-20,107\\n',\n",
       " '1891-06-21,131\\n',\n",
       " '1891-06-22,131\\n',\n",
       " '1891-06-23,126\\n',\n",
       " '1891-06-24,129\\n',\n",
       " '1891-06-25,144\\n',\n",
       " '1891-06-26,171\\n',\n",
       " '1891-06-27,181\\n',\n",
       " '1891-06-28,131\\n',\n",
       " '1891-06-29,139\\n',\n",
       " '1891-06-30,180\\n',\n",
       " '1891-07-01,170\\n',\n",
       " '1891-07-02,166\\n',\n",
       " '1891-07-03,138\\n',\n",
       " '1891-07-04,164\\n',\n",
       " '1891-07-05,122\\n',\n",
       " '1891-07-06,145\\n',\n",
       " '1891-07-07,151\\n',\n",
       " '1891-07-08,124\\n',\n",
       " '1891-07-09,120\\n',\n",
       " '1891-07-10,137\\n',\n",
       " '1891-07-11,123\\n',\n",
       " '1891-07-12,113\\n',\n",
       " '1891-07-13,119\\n',\n",
       " '1891-07-14,133\\n',\n",
       " '1891-07-15,151\\n',\n",
       " '1891-07-16,165\\n',\n",
       " '1891-07-17,153\\n',\n",
       " '1891-07-18,160\\n',\n",
       " '1891-07-19,174\\n',\n",
       " '1891-07-20,141\\n',\n",
       " '1891-07-21,153\\n',\n",
       " '1891-07-22,151\\n',\n",
       " '1891-07-23,148\\n',\n",
       " '1891-07-24,124\\n',\n",
       " '1891-07-25,136\\n',\n",
       " '1891-07-26,131\\n',\n",
       " '1891-07-27,136\\n',\n",
       " '1891-07-28,131\\n',\n",
       " '1891-07-29,103\\n',\n",
       " '1891-07-30,129\\n',\n",
       " '1891-07-31,121\\n',\n",
       " '1891-08-01,113\\n',\n",
       " '1891-08-02,124\\n',\n",
       " '1891-08-03,133\\n',\n",
       " '1891-08-04,121\\n',\n",
       " '1891-08-05,104\\n',\n",
       " '1891-08-06,117\\n',\n",
       " '1891-08-07,110\\n',\n",
       " '1891-08-08,121\\n',\n",
       " '1891-08-09,143\\n',\n",
       " '1891-08-10,143\\n',\n",
       " '1891-08-11,119\\n',\n",
       " '1891-08-12,116\\n',\n",
       " '1891-08-13,129\\n',\n",
       " '1891-08-14,118\\n',\n",
       " '1891-08-15,143\\n',\n",
       " '1891-08-16,125\\n',\n",
       " '1891-08-17,132\\n',\n",
       " '1891-08-18,124\\n',\n",
       " '1891-08-19,131\\n',\n",
       " '1891-08-20,110\\n',\n",
       " '1891-08-21,112\\n',\n",
       " '1891-08-22,130\\n',\n",
       " '1891-08-23,112\\n',\n",
       " '1891-08-24,136\\n',\n",
       " '1891-08-25,116\\n',\n",
       " '1891-08-26,142\\n',\n",
       " '1891-08-27,171\\n',\n",
       " '1891-08-28,171\\n',\n",
       " '1891-08-29,131\\n',\n",
       " '1891-08-30,101\\n',\n",
       " '1891-08-31,123\\n',\n",
       " '1891-09-01,136\\n',\n",
       " '1891-09-02,130\\n',\n",
       " '1891-09-03,129\\n',\n",
       " '1891-09-04,171\\n',\n",
       " '1891-09-05,128\\n',\n",
       " '1891-09-06,111\\n',\n",
       " '1891-09-07,119\\n',\n",
       " '1891-09-08,81\\n',\n",
       " '1891-09-09,119\\n',\n",
       " '1891-09-10,127\\n',\n",
       " '1891-09-11,121\\n',\n",
       " '1891-09-12,107\\n',\n",
       " '1891-09-13,121\\n',\n",
       " '1891-09-14,137\\n',\n",
       " '1891-09-15,161\\n',\n",
       " '1891-09-16,111\\n',\n",
       " '1891-09-17,131\\n',\n",
       " '1891-09-18,141\\n',\n",
       " '1891-09-19,145\\n',\n",
       " '1891-09-20,151\\n',\n",
       " '1891-09-21,146\\n',\n",
       " '1891-09-22,104\\n',\n",
       " '1891-09-23,101\\n',\n",
       " '1891-09-24,71\\n',\n",
       " '1891-09-25,62\\n',\n",
       " '1891-09-26,125\\n',\n",
       " '1891-09-27,128\\n',\n",
       " '1891-09-28,91\\n',\n",
       " '1891-09-29,101\\n',\n",
       " '1891-09-30,121\\n',\n",
       " '1891-10-01,116\\n',\n",
       " '1891-10-02,141\\n',\n",
       " '1891-10-03,82\\n',\n",
       " '1891-10-04,66\\n',\n",
       " '1891-10-05,71\\n',\n",
       " '1891-10-06,79\\n',\n",
       " '1891-10-07,104\\n',\n",
       " '1891-10-08,114\\n',\n",
       " '1891-10-09,66\\n',\n",
       " '1891-10-10,107\\n',\n",
       " '1891-10-11,97\\n',\n",
       " '1891-10-12,107\\n',\n",
       " '1891-10-13,106\\n',\n",
       " '1891-10-14,94\\n',\n",
       " '1891-10-15,88\\n',\n",
       " '1891-10-16,80\\n',\n",
       " '1891-10-17,98\\n',\n",
       " '1891-10-18,68\\n',\n",
       " '1891-10-19,60\\n',\n",
       " '1891-10-20,97\\n',\n",
       " '1891-10-21,104\\n',\n",
       " '1891-10-22,113\\n',\n",
       " '1891-10-23,117\\n',\n",
       " '1891-10-24,79\\n',\n",
       " '1891-10-25,88\\n',\n",
       " '1891-10-26,103\\n',\n",
       " '1891-10-27,62\\n',\n",
       " '1891-10-28,9\\n',\n",
       " '1891-10-29,12\\n',\n",
       " '1891-10-30,-21\\n',\n",
       " '1891-10-31,-1\\n',\n",
       " '1891-11-01,33\\n',\n",
       " '1891-11-02,40\\n',\n",
       " '1891-11-03,36\\n',\n",
       " '1891-11-04,39\\n',\n",
       " '1891-11-05,-10\\n',\n",
       " '1891-11-06,-17\\n',\n",
       " '1891-11-07,30\\n',\n",
       " '1891-11-08,-6\\n',\n",
       " '1891-11-09,-28\\n',\n",
       " '1891-11-10,-13\\n',\n",
       " '1891-11-11,8\\n',\n",
       " '1891-11-12,45\\n',\n",
       " '1891-11-13,7\\n',\n",
       " '1891-11-14,42\\n',\n",
       " '1891-11-15,40\\n',\n",
       " '1891-11-16,52\\n',\n",
       " '1891-11-17,59\\n',\n",
       " '1891-11-18,26\\n',\n",
       " '1891-11-19,40\\n',\n",
       " '1891-11-20,90\\n',\n",
       " '1891-11-21,60\\n',\n",
       " '1891-11-22,34\\n',\n",
       " '1891-11-23,31\\n',\n",
       " '1891-11-24,-8\\n',\n",
       " '1891-11-25,4\\n',\n",
       " '1891-11-26,15\\n',\n",
       " '1891-11-27,5\\n',\n",
       " '1891-11-28,1\\n',\n",
       " '1891-11-29,-15\\n',\n",
       " '1891-11-30,6\\n',\n",
       " '1891-12-01,28\\n',\n",
       " '1891-12-02,11\\n',\n",
       " '1891-12-03,21\\n',\n",
       " '1891-12-04,61\\n',\n",
       " '1891-12-05,62\\n',\n",
       " '1891-12-06,104\\n',\n",
       " '1891-12-07,31\\n',\n",
       " '1891-12-08,49\\n',\n",
       " '1891-12-09,30\\n',\n",
       " '1891-12-10,51\\n',\n",
       " '1891-12-11,52\\n',\n",
       " '1891-12-12,12\\n',\n",
       " '1891-12-13,13\\n',\n",
       " '1891-12-14,44\\n',\n",
       " '1891-12-15,25\\n',\n",
       " '1891-12-16,7\\n',\n",
       " '1891-12-17,-11\\n',\n",
       " '1891-12-18,-25\\n',\n",
       " '1891-12-19,-34\\n',\n",
       " '1891-12-20,-29\\n',\n",
       " '1891-12-21,-49\\n',\n",
       " '1891-12-22,-44\\n',\n",
       " '1891-12-23,-44\\n',\n",
       " '1891-12-24,-52\\n',\n",
       " '1891-12-25,-44\\n',\n",
       " '1891-12-26,-19\\n',\n",
       " '1891-12-27,9\\n',\n",
       " '1891-12-28,20\\n',\n",
       " '1891-12-29,-3\\n',\n",
       " '1891-12-30,11\\n',\n",
       " '1891-12-31,17\\n',\n",
       " '1892-01-01,23\\n',\n",
       " '1892-01-02,-17\\n',\n",
       " '1892-01-03,16\\n',\n",
       " '1892-01-04,7\\n',\n",
       " '1892-01-05,2\\n',\n",
       " '1892-01-06,-4\\n',\n",
       " '1892-01-07,-25\\n',\n",
       " '1892-01-08,-14\\n',\n",
       " '1892-01-09,-41\\n',\n",
       " '1892-01-10,-29\\n',\n",
       " '1892-01-11,-29\\n',\n",
       " '1892-01-12,-49\\n',\n",
       " '1892-01-13,-57\\n',\n",
       " '1892-01-14,-112\\n',\n",
       " '1892-01-15,-124\\n',\n",
       " '1892-01-16,-89\\n',\n",
       " '1892-01-17,-71\\n',\n",
       " '1892-01-18,-110\\n',\n",
       " '1892-01-19,-95\\n',\n",
       " '1892-01-20,-99\\n',\n",
       " '1892-01-21,-121\\n',\n",
       " '1892-01-22,-151\\n',\n",
       " '1892-01-23,-59\\n',\n",
       " '1892-01-24,-19\\n',\n",
       " '1892-01-25,-5\\n',\n",
       " '1892-01-26,3\\n',\n",
       " '1892-01-27,5\\n',\n",
       " '1892-01-28,20\\n',\n",
       " '1892-01-29,21\\n',\n",
       " '1892-01-30,55\\n',\n",
       " '1892-01-31,39\\n',\n",
       " '1892-02-01,6\\n',\n",
       " '1892-02-02,31\\n',\n",
       " '1892-02-03,2\\n',\n",
       " '1892-02-04,1\\n',\n",
       " '1892-02-05,-1\\n',\n",
       " '1892-02-06,11\\n',\n",
       " '1892-02-07,2\\n',\n",
       " '1892-02-08,4\\n',\n",
       " '1892-02-09,-31\\n',\n",
       " '1892-02-10,-17\\n',\n",
       " '1892-02-11,-4\\n',\n",
       " '1892-02-12,46\\n',\n",
       " '1892-02-13,11\\n',\n",
       " '1892-02-14,-19\\n',\n",
       " '1892-02-15,-41\\n',\n",
       " '1892-02-16,-66\\n',\n",
       " '1892-02-17,-100\\n',\n",
       " '1892-02-18,-74\\n',\n",
       " '1892-02-19,-89\\n',\n",
       " '1892-02-20,-27\\n',\n",
       " '1892-02-21,-9\\n',\n",
       " '1892-02-22,1\\n',\n",
       " '1892-02-23,15\\n',\n",
       " '1892-02-24,16\\n',\n",
       " '1892-02-25,6\\n',\n",
       " '1892-02-26,10\\n',\n",
       " '1892-02-27,11\\n',\n",
       " '1892-02-28,13\\n',\n",
       " '1892-02-29,13\\n',\n",
       " '1892-03-01,-1\\n',\n",
       " '1892-03-02,-38\\n',\n",
       " '1892-03-03,-51\\n',\n",
       " '1892-03-04,-39\\n',\n",
       " '1892-03-05,-33\\n',\n",
       " '1892-03-06,-44\\n',\n",
       " '1892-03-07,-77\\n',\n",
       " '1892-03-08,-35\\n',\n",
       " '1892-03-09,-34\\n',\n",
       " '1892-03-10,-41\\n',\n",
       " '1892-03-11,-40\\n',\n",
       " '1892-03-12,-17\\n',\n",
       " '1892-03-13,-30\\n',\n",
       " '1892-03-14,-48\\n',\n",
       " '1892-03-15,-9\\n',\n",
       " '1892-03-16,-19\\n',\n",
       " '1892-03-17,-11\\n',\n",
       " '1892-03-18,1\\n',\n",
       " '1892-03-19,11\\n',\n",
       " '1892-03-20,4\\n',\n",
       " '1892-03-21,10\\n',\n",
       " '1892-03-22,14\\n',\n",
       " '1892-03-23,5\\n',\n",
       " '1892-03-24,13\\n',\n",
       " '1892-03-25,41\\n',\n",
       " '1892-03-26,13\\n',\n",
       " '1892-03-27,33\\n',\n",
       " '1892-03-28,9\\n',\n",
       " '1892-03-29,-14\\n',\n",
       " '1892-03-30,-24\\n',\n",
       " '1892-03-31,1\\n',\n",
       " '1892-04-01,27\\n',\n",
       " '1892-04-02,41\\n',\n",
       " '1892-04-03,31\\n',\n",
       " '1892-04-04,31\\n',\n",
       " '1892-04-05,61\\n',\n",
       " '1892-04-06,46\\n',\n",
       " '1892-04-07,56\\n',\n",
       " '1892-04-08,31\\n',\n",
       " '1892-04-09,11\\n',\n",
       " '1892-04-10,26\\n',\n",
       " '1892-04-11,51\\n',\n",
       " '1892-04-12,31\\n',\n",
       " '1892-04-13,5\\n',\n",
       " '1892-04-14,-12\\n',\n",
       " '1892-04-15,-14\\n',\n",
       " '1892-04-16,-9\\n',\n",
       " '1892-04-17,19\\n',\n",
       " '1892-04-18,2\\n',\n",
       " '1892-04-19,21\\n',\n",
       " '1892-04-20,-8\\n',\n",
       " '1892-04-21,33\\n',\n",
       " '1892-04-22,66\\n',\n",
       " '1892-04-23,61\\n',\n",
       " '1892-04-24,39\\n',\n",
       " '1892-04-25,19\\n',\n",
       " '1892-04-26,24\\n',\n",
       " '1892-04-27,33\\n',\n",
       " '1892-04-28,15\\n',\n",
       " '1892-04-29,61\\n',\n",
       " '1892-04-30,4\\n',\n",
       " '1892-05-01,8\\n',\n",
       " '1892-05-02,58\\n',\n",
       " '1892-05-03,52\\n',\n",
       " '1892-05-04,66\\n',\n",
       " '1892-05-05,41\\n',\n",
       " '1892-05-06,11\\n',\n",
       " '1892-05-07,-2\\n',\n",
       " '1892-05-08,45\\n',\n",
       " '1892-05-09,77\\n',\n",
       " '1892-05-10,79\\n',\n",
       " '1892-05-11,89\\n',\n",
       " '1892-05-12,49\\n',\n",
       " '1892-05-13,40\\n',\n",
       " '1892-05-14,74\\n',\n",
       " '1892-05-15,79\\n',\n",
       " '1892-05-16,92\\n',\n",
       " '1892-05-17,75\\n',\n",
       " '1892-05-18,46\\n',\n",
       " '1892-05-19,86\\n',\n",
       " '1892-05-20,57\\n',\n",
       " '1892-05-21,73\\n',\n",
       " '1892-05-22,30\\n',\n",
       " '1892-05-23,32\\n',\n",
       " '1892-05-24,104\\n',\n",
       " '1892-05-25,136\\n',\n",
       " '1892-05-26,157\\n',\n",
       " '1892-05-27,182\\n',\n",
       " '1892-05-28,161\\n',\n",
       " '1892-05-29,194\\n',\n",
       " '1892-05-30,138\\n',\n",
       " '1892-05-31,151\\n',\n",
       " '1892-06-01,169\\n',\n",
       " '1892-06-02,111\\n',\n",
       " '1892-06-03,161\\n',\n",
       " '1892-06-04,91\\n',\n",
       " '1892-06-05,112\\n',\n",
       " '1892-06-06,117\\n',\n",
       " '1892-06-07,89\\n',\n",
       " '1892-06-08,82\\n',\n",
       " '1892-06-09,126\\n',\n",
       " '1892-06-10,121\\n',\n",
       " '1892-06-11,100\\n',\n",
       " '1892-06-12,101\\n',\n",
       " '1892-06-13,79\\n',\n",
       " '1892-06-14,72\\n',\n",
       " '1892-06-15,62\\n',\n",
       " '1892-06-16,68\\n',\n",
       " '1892-06-17,102\\n',\n",
       " '1892-06-18,93\\n',\n",
       " '1892-06-19,65\\n',\n",
       " '1892-06-20,100\\n',\n",
       " '1892-06-21,109\\n',\n",
       " '1892-06-22,95\\n',\n",
       " '1892-06-23,125\\n',\n",
       " '1892-06-24,113\\n',\n",
       " '1892-06-25,90\\n',\n",
       " '1892-06-26,121\\n',\n",
       " '1892-06-27,150\\n',\n",
       " '1892-06-28,166\\n',\n",
       " '1892-06-29,149\\n',\n",
       " '1892-06-30,106\\n',\n",
       " '1892-07-01,89\\n',\n",
       " '1892-07-02,115\\n',\n",
       " '1892-07-03,110\\n',\n",
       " '1892-07-04,152\\n',\n",
       " '1892-07-05,137\\n',\n",
       " '1892-07-06,151\\n',\n",
       " '1892-07-07,124\\n',\n",
       " '1892-07-08,139\\n',\n",
       " '1892-07-09,121\\n',\n",
       " '1892-07-10,131\\n',\n",
       " '1892-07-11,99\\n',\n",
       " '1892-07-12,113\\n',\n",
       " '1892-07-13,131\\n',\n",
       " '1892-07-14,141\\n',\n",
       " '1892-07-15,128\\n',\n",
       " '1892-07-16,116\\n',\n",
       " '1892-07-17,101\\n',\n",
       " '1892-07-18,112\\n',\n",
       " '1892-07-19,100\\n',\n",
       " '1892-07-20,101\\n',\n",
       " '1892-07-21,100\\n',\n",
       " '1892-07-22,110\\n',\n",
       " '1892-07-23,121\\n',\n",
       " '1892-07-24,126\\n',\n",
       " '1892-07-25,101\\n',\n",
       " '1892-07-26,114\\n',\n",
       " '1892-07-27,101\\n',\n",
       " '1892-07-28,98\\n',\n",
       " '1892-07-29,155\\n',\n",
       " '1892-07-30,153\\n',\n",
       " '1892-07-31,129\\n',\n",
       " '1892-08-01,122\\n',\n",
       " '1892-08-02,139\\n',\n",
       " '1892-08-03,128\\n',\n",
       " '1892-08-04,128\\n',\n",
       " '1892-08-05,99\\n',\n",
       " '1892-08-06,118\\n',\n",
       " '1892-08-07,116\\n',\n",
       " '1892-08-08,89\\n',\n",
       " '1892-08-09,149\\n',\n",
       " '1892-08-10,124\\n',\n",
       " '1892-08-11,108\\n',\n",
       " '1892-08-12,115\\n',\n",
       " '1892-08-13,113\\n',\n",
       " '1892-08-14,159\\n',\n",
       " '1892-08-15,145\\n',\n",
       " '1892-08-16,125\\n',\n",
       " '1892-08-17,171\\n',\n",
       " '1892-08-18,140\\n',\n",
       " '1892-08-19,167\\n',\n",
       " '1892-08-20,174\\n',\n",
       " '1892-08-21,150\\n',\n",
       " '1892-08-22,137\\n',\n",
       " '1892-08-23,180\\n',\n",
       " '1892-08-24,193\\n',\n",
       " '1892-08-25,211\\n',\n",
       " '1892-08-26,157\\n',\n",
       " '1892-08-27,104\\n',\n",
       " '1892-08-28,140\\n',\n",
       " '1892-08-29,101\\n',\n",
       " '1892-08-30,147\\n',\n",
       " '1892-08-31,163\\n',\n",
       " '1892-09-01,123\\n',\n",
       " '1892-09-02,129\\n',\n",
       " '1892-09-03,128\\n',\n",
       " '1892-09-04,96\\n',\n",
       " '1892-09-05,91\\n',\n",
       " '1892-09-06,89\\n',\n",
       " '1892-09-07,69\\n',\n",
       " '1892-09-08,93\\n',\n",
       " '1892-09-09,91\\n',\n",
       " '1892-09-10,71\\n',\n",
       " '1892-09-11,121\\n',\n",
       " '1892-09-12,134\\n',\n",
       " '1892-09-13,127\\n',\n",
       " '1892-09-14,143\\n',\n",
       " '1892-09-15,83\\n',\n",
       " '1892-09-16,129\\n',\n",
       " '1892-09-17,133\\n',\n",
       " '1892-09-18,96\\n',\n",
       " '1892-09-19,76\\n',\n",
       " '1892-09-20,121\\n',\n",
       " '1892-09-21,141\\n',\n",
       " '1892-09-22,142\\n',\n",
       " '1892-09-23,147\\n',\n",
       " '1892-09-24,131\\n',\n",
       " '1892-09-25,88\\n',\n",
       " '1892-09-26,110\\n',\n",
       " '1892-09-27,106\\n',\n",
       " '1892-09-28,143\\n',\n",
       " '1892-09-29,89\\n',\n",
       " '1892-09-30,76\\n',\n",
       " '1892-10-01,105\\n',\n",
       " '1892-10-02,131\\n',\n",
       " '1892-10-03,81\\n',\n",
       " '1892-10-04,55\\n',\n",
       " '1892-10-05,69\\n',\n",
       " '1892-10-06,114\\n',\n",
       " '1892-10-07,97\\n',\n",
       " '1892-10-08,82\\n',\n",
       " '1892-10-09,71\\n',\n",
       " '1892-10-10,76\\n',\n",
       " '1892-10-11,74\\n',\n",
       " '1892-10-12,77\\n',\n",
       " '1892-10-13,63\\n',\n",
       " '1892-10-14,78\\n',\n",
       " '1892-10-15,85\\n',\n",
       " '1892-10-16,73\\n',\n",
       " '1892-10-17,49\\n',\n",
       " '1892-10-18,17\\n',\n",
       " '1892-10-19,25\\n',\n",
       " '1892-10-20,31\\n',\n",
       " '1892-10-21,40\\n',\n",
       " '1892-10-22,1\\n',\n",
       " '1892-10-23,19\\n',\n",
       " '1892-10-24,11\\n',\n",
       " '1892-10-25,36\\n',\n",
       " '1892-10-26,1\\n',\n",
       " '1892-10-27,-14\\n',\n",
       " '1892-10-28,41\\n',\n",
       " '1892-10-29,111\\n',\n",
       " '1892-10-30,113\\n',\n",
       " '1892-10-31,88\\n',\n",
       " '1892-11-01,90\\n',\n",
       " '1892-11-02,61\\n',\n",
       " '1892-11-03,61\\n',\n",
       " '1892-11-04,75\\n',\n",
       " '1892-11-05,36\\n',\n",
       " '1892-11-06,49\\n',\n",
       " '1892-11-07,35\\n',\n",
       " '1892-11-08,40\\n',\n",
       " '1892-11-09,68\\n',\n",
       " '1892-11-10,52\\n',\n",
       " '1892-11-11,51\\n',\n",
       " '1892-11-12,9\\n',\n",
       " '1892-11-13,26\\n',\n",
       " '1892-11-14,-2\\n',\n",
       " '1892-11-15,-11\\n',\n",
       " '1892-11-16,19\\n',\n",
       " '1892-11-17,0\\n',\n",
       " '1892-11-18,-21\\n',\n",
       " '1892-11-19,-14\\n',\n",
       " '1892-11-20,-12\\n',\n",
       " '1892-11-21,-21\\n',\n",
       " '1892-11-22,-35\\n',\n",
       " '1892-11-23,-54\\n',\n",
       " '1892-11-24,-35\\n',\n",
       " '1892-11-25,-20\\n',\n",
       " '1892-11-26,-61\\n',\n",
       " '1892-11-27,-84\\n',\n",
       " '1892-11-28,-60\\n',\n",
       " '1892-11-29,36\\n',\n",
       " '1892-11-30,29\\n',\n",
       " '1892-12-01,4\\n',\n",
       " '1892-12-02,-25\\n',\n",
       " '1892-12-03,-64\\n',\n",
       " '1892-12-04,-21\\n',\n",
       " '1892-12-05,-19\\n',\n",
       " '1892-12-06,-49\\n',\n",
       " '1892-12-07,-31\\n',\n",
       " '1892-12-08,-31\\n',\n",
       " '1892-12-09,-3\\n',\n",
       " '1892-12-10,-48\\n',\n",
       " '1892-12-11,-105\\n',\n",
       " '1892-12-12,-54\\n',\n",
       " '1892-12-13,6\\n',\n",
       " '1892-12-14,-19\\n',\n",
       " '1892-12-15,5\\n',\n",
       " '1892-12-16,30\\n',\n",
       " '1892-12-17,28\\n',\n",
       " '1892-12-18,52\\n',\n",
       " '1892-12-19,48\\n',\n",
       " '1892-12-20,39\\n',\n",
       " '1892-12-21,-10\\n',\n",
       " '1892-12-22,11\\n',\n",
       " '1892-12-23,-42\\n',\n",
       " '1892-12-24,-77\\n',\n",
       " '1892-12-25,-87\\n',\n",
       " '1892-12-26,-77\\n',\n",
       " '1892-12-27,-34\\n',\n",
       " '1892-12-28,-20\\n',\n",
       " '1892-12-29,-3\\n',\n",
       " '1892-12-30,-11\\n',\n",
       " '1892-12-31,-68\\n',\n",
       " '1893-01-01,-81\\n',\n",
       " '1893-01-02,-79\\n',\n",
       " '1893-01-03,-131\\n',\n",
       " '1893-01-04,-148\\n',\n",
       " '1893-01-05,-49\\n',\n",
       " '1893-01-06,-41\\n',\n",
       " '1893-01-07,-118\\n',\n",
       " '1893-01-08,-139\\n',\n",
       " '1893-01-09,-92\\n',\n",
       " '1893-01-10,-79\\n',\n",
       " '1893-01-11,-91\\n',\n",
       " '1893-01-12,-149\\n',\n",
       " '1893-01-13,-98\\n',\n",
       " '1893-01-14,-59\\n',\n",
       " '1893-01-15,-119\\n',\n",
       " '1893-01-16,-151\\n',\n",
       " '1893-01-17,-137\\n',\n",
       " '1893-01-18,-184\\n',\n",
       " '1893-01-19,-182\\n',\n",
       " '1893-01-20,-182\\n',\n",
       " '1893-01-21,-37\\n',\n",
       " '1893-01-22,-88\\n',\n",
       " '1893-01-23,-66\\n',\n",
       " '1893-01-24,-107\\n',\n",
       " '1893-01-25,17\\n',\n",
       " '1893-01-26,8\\n',\n",
       " '1893-01-27,-6\\n',\n",
       " '1893-01-28,7\\n',\n",
       " '1893-01-29,-38\\n',\n",
       " '1893-01-30,11\\n',\n",
       " '1893-01-31,19\\n',\n",
       " '1893-02-01,39\\n',\n",
       " '1893-02-02,11\\n',\n",
       " '1893-02-03,-31\\n',\n",
       " '1893-02-04,-46\\n',\n",
       " '1893-02-05,-89\\n',\n",
       " '1893-02-06,-42\\n',\n",
       " '1893-02-07,-54\\n',\n",
       " '1893-02-08,6\\n',\n",
       " '1893-02-09,1\\n',\n",
       " '1893-02-10,19\\n',\n",
       " '1893-02-11,26\\n',\n",
       " '1893-02-12,-13\\n',\n",
       " '1893-02-13,-49\\n',\n",
       " '1893-02-14,0\\n',\n",
       " '1893-02-15,31\\n',\n",
       " '1893-02-16,40\\n',\n",
       " '1893-02-17,29\\n',\n",
       " '1893-02-18,12\\n',\n",
       " '1893-02-19,40\\n',\n",
       " '1893-02-20,42\\n',\n",
       " '1893-02-21,31\\n',\n",
       " '1893-02-22,6\\n',\n",
       " '1893-02-23,-39\\n',\n",
       " '1893-02-24,-80\\n',\n",
       " '1893-02-25,-29\\n',\n",
       " '1893-02-26,1\\n',\n",
       " '1893-02-27,26\\n',\n",
       " '1893-02-28,50\\n',\n",
       " '1893-03-01,-9\\n',\n",
       " '1893-03-02,46\\n',\n",
       " '1893-03-03,6\\n',\n",
       " '1893-03-04,-16\\n',\n",
       " '1893-03-05,37\\n',\n",
       " '1893-03-06,35\\n',\n",
       " '1893-03-07,4\\n',\n",
       " '1893-03-08,43\\n',\n",
       " '1893-03-09,20\\n',\n",
       " '1893-03-10,34\\n',\n",
       " '1893-03-11,11\\n',\n",
       " '1893-03-12,28\\n',\n",
       " '1893-03-13,51\\n',\n",
       " '1893-03-14,32\\n',\n",
       " '1893-03-15,69\\n',\n",
       " '1893-03-16,70\\n',\n",
       " '1893-03-17,13\\n',\n",
       " '1893-03-18,-12\\n',\n",
       " '1893-03-19,-19\\n',\n",
       " '1893-03-20,-7\\n',\n",
       " '1893-03-21,31\\n',\n",
       " '1893-03-22,18\\n',\n",
       " '1893-03-23,21\\n',\n",
       " '1893-03-24,28\\n',\n",
       " '1893-03-25,13\\n',\n",
       " '1893-03-26,-11\\n',\n",
       " '1893-03-27,-5\\n',\n",
       " '1893-03-28,4\\n',\n",
       " '1893-03-29,1\\n',\n",
       " '1893-03-30,6\\n',\n",
       " '1893-03-31,31\\n',\n",
       " '1893-04-01,47\\n',\n",
       " '1893-04-02,50\\n',\n",
       " '1893-04-03,41\\n',\n",
       " '1893-04-04,48\\n',\n",
       " '1893-04-05,18\\n',\n",
       " '1893-04-06,11\\n',\n",
       " '1893-04-07,63\\n',\n",
       " '1893-04-08,16\\n',\n",
       " '1893-04-09,51\\n',\n",
       " '1893-04-10,59\\n',\n",
       " '1893-04-11,13\\n',\n",
       " '1893-04-12,-7\\n',\n",
       " '1893-04-13,19\\n',\n",
       " '1893-04-14,0\\n',\n",
       " '1893-04-15,37\\n',\n",
       " '1893-04-16,46\\n',\n",
       " '1893-04-17,15\\n',\n",
       " '1893-04-18,-3\\n',\n",
       " '1893-04-19,39\\n',\n",
       " '1893-04-20,99\\n',\n",
       " '1893-04-21,61\\n',\n",
       " '1893-04-22,36\\n',\n",
       " '1893-04-23,71\\n',\n",
       " '1893-04-24,58\\n',\n",
       " '1893-04-25,58\\n',\n",
       " '1893-04-26,86\\n',\n",
       " '1893-04-27,51\\n',\n",
       " '1893-04-28,61\\n',\n",
       " '1893-04-29,25\\n',\n",
       " '1893-04-30,69\\n',\n",
       " '1893-05-01,42\\n',\n",
       " '1893-05-02,40\\n',\n",
       " '1893-05-03,68\\n',\n",
       " '1893-05-04,41\\n',\n",
       " '1893-05-05,19\\n',\n",
       " '1893-05-06,31\\n',\n",
       " '1893-05-07,22\\n',\n",
       " '1893-05-08,65\\n',\n",
       " '1893-05-09,61\\n',\n",
       " '1893-05-10,66\\n',\n",
       " '1893-05-11,51\\n',\n",
       " '1893-05-12,81\\n',\n",
       " '1893-05-13,114\\n',\n",
       " '1893-05-14,59\\n',\n",
       " '1893-05-15,120\\n',\n",
       " '1893-05-16,102\\n',\n",
       " '1893-05-17,155\\n',\n",
       " '1893-05-18,146\\n',\n",
       " '1893-05-19,132\\n',\n",
       " '1893-05-20,106\\n',\n",
       " '1893-05-21,111\\n',\n",
       " '1893-05-22,73\\n',\n",
       " '1893-05-23,131\\n',\n",
       " '1893-05-24,101\\n',\n",
       " '1893-05-25,103\\n',\n",
       " '1893-05-26,94\\n',\n",
       " '1893-05-27,89\\n',\n",
       " '1893-05-28,99\\n',\n",
       " '1893-05-29,75\\n',\n",
       " '1893-05-30,84\\n',\n",
       " '1893-05-31,46\\n',\n",
       " '1893-06-01,75\\n',\n",
       " '1893-06-02,74\\n',\n",
       " '1893-06-03,66\\n',\n",
       " '1893-06-04,103\\n',\n",
       " '1893-06-05,109\\n',\n",
       " '1893-06-06,86\\n',\n",
       " '1893-06-07,80\\n',\n",
       " '1893-06-08,83\\n',\n",
       " '1893-06-09,106\\n',\n",
       " '1893-06-10,119\\n',\n",
       " '1893-06-11,110\\n',\n",
       " '1893-06-12,94\\n',\n",
       " '1893-06-13,111\\n',\n",
       " '1893-06-14,126\\n',\n",
       " '1893-06-15,150\\n',\n",
       " '1893-06-16,141\\n',\n",
       " '1893-06-17,157\\n',\n",
       " '1893-06-18,134\\n',\n",
       " '1893-06-19,134\\n',\n",
       " '1893-06-20,122\\n',\n",
       " '1893-06-21,112\\n',\n",
       " '1893-06-22,112\\n',\n",
       " '1893-06-23,131\\n',\n",
       " '1893-06-24,137\\n',\n",
       " '1893-06-25,116\\n',\n",
       " '1893-06-26,102\\n',\n",
       " '1893-06-27,94\\n',\n",
       " '1893-06-28,170\\n',\n",
       " '1893-06-29,156\\n',\n",
       " '1893-06-30,152\\n',\n",
       " '1893-07-01,135\\n',\n",
       " '1893-07-02,120\\n',\n",
       " '1893-07-03,116\\n',\n",
       " '1893-07-04,150\\n',\n",
       " '1893-07-05,111\\n',\n",
       " '1893-07-06,133\\n',\n",
       " '1893-07-07,154\\n',\n",
       " '1893-07-08,177\\n',\n",
       " '1893-07-09,182\\n',\n",
       " '1893-07-10,171\\n',\n",
       " '1893-07-11,171\\n',\n",
       " '1893-07-12,158\\n',\n",
       " '1893-07-13,159\\n',\n",
       " '1893-07-14,136\\n',\n",
       " '1893-07-15,122\\n',\n",
       " '1893-07-16,138\\n',\n",
       " '1893-07-17,141\\n',\n",
       " '1893-07-18,103\\n',\n",
       " '1893-07-19,131\\n',\n",
       " '1893-07-20,150\\n',\n",
       " '1893-07-21,166\\n',\n",
       " '1893-07-22,166\\n',\n",
       " '1893-07-23,117\\n',\n",
       " '1893-07-24,129\\n',\n",
       " '1893-07-25,164\\n',\n",
       " '1893-07-26,138\\n',\n",
       " '1893-07-27,132\\n',\n",
       " '1893-07-28,128\\n',\n",
       " '1893-07-29,116\\n',\n",
       " '1893-07-30,121\\n',\n",
       " '1893-07-31,131\\n',\n",
       " '1893-08-01,103\\n',\n",
       " '1893-08-02,111\\n',\n",
       " '1893-08-03,141\\n',\n",
       " '1893-08-04,141\\n',\n",
       " '1893-08-05,141\\n',\n",
       " '1893-08-06,128\\n',\n",
       " '1893-08-07,116\\n',\n",
       " '1893-08-08,135\\n',\n",
       " '1893-08-09,131\\n',\n",
       " '1893-08-10,143\\n',\n",
       " '1893-08-11,146\\n',\n",
       " '1893-08-12,161\\n',\n",
       " '1893-08-13,178\\n',\n",
       " '1893-08-14,156\\n',\n",
       " '1893-08-15,144\\n',\n",
       " '1893-08-16,156\\n',\n",
       " '1893-08-17,161\\n',\n",
       " '1893-08-18,133\\n',\n",
       " '1893-08-19,167\\n',\n",
       " '1893-08-20,172\\n',\n",
       " '1893-08-21,186\\n',\n",
       " '1893-08-22,189\\n',\n",
       " '1893-08-23,161\\n',\n",
       " '1893-08-24,151\\n',\n",
       " '1893-08-25,125\\n',\n",
       " '1893-08-26,113\\n',\n",
       " '1893-08-27,104\\n',\n",
       " '1893-08-28,105\\n',\n",
       " '1893-08-29,126\\n',\n",
       " '1893-08-30,146\\n',\n",
       " '1893-08-31,110\\n',\n",
       " '1893-09-01,69\\n',\n",
       " '1893-09-02,96\\n',\n",
       " '1893-09-03,70\\n',\n",
       " '1893-09-04,132\\n',\n",
       " '1893-09-05,113\\n',\n",
       " '1893-09-06,99\\n',\n",
       " '1893-09-07,143\\n',\n",
       " '1893-09-08,131\\n',\n",
       " '1893-09-09,107\\n',\n",
       " '1893-09-10,79\\n',\n",
       " '1893-09-11,63\\n',\n",
       " '1893-09-12,71\\n',\n",
       " '1893-09-13,72\\n',\n",
       " '1893-09-14,126\\n',\n",
       " '1893-09-15,91\\n',\n",
       " '1893-09-16,121\\n',\n",
       " '1893-09-17,125\\n',\n",
       " '1893-09-18,88\\n',\n",
       " '1893-09-19,126\\n',\n",
       " '1893-09-20,142\\n',\n",
       " '1893-09-21,114\\n',\n",
       " '1893-09-22,115\\n',\n",
       " '1893-09-23,77\\n',\n",
       " '1893-09-24,75\\n',\n",
       " '1893-09-25,69\\n',\n",
       " '1893-09-26,46\\n',\n",
       " ...]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "lines"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'1891-01-01,-132\\n'"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "lines[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'1891-01-06,-58\\n'"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "lines[5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "one_line = lines[10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'1891-01-11,-129\\n'"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "one_line"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "We can separate this line in to several parts (that wil form another list)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['1891-01-11', '-129\\n']"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "one_line.split(',')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'1891-01-11'"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "one_line.split(',')[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'-129\\n'"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "one_line.split(',')[1]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "##Exersise\n",
    "\n",
    "- Split `one_split` variable in a way, that 0$^{th}$ element of resulting list contains only year."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "If we can split one line, we can split many in a loop. Here we use only first 10 elements from out list:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1891-01-01,-132\n",
      "\n",
      "1891-01-02,-119\n",
      "\n",
      "1891-01-03,-116\n",
      "\n",
      "1891-01-04,-108\n",
      "\n",
      "1891-01-05,-37\n",
      "\n",
      "1891-01-06,-58\n",
      "\n",
      "1891-01-07,-58\n",
      "\n",
      "1891-01-08,-128\n",
      "\n",
      "1891-01-09,-110\n",
      "\n",
      "1891-01-10,-131\n",
      "\n"
     ]
    }
   ],
   "source": [
    "for line in lines[:10]:\n",
    "    print(line)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['1891-01-01', '-132\\n']\n",
      "['1891-01-02', '-119\\n']\n",
      "['1891-01-03', '-116\\n']\n",
      "['1891-01-04', '-108\\n']\n",
      "['1891-01-05', '-37\\n']\n",
      "['1891-01-06', '-58\\n']\n",
      "['1891-01-07', '-58\\n']\n",
      "['1891-01-08', '-128\\n']\n",
      "['1891-01-09', '-110\\n']\n",
      "['1891-01-10', '-131\\n']\n"
     ]
    }
   ],
   "source": [
    "for line in lines[:10]:\n",
    "    print(line.split(','))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1891-01-01\n",
      "1891-01-02\n",
      "1891-01-03\n",
      "1891-01-04\n",
      "1891-01-05\n",
      "1891-01-06\n",
      "1891-01-07\n",
      "1891-01-08\n",
      "1891-01-09\n",
      "1891-01-10\n"
     ]
    }
   ],
   "source": [
    "for line in lines[:10]:\n",
    "    print(line.split(',')[0])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "##Exersice\n",
    "\n",
    " - Print first 10 temparatures from lines devided by 10."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Ok, we can print things out, but how about storing them in some usefull variable? One of the ways to do so, is to create an empty list, and append to it:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "years = []\n",
    "for line in lines[:10]:\n",
    "    year = line.split(',')[0]\n",
    "    years.append(year)\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['1891-01-01',\n",
       " '1891-01-02',\n",
       " '1891-01-03',\n",
       " '1891-01-04',\n",
       " '1891-01-05',\n",
       " '1891-01-06',\n",
       " '1891-01-07',\n",
       " '1891-01-08',\n",
       " '1891-01-09',\n",
       " '1891-01-10']"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "years"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "##Exercise\n",
    "\n",
    "- create variable `temp` with temperature values (devided by 10)\n",
    "- plot variable `temp`"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "We get some values, now, let's write them down."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "fout = open('out.txt', 'w') # 'w' means file will be opened for writing"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "for year in years:\n",
    "    fout.write(year+'\\n')\n",
    "fout.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# %load out.txt\n",
    "1891-01-01\n",
    "1891-01-02\n",
    "1891-01-03\n",
    "1891-01-04\n",
    "1891-01-05\n",
    "1891-01-06\n",
    "1891-01-07\n",
    "1891-01-08\n",
    "1891-01-09\n",
    "1891-01-10\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Another variant:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "fout = open('out.txt', 'w')\n",
    "for n in range(10):\n",
    "    fout.write(years[n]+'\\n')\n",
    "fout.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# %load out.txt\n",
    "1891-01-01\n",
    "1891-01-02\n",
    "1891-01-03\n",
    "1891-01-04\n",
    "1891-01-05\n",
    "1891-01-06\n",
    "1891-01-07\n",
    "1891-01-08\n",
    "1891-01-09\n",
    "1891-01-10\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "We can combine values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[100, 101, 102, 103, 104, 105, 106, 107, 108, 109]"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dummy = range(100,110)\n",
    "dummy"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "fout = open('out.txt', 'w')\n",
    "\n",
    "for n in range(10):\n",
    "    fout.write(years[n]+'\\t'+str(dummy[n])+'\\n')\n",
    "\n",
    "fout.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# %load out.txt\n",
    "1891-01-01\t100\n",
    "1891-01-02\t101\n",
    "1891-01-03\t102\n",
    "1891-01-04\t103\n",
    "1891-01-05\t104\n",
    "1891-01-06\t105\n",
    "1891-01-07\t106\n",
    "1891-01-08\t107\n",
    "1891-01-09\t108\n",
    "1891-01-10\t109\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Bonus example with .format() method"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "fout = open('out.txt', 'w')\n",
    "\n",
    "for n in range(10):\n",
    "    fout.write('{}\\t{}\\n'.format( years[n], str(dummy[n])))\n",
    "\n",
    "fout.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# %load out.txt"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "##Exersise - data converter\n",
    "\n",
    "- Open '../Week5/Ham_tmin.txt'\n",
    "- Convert temperatures to degrees celsius (divide by 10)\n",
    "- write `Ham_tmin_converted.txt` with temperature in celsius"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": []
  }
 ],
 "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.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}