IS2000 Create Complex XPath Expressions

Run Code: Cmd+Shift+Enter. New Code Block: Cmd+Option+I

Question 3 and Question 4: Load the XML with the DTD into R using validation.

[1] "The document is DTD valid."

Question 5: Execute an XPath expression that returns the names of all customers that do not live in “MA”? Return the company name.

[1] "Company names of customers not living in MA:"
[1] "Great Lakes Food Market"    "Hungry Coyote Import Store"
[3] "Lazy K Kountry Store"       "Eduardo Moveis"            
[5] "Let's Stop N Shop"         

Question 6: Using the result returned in (5), count how many customers there are.

[1] "Number of customers not living in MA: 5"

Question 7: Using a combination of R and XPath, calculate the total amount paid for freight for all orders placed by customer except for those with ID “GREAL”.

[1] "Total freight for orders not placed by GREAL: 878.59"

Question 8: Using a combination of R and XPath, calculate the average amount paid for freight for all orders shipped to Oregon (“OR”) in the United States.

[1] "Average freight for orders shipped to Oregon, USA: 80.918125"