In [10]:
import os
DATADIR = ""
DATAFILE = "beatles-diskography.csv"
def parse_file(datafile):
data = []
with open(datafile, "r") as f:
header = f.readline().split(",")
counter = 0
for line in f:
if counter == 10:
break
fields = line.split(",")
entry = {}
for key, value in enumerate(fields):
entry[header[key].strip()] = value.strip()
data.append(entry)
counter += 1
return data
def test():
# a simple test of your implemetation
datafile = os.path.join(DATADIR, DATAFILE)
d = parse_file(datafile)
firstline = {'Title': 'Please Please Me', 'UK Chart Position': '1', 'Label': 'Parlophone(UK)', 'Released': '22 March 1963', 'US Chart Position': '-', 'RIAA Certification': 'Platinum', 'BPI Certification': 'Gold'}
tenthline = {'Title': '', 'UK Chart Position': '1', 'Label': 'Parlophone(UK)', 'Released': '10 July 1964', 'US Chart Position': '-', 'RIAA Certification': '', 'BPI Certification': 'Gold'}
assert d[0] == firstline
assert d[9] == tenthline
print "Well done!"
test()
In [3]:
import pandas as pd
data = pd.read_excel('2013_ERCOT_Hourly_Load_Data.xls')
In [4]:
data
Out[4]:
In [37]:
import xlrd
datafile = "2013_ERCOT_Hourly_Load_Data.xls"
def parse_file(datafile):
workbook = xlrd.open_workbook(datafile)
sheet = workbook.sheet_by_index(0)
data = [[sheet.cell_value(r, col)
for col in range(sheet.ncols)]
for r in range(sheet.nrows)]
return data
data = parse_file(datafile)
In [112]:
coast = []
for i in range(len(data[:])-1):
coast.append(data[i+1][1])
average= (sum(coast))/(len(coast))
In [111]:
for i, value in enumerate(coast):
if value == max(coast):
maxvalue = value
maxtime = xlrd.xldate_as_tuple(data[i+1][0], 0)
if value == min(coast):
minvalue = value
mintime = xlrd.xldate_as_tuple(data[i+1][0], 0)
print maxvalue, maxtime
print minvalue, mintime
In [8]:
results = query_by_name(ARTIST_URL, query_type["simple"], "First Aid Kit")
# pretty_print(results)
count_match = 0
for artist in results["artists"]:
# pretty_print(artist)
if artist["name"] == "First Aid Kit":
count_match += 1
print "There are {0} bands named First Aid Kit".format(count_match)
# Question 2: Begin-Area name for Queen?
results = query_by_name(ARTIST_URL, query_type["simple"], "Queen")
print ("The Begin-Area name is ", results["artists"][0]["begin-area"]["name"])
# Question 3: Spanish alias for The Beatles?
results = query_by_name(ARTIST_URL, query_type["simple"], "The Beatles")
# pretty_print(results)
for alias in results["artists"][0]["aliases"]:
if alias["locale"] == "es":
print "The Spanish alias for The Beatles is " + alias["name"]
# Question 4: Nirvana disambiguation?
results = query_by_name(ARTIST_URL, query_type["simple"], "Nirvana")
# pretty_print(results)
print "The disambiguation for Nirvana is " + results["artists"][0]["disambiguation"]
# Question 5: Where was One Direction formed?
results = query_by_name(ARTIST_URL, query_type["simple"], "One Direction")
# pretty_print(results)
print "One Direction was formed in " + results["artists"][0]["life-span"]["begin"]
In [ ]: