Discussion

Sunghwan Kim | Wed, 03/15/2017 - 23:10

I recommend these two papers:

Sunghwan Kim | Wed, 03/15/2017 - 23:10

I recommend these two papers:

Sunghwan Kim | Wed, 03/15/2017 - 22:43

Hi, Phuc. PubChem's data contents are updated on a daily basis, so it is not unusual to see a small variation in the number of returned records. I've tried the question again and I got the same number of hits as yours. So, consider that the number 16 stated in the question is an approximate number that may vary.

[I added that number as a reference. If a student get an answer that is way off 16, there is a possibility that he or she is doing something wrong. However, if the discrepancy is small, you can consider it's because PubChem's information has been updated.]

olcc s16 | Wed, 03/15/2017 - 16:27
Hi Dr. Kim, In question 4c, after performing identifier exchange, I got 15 compounds but in question 4c itself saying there are 16. I've been repeating part b but keep getting 15. Phuc

Jordi Cuadros's picture
Jordi Cuadros | Tue, 03/14/2017 - 16:50
I can't see any easy way to do it: the contents won't fit in a cell and when splitted apart it takes more cells than allowed in Goggle Sheets. Either some external processing or some coding will be required. Cheers, Jordi

Robert Belford's picture
Robert Belford | Tue, 03/14/2017 - 16:33
so is there a way to upload that to a Google Sheet? Cheers (and thanks)

Jordi Cuadros's picture
Jordi Cuadros | Tue, 03/14/2017 - 16:24
The information at this URL seems to be longer than what IMPORTXML can proccess. It won't be an XPath issue. For more info on XPath looks at the following links (repeated from a previous post): <a href="https://www.w3.org/TR/xpath/">https://www.w3.org/TR/xpath/</a> <a href="https://www.w3schools.com/xml/xpath_intro.asp">https://www.w3schools.com/xml/xpath_intro.asp</a> <a href="https://www.tutorialspoint.com/xpath/index.htm">https://www.tutorialspoint.com/xpath/index.htm</a> Best. Jordi

Robert Belford's picture
Robert Belford | Tue, 03/14/2017 - 15:56

How would one load this page to a google sheet? https://pubchem.ncbi.nlm.nih.gov/rest/pug_view/annotations/heading/XML/?heading=Boiling+Point&response_type=display

I am assuming you place this in a cell (D52) https://pubchem.ncbi.nlm.nih.gov/rest/pug_view/annotations/heading/XML/?heading=Boiling+Point

And then something like =IMPORTXML(D52"//XPath_query")
But I do not know the XPath_query, or how to understand the Xpath_query