On Monday, 18 April 2016 12:05:39 UTC+10, Sayth Renshaw wrote:
> Hi
>
> I have an XML and using pyquery to obtain the elements within it and then
> write it to csv.
>
> What is the best most reliable way to take dictionaries of each element, and
> print them(csv write later) based on each position so get item 0 of each list
> and then it 1 and so on.
>
> Any other code I post is open to criticism. Because there are many attributes
> I will want to collect my thought is to create a list of lists, again seems a
> bit clunky so could be wrong.
>
> from pyquery import PyQuery as pq
>
>
> d = pq(filename='20160319RHIL0_edit.xml')
> res = d('nomination')
> # myAt = pq.each(res.attr('bbid'))
> # print(repr(res))
> # myAt = [res.eq(i).attr('horse') for i in range(len(res))]
> # print(myAt)
>
> nomID = [res.eq(i).attr('horse') for i in range(len(res))]
> horseName = [res.eq(i).attr('horse') for i in range(len(res))]
> group = [nomID, horseName]
>
> for items in group:
> print(items)
>
>
> This is my source.
>
> <?xml version="1.0" encoding="UTF-8"?>
> <meeting id="42736" barriertrial="0" venue="Rosehill Gardens"
> date="2016-03-19T00:00:00" gearchanges="-1" stewardsreport="-1" gearlist="-1"
> racebook="0" postracestewards="0" meetingtype="TAB" rail="Timing - Electronic
> : Rail - +2m" weather="Fine " trackcondition="Good"
> nomsdeadline="2016-03-14T11:00:00" weightsdeadline="2016-03-15T16:00:00"
> acceptdeadline="2016-03-16T09:00:00" jockeydeadline="2016-03-16T12:00:00">
> <club abbrevname="Australian Turf Club" code="56398" associationclass="1"
> website="http://"; />
> <race id="213262" number="1" nomnumber="7" division="0" name="NATHAN'S
> FAMOUS EPONA STAKES" mediumname="EPONA" shortname="EPONA STAKES"
> stage="Results" distance="1900" minweight="0" raisedweight="0" class="~
> " age="3U " grade="0" weightcondition="SWP " trophy="1000"
> owner="1000" trainer="0" jockey="0" strapper="0" totalprize="150000"
> first="90000" second="30000" third="15000" fourth="7500" fifth="3000"
> time="2016-03-19T12:40:00" bonustype=" " nomsfee="0" acceptfee="0"
> trackcondition="Good " timingmethod="Electronic" fastesttime="1-56.83
> " sectionaltime="600/35.3 " formavailable="0" racebookprize="Of $150000 and
> trophies of $1000. First $90000 and trophies of $1000 to owner, second
> $30000, third $15000, fourth $7500, fifth $3000, sixth $1500, seventh $1500,
> eighth $1500">
> <condition line="1">Of $150000 and trophies of $1000. First $90000 and
> trophies of $1000 to owner, second $30000, third $15000, fourth $7500, fifth
> $3000, sixth $1500, seventh $1500, eighth $1500</condition>
> <condition line="3">No class restriction, Set Weights plus Penalties, For
> Three-Years-Old and Upwards, Fillies and Mares, (Group 3)</condition>
> <condition line="5">No Allowances for apprentices. Field Limit: 14 + 4
> EM</condition>
> <nomination number="4" saddlecloth="4" horse="Vergara" id="171115"
> idnumber="" regnumber="" blinkers="1" trainernumber="38701"
> trainersurname="Cummings" trainerfirstname="Anthony" trainertrack="Randwick"
> rsbtrainername="Anthony Cummings" jockeynumber="86876"
> jockeysurname="McDonald" jockeyfirstname="James" barrier="7" weight="55"
> rating="93" description="B M 5 Snippetson x Graces Spirit (Flying Spur)"
> colours="Yellow, Red Epaulettes And Cap" owners="Anthony Cummings
> Thoroughbreds Pty Ltd Syndicate (Mgrs: A & B Cummings) & P C Racing
> Investments Syndicate (Mgr: P J Carroll) " dob="2010-10-07T00:00:00" age="6"
> sex="M" career="30-7-4-2 $295445.00" thistrack="6-1-1-0 $90500.00"
> thisdistance="0-0-0-0" goodtrack="17-3-2-2 $101440.00" heavytrack="5-0-1-0
> $20200.00" slowtrack="" deadtrack="" fasttrack="0-0-0-0" firstup="7-2-1-2
> $108340.00" secondup="7-1-1-0 $43200.00" mindistancewin="0"
> maxdistancewin="0" finished="1" weightvariation="0" variedweight="55"
> decimalmargin="0.00"
penalty="0" pricestarting="$12" sectional200="0" sectional400="0"
sectional600="0" sectional800="0" sectional1200="0" bonusindicator="" />
> <nomination number="2" saddlecloth="2" horse="Heavens Above" id="187674"
> idnumber="" regnumber="" blinkers="0" trainernumber="736"
> trainersurname="Martin" trainerfirstname="Tim" trainertrack="Rosehill"
> rsbtrainername="Tim Martin" jockeynumber="46930" jockeysurname="Angland"
> jockeyfirstname="Tye" barrier="6" weight="56" rating="88" description="B M 4
> Street Cry(IRE) x Reggie(NZ) (Germano(GB))" colours="Yellow, Green Chevrons,
> Striped Cap" owners="President Bloodstock Pty Ltd (Mgr: R C Kemister)"
> dob="2011-08-12T00:00:00" age="5" sex="M" career="12-3-3-4 $271520.00"
> thistrack="4-0-3-0 $41425.00" thisdistance="0-0-0-0" goodtrack="10-2-2-4
> $214845.00" heavytrack="0-0-0-0" slowtrack="" deadtrack=""
> fasttrack="0-0-0-0" firstup="2-0-1-1 $20710.00" secondup="2-0-2-0 $24675.00"
> mindistancewin="0" maxdistancewin="0" finished="2" weightvariation="0"
> variedweight="56" decimalmargin="0.20" penalty="0" pricestarting="$3.80F"
> sectional200="0" sectional400="0" sectional600="0" sectional800="0"
sectional1200="0" bonusindicator="" />
> <nomination number="6" saddlecloth="6" horse="Sweet Fire" id="184732"
> idnumber="" regnumber="" blinkers="0" trainernumber="681"
> trainersurname="Waller" trainerfirstname="Chris" trainertrack="Rosehill"
> rsbtrainername="Chris Waller" jockeynumber="51661" jockeysurname="Berry"
> jockeyfirstname="Tommy" barrier="5" weight="54" rating="85" description="BR M
> 4 Shamardal(USA) x Zarinia(IRE) (Intikhab(USA))" colours="Lilac And White
> Halves, Black Cap" owners="E J Lucas " dob="2011-09-25T00:00:00" age="5"
> sex="M" career="15-4-2-2 $212750.00" thistrack="6-1-1-1 $56690.00"
> thisdistance="0-0-0-0" goodtrack="9-2-1-2 $120395.00" heavytrack="1-0-0-0
> $450.00" slowtrack="" deadtrack="" fasttrack="0-0-0-0" firstup="3-0-0-0
> $1900.00" secondup="3-1-1-0 $42200.00" mindistancewin="0" maxdistancewin="0"
> finished="3" weightvariation="0" variedweight="54" decimalmargin="0.50"
> penalty="0" pricestarting="$7" sectional200="0" sectional400="0"
> sectional600="0" sectional800="0" sectional1200="0" bonusindicator
="" />
> <nomination number="7" saddlecloth="7" horse="Alegria" id="181928"
> idnumber="" regnumber="" blinkers="1" trainernumber="235"
> trainersurname="O'Shea" trainerfirstname="John" trainertrack="Agnes
> Banks/Hawkesbury" rsbtrainername="John O'Shea" jockeynumber="40275"
> jockeysurname="Clark" jockeyfirstname="Tim" barrier="1" weight="54"
> rating="81" description="B M 4 Medaglia D'oro(USA) x Pure Joy (Fusaichi
> Pegasus(USA))" colours="Royal Blue" owners="Godolphin"
> dob="2011-10-06T00:00:00" age="5" sex="M" career="12-3-1-5 $216850.00"
> thistrack="4-1-0-2 $89600.00" thisdistance="0-0-0-0" goodtrack="5-1-1-3
> $87575.00" heavytrack="4-2-0-1 $114275.00" slowtrack="" deadtrack=""
> fasttrack="0-0-0-0" firstup="3-2-0-1 $80500.00" secondup="3-0-0-2 $20850.00"
> mindistancewin="0" maxdistancewin="0" finished="4" weightvariation="0"
> variedweight="54" decimalmargin="0.70" penalty="0" pricestarting="$8.50"
> sectional200="0" sectional400="0" sectional600="0" sectional800="0"
> sectional1200="0" bonusindicator=""
/>
> <nomination number="11" saddlecloth="11" horse="Piamimi" id="158914"
> idnumber="" regnumber="" blinkers="0" trainernumber="773"
> trainersurname="Bennett" trainerfirstname="Greg" trainertrack="Scone"
> rsbtrainername="Greg Bennett" jockeynumber="48503" jockeysurname="Williams"
> jockeyfirstname="Craig" barrier="8" weight="54" rating="75" description="B OR
> BR M 6 Not a Single Doubt x Blurrta(NZ) (Bahhare(USA))" colours="Yellow, Dark
> Blue Diamonds, Striped Sleeves And Cap" owners="Dr M Wylie, K Kenny, J
> Canning, M Mcfayden, B Hyde & P Toubji " dob="2009-08-23T00:00:00"
> age="7" sex="M" career="35-6-4-3 $170275.00" thistrack="2-0-0-0 $5150.00"
> thisdistance="2-0-0-0 $900.00" goodtrack="25-3-2-2 $78640.00"
> heavytrack="4-1-1-1 $24510.00" slowtrack="" deadtrack="" fasttrack="0-0-0-0"
> firstup="8-1-3-0 $27375.00" secondup="8-1-0-2 $32645.00" mindistancewin="0"
> maxdistancewin="0" finished="5" weightvariation="0" variedweight="54"
> decimalmargin="1.10" penalty="0" pricestarting="$41" sectional
200="0" sectional400="0" sectional600="0" sectional800="0" sectional1200="0"
bonusindicator="" />
> <nomination number="10" saddlecloth="10" horse="Blendwell" id="171408"
> idnumber="" regnumber="" blinkers="0" trainernumber="78024"
> trainersurname="Moody" trainerfirstname="Peter G" trainertrack="Warwick Farm"
> rsbtrainername="Peter G Moody" jockeynumber="85036" jockeysurname="Lane"
> jockeyfirstname="Damian" barrier="10" weight="54" rating="78" description="B
> M 5 Hard Spun(USA) x Bridie Belle(NZ) (Al Akbar)" colours="Tartan, Red Sash
> And Armbands" owners="D & M Esplin Pty Ltd (Mgr: Mrs M E Esplin)"
> dob="2010-10-06T00:00:00" age="6" sex="M" career="17-4-3-4 $107845.00"
> thistrack="0-0-0-0" thisdistance="0-0-0-0" goodtrack="8-0-1-2 $25135.00"
> heavytrack="2-2-0-0 $42000.00" slowtrack="" deadtrack="" fasttrack="0-0-0-0"
> firstup="6-0-0-3 $8835.00" secondup="3-1-0-1 $20050.00" mindistancewin="0"
> maxdistancewin="0" finished="6" weightvariation="0" variedweight="54"
> decimalmargin="1.20" penalty="0" pricestarting="$17" sectional200="0"
> sectional400="0" sectional600="0" sectional800="0"
sectional1200="0" bonusindicator="" />
> <nomination number="3" saddlecloth="3" horse="Adorabeel (NZ)" id="166836"
> idnumber="" regnumber="" blinkers="0" trainernumber="1942"
> trainersurname="Pride" trainerfirstname="Joseph" trainertrack="Warwick Farm"
> rsbtrainername="Joseph Pride" jockeynumber="86280" jockeysurname="Clipperton"
> jockeyfirstname="Sam" barrier="9" weight="56" rating="86" description="BR OR
> BLK M 6 Savabeel x Plaza Doree(FR) (Saumarez(GB))" colours="Maroon, White
> Crossed Sashes, Yellow Armbands And Cap" owners="Mystery Downs (Mgr: F W
> Cook)" dob="2009-09-11T00:00:00" age="7" sex="M" career="34-6-5-4 $281810.00"
> thistrack="11-1-2-1 $105750.00" thisdistance="2-0-0-0 $3800.00"
> goodtrack="24-3-3-1 $203910.00" heavytrack="0-0-0-0" slowtrack=""
> deadtrack="" fasttrack="0-0-0-0" firstup="7-1-1-1 $28650.00"
> secondup="7-0-2-1 $25050.00" mindistancewin="0" maxdistancewin="0"
> finished="7" weightvariation="0" variedweight="56" decimalmargin="2.30"
> penalty="0" pricestarting="$13" sectional200="0" sectional400="0" sectio
nal600="0" sectional800="0" sectional1200="0" bonusindicator="" />
> <nomination number="8" saddlecloth="8" horse="Mary Lou" id="172933"
> idnumber="" regnumber="" blinkers="1" trainernumber="38701"
> trainersurname="Cummings" trainerfirstname="Anthony" trainertrack="Randwick"
> rsbtrainername="Anthony Cummings" jockeynumber="86596"
> jockeysurname="Collett" jockeyfirstname="Jason" barrier="11" weight="54"
> rating="80" description="B M 5 Fastnet Rock x Miss Alabama(NZ)
> (Woodman(USA))" colours="Red, Black Diagonal Stripes And Armbands, Quartered
> Cap" owners="E-Thoroughbred (Mgr: A W & M G Bott) & Evergreen Rich
> (Mgr: A W Bott, P K Siu, M Siu & E Siu)" dob="2010-09-18T00:00:00"
> age="6" sex="M" career="18-3-3-4 $156860.00" thistrack="3-1-0-1 $33375.00"
> thisdistance="1-1-0-0 $17250.00" goodtrack="14-3-2-4 $130335.00"
> heavytrack="2-0-0-0 $525.00" slowtrack="" deadtrack="" fasttrack="0-0-0-0"
> firstup="3-1-0-0 $31125.00" secondup="3-0-1-2 $25100.00" mindistancewin="0"
> maxdistancewin="0" finished="8" weightvariation="0" variedweight="54"
> decimalmargi
n="2.70" penalty="0" pricestarting="$18" sectional200="0" sectional400="0"
sectional600="0" sectional800="0" sectional1200="0" bonusindicator="" />
> <nomination number="9" saddlecloth="9" horse="Skyline Blush" id="182533"
> idnumber="" regnumber="" blinkers="1" trainernumber="38701"
> trainersurname="Cummings" trainerfirstname="Anthony" trainertrack="Randwick"
> rsbtrainername="Anthony Cummings" jockeynumber="1472" jockeysurname="McEvoy"
> jockeyfirstname="Kerrin" barrier="4" weight="54" rating="80" description="B M
> 4 Northern Meteor x Cara Y Cruz(USA) (King of Kings(IRE))" colours="Red,
> Black Stripes" owners="Gooree Stud (E M Cojuangco & M C Cummings)"
> dob="2011-10-29T00:00:00" age="5" sex="M" career="14-5-0-2 $204190.00"
> thistrack="4-1-0-1 $52225.00" thisdistance="2-1-0-1 $41375.00"
> goodtrack="7-0-0-1 $19535.00" heavytrack="4-2-0-1 $111125.00" slowtrack=""
> deadtrack="" fasttrack="0-0-0-0" firstup="3-1-0-0 $21125.00"
> secondup="3-0-0-1 $12460.00" mindistancewin="0" maxdistancewin="0"
> finished="9" weightvariation="0" variedweight="54" decimalmargin="3.10"
> penalty="0" pricestarting="$9.50" sectional200="0" sectional400="0" sectio
nal600="0" sectional800="0" sectional1200="0" bonusindicator="" />
> <nomination number="5" saddlecloth="5" horse="All Cerise" id="171801"
> idnumber="" regnumber="" blinkers="0" trainernumber="681"
> trainersurname="Waller" trainerfirstname="Chris" trainertrack="Rosehill"
> rsbtrainername="Chris Waller" jockeynumber="86721" jockeysurname="Dunn"
> jockeyfirstname="Dwayne" barrier="3" weight="54" rating="92" description="B M
> 5 Redoute's Choice x Trick Taker(USA) (Capote(USA))" colours="Purple, White
> Hoops, Black Seams, Purple And White Quartered Cap" owners="Woppitt
> Bloodstock (Mgr: Mrs D N Kepitis)" dob="2010-11-05T00:00:00" age="6" sex="M"
> career="28-6-3-3 $349890.00" thistrack="10-1-1-1 $111750.00"
> thisdistance="0-0-0-0" goodtrack="21-6-2-3 $327690.00" heavytrack="2-0-0-0
> $450.00" slowtrack="" deadtrack="" fasttrack="0-0-0-0" firstup="7-1-0-2
> $45790.00" secondup="4-1-0-0 $71200.00" mindistancewin="0" maxdistancewin="0"
> finished="10" weightvariation="0" variedweight="54" decimalmargin="4.10"
> penalty="0" pricestarting="$6" sectional200="0" sectional400=
"0" sectional600="0" sectional800="0" sectional1200="0" bonusindicator="" />
> <nomination number="1" saddlecloth="1" horse="Gust of Wind (NZ)"
> id="181079" idnumber="" regnumber="" blinkers="1" trainernumber="41655"
> trainersurname="Sargent" trainerfirstname="John" trainertrack="Randwick"
> rsbtrainername="John Sargent" jockeynumber="84015" jockeysurname="Avdulla"
> jockeyfirstname="Brenton" barrier="2" weight="59" rating="106" description="B
> M 4 Darci Brahma(NZ) x Starrystarrynight(IRE) (Sadler's Wells(USA))"
> colours="Yellow, White Checked Sash, Checked Sleeves And Cap" owners="Go
> Bloodstock (Mgr: Sir O G Glenn)" dob="2011-09-07T00:00:00" age="5" sex="M"
> career="12-3-0-0 $974900.00" thistrack="0-0-0-0" thisdistance="0-0-0-0"
> goodtrack="10-2-0-0 $279150.00" heavytrack="0-0-0-0" slowtrack=""
> deadtrack="" fasttrack="0-0-0-0" firstup="4-1-0-0 $8900.00" secondup="3-1-0-0
> $20250.00" mindistancewin="0" maxdistancewin="0" finished="11"
> weightvariation="0" variedweight="59" decimalmargin="7.40" penalty="0"
> pricestarting="$15" sectional200="0" sectional400="0" sectiona
l600="0" sectional800="0" sectional1200="0" bonusindicator="" />
> </race>
> </meeting>
>
> If I do this
>
>
> nomID = [res.eq(i).attr('horse') for i in range(len(res))]
> horseName = [res.eq(i).attr('horse') for i in range(len(res))]
> print(nomID, horseName)
>
> comes out correctly
>
> In [7]: 171115 Vergara
>
> Since I will be taking another 10 attributes out of nominmation category an
> efficient way that ensures data integrity would be valued.
>
> Thanks
>
> Sayth
Also if I create it as an iterable only the first list in the list is printed.
group = [nomID, horseName]
iterthis = iter(group)
for items in iterthis:
print(items)
In [10]: ['Vergara', 'Heavens Above', 'Sweet Fire', 'Alegria', 'Piamimi',
'Blendwell', 'Adorabeel (NZ)', 'Mary Lou', 'Skyline Blush', 'All Cerise', 'Gust
of Wind (NZ)']
['Vergara', 'Heavens Above', 'Sweet Fire', 'Alegria', 'Piamimi', 'Blendwell',
'Adorabeel (NZ)', 'Mary Lou', 'Skyline Blush', 'All Cerise', 'Gust of Wind
(NZ)']
Sayth
--
https://mail.python.org/mailman/listinfo/python-list
