Questions tagged [readxml]

113 questions
0
votes
0 answers

Pandas read_xml - AttributeError: module 'pandas' has no attribute 'read_xml'

I ran into the error: " AttributeError: module 'pandas' has no attribute 'read_xml' " This would be a huge lifesaver if I could ingest the XML with one function into a pandas df without trying to iterate through etc. I am running pandas 1.3.4 and…
0
votes
1 answer

Dataset ReadXml returns Rows Instead of Columns

I am trying to create a datatable from an xml file, using the dataset readxml method. however i am struggling to define the schema correctly to properly interpret this file. i think the problem lies with the nesting and the fact that the ColumnUid…
Praxiom
  • 578
  • 1
  • 8
  • 21
0
votes
2 answers

Read XML with column names as attribute values into pandas DataFrame

I have an XML file like this: 1
Borut Flis
  • 15,715
  • 30
  • 92
  • 119
0
votes
1 answer

Read xml file into DataSet when xmlns' are present

The end goal is to be able to query an XML file that has been provided by a third party. I need to be able to query each element to return its results. I am not stuck on the idea of reading it into a dataset, however, for me it just seems to be the…
Talsiter
  • 53
  • 1
  • 6
0
votes
1 answer

C# DataSet ReadXML error: "the table xxx is already allocated as a child of another table yyy". No schema

I'm using ReadXML from DataSet to read a XML document without any schema. There are 2 'duration' tags each in a different parent tag. That is why ReadXML complaining: System.Data.DataException: The table 'duration' is already allocated as a child…
RoundOutTooSoon
  • 9,821
  • 8
  • 35
  • 52
0
votes
1 answer

Visual Basic set User Agent with ReadXml

I'm trying to set the user agent for a request with XmlRead. I googled a lot about this and couldn't find the answer. Here is my chunk of code: Dim RssData As DataSet Dim Title As String Dim Url As String Dim Stream As…
BebliucGeorge
  • 751
  • 2
  • 8
  • 15
0
votes
1 answer

lapply and read_xml.character

Iam trying to extract data from a website using a custom function: library(tidyverse) library(rvest) url = "https://www.boerse.de/fundamental-analyse/garbage/" # last part does not change outcome, therefore 'garbage' read_html_tables =…
0
votes
1 answer

C# Reading XML to dataset throwing error with nested element of same name

DataSet dset = new DataSet(); dset.ReadXml(FILENAME); The error I got while Reading xml to dataset : Cannot add a SimpleContent column to a table containing element columns or nested relations. I got to know what is causing the issue. My xml element…
0
votes
0 answers

I want to read a xml file and store only specific tags into a new xml file using java?

Ex: Xmlfile.xml( id, name, age, email) and newxmlfile.xml(email).
GAJENDRAN
  • 1
  • 1
0
votes
0 answers

pandas-read-xml has error on 'json-normalize'

I saw there is a way to directly read XML files using pandas. I followed and used this package. However, I keep getting errors. https://pypi.org/project/pandas-read-xml/ import pandas as pd import pandas_read_xml as pdx from pandas.io.json import…
0
votes
1 answer

Strange mismatched tag error with pandas read xml

I have been using the package pandas_read_xml to read XML files into pandas dataframe. However, I have started experiencing very strange behavior with this package lately. The xml parser occasionally crashes, but on repeated attempts, it works. I am…
stump
  • 85
  • 1
  • 6
0
votes
1 answer

Can't read_xml or xmlParse, but when downloading manually the XML is fine and can be loaded by R

I am trying to get to read this xml in R: url <- 'https://fnet.bmfbovespa.com.br/fnet/publico/downloadDocumento?id=155020&cvm=true&#toolbar=0' xml <- url %>% httr::GET(httr::config(ssl_verifypeer = FALSE, ssl_verifyhost = FALSE)) %>% read_xml() The…
0
votes
1 answer

Exception thrown with DataTable ReadXml

I have dataTable and I save it to file using DataTable.WriteXml But when I try to load it using DataTable.ReadXml I get an exception: Invalid Operation exception DataTable does not support schema interface from Xml Anyone know how to solve this…
0
votes
1 answer

How to use Libxml2 to parse data from XML? LINUX + C Code

Read xml file using libxml2 I want to parse all the data from XML file and store in the structure so I can use that data where I want in my aplication. I am using Libxml2 library to parse the data and this is the simplest code to take the data from…
Omkar
  • 343
  • 3
  • 12
0
votes
0 answers

I have a Huge XML File of which I want to read its childtrees into the C++ boost::property_tree::pTree type

The normal way of doing it is using boost::property_tree::ptree pt1; boost::property_tree::read_xml( XML_FILE_PATH, pt1 ); But what this does is that it reads the entire XML File, which is really huge in the pt1 So I think it is inefficient when…
rrajanuk
  • 27
  • 8