How to read xml files in R
Just like
In R, an XML file can be read using the XML package. The following command is used to install this package:
install.packages("XML")
To process XML data with R, we can include the XML library in our program by using:
library("XML")
Reading the XML file
- An XML file can be read in R using the function
xmlParse(). Then, load data is stored in a list. - An XML file can also be read in the form of a data frame by using the
xmlToDataFrame()method.
main.r
employee.xml
<RECORDS><EMPLOYEE><ID>1</ID><NAME>Jonhnny</NAME><SALARY>215</SALARY><STARTDATE>9/23/2015</STARTDATE><DEPT>Operations</DEPT></EMPLOYEE><EMPLOYEE><ID>2</ID><NAME>Allen</NAME><SALARY>723.3</SALARY><STARTDATE>3/5/2019</STARTDATE><DEPT>IT and Infrastructure</DEPT></EMPLOYEE><EMPLOYEE><ID>3</ID><NAME>Fench</NAME><SALARY>890</SALARY><STARTDATE>11/15/2014</STARTDATE><DEPT>IT and Infrastructure</DEPT></EMPLOYEE><EMPLOYEE><ID>4</ID><NAME>Patricia</NAME><SALARY>901.25</SALARY><STARTDATE>6/21/2017</STARTDATE><DEPT>Finance and Accounting</DEPT></EMPLOYEE><EMPLOYEE><ID>5</ID><NAME>Jennifer</NAME><SALARY>780</SALARY><STARTDATE>12/16/2016</STARTDATE><DEPT>HR Resource Management</DEPT></EMPLOYEE><EMPLOYEE><ID>6</ID><NAME>George</NAME><SALARY>890</SALARY><STARTDATE>6/22/2018</STARTDATE><DEPT>IT and Infrastructure</DEPT></EMPLOYEE><EMPLOYEE><ID>7</ID><NAME>Simon</NAME><SALARY>1045.6</SALARY><STARTDATE>7/30/2013</STARTDATE><DEPT>Operations</DEPT></EMPLOYEE><EMPLOYEE><ID>8</ID><NAME>Crow</NAME><SALARY>752.6</SALARY><STARTDATE>4/12/2020</STARTDATE><DEPT>Finance and Accounting</DEPT></EMPLOYEE></RECORDS>
main.r
employee.xml
# Loading the other required packagelibrary("methods") #optional# calling method for reading xml fileresults <- xmlToDataFrame("employee.xml")# Print as data frame.print(results)
TRENDING TOPICS
