Read txt files line by line

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.

Let's open some file that is already familiar:



In [1]:

    
f = open('./Ham_tmin.txt')

f is now just a file handler:



In [2]:

    
f









    Out[2]:





<open file './Ham_tmin.txt', mode 'r' at 0x103811540>

Read lines to list



In [3]:

    
lines = f.readlines()



In [4]:

    
lines









    Out[4]:





['1891-01-01,-132\n',
 '1891-01-02,-119\n',
 '1891-01-03,-116\n',
 '1891-01-04,-108\n',
 '1891-01-05,-37\n',
 '1891-01-06,-58\n',
 '1891-01-07,-58\n',
 '1891-01-08,-128\n',
 '1891-01-09,-110\n',
 '1891-01-10,-131\n',
 '1891-01-11,-129\n',
 '1891-01-12,-105\n',
 '1891-01-13,10\n',
 '1891-01-14,-3\n',
 '1891-01-15,-47\n',
 '1891-01-16,-117\n',
 '1891-01-17,-128\n',
 '1891-01-18,-81\n',
 '1891-01-19,-86\n',
 '1891-01-20,-70\n',
 '1891-01-21,-40\n',
 '1891-01-22,-61\n',
 '1891-01-23,-60\n',
 '1891-01-24,-32\n',
 '1891-01-25,17\n',
 '1891-01-26,8\n',
 '1891-01-27,1\n',
 '1891-01-28,19\n',
 '1891-01-29,20\n',
 '1891-01-30,26\n',
 '1891-01-31,27\n',
 '1891-02-01,32\n',
 '1891-02-02,2\n',
 '1891-02-03,7\n',
 '1891-02-04,11\n',
 '1891-02-05,-27\n',
 '1891-02-06,-5\n',
 '1891-02-07,2\n',
 '1891-02-08,-28\n',
 '1891-02-09,-31\n',
 '1891-02-10,-44\n',
 '1891-02-11,-21\n',
 '1891-02-12,13\n',
 '1891-02-13,-24\n',
 '1891-02-14,-89\n',
 '1891-02-15,-7\n',
 '1891-02-16,18\n',
 '1891-02-17,9\n',
 '1891-02-18,11\n',
 '1891-02-19,1\n',
 '1891-02-20,-4\n',
 '1891-02-21,-14\n',
 '1891-02-22,-16\n',
 '1891-02-23,-25\n',
 '1891-02-24,-47\n',
 '1891-02-25,-9\n',
 '1891-02-26,6\n',
 '1891-02-27,2\n',
 '1891-02-28,-18\n',
 '1891-03-01,22\n',
 '1891-03-02,58\n',
 '1891-03-03,22\n',
 '1891-03-04,-1\n',
 '1891-03-05,32\n',
 '1891-03-06,53\n',
 '1891-03-07,1\n',
 '1891-03-08,1\n',
 '1891-03-09,8\n',
 '1891-03-10,-14\n',
 '1891-03-11,6\n',
 '1891-03-12,16\n',
 '1891-03-13,-14\n',
 '1891-03-14,8\n',
 '1891-03-15,8\n',
 '1891-03-16,11\n',
 '1891-03-17,37\n',
 '1891-03-18,9\n',
 '1891-03-19,3\n',
 '1891-03-20,-31\n',
 '1891-03-21,-31\n',
 '1891-03-22,-49\n',
 '1891-03-23,-37\n',
 '1891-03-24,-38\n',
 '1891-03-25,1\n',
 '1891-03-26,37\n',
 '1891-03-27,5\n',
 '1891-03-28,4\n',
 '1891-03-29,6\n',
 '1891-03-30,-15\n',
 '1891-03-31,-9\n',
 '1891-04-01,-26\n',
 '1891-04-02,-16\n',
 '1891-04-03,-7\n',
 '1891-04-04,-10\n',
 '1891-04-05,1\n',
 '1891-04-06,13\n',
 '1891-04-07,21\n',
 '1891-04-08,60\n',
 '1891-04-09,46\n',
 '1891-04-10,36\n',
 '1891-04-11,14\n',
 '1891-04-12,21\n',
 '1891-04-13,12\n',
 '1891-04-14,15\n',
 '1891-04-15,30\n',
 '1891-04-16,32\n',
 '1891-04-17,34\n',
 '1891-04-18,6\n',
 '1891-04-19,25\n',
 '1891-04-20,19\n',
 '1891-04-21,50\n',
 '1891-04-22,31\n',
 '1891-04-23,26\n',
 '1891-04-24,31\n',
 '1891-04-25,27\n',
 '1891-04-26,22\n',
 '1891-04-27,33\n',
 '1891-04-28,61\n',
 '1891-04-29,60\n',
 '1891-04-30,70\n',
 '1891-05-01,107\n',
 '1891-05-02,101\n',
 '1891-05-03,79\n',
 '1891-05-04,64\n',
 '1891-05-05,40\n',
 '1891-05-06,64\n',
 '1891-05-07,72\n',
 '1891-05-08,86\n',
 '1891-05-09,93\n',
 '1891-05-10,92\n',
 '1891-05-11,91\n',
 '1891-05-12,67\n',
 '1891-05-13,66\n',
 '1891-05-14,90\n',
 '1891-05-15,66\n',
 '1891-05-16,47\n',
 '1891-05-17,14\n',
 '1891-05-18,23\n',
 '1891-05-19,70\n',
 '1891-05-20,57\n',
 '1891-05-21,95\n',
 '1891-05-22,122\n',
 '1891-05-23,80\n',
 '1891-05-24,102\n',
 '1891-05-25,101\n',
 '1891-05-26,112\n',
 '1891-05-27,83\n',
 '1891-05-28,85\n',
 '1891-05-29,91\n',
 '1891-05-30,123\n',
 '1891-05-31,131\n',
 '1891-06-01,113\n',
 '1891-06-02,111\n',
 '1891-06-03,97\n',
 '1891-06-04,68\n',
 '1891-06-05,60\n',
 '1891-06-06,78\n',
 '1891-06-07,65\n',
 '1891-06-08,104\n',
 '1891-06-09,95\n',
 '1891-06-10,101\n',
 '1891-06-11,93\n',
 '1891-06-12,77\n',
 '1891-06-13,65\n',
 '1891-06-14,97\n',
 '1891-06-15,85\n',
 '1891-06-16,83\n',
 '1891-06-17,77\n',
 '1891-06-18,81\n',
 '1891-06-19,129\n',
 '1891-06-20,107\n',
 '1891-06-21,131\n',
 '1891-06-22,131\n',
 '1891-06-23,126\n',
 '1891-06-24,129\n',
 '1891-06-25,144\n',
 '1891-06-26,171\n',
 '1891-06-27,181\n',
 '1891-06-28,131\n',
 '1891-06-29,139\n',
 '1891-06-30,180\n',
 '1891-07-01,170\n',
 '1891-07-02,166\n',
 '1891-07-03,138\n',
 '1891-07-04,164\n',
 '1891-07-05,122\n',
 '1891-07-06,145\n',
 '1891-07-07,151\n',
 '1891-07-08,124\n',
 '1891-07-09,120\n',
 '1891-07-10,137\n',
 '1891-07-11,123\n',
 '1891-07-12,113\n',
 '1891-07-13,119\n',
 '1891-07-14,133\n',
 '1891-07-15,151\n',
 '1891-07-16,165\n',
 '1891-07-17,153\n',
 '1891-07-18,160\n',
 '1891-07-19,174\n',
 '1891-07-20,141\n',
 '1891-07-21,153\n',
 '1891-07-22,151\n',
 '1891-07-23,148\n',
 '1891-07-24,124\n',
 '1891-07-25,136\n',
 '1891-07-26,131\n',
 '1891-07-27,136\n',
 '1891-07-28,131\n',
 '1891-07-29,103\n',
 '1891-07-30,129\n',
 '1891-07-31,121\n',
 '1891-08-01,113\n',
 '1891-08-02,124\n',
 '1891-08-03,133\n',
 '1891-08-04,121\n',
 '1891-08-05,104\n',
 '1891-08-06,117\n',
 '1891-08-07,110\n',
 '1891-08-08,121\n',
 '1891-08-09,143\n',
 '1891-08-10,143\n',
 '1891-08-11,119\n',
 '1891-08-12,116\n',
 '1891-08-13,129\n',
 '1891-08-14,118\n',
 '1891-08-15,143\n',
 '1891-08-16,125\n',
 '1891-08-17,132\n',
 '1891-08-18,124\n',
 '1891-08-19,131\n',
 '1891-08-20,110\n',
 '1891-08-21,112\n',
 '1891-08-22,130\n',
 '1891-08-23,112\n',
 '1891-08-24,136\n',
 '1891-08-25,116\n',
 '1891-08-26,142\n',
 '1891-08-27,171\n',
 '1891-08-28,171\n',
 '1891-08-29,131\n',
 '1891-08-30,101\n',
 '1891-08-31,123\n',
 '1891-09-01,136\n',
 '1891-09-02,130\n',
 '1891-09-03,129\n',
 '1891-09-04,171\n',
 '1891-09-05,128\n',
 '1891-09-06,111\n',
 '1891-09-07,119\n',
 '1891-09-08,81\n',
 '1891-09-09,119\n',
 '1891-09-10,127\n',
 '1891-09-11,121\n',
 '1891-09-12,107\n',
 '1891-09-13,121\n',
 '1891-09-14,137\n',
 '1891-09-15,161\n',
 '1891-09-16,111\n',
 '1891-09-17,131\n',
 '1891-09-18,141\n',
 '1891-09-19,145\n',
 '1891-09-20,151\n',
 '1891-09-21,146\n',
 '1891-09-22,104\n',
 '1891-09-23,101\n',
 '1891-09-24,71\n',
 '1891-09-25,62\n',
 '1891-09-26,125\n',
 '1891-09-27,128\n',
 '1891-09-28,91\n',
 '1891-09-29,101\n',
 '1891-09-30,121\n',
 '1891-10-01,116\n',
 '1891-10-02,141\n',
 '1891-10-03,82\n',
 '1891-10-04,66\n',
 '1891-10-05,71\n',
 '1891-10-06,79\n',
 '1891-10-07,104\n',
 '1891-10-08,114\n',
 '1891-10-09,66\n',
 '1891-10-10,107\n',
 '1891-10-11,97\n',
 '1891-10-12,107\n',
 '1891-10-13,106\n',
 '1891-10-14,94\n',
 '1891-10-15,88\n',
 '1891-10-16,80\n',
 '1891-10-17,98\n',
 '1891-10-18,68\n',
 '1891-10-19,60\n',
 '1891-10-20,97\n',
 '1891-10-21,104\n',
 '1891-10-22,113\n',
 '1891-10-23,117\n',
 '1891-10-24,79\n',
 '1891-10-25,88\n',
 '1891-10-26,103\n',
 '1891-10-27,62\n',
 '1891-10-28,9\n',
 '1891-10-29,12\n',
 '1891-10-30,-21\n',
 '1891-10-31,-1\n',
 '1891-11-01,33\n',
 '1891-11-02,40\n',
 '1891-11-03,36\n',
 '1891-11-04,39\n',
 '1891-11-05,-10\n',
 '1891-11-06,-17\n',
 '1891-11-07,30\n',
 '1891-11-08,-6\n',
 '1891-11-09,-28\n',
 '1891-11-10,-13\n',
 '1891-11-11,8\n',
 '1891-11-12,45\n',
 '1891-11-13,7\n',
 '1891-11-14,42\n',
 '1891-11-15,40\n',
 '1891-11-16,52\n',
 '1891-11-17,59\n',
 '1891-11-18,26\n',
 '1891-11-19,40\n',
 '1891-11-20,90\n',
 '1891-11-21,60\n',
 '1891-11-22,34\n',
 '1891-11-23,31\n',
 '1891-11-24,-8\n',
 '1891-11-25,4\n',
 '1891-11-26,15\n',
 '1891-11-27,5\n',
 '1891-11-28,1\n',
 '1891-11-29,-15\n',
 '1891-11-30,6\n',
 '1891-12-01,28\n',
 '1891-12-02,11\n',
 '1891-12-03,21\n',
 '1891-12-04,61\n',
 '1891-12-05,62\n',
 '1891-12-06,104\n',
 '1891-12-07,31\n',
 '1891-12-08,49\n',
 '1891-12-09,30\n',
 '1891-12-10,51\n',
 '1891-12-11,52\n',
 '1891-12-12,12\n',
 '1891-12-13,13\n',
 '1891-12-14,44\n',
 '1891-12-15,25\n',
 '1891-12-16,7\n',
 '1891-12-17,-11\n',
 '1891-12-18,-25\n',
 '1891-12-19,-34\n',
 '1891-12-20,-29\n',
 '1891-12-21,-49\n',
 '1891-12-22,-44\n',
 '1891-12-23,-44\n',
 '1891-12-24,-52\n',
 '1891-12-25,-44\n',
 '1891-12-26,-19\n',
 '1891-12-27,9\n',
 '1891-12-28,20\n',
 '1891-12-29,-3\n',
 '1891-12-30,11\n',
 '1891-12-31,17\n',
 '1892-01-01,23\n',
 '1892-01-02,-17\n',
 '1892-01-03,16\n',
 '1892-01-04,7\n',
 '1892-01-05,2\n',
 '1892-01-06,-4\n',
 '1892-01-07,-25\n',
 '1892-01-08,-14\n',
 '1892-01-09,-41\n',
 '1892-01-10,-29\n',
 '1892-01-11,-29\n',
 '1892-01-12,-49\n',
 '1892-01-13,-57\n',
 '1892-01-14,-112\n',
 '1892-01-15,-124\n',
 '1892-01-16,-89\n',
 '1892-01-17,-71\n',
 '1892-01-18,-110\n',
 '1892-01-19,-95\n',
 '1892-01-20,-99\n',
 '1892-01-21,-121\n',
 '1892-01-22,-151\n',
 '1892-01-23,-59\n',
 '1892-01-24,-19\n',
 '1892-01-25,-5\n',
 '1892-01-26,3\n',
 '1892-01-27,5\n',
 '1892-01-28,20\n',
 '1892-01-29,21\n',
 '1892-01-30,55\n',
 '1892-01-31,39\n',
 '1892-02-01,6\n',
 '1892-02-02,31\n',
 '1892-02-03,2\n',
 '1892-02-04,1\n',
 '1892-02-05,-1\n',
 '1892-02-06,11\n',
 '1892-02-07,2\n',
 '1892-02-08,4\n',
 '1892-02-09,-31\n',
 '1892-02-10,-17\n',
 '1892-02-11,-4\n',
 '1892-02-12,46\n',
 '1892-02-13,11\n',
 '1892-02-14,-19\n',
 '1892-02-15,-41\n',
 '1892-02-16,-66\n',
 '1892-02-17,-100\n',
 '1892-02-18,-74\n',
 '1892-02-19,-89\n',
 '1892-02-20,-27\n',
 '1892-02-21,-9\n',
 '1892-02-22,1\n',
 '1892-02-23,15\n',
 '1892-02-24,16\n',
 '1892-02-25,6\n',
 '1892-02-26,10\n',
 '1892-02-27,11\n',
 '1892-02-28,13\n',
 '1892-02-29,13\n',
 '1892-03-01,-1\n',
 '1892-03-02,-38\n',
 '1892-03-03,-51\n',
 '1892-03-04,-39\n',
 '1892-03-05,-33\n',
 '1892-03-06,-44\n',
 '1892-03-07,-77\n',
 '1892-03-08,-35\n',
 '1892-03-09,-34\n',
 '1892-03-10,-41\n',
 '1892-03-11,-40\n',
 '1892-03-12,-17\n',
 '1892-03-13,-30\n',
 '1892-03-14,-48\n',
 '1892-03-15,-9\n',
 '1892-03-16,-19\n',
 '1892-03-17,-11\n',
 '1892-03-18,1\n',
 '1892-03-19,11\n',
 '1892-03-20,4\n',
 '1892-03-21,10\n',
 '1892-03-22,14\n',
 '1892-03-23,5\n',
 '1892-03-24,13\n',
 '1892-03-25,41\n',
 '1892-03-26,13\n',
 '1892-03-27,33\n',
 '1892-03-28,9\n',
 '1892-03-29,-14\n',
 '1892-03-30,-24\n',
 '1892-03-31,1\n',
 '1892-04-01,27\n',
 '1892-04-02,41\n',
 '1892-04-03,31\n',
 '1892-04-04,31\n',
 '1892-04-05,61\n',
 '1892-04-06,46\n',
 '1892-04-07,56\n',
 '1892-04-08,31\n',
 '1892-04-09,11\n',
 '1892-04-10,26\n',
 '1892-04-11,51\n',
 '1892-04-12,31\n',
 '1892-04-13,5\n',
 '1892-04-14,-12\n',
 '1892-04-15,-14\n',
 '1892-04-16,-9\n',
 '1892-04-17,19\n',
 '1892-04-18,2\n',
 '1892-04-19,21\n',
 '1892-04-20,-8\n',
 '1892-04-21,33\n',
 '1892-04-22,66\n',
 '1892-04-23,61\n',
 '1892-04-24,39\n',
 '1892-04-25,19\n',
 '1892-04-26,24\n',
 '1892-04-27,33\n',
 '1892-04-28,15\n',
 '1892-04-29,61\n',
 '1892-04-30,4\n',
 '1892-05-01,8\n',
 '1892-05-02,58\n',
 '1892-05-03,52\n',
 '1892-05-04,66\n',
 '1892-05-05,41\n',
 '1892-05-06,11\n',
 '1892-05-07,-2\n',
 '1892-05-08,45\n',
 '1892-05-09,77\n',
 '1892-05-10,79\n',
 '1892-05-11,89\n',
 '1892-05-12,49\n',
 '1892-05-13,40\n',
 '1892-05-14,74\n',
 '1892-05-15,79\n',
 '1892-05-16,92\n',
 '1892-05-17,75\n',
 '1892-05-18,46\n',
 '1892-05-19,86\n',
 '1892-05-20,57\n',
 '1892-05-21,73\n',
 '1892-05-22,30\n',
 '1892-05-23,32\n',
 '1892-05-24,104\n',
 '1892-05-25,136\n',
 '1892-05-26,157\n',
 '1892-05-27,182\n',
 '1892-05-28,161\n',
 '1892-05-29,194\n',
 '1892-05-30,138\n',
 '1892-05-31,151\n',
 '1892-06-01,169\n',
 '1892-06-02,111\n',
 '1892-06-03,161\n',
 '1892-06-04,91\n',
 '1892-06-05,112\n',
 '1892-06-06,117\n',
 '1892-06-07,89\n',
 '1892-06-08,82\n',
 '1892-06-09,126\n',
 '1892-06-10,121\n',
 '1892-06-11,100\n',
 '1892-06-12,101\n',
 '1892-06-13,79\n',
 '1892-06-14,72\n',
 '1892-06-15,62\n',
 '1892-06-16,68\n',
 '1892-06-17,102\n',
 '1892-06-18,93\n',
 '1892-06-19,65\n',
 '1892-06-20,100\n',
 '1892-06-21,109\n',
 '1892-06-22,95\n',
 '1892-06-23,125\n',
 '1892-06-24,113\n',
 '1892-06-25,90\n',
 '1892-06-26,121\n',
 '1892-06-27,150\n',
 '1892-06-28,166\n',
 '1892-06-29,149\n',
 '1892-06-30,106\n',
 '1892-07-01,89\n',
 '1892-07-02,115\n',
 '1892-07-03,110\n',
 '1892-07-04,152\n',
 '1892-07-05,137\n',
 '1892-07-06,151\n',
 '1892-07-07,124\n',
 '1892-07-08,139\n',
 '1892-07-09,121\n',
 '1892-07-10,131\n',
 '1892-07-11,99\n',
 '1892-07-12,113\n',
 '1892-07-13,131\n',
 '1892-07-14,141\n',
 '1892-07-15,128\n',
 '1892-07-16,116\n',
 '1892-07-17,101\n',
 '1892-07-18,112\n',
 '1892-07-19,100\n',
 '1892-07-20,101\n',
 '1892-07-21,100\n',
 '1892-07-22,110\n',
 '1892-07-23,121\n',
 '1892-07-24,126\n',
 '1892-07-25,101\n',
 '1892-07-26,114\n',
 '1892-07-27,101\n',
 '1892-07-28,98\n',
 '1892-07-29,155\n',
 '1892-07-30,153\n',
 '1892-07-31,129\n',
 '1892-08-01,122\n',
 '1892-08-02,139\n',
 '1892-08-03,128\n',
 '1892-08-04,128\n',
 '1892-08-05,99\n',
 '1892-08-06,118\n',
 '1892-08-07,116\n',
 '1892-08-08,89\n',
 '1892-08-09,149\n',
 '1892-08-10,124\n',
 '1892-08-11,108\n',
 '1892-08-12,115\n',
 '1892-08-13,113\n',
 '1892-08-14,159\n',
 '1892-08-15,145\n',
 '1892-08-16,125\n',
 '1892-08-17,171\n',
 '1892-08-18,140\n',
 '1892-08-19,167\n',
 '1892-08-20,174\n',
 '1892-08-21,150\n',
 '1892-08-22,137\n',
 '1892-08-23,180\n',
 '1892-08-24,193\n',
 '1892-08-25,211\n',
 '1892-08-26,157\n',
 '1892-08-27,104\n',
 '1892-08-28,140\n',
 '1892-08-29,101\n',
 '1892-08-30,147\n',
 '1892-08-31,163\n',
 '1892-09-01,123\n',
 '1892-09-02,129\n',
 '1892-09-03,128\n',
 '1892-09-04,96\n',
 '1892-09-05,91\n',
 '1892-09-06,89\n',
 '1892-09-07,69\n',
 '1892-09-08,93\n',
 '1892-09-09,91\n',
 '1892-09-10,71\n',
 '1892-09-11,121\n',
 '1892-09-12,134\n',
 '1892-09-13,127\n',
 '1892-09-14,143\n',
 '1892-09-15,83\n',
 '1892-09-16,129\n',
 '1892-09-17,133\n',
 '1892-09-18,96\n',
 '1892-09-19,76\n',
 '1892-09-20,121\n',
 '1892-09-21,141\n',
 '1892-09-22,142\n',
 '1892-09-23,147\n',
 '1892-09-24,131\n',
 '1892-09-25,88\n',
 '1892-09-26,110\n',
 '1892-09-27,106\n',
 '1892-09-28,143\n',
 '1892-09-29,89\n',
 '1892-09-30,76\n',
 '1892-10-01,105\n',
 '1892-10-02,131\n',
 '1892-10-03,81\n',
 '1892-10-04,55\n',
 '1892-10-05,69\n',
 '1892-10-06,114\n',
 '1892-10-07,97\n',
 '1892-10-08,82\n',
 '1892-10-09,71\n',
 '1892-10-10,76\n',
 '1892-10-11,74\n',
 '1892-10-12,77\n',
 '1892-10-13,63\n',
 '1892-10-14,78\n',
 '1892-10-15,85\n',
 '1892-10-16,73\n',
 '1892-10-17,49\n',
 '1892-10-18,17\n',
 '1892-10-19,25\n',
 '1892-10-20,31\n',
 '1892-10-21,40\n',
 '1892-10-22,1\n',
 '1892-10-23,19\n',
 '1892-10-24,11\n',
 '1892-10-25,36\n',
 '1892-10-26,1\n',
 '1892-10-27,-14\n',
 '1892-10-28,41\n',
 '1892-10-29,111\n',
 '1892-10-30,113\n',
 '1892-10-31,88\n',
 '1892-11-01,90\n',
 '1892-11-02,61\n',
 '1892-11-03,61\n',
 '1892-11-04,75\n',
 '1892-11-05,36\n',
 '1892-11-06,49\n',
 '1892-11-07,35\n',
 '1892-11-08,40\n',
 '1892-11-09,68\n',
 '1892-11-10,52\n',
 '1892-11-11,51\n',
 '1892-11-12,9\n',
 '1892-11-13,26\n',
 '1892-11-14,-2\n',
 '1892-11-15,-11\n',
 '1892-11-16,19\n',
 '1892-11-17,0\n',
 '1892-11-18,-21\n',
 '1892-11-19,-14\n',
 '1892-11-20,-12\n',
 '1892-11-21,-21\n',
 '1892-11-22,-35\n',
 '1892-11-23,-54\n',
 '1892-11-24,-35\n',
 '1892-11-25,-20\n',
 '1892-11-26,-61\n',
 '1892-11-27,-84\n',
 '1892-11-28,-60\n',
 '1892-11-29,36\n',
 '1892-11-30,29\n',
 '1892-12-01,4\n',
 '1892-12-02,-25\n',
 '1892-12-03,-64\n',
 '1892-12-04,-21\n',
 '1892-12-05,-19\n',
 '1892-12-06,-49\n',
 '1892-12-07,-31\n',
 '1892-12-08,-31\n',
 '1892-12-09,-3\n',
 '1892-12-10,-48\n',
 '1892-12-11,-105\n',
 '1892-12-12,-54\n',
 '1892-12-13,6\n',
 '1892-12-14,-19\n',
 '1892-12-15,5\n',
 '1892-12-16,30\n',
 '1892-12-17,28\n',
 '1892-12-18,52\n',
 '1892-12-19,48\n',
 '1892-12-20,39\n',
 '1892-12-21,-10\n',
 '1892-12-22,11\n',
 '1892-12-23,-42\n',
 '1892-12-24,-77\n',
 '1892-12-25,-87\n',
 '1892-12-26,-77\n',
 '1892-12-27,-34\n',
 '1892-12-28,-20\n',
 '1892-12-29,-3\n',
 '1892-12-30,-11\n',
 '1892-12-31,-68\n',
 '1893-01-01,-81\n',
 '1893-01-02,-79\n',
 '1893-01-03,-131\n',
 '1893-01-04,-148\n',
 '1893-01-05,-49\n',
 '1893-01-06,-41\n',
 '1893-01-07,-118\n',
 '1893-01-08,-139\n',
 '1893-01-09,-92\n',
 '1893-01-10,-79\n',
 '1893-01-11,-91\n',
 '1893-01-12,-149\n',
 '1893-01-13,-98\n',
 '1893-01-14,-59\n',
 '1893-01-15,-119\n',
 '1893-01-16,-151\n',
 '1893-01-17,-137\n',
 '1893-01-18,-184\n',
 '1893-01-19,-182\n',
 '1893-01-20,-182\n',
 '1893-01-21,-37\n',
 '1893-01-22,-88\n',
 '1893-01-23,-66\n',
 '1893-01-24,-107\n',
 '1893-01-25,17\n',
 '1893-01-26,8\n',
 '1893-01-27,-6\n',
 '1893-01-28,7\n',
 '1893-01-29,-38\n',
 '1893-01-30,11\n',
 '1893-01-31,19\n',
 '1893-02-01,39\n',
 '1893-02-02,11\n',
 '1893-02-03,-31\n',
 '1893-02-04,-46\n',
 '1893-02-05,-89\n',
 '1893-02-06,-42\n',
 '1893-02-07,-54\n',
 '1893-02-08,6\n',
 '1893-02-09,1\n',
 '1893-02-10,19\n',
 '1893-02-11,26\n',
 '1893-02-12,-13\n',
 '1893-02-13,-49\n',
 '1893-02-14,0\n',
 '1893-02-15,31\n',
 '1893-02-16,40\n',
 '1893-02-17,29\n',
 '1893-02-18,12\n',
 '1893-02-19,40\n',
 '1893-02-20,42\n',
 '1893-02-21,31\n',
 '1893-02-22,6\n',
 '1893-02-23,-39\n',
 '1893-02-24,-80\n',
 '1893-02-25,-29\n',
 '1893-02-26,1\n',
 '1893-02-27,26\n',
 '1893-02-28,50\n',
 '1893-03-01,-9\n',
 '1893-03-02,46\n',
 '1893-03-03,6\n',
 '1893-03-04,-16\n',
 '1893-03-05,37\n',
 '1893-03-06,35\n',
 '1893-03-07,4\n',
 '1893-03-08,43\n',
 '1893-03-09,20\n',
 '1893-03-10,34\n',
 '1893-03-11,11\n',
 '1893-03-12,28\n',
 '1893-03-13,51\n',
 '1893-03-14,32\n',
 '1893-03-15,69\n',
 '1893-03-16,70\n',
 '1893-03-17,13\n',
 '1893-03-18,-12\n',
 '1893-03-19,-19\n',
 '1893-03-20,-7\n',
 '1893-03-21,31\n',
 '1893-03-22,18\n',
 '1893-03-23,21\n',
 '1893-03-24,28\n',
 '1893-03-25,13\n',
 '1893-03-26,-11\n',
 '1893-03-27,-5\n',
 '1893-03-28,4\n',
 '1893-03-29,1\n',
 '1893-03-30,6\n',
 '1893-03-31,31\n',
 '1893-04-01,47\n',
 '1893-04-02,50\n',
 '1893-04-03,41\n',
 '1893-04-04,48\n',
 '1893-04-05,18\n',
 '1893-04-06,11\n',
 '1893-04-07,63\n',
 '1893-04-08,16\n',
 '1893-04-09,51\n',
 '1893-04-10,59\n',
 '1893-04-11,13\n',
 '1893-04-12,-7\n',
 '1893-04-13,19\n',
 '1893-04-14,0\n',
 '1893-04-15,37\n',
 '1893-04-16,46\n',
 '1893-04-17,15\n',
 '1893-04-18,-3\n',
 '1893-04-19,39\n',
 '1893-04-20,99\n',
 '1893-04-21,61\n',
 '1893-04-22,36\n',
 '1893-04-23,71\n',
 '1893-04-24,58\n',
 '1893-04-25,58\n',
 '1893-04-26,86\n',
 '1893-04-27,51\n',
 '1893-04-28,61\n',
 '1893-04-29,25\n',
 '1893-04-30,69\n',
 '1893-05-01,42\n',
 '1893-05-02,40\n',
 '1893-05-03,68\n',
 '1893-05-04,41\n',
 '1893-05-05,19\n',
 '1893-05-06,31\n',
 '1893-05-07,22\n',
 '1893-05-08,65\n',
 '1893-05-09,61\n',
 '1893-05-10,66\n',
 '1893-05-11,51\n',
 '1893-05-12,81\n',
 '1893-05-13,114\n',
 '1893-05-14,59\n',
 '1893-05-15,120\n',
 '1893-05-16,102\n',
 '1893-05-17,155\n',
 '1893-05-18,146\n',
 '1893-05-19,132\n',
 '1893-05-20,106\n',
 '1893-05-21,111\n',
 '1893-05-22,73\n',
 '1893-05-23,131\n',
 '1893-05-24,101\n',
 '1893-05-25,103\n',
 '1893-05-26,94\n',
 '1893-05-27,89\n',
 '1893-05-28,99\n',
 '1893-05-29,75\n',
 '1893-05-30,84\n',
 '1893-05-31,46\n',
 '1893-06-01,75\n',
 '1893-06-02,74\n',
 '1893-06-03,66\n',
 '1893-06-04,103\n',
 '1893-06-05,109\n',
 '1893-06-06,86\n',
 '1893-06-07,80\n',
 '1893-06-08,83\n',
 '1893-06-09,106\n',
 '1893-06-10,119\n',
 '1893-06-11,110\n',
 '1893-06-12,94\n',
 '1893-06-13,111\n',
 '1893-06-14,126\n',
 '1893-06-15,150\n',
 '1893-06-16,141\n',
 '1893-06-17,157\n',
 '1893-06-18,134\n',
 '1893-06-19,134\n',
 '1893-06-20,122\n',
 '1893-06-21,112\n',
 '1893-06-22,112\n',
 '1893-06-23,131\n',
 '1893-06-24,137\n',
 '1893-06-25,116\n',
 '1893-06-26,102\n',
 '1893-06-27,94\n',
 '1893-06-28,170\n',
 '1893-06-29,156\n',
 '1893-06-30,152\n',
 '1893-07-01,135\n',
 '1893-07-02,120\n',
 '1893-07-03,116\n',
 '1893-07-04,150\n',
 '1893-07-05,111\n',
 '1893-07-06,133\n',
 '1893-07-07,154\n',
 '1893-07-08,177\n',
 '1893-07-09,182\n',
 '1893-07-10,171\n',
 '1893-07-11,171\n',
 '1893-07-12,158\n',
 '1893-07-13,159\n',
 '1893-07-14,136\n',
 '1893-07-15,122\n',
 '1893-07-16,138\n',
 '1893-07-17,141\n',
 '1893-07-18,103\n',
 '1893-07-19,131\n',
 '1893-07-20,150\n',
 '1893-07-21,166\n',
 '1893-07-22,166\n',
 '1893-07-23,117\n',
 '1893-07-24,129\n',
 '1893-07-25,164\n',
 '1893-07-26,138\n',
 '1893-07-27,132\n',
 '1893-07-28,128\n',
 '1893-07-29,116\n',
 '1893-07-30,121\n',
 '1893-07-31,131\n',
 '1893-08-01,103\n',
 '1893-08-02,111\n',
 '1893-08-03,141\n',
 '1893-08-04,141\n',
 '1893-08-05,141\n',
 '1893-08-06,128\n',
 '1893-08-07,116\n',
 '1893-08-08,135\n',
 '1893-08-09,131\n',
 '1893-08-10,143\n',
 '1893-08-11,146\n',
 '1893-08-12,161\n',
 '1893-08-13,178\n',
 '1893-08-14,156\n',
 '1893-08-15,144\n',
 '1893-08-16,156\n',
 '1893-08-17,161\n',
 '1893-08-18,133\n',
 '1893-08-19,167\n',
 '1893-08-20,172\n',
 '1893-08-21,186\n',
 '1893-08-22,189\n',
 '1893-08-23,161\n',
 '1893-08-24,151\n',
 '1893-08-25,125\n',
 '1893-08-26,113\n',
 '1893-08-27,104\n',
 '1893-08-28,105\n',
 '1893-08-29,126\n',
 '1893-08-30,146\n',
 '1893-08-31,110\n',
 '1893-09-01,69\n',
 '1893-09-02,96\n',
 '1893-09-03,70\n',
 '1893-09-04,132\n',
 '1893-09-05,113\n',
 '1893-09-06,99\n',
 '1893-09-07,143\n',
 '1893-09-08,131\n',
 '1893-09-09,107\n',
 '1893-09-10,79\n',
 '1893-09-11,63\n',
 '1893-09-12,71\n',
 '1893-09-13,72\n',
 '1893-09-14,126\n',
 '1893-09-15,91\n',
 '1893-09-16,121\n',
 '1893-09-17,125\n',
 '1893-09-18,88\n',
 '1893-09-19,126\n',
 '1893-09-20,142\n',
 '1893-09-21,114\n',
 '1893-09-22,115\n',
 '1893-09-23,77\n',
 '1893-09-24,75\n',
 '1893-09-25,69\n',
 '1893-09-26,46\n',
 ...]



In [5]:

    
lines[0]









    Out[5]:





'1891-01-01,-132\n'



In [6]:

    
lines[5]









    Out[6]:





'1891-01-06,-58\n'



In [7]:

    
one_line = lines[10]



In [8]:

    
one_line









    Out[8]:





'1891-01-11,-129\n'

We can separate this line in to several parts (that wil form another list)



In [9]:

    
one_line.split(',')









    Out[9]:





['1891-01-11', '-129\n']



In [10]:

    
one_line.split(',')[0]









    Out[10]:





'1891-01-11'



In [11]:

    
one_line.split(',')[1]









    Out[11]:





'-129\n'

Exersise

Split one_split variable in a way, that 0$^{th}$ element of resulting list contains only year.



In [ ]:



In [ ]:

If we can split one line, we can split many in a loop. Here we use only first 10 elements from out list:



In [12]:

    
for line in lines[:10]:
    print(line)









    



1891-01-01,-132

1891-01-02,-119

1891-01-03,-116

1891-01-04,-108

1891-01-05,-37

1891-01-06,-58

1891-01-07,-58

1891-01-08,-128

1891-01-09,-110

1891-01-10,-131



In [13]:

    
for line in lines[:10]:
    print(line.split(','))









    



['1891-01-01', '-132\n']
['1891-01-02', '-119\n']
['1891-01-03', '-116\n']
['1891-01-04', '-108\n']
['1891-01-05', '-37\n']
['1891-01-06', '-58\n']
['1891-01-07', '-58\n']
['1891-01-08', '-128\n']
['1891-01-09', '-110\n']
['1891-01-10', '-131\n']



In [14]:

    
for line in lines[:10]:
    print(line.split(',')[0])

Exersice

Print first 10 temparatures from lines devided by 10.



In [ ]:



In [ ]:

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:



In [15]:

    
years = []
for line in lines[:10]:
    year = line.split(',')[0]
    years.append(year)



In [16]:

    
years









    Out[16]:





['1891-01-01',
 '1891-01-02',
 '1891-01-03',
 '1891-01-04',
 '1891-01-05',
 '1891-01-06',
 '1891-01-07',
 '1891-01-08',
 '1891-01-09',
 '1891-01-10']

Exercise

create variable temp with temperature values (devided by 10)
plot variable temp



In [ ]:



In [ ]:

We get some values, now, let's write them down.



In [34]:

    
fout = open('out.txt', 'w') # 'w' means file will be opened for writing



In [35]:

    
for year in years:
    fout.write(year+'\n')
fout.close()



In [ ]:

    
# %load out.txt
1891-01-01
1891-01-02
1891-01-03
1891-01-04
1891-01-05
1891-01-06
1891-01-07
1891-01-08
1891-01-09
1891-01-10

Another variant:



In [40]:

    
fout = open('out.txt', 'w')
for n in range(10):
    fout.write(years[n]+'\n')
fout.close()



In [ ]:

    
# %load out.txt
1891-01-01
1891-01-02
1891-01-03
1891-01-04
1891-01-05
1891-01-06
1891-01-07
1891-01-08
1891-01-09
1891-01-10

We can combine values



In [42]:

    
dummy = range(100,110)
dummy









    Out[42]:





[100, 101, 102, 103, 104, 105, 106, 107, 108, 109]



In [43]:

    
fout = open('out.txt', 'w')

for n in range(10):
    fout.write(years[n]+'\t'+str(dummy[n])+'\n')

fout.close()



In [ ]:

    
# %load out.txt
1891-01-01	100
1891-01-02	101
1891-01-03	102
1891-01-04	103
1891-01-05	104
1891-01-06	105
1891-01-07	106
1891-01-08	107
1891-01-09	108
1891-01-10	109

Bonus example with .format() method



In [46]:

    
fout = open('out.txt', 'w')

for n in range(10):
    fout.write('{}\t{}\n'.format( years[n], str(dummy[n])))

fout.close()



In [47]:

    
# %load out.txt

Exersise - data converter

Open '../Week5/Ham_tmin.txt'
Convert temperatures to degrees celsius (divide by 10)
write Ham_tmin_converted.txt with temperature in celsius



In [ ]: