import requests
import csv
from xml.dom.minidom import parse
import xml.dom.minidom
resultFile = open("output_jl.csv",'wb')
wr = csv.writer(resultFyle,delimiter=',')
wr.writerow(["issn","tag", "ind1", "ind2" ,"code" ,"value"])
#Replace XXX.. with your own key
url ="http://www.worldcat.org/webservices/catalog/content/issn/0000-0019?wskey=XXXXXXXXXXXXXXXXXX"
response = requests.get(url)
print response.content
DOMTree = xml.dom.minidom.parseString(response.content)
collection = DOMTree.documentElement
datafields = collection.getElementsByTagName("datafield")
for datafield in datafields:
subfields = datafield.getElementsByTagName("subfield")
for subfield in subfields:
issn = "0000-0019"
tag = datafield.getAttribute("tag").encode('utf-8')
ind1 = datafield.getAttribute("ind1").encode('utf-8')
ind2 = datafield.getAttribute("ind2").encode('utf-8')
code = subfield.getAttribute("code").encode('utf-8')
value = subfield.childNodes[0].data.encode('utf-8')
wr.writerow([issn,tag, ind1, ind2 ,code ,value])
#-------------------------------------------------------------------------------------------------------------#
XML:
<?xml version="1.0" encoding="UTF-8"?>
-<record xmlns="http://www.loc.gov/MARC21/slim">
<leader>00000cas a2200000 a 4500</leader>
<controlfield tag="001">2396688</controlfield>
<controlfield tag="008">760826d19492013dcuwr p 0 a0eng c</controlfield>
-<datafield tag="010" ind2=" " ind1=" ">
<subfield code="a"> 80643369 </subfield>
<subfield code="z"> 83641459 </subfield>
<subfield code="z"> 85644546 </subfield>
<subfield code="z"> 83641460 </subfield>
<subfield code="z"> 84644357 </subfield>
</datafield>
-<datafield tag="022" ind2=" " ind1="0">
<subfield code="a">0148-0227</subfield>
<subfield code="l">0148-0227</subfield>
<subfield code="z">0022-1406</subfield>
<subfield code="z">0196-6928</subfield>
<subfield code="z">0196-6936</subfield>
<subfield code="z">0885-3401</subfield>
<subfield code="z">8755-8556</subfield>
<subfield code="z">0196-2256</subfield>
<subfield code="z">0747-7309</subfield>
<subfield code="z">1934-8592</subfield>
<subfield code="z">1934-8843</subfield>
<subfield code="2">1</subfield>
</datafield>
-<datafield tag="222" ind2="0" ind1=" ">
<subfield code="a">Journal of geophysical research</subfield>
</datafield>
-<datafield tag="245" ind2="0" ind1="0">
<subfield code="a">Journal of geophysical research.</subfield>
</datafield>
-<datafield tag="246" ind2=" " ind1="1">
<subfield code="a">Journal of geophysical research.</subfield>
<subfield code="p">Space physics</subfield>
</datafield>
-<datafield tag="246" ind2=" " ind1="1">
<subfield code="a">Journal of geophysical research.</subfield>
<subfield code="p">Oceans and atmospheres</subfield>
</datafield>
-<datafield tag="246" ind2=" " ind1="1">
<subfield code="a">Journal of geophysical research.</subfield>
<subfield code="p">Solid earth and planets</subfield>
</datafield>
-<datafield tag="246" ind2=" " ind1="1">
<subfield code="a">Journal of geophysical research.</subfield>
<subfield code="p">Solid earth</subfield>
</datafield>
-<datafield tag="246" ind2=" " ind1="1">
<subfield code="a">Journal of geophysical research.</subfield>
<subfield code="p">Oceans</subfield>
</datafield>
-<datafield tag="246" ind2=" " ind1="1">
<subfield code="a">Journal of geophysical research.</subfield>
<subfield code="p">Atmospheres</subfield>
</datafield>
-<datafield tag="246" ind2=" " ind1="1">
<subfield code="a">Journal of geophysical research.</subfield>
<subfield code="p">Earth surface</subfield>
</datafield>
-<datafield tag="246" ind2=" " ind1="1">
<subfield code="a">Journal of geophysical research.</subfield>
<subfield code="p">Biogeosciences</subfield>
</datafield>
-<datafield tag="246" ind2=" " ind1="1">
<subfield code="i">Issues for 1974- also have title:</subfield>
<subfield code="a">JGR</subfield>
</datafield>
-<datafield tag="260" ind2=" " ind1=" ">
<subfield code="a">Richmond, Va. :</subfield>
<subfield code="b">William Byrd Press for John Hopkins Press,</subfield>
<subfield code="c">1949-2013</subfield>
</datafield>
-<datafield tag="260" ind2=" " ind1="3">
<subfield code="3">1959- :</subfield>
<subfield code="a">Washington, D.C. :</subfield>
<subfield code="b">American Geophysical Union</subfield>
</datafield>
-<datafield tag="300" ind2=" " ind1=" ">
<subfield code="a">v. :</subfield>
<subfield code="b">ill. ;</subfield>
<subfield code="c">30 cm.</subfield>
</datafield>
-<datafield tag="500" ind2=" " ind1=" ">
<subfield code="a">Title from cover.</subfield>
</datafield>
-<datafield tag="500" ind2=" " ind1=" ">
<subfield code="a">Each pt. is also available separately from publisher.</subfield>
</datafield>
-<datafield tag="650" ind2="0" ind1=" ">
<subfield code="a">Geomagnetism</subfield>
<subfield code="v">Periodicals.</subfield>
</datafield>
-<datafield tag="650" ind2="0" ind1=" ">
<subfield code="a">Geophysics</subfield>
<subfield code="v">Periodicals.</subfield>
</datafield>
-<datafield tag="650" ind2="0" ind1=" ">
<subfield code="a">Astrophysics</subfield>
<subfield code="v">Periodicals.</subfield>
</datafield>
-<datafield tag="650" ind2="7" ind1="1">
<subfield code="a">Geofysica.</subfield>
<subfield code="2">gtt</subfield>
</datafield>
-<datafield tag="650" ind2="7" ind1=" ">
<subfield code="a">Astrophysics.</subfield>
<subfield code="2">fast</subfield>
<subfield code="0">(OCoLC)fst00819797</subfield>
</datafield>
-<datafield tag="650" ind2="7" ind1=" ">
<subfield code="a">Geomagnetism.</subfield>
<subfield code="2">fast</subfield>
<subfield code="0">(OCoLC)fst00940796</subfield>
</datafield>
-<datafield tag="650" ind2="7" ind1=" ">
<subfield code="a">Geophysics.</subfield>
<subfield code="2">fast</subfield>
<subfield code="0">(OCoLC)fst00941002</subfield>
</datafield>
-<datafield tag="655" ind2="7" ind1=" ">
<subfield code="a">Periodicals.</subfield>
<subfield code="2">fast</subfield>
<subfield code="0">(OCoLC)fst01411641</subfield>
</datafield>
-<datafield tag="710" ind2=" " ind1="2">
<subfield code="a">American Geophysical Union.</subfield>
</datafield>
-<datafield tag="856" ind2="1" ind1="4">
<subfield code="3">Space physics section</subfield>
<subfield code="u">http://www.agu.org/journals/ja/</subfield>
</datafield>
-<datafield tag="856" ind2="1" ind1="4">
<subfield code="3">Solid earth section</subfield>
<subfield code="u">http://www.agu.org/journals/jb/</subfield>
</datafield>
-<datafield tag="856" ind2="1" ind1="4">
<subfield code="3">Oceans section</subfield>
<subfield code="u">http://www.agu.org/journals/jc/</subfield>
</datafield>
-<datafield tag="856" ind2="1" ind1="4">
<subfield code="3">Atmospheres section</subfield>
<subfield code="u">http://www.agu.org/journals/jd/</subfield>
</datafield>
-<datafield tag="856" ind2="1" ind1="4">
<subfield code="3">Planets section</subfield>
<subfield code="u">http://www.agu.org/journals/je/</subfield>
</datafield>
-<datafield tag="856" ind2="1" ind1="4">
<subfield code="3">Earth surface section</subfield>
<subfield code="u">http://www.agu.org/journals/jf/</subfield>
</datafield>
-<datafield tag="856" ind2="1" ind1="4">
<subfield code="3">Biogeosciences section</subfield>
<subfield code="u">http://www.agu.org/journals/jg/</subfield>
</datafield>
-<datafield tag="856" ind2="1" ind1="4">
<subfield code="u">http://www.agu.org/journals/jgr/1950.shtml</subfield>
</datafield>
-<datafield tag="856" ind2="1" ind1="4">
<subfield code="3">1949-1977</subfield>
<subfield code="u">http://wileyonlinelibrary.com/journal/JGR</subfield>
<subfield code="z">Issues of earlier title also at website</subfield>
</datafield>
</record>
No comments:
Post a Comment