Python Forum
parsing local xml files to csv
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
parsing local xml files to csv
#6
(Feb-24-2019, 11:46 AM)erdem_ustunmu Wrote: >>> [i.text.strip() for i in var.find_all('sumStat')]
as below or otherwise
['vald':'76208', 'invd':'0', 'min':'1001', 'max':'1800', 'mean':'1412.79', 'stdev':'231.955']


2.How do I combine category tags?
Example:
>>> sum_stat = [i.text.strip() for i in var.find_all('sumStat')]
>>> sum_stat
['76208', '0', '1001', '1800', '1412.79', '231.955']

>>> att = [i.attrs['type'] for i in var.find_all('sumStat')]
>>> att
['vald', 'invd', 'min', 'max', 'mean', 'stdev']

>>> # Combine with zip()
>>> list(zip(att, sum_stat))
[('vald', '76208'),
 ('invd', '0'),
 ('min', '1001'),
 ('max', '1800'),
 ('mean', '1412.79'),
 ('stdev', '231.955')]

>>> dict(list(zip(att, sum_stat)))
{'vald': '76208',
 'invd': '0',
 'min': '1001',
 'max': '1800',
 'mean': '1412.79',
 'stdev': '231.955'}
erdem_ustunmu Wrote:2.How do I combine category tags?
Try something yourself based on info gotten til now.
Reply


Messages In This Thread
parsing local xml files to csv - by erdem_ustunmu - Feb-23-2019, 11:30 AM
RE: parsing local xml files to csv - by snippsat - Feb-23-2019, 12:22 PM
RE: parsing local xml files to csv - by snippsat - Feb-23-2019, 10:41 PM
RE: parsing local xml files to csv - by snippsat - Feb-25-2019, 03:24 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  uploading files from a ubuntu local directory to Minio storage container dchilambo 0 571 Dec-22-2023, 07:17 AM
Last Post: dchilambo
  How to take the tar backup files form remote server to local server sivareddy 0 1,989 Jul-14-2021, 01:32 PM
Last Post: sivareddy
  opening files and output of parsing leodavinci1990 4 2,645 Oct-12-2020, 06:52 AM
Last Post: bowlofred
  Parsing Xml files >3gb using lxml iterparse Prit_Modi 2 2,454 May-16-2020, 06:53 AM
Last Post: Prit_Modi
  Parsing Attached .MSG Files with Python3 ericl42 1 3,754 Apr-12-2019, 06:28 PM
Last Post: ericl42
  Fetching html files from local directories shiva 3 3,558 Mar-20-2018, 05:12 PM
Last Post: wavic

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020