similar to: How do I convert a XML file to a data.frame?

Displaying 20 results from an estimated 90 matches similar to: "How do I convert a XML file to a data.frame?"

2010 Jan 10
2
xmlToDataFrame#Help!!!
I'm struggling with interpreting XML files created by ADODB as data.frames and I'm looking for advice (see attached example file). Note: This file contains a result set which comes from a rectangular data array. I've been trying to play with parameters to the xmlToDataFrame function in the XML package but I dont get it to extract the data frame. This is what the result should look
2013 Apr 30
1
Trouble with reading xml in R
Hi I have been trying for days now to read the contents of this xml file into R. I tried the simpler solution xmlToDataFrame, which worked on another file, but somehow it doesn't work for this file. I have tried different other solutions, but I just can't seem to get it quite right. doc <- xmlRoot(xmlTreeParse(url)) art <- doc[[1]] [["DeliveryDay"]] fields <-
2013 Jan 29
2
converting XML document to table or dataframe
I am a relatively new user to R, and I am trying to learn more about converting data in an XML document into "2-dimensional format" such as a table or array. I might eventually wish to export this data into a relational database such as SQL, and/or to work with this data within the R package. My sample XML document is located at "
2010 Jan 10
1
xmlToDataFrame#Help!!!#follow-up
Dieter Menne pointed out that the (small) xml attachment didn't make it. Here is an in-line version (see end of message). Let's hope it works this time. I'm struggling with interpreting XML files created by ADODB as data.frames and I'm looking for advice. Note: This xlm contains a result set which comes from a rectangular data array. I've been trying to play with
2009 Jul 14
1
(simple) xml into data.frame and reverse
Hello, I am trying to convert a simple data.frame (it will always be a few equally long variables) into the XML format (which I don't understand too well but need as input for another program) and reverse the operation (from XML back into data.frame). I found some code which does the first and it works good enough for me (see below). Is there an easy way to reverse the operation? My XML files
2012 Sep 13
2
rstudio client on the i-pad
Hi, The combination of ipad+rstudio (server) would be a fantastic combination-if it worked. It _is_ possible to run rstudio in the safari browser of the ipad, but the keyboard doesn't work correctly (blanks are inserted after each character), making it almost impossible to use. Does anyone know a solution? Or know when a solution is ready? ------------------- dr F.H.G. (Frans) Marcelissen
2012 May 09
0
serie de tiempo incompleta: rellenar sólo fechas (claudiomet)
Hola.. yo lo haría de la siguiente manera ... En excel:genero una columna con la serie de fechas continuas ... con la función buscarv, agrego las variables que tienen dato a esta serie.. en base a la fecha muy largo y mecánico para mi gusto.... En R ..de igual manera genero el vector de fechas require(chron)# crear el vector continuo de fechasfch01 <- data.frame(''fch'' =
2012 May 20
3
dot - comma problem
Dear all I am trying to use the ODB package to connect to an libreoffice-odb database. The libreoffice package is german, thus, decimal separator is a comma. However, I can open the database and upload a it without error, library(ODB) db <- odb.open("Test.odb") but a soon as the "odb.open" command is executed, the decimal separator in R is changed to comma. Before
2008 Mar 07
0
linear discriminant analysis / search
Dear R help list, I have a training dataset that looks like Table1. I have an unknown dataset that looks like Table2. I want to have a program that should search the training dataset and identify that the unknown sample belongs to which category (type1, type2 or type3) and also if the unknown does not belong to any of the categories, it should let me know. The real dataset has 600 variables and
2008 Mar 07
0
linear discriminant analysis
Dear R help list, I have a training dataset that looks like Table1. I have an unknown dataset that looks like Table2. I want to have a program that should search the training dataset and identify that the unknown sample belongs to which category (type1, type2 or type3) and also if the unknown does not belong to any of the categories, it should let me know. The real dataset has 600 variables and
2008 Apr 28
1
error in summary.Design
Dear list, after fitting an lrm with the Design package (stored as "mymodel") I try running a summary, but I get the following error: dim(mydata) [1] 235 9 names(mydata) [1] "id" "VAR1" "VAR2" "VAR3" "VAR4" "VAR5" "VAR6" "VAR7" "VAR8" summary(mymodel) Error in `contrasts<-`(`*tmp*`,
2010 Jul 29
1
(no subject)
Dear R Users! I have a dataframe with duplicate cases. Var1 duplicated by var2. var1 var2 var3 var4 var5 var6 1 4 500 1 2 a 1 3 200 2 5 b 1 8 125 1 9 b
2010 Nov 08
2
Several lattice plots on one page
Dear all, I am trying (!!!) to generate pdfs that have 8 plots on one page: df = data.frame( day = c(1,2,3,4), var1 = c(1,2,3,4), var2 = c(100,200,300,4000), var3 = c(10,20,300,40000), var4 = c(100000,20000,30000,4000), var5 = c(10,20,30,40), var6 = c(0.001,0.002,0.003,0.004), var7 = c(123,223,123,412), var8 = c(213,123,234,435), all = as.factor(c(1,1,1,1)))
2010 Dec 03
2
Add columns of dataset
Dear all, I have a dataset that looks like id var1 var2 var4 var7 var8 1 0.0 0.1 0.3 0.9 0.0 2 0.4 0.6 0.0 0.0 0.2 3 0.0 0.0 0.0 0.8 0.7 Some columns are missed, for example, here the fourth (var3), sixth(var5) and seventh (var6) columns. I want to first determine which columns are missed in a huge dataset and then add the missed
2007 Apr 24
1
exclude the unfit data from the iteration
Dear List, Trying to explain my situation as simply as possible for me: I am running a series of iteration on coxph model on simulated data (newly generated data on each iteration to run under coxph; in my example below- sim.fr is the generated data). However, sometimes i get warning messages like "Ran out of iterations and did not converge" or "Error in var(x, na.rm = na.rm) :
2011 Jun 23
2
Merging multiple data sets
Hi, I am trying to merge data similar to the example data below > dat0 id var1 var2 var3 2 1 0 1 3 1 0 1 4 0 1 1 5 0 1 1 > dat1 id var4 var5 var6 2 1 0 1 3 1 0 1 6 0 1 1 7 0 1 1 > dat2 id
2009 Dec 15
1
Changing Column names in (Output) csv file
Dear R helpers   Following is a part of R code.   data_lab <- expand.grid(c("R11", "R12", "R13"), c("R21", "R22", "R23"), c("R31", "R32", "R33"), c("R41", "R42", "R43"), c("R51", "R52", "R53"), c("R61", "R62", "R63"),
2007 Apr 20
1
Hiding "Warning messages" in coxme output
Dear list, I have been trying to use coxme in R 2.3.1. When I use coxme in the following data sim.fr1, i get "Warning messages: using 'as.environment(NULL)' is deprecated" Why does it occur? How can I hide such warning message, especially when coxme is under a loop? Mohammad Ehsanul Karim (Institute of Statistical Research and Training, University of Dhaka) >
2006 Feb 21
6
How to sum values across multiple variables using a wildcard?
I have a dataframe called "data" with 5 records (in rows) each of which has been scored on each of many variables (in columns). Five of the variables are named var1, var2, var3, var4, var5 using headers. The other variables are named using other conventions. I can create a new variable called var6 with the value 15 for each record with this code: > var6=var1+var2+var3+var4+var5
2011 Oct 24
4
Problem with svyvar in survey package
I am facing a problem with a function in survey package. The function svyvar gives the estimated population variance from a given sampling scheme. I am working with a data having more than four continuous variables. In order to have have population total for all those cont. variables I have written in the following format svyvar(~var1+var2+var3+var4+var5+var6,data) ; var1,var2,...,var6 are 6