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
#3
Thank you so much for answering.
I reviewed the Beautiful Soup package you mentioned.
I've also tried xml, which has a simple level of html or a few elements in xml.
But I've never been successful in nested tags.

how to get the tags and elements between the <dataDscr> ... </ dataDscr> tags,attributes and transfer them to csv.

How do I make a find and loop for <dataDscr><var> ... </ var></ dataDscr> tags?

There are too many xml files, So have to I ,to define all the tags and attributes that depend on them one by one?

for example:Located at the end of the xml file
<var ID="V541" name="ilo_neet" files="F6" dcml="0" intrvl="discrete">

There are multiple categories for this variable
<catgry>
<catValu>
1
</catValu>
<labl>
Youth not in education, employment or training
</labl>
<catStat type="freq">
4967
</catStat>
</catgry>
<catgry missing="Y">
<catValu>
Sysmiss
</catValu>
<catStat type="freq">
71241
</catStat>
</catgry>


(Feb-23-2019, 12:22 PM)snippsat Wrote: You use a parser Python has two big ones that most use BeautifulSoup and lxml.
To give start example and parse a couple of values.
from bs4 import BeautifulSoup

soup = BeautifulSoup(open('NPL_2008_LFS_v01_M_v01_A_ILOVAR.xml', encoding='utf-8'), 'xml')
title = soup.find('titl')
producer = soup.find('producer')
print(title.text.strip())
print(producer.attrs.get('affiliation'))
Output:
NPL_2008_LFS_v01_M International Labour Organization
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 erdem_ustunmu - Feb-23-2019, 03:17 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 514 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,939 Jul-14-2021, 01:32 PM
Last Post: sivareddy
  opening files and output of parsing leodavinci1990 4 2,606 Oct-12-2020, 06:52 AM
Last Post: bowlofred
  Parsing Xml files >3gb using lxml iterparse Prit_Modi 2 2,401 May-16-2020, 06:53 AM
Last Post: Prit_Modi
  Parsing Attached .MSG Files with Python3 ericl42 1 3,716 Apr-12-2019, 06:28 PM
Last Post: ericl42
  Fetching html files from local directories shiva 3 3,465 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