xml_file = "nyct_ene.xml"

import untangle

doc = untangle.parse(xml_file)

doc.get_elements()

doc.

outages = doc.NYCOutages.outage

len(outages)

outage = outages[5]

outage.get_elements()

outage.estimatedreturntoservice.cdata

%%bash
head thousand_signs.csv

# Simple reading

f = open("thousand_signs.csv", "r")
for _ in range(3):
    print(repr(f.readline()))

import csv

# Using a CSV reader

f.seek(0)

reader = csv.reader(f)
reader

for _ in range(3):
    print(repr(reader.next()))

f.close()

csv.list_dialects()

%%bash
head example.csv

csv.register_dialect("semicolon", delimiter=";", skipinitialspace=True)
csv.list_dialects()

f = open("example.csv", "r")

reader = csv.reader(f, "semicolon")

for line in reader:
    print(line)

f.close()

sniffer = csv.Sniffer()

f = open("example.csv", "r")

sample = f.read()

dialect = sniffer.sniff(sample)

f.seek(0)
reader = csv.reader(f, dialect)
for line in reader:
    print(line)

f.seek(0)

sample = f.read(7)  # Read 7 bytes

print(repr(sample))
print("")

f.seek(0)

dialect = sniffer.sniff(sample)

reader = csv.reader(f, dialect)
for line in reader:
    print(line)

f.seek(0)

sample = f.read(80)

print(repr(sample))
print("")

f.seek(0)

dialect = sniffer.sniff(sample)

reader = csv.reader(f, dialect)
for line in reader:
    print(line)

f.seek(0)

dialect.delimiter, dialect.lineterminator, dialect.skipinitialspace

sniffer.has_header(sample)

f.close()

f = open("thousand_signs.csv", "r")
sample = f.read(100)
f.close

sniffer.has_header(sample)

%%bash
# Example from wikipeda page on JSON
cat example.json

import json

f = open("example.json", "r")

json_data = json.load(f)

f.close()

json_data

import requests

r = requests.get("http://ws.spotify.com/search/1/track.json", params={"q": "kaizers orchestra"})

r.url

r.status_code

r.text[:2000]

json_data = r.json()

len(json_data["tracks"])

json_data["tracks"][1]

r.headers

logo = requests.get("http://www.scilifelab.se/images/logo_header.png")

logo.headers

logo.content[:100]

from IPython.core.display import Image

Image(logo.content)