In [ ]:

    

! python --version


    

In [ ]:

    

! pip install --upgrade quandl


    

In [ ]:

    

import quandl
print quandl.get("SOCSEC/RETIRED")


    

In [ ]:

    

! apt-get install curl


    

In [ ]:

    

! curl http://data.edwardsaquifer.org/csv_j17.php > csv_j17
! curl http://data.edwardsaquifer.org/csv_j27.php > csv_j27
! curl http://data.edwardsaquifer.org/csv_comal.php > csv_comal
! curl http://data.edwardsaquifer.org/csv_san.php > csv_san_marcos
! curl http://data.edwardsaquifer.org/csv_hondo.php > csv_hondd


    

In [ ]:

    

import csv
with open('csv_j17','rb') as infile:
    reader = csv.reader(infile)
    j17_list = list(reader0
len(j17_list)
print j17_list[0]
print j17_list[1]
print j17_list[-1]


    

In [ ]:

    

for x in range(1, len(j17_list) -1):
    if abs(float(j17_list[x][1]) - float(j17_list[x+1][1]))> 3:
        print j17_list[x], j17_list[x+1], float(j17_list[x][1]) - float(j17_list[x+1][1])


    

In [ ]:

    

import csv
with open('csv_j27','rb') as infile:
    reader = csv.reader(infile)
    j27_list = list(reader)
len(j27_list)
print j27_list[0]
print j27_list[1]
print j27_list[-1]


    

In [ ]:

    

for x in range(1, len(j27_list) -1):
    if abs(float(j27_list[x][1]) - float(j27_list[x+1][1]))> 2:
        print j27_list[x], j27_list[x+1], float(j27_list[x][1]) - float(j27_list[x+1][1])


    

In [ ]:

    

for x in j17_list:
    print x