Skip to main content

All Questions

Tagged with
2 votes
4 answers
75 views

how to turn an xml file into a csv python

I am looking to turn this XNL file countries into a table in a CSV. However, I am having trouble parsing it/extracting the data from it. I am trying to turn it into a table with 5 columns which are ['...
user23486108's user avatar
3 votes
2 answers
132 views

Parsing a csv file to add details to xml file

Ned help to parse a csv file which has following details to xml file csv file is in the following format: name,ip,timeout domain\user1,10.119.77.218,9000 domain\user2,2.80.189.26,9001 domain\user3,4....
deep's user avatar
  • 726
0 votes
1 answer
97 views

Check mismatch data from 2 file CSV and XML

I have 2 kinds of file contains the data are CSV and XML, I want to code in Python and probably using Pandas to read data from 2 file and compare to check if when one of the file have changed the data ...
My Võ's user avatar
  • 1
0 votes
1 answer
62 views

XML Nesting Format Using CSV Through Python

I have a csv format file that I am trying to convert to xml using python. Right now the logic is building one block of xml per single row in csv. I am looking for nesting of some elements in xml. For ...
Mr Peanutbutter's user avatar
0 votes
1 answer
64 views

How to read stackoverflow archive post data to python? [duplicate]

I downloaded the archival data of stackoverflow posts from https://archive.org/details/stackexchange. However, after expanding the 7z file, I have a 103GB xml file of posts. I tried to use python to ...
T. Xu's user avatar
  • 1
1 vote
2 answers
249 views

Parsing XML to CSV in Python

I'm trying to write a Python script that parses an XML file and generates CSV files for each table in the XML. Each table should contain its attributes. Additionally, I want to create a CSV file that ...
Taliesin's user avatar
-2 votes
1 answer
38 views

XML Conversion to CSV with jsaon loads

Hell All , I'm new to python and I have a request to convert XML to CSV..can any 1 help me on it..here the XML text what I have and I used following code ..but it works fine only if there are no curly ...
KJT's user avatar
  • 1
0 votes
3 answers
86 views

Xml file returning NonType traceback errror while parsing

I have been trying to parse an xml file using ElementTree.parse and I was getting NullType TraceBack Error. I know a lot of question has been asked about this same issue, but I noticed something about ...
Z.Edibo's user avatar
  • 27
0 votes
0 answers
51 views

how to search for a specific nouns in a PDF file inside an XML file and print the noun and its root as an output

I have a code that is going to extract the nouns from a specific line in a PDF file and then save the outputs in another file, then I made an XML file that contains some of these nouns inside a root ...
yousef alnajjar's user avatar
1 vote
1 answer
89 views

Is there a script to convert an XML file to Excel that doesn't use PHP nor Excel's Import Data?

Python has been attempted with the following code but output data in XLS or CSV is not the same as the data observed in the XML (via XML Notepad). Any support on this would be appreciated ... thanks: ...
stitch70's user avatar
  • 143
1 vote
2 answers
10k views

How can I convert XML to CSV in Python without using libraries such as Etree or Xmltodict?

xml file would be like this: <employee> <id>303</id> <name>varma</name> <age>20</age> <salary>120000</salary> ...
JANAKI RAM KILUMU HU21CSEN0300's user avatar
0 votes
2 answers
96 views

Parsing xml data and writing it on a csv file

I am trying to scrape and save data about prison population and prison population rates per year and per country from https://www.prisonstudies.org/. These data are reported in country-specific pages, ...
Pelin Kasap's user avatar
0 votes
1 answer
137 views

Python, large files

I'm trying to open a 100GB file in python, this is the stack overflow archive (https://archive.org/download/stackexchange zip file name stackoverflow.com-Posts.7z content Posts.xml) of posts from 2008 ...
Matthew's user avatar
  • 27
-1 votes
2 answers
134 views

How do I convert XML to CSV, when one of the values is a header attribute?

I'm trying to convert an XML file into a CSV file using Python. I have two values in the XML that I'm trying to find. Here's my code: import csv import xml.etree.ElementTree as ET def main(): # ...
enor's user avatar
  • 119
1 vote
1 answer
106 views

Pyhton split XML file and store in a CSV file

I want to convert an XML file to CSV, the full file is here. Here's a sample: <?xml version="1.0" encoding="Windows-1252" standalone="yes"?> <pdv_liste> &...
hug's user avatar
  • 305

15 30 50 per page
1
2 3 4 5
23