{"id":1728,"date":"2020-12-04T20:29:14","date_gmt":"2020-12-04T20:29:14","guid":{"rendered":"https:\/\/ded9.com\/?p=1728"},"modified":"2025-12-13T12:05:28","modified_gmt":"2025-12-13T12:05:28","slug":"learning-xml-file-in-r-programming-language","status":"publish","type":"post","link":"https:\/\/ded9.com\/tr\/learning-xml-file-in-r-programming-language\/","title":{"rendered":"Learning XML Files in R Programming Language"},"content":{"rendered":"

XML is a file Format that uses standard ASCII<\/a> text; it shares both file formats and data on the World Wide Web, the Internet, and elsewhere.\u00a0<\/span><\/p>\n

XML File, Similar to HTML, this language contains markup tags. However, unlike HTML<\/a>, where tags describe the structure of the page, in XML, the meaning of the data they contain is explicitly defined.<\/p>\n

You can read an XML File in R using the “XML” package. This package can be installed using the following Command.<\/p>\n

\n
install.packages (\u201cXML\u201d)<\/pre>\n<\/div>\n
Input data<\/h2>\n
Create an XML File by copying the following data into a text editor such as Notepad. Save the File with an .xml extension and select ‘All files’ as the File type.<\/p>\n
\n
<RECORDS>\r\n\r\n<EMPLOYEE>\r\n\r\n<ID> 1 <\/ID>\r\n\r\n<NAME> Rick <\/NAME>\r\n\r\n<SALARY> 623.3 <\/SALARY>\r\n\r\n<STARTDATE> 1\/1\/2012 <\/STARTDATE>\r\n\r\n<DEPT> IT <\/DEPT>\r\n\r\n<\/EMPLOYEE>\r\n\r\n<EMPLOYEE>\r\n\r\n<ID> 2 <\/ID>\r\n\r\n<NAME> Dan <\/NAME>\r\n\r\n<SALARY> 515.2 <\/SALARY>\r\n\r\n<STARTDATE> 9\/23\/2013 <\/STARTDATE>\r\n\r\n<DEPT> Operations <\/DEPT>\r\n\r\n<\/EMPLOYEE>\r\n\r\n<EMPLOYEE>\r\n\r\n<ID> 3 <\/ID>\r\n\r\n<NAME> Michelle <\/NAME>\r\n\r\n<SALARY> 611 <\/SALARY>\r\n\r\n<STARTDATE> 11\/15\/2014 <\/STARTDATE>\r\n\r\n<DEPT> IT <\/DEPT>\r\n\r\n<\/EMPLOYEE>\r\n\r\n<EMPLOYEE>\r\n\r\n<ID> 4 <\/ID>\r\n\r\n<NAME> Ryan <\/NAME>\r\n\r\n<SALARY> 729 <\/SALARY>\r\n\r\n<STARTDATE> 5\/11\/2014 <\/STARTDATE>\r\n\r\n<DEPT> HR <\/DEPT>\r\n\r\n<\/EMPLOYEE>\r\n\r\n<EMPLOYEE>\r\n\r\n<ID> 5 <\/ID>\r\n\r\n<NAME> Gary <\/NAME>\r\n\r\n<SALARY> 843.25 <\/SALARY>\r\n\r\n<STARTDATE> 3\/27\/2015 <\/STARTDATE>\r\n\r\n<DEPT> Finance <\/DEPT>\r\n\r\n<\/EMPLOYEE>\r\n\r\n<EMPLOYEE>\r\n\r\n<ID> 6 <\/ID>\r\n\r\n<NAME> Nina <\/NAME>\r\n\r\n<SALARY> 578 <\/SALARY>\r\n\r\n<STARTDATE> 5\/21\/2013 <\/STARTDATE>\r\n\r\n<DEPT> IT <\/DEPT>\r\n\r\n<\/EMPLOYEE>\r\n\r\n<EMPLOYEE>\r\n\r\n<ID> 7 <\/ID>\r\n\r\n<NAME> Simon <\/NAME>\r\n\r\n<SALARY> 632.8 <\/SALARY>\r\n\r\n<STARTDATE> 7\/30\/2013 <\/STARTDATE>\r\n\r\n<DEPT> Operations <\/DEPT>\r\n\r\n<\/EMPLOYEE>\r\n\r\n<EMPLOYEE>\r\n\r\n<ID> 8 <\/ID>\r\n\r\n<NAME> Guru <\/NAME>\r\n\r\n<SALARY> 722.5 <\/SALARY>\r\n\r\n<STARTDATE> 6\/17\/2014 <\/STARTDATE>\r\n\r\n<DEPT> Finance <\/DEPT>\r\n\r\n<\/EMPLOYEE>\r\n\r\n<\/RECORDS><\/pre>\n<\/div>\n
Read the XML File<\/h2>\n
\"Read<\/h2>\n
The XML File is read by R using the xmlParse() function. This File is stored as a List in R.<\/p>\n
\n
# Load the package required to read XML files.\r\n\r\nlibrary (\u201cXML\u201d)\r\n\r\n# Also load the other required package.\r\n\r\nlibrary (\u201cmethods\u201d)\r\n\r\n# Give the input file name to the function.\r\n\r\nresult <- xmlParse (file = \"input.xml\")\r\n\r\n# Print the result.\r\n\r\nprint (result)<\/pre>\n<\/div>\n
When we run the above code, the following result is obtained:<\/p>\n
\n
1\r\n\r\nRick\r\n\r\n623.3\r\n\r\n1\/1\/2012\r\n\r\nIT\r\n\r\n2\r\n\r\nDan\r\n\r\n515.2\r\n\r\n9\/23\/2013\r\n\r\nOperations\r\n\r\n3\r\n\r\nMichelle\r\n\r\n611\r\n\r\n11\/15\/2014\r\n\r\nIT\r\n\r\n4\r\n\r\nRyan\r\n\r\n729\r\n\r\n5\/11\/2014\r\n\r\nHR\r\n\r\n5\r\n\r\nGary\r\n\r\n843. 25\r\n\r\n3\/27\/2015\r\n\r\nFinance\r\n\r\n6\r\n\r\nNina\r\n\r\n578\r\n\r\n5\/21\/2013\r\n\r\nIT\r\n\r\n7\r\n\r\nSimon\r\n\r\n632.8\r\n\r\n7\/30\/2013\r\n\r\nOperations\r\n\r\n8\r\n\r\nGuru\r\n\r\n722.5\r\n\r\n6\/17\/2014\r\n\r\nFinance<\/pre>\n<\/div>\n
Get the number of nodes in the XML File.<\/h2>\n
\n
# Load the packages required to read XML files.\r\n\r\nlibrary (\u201cXML\u201d)\r\n\r\nlibrary (\u201cmethods\u201d)\r\n\r\n# Give the input file name to the function.\r\n\r\nresult <- xmlParse (file = \"input.xml\")\r\n\r\n# Extract the root node form the xml file.\r\n\r\nrootnode <- xmlRoot (result)\r\n\r\n# Find number of nodes in the root.\r\n\r\nrootsize <- xmlSize (rootnode)\r\n\r\n# Print the result.\r\n\r\nprint (rootsize)<\/pre>\n<\/div>\n
When we execute the above code, we get the following result:<\/p>\n
\n
output\r\n\r\n[1] 8<\/pre>\n<\/div>\n
Details of the first node<\/h2>\n
Let’s take a look at the first parsed File. This File suggests that there are various elements within a high-level node.<\/p>\n
\n
# Load the packages required to read XML files.\r\n\r\nlibrary (\u201cXML\u201d)\r\n\r\nlibrary (\u201cmethods\u201d)\r\n\r\n# Give the input file name to the function.\r\n\r\nresult <- xmlParse (file = \"input.xml\")\r\n\r\n# Extract the root node form the xml file.\r\n\r\nrootnode <- xmlRoot (result)\r\n\r\n# Print the result.\r\n\r\nprint (rootnode [1])<\/pre>\n<\/div>\n
When we run the above code, the following result is obtained:<\/p>\n
\n
$ EMPLOYEE\r\n\r\n1\r\n\r\nRick\r\n\r\n623.3\r\n\r\n1\/1\/2012\r\n\r\nIT\r\n\r\nattr (\u201cclass\")\r\n\r\n[1] \"XMLInternalNodeList\" \"XMLNodeList\"<\/pre>\n<\/div>\n
Get different elements of a node.<\/span><\/h2>\n
\n
# Load the packages required to read XML files.\r\n\r\nlibrary (\u201cXML\u201d)\r\n\r\nlibrary (\u201cmethods\u201d)\r\n\r\n# Give the input file name to the function.\r\n\r\nresult <- xmlParse (file = \"input.xml\")\r\n\r\n# Extract the root node form the xml file.\r\n\r\nrootnode <- xmlRoot (result)\r\n\r\n# Get the first element of the first node.\r\n\r\nprint (rootnode [[1]] [[1]])\r\n\r\n# Get the fifth element of the first node.\r\n\r\nprint (rootnode [[1]] [[5]])\r\n\r\n# Get the second element of the third node.\r\n\r\nprint (rootnode [[3]] [[2]])<\/pre>\n<\/div>\n
When we run the above code, the following result is obtained:<\/p>\n
\n
1\r\n\r\nIT\r\n\r\nMichelle<\/pre>\n<\/div>\n
For effective data management of large files, we read the data from the XML File as a DataFrame. Data framework process for data analysis.<\/p>\n
\n
# Load the packages required to read XML files.\r\n\r\nlibrary (\u201cXML\u201d)\r\n\r\nlibrary (\u201cmethods\u201d)\r\n\r\n# Convert the input xml file to a data frame.\r\n\r\nxmldataframe <- xmlToDataFrame (\"input.xml\")\r\n\r\nprint (xmldataframe)<\/pre>\n<\/div>\n
When we run the above code, the following result is obtained:<\/p>\n
\n
ID NAME SALARY STARTDATE DEPT\r\n\r\n1 1 Rick 623.30 2012-01-01 IT\r\n\r\n2 2 Dan 515.20 2013-09-23 Operations\r\n\r\n3 3 Michelle 611.00 2014-11-15 IT\r\n\r\n4 4 Ryan 729.00 2014-05-11 HR\r\n\r\n5 NA Gary 843.25 2015-03-27 Finance\r\n\r\n6 6 Nina 578.00 2013-05-21 IT\r\n\r\n7 7 Simon 632.80 2013-07-30 Operations\r\n\r\n8 8 Guru 722.50 2014-06-17 Finance<\/pre>\n<\/div>\n
Since the data is now available as a data frame, we can utilize the data frame function to read and process files.<\/p>\n
FAQ<\/h2>\n
\n
\n
\n
What is an XML file?<\/h3>\n
\n\n
XML is a structured data format used to store and exchange data in a readable, hierarchical form.<\/p>\n\n<\/div>\n<\/div>\n
\n
How can R work with XML files?<\/h3>\n
\n\n
R can read and parse XML files using dedicated packages that convert XML data into usable R objects.<\/p>\n\n<\/div>\n<\/div>\n
\n
Why is XML used in data processing?<\/h3>\n
\n\n
XML is widely used because it is flexible, platform-independent, and suitable for structured data exchange.<\/p>\n\n<\/div>\n<\/div>\n<\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"
XML is a file Format that uses standard ASCII text; it shares both file formats and data on the World Wide Web, the Internet, and elsewhere.\u00a0 XML File, Similar to HTML, this language contains markup tags. However, unlike HTML, where tags describe the structure of the page, in XML, the meaning of the data they […]<\/p>\n","protected":false},"author":6,"featured_media":1729,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[174],"tags":[11900],"class_list":["post-1728","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-r-r-studio","tag-xml-file"],"acf":[],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ded9.com\/tr\/wp-json\/wp\/v2\/posts\/1728","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ded9.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ded9.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ded9.com\/tr\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/ded9.com\/tr\/wp-json\/wp\/v2\/comments?post=1728"}],"version-history":[{"count":4,"href":"https:\/\/ded9.com\/tr\/wp-json\/wp\/v2\/posts\/1728\/revisions"}],"predecessor-version":[{"id":266107,"href":"https:\/\/ded9.com\/tr\/wp-json\/wp\/v2\/posts\/1728\/revisions\/266107"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ded9.com\/tr\/wp-json\/wp\/v2\/media\/1729"}],"wp:attachment":[{"href":"https:\/\/ded9.com\/tr\/wp-json\/wp\/v2\/media?parent=1728"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ded9.com\/tr\/wp-json\/wp\/v2\/categories?post=1728"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ded9.com\/tr\/wp-json\/wp\/v2\/tags?post=1728"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}