Dear Jennifer,
my apologies for the delay in my response. I uploaded the chapter again and this time made sure it appears. Please do share any thoughts you have!
Anja
Discussion
Dear Jennifer,
We want one more student for this project
Hi, all.
The student who showed interest in this project was actually a faculty member at a participating school, who wants to learn cheminformatics. Both she and I want young students to have an opportunity to get some hands-on experiences from this project. So, we want to have one more person (either undergraduate or graduate student) that is willing to work with us (as a team of three). Please let us know if you are interested in this project or if you have questions about it. Thanks.
Best,
Sunghwan,
A slightly better option...
could be:
https://docs.google.com/spreadsheets/d/1Qw5UVxDSBiGKjxACs-PaUVjkZlZCCH1IM7brcfo9xS8/copy
I don't think I will be able to do more than this without scripting.
Best,
Jordi
My current approach...
is here: https://docs.google.com/spreadsheets/d/15WjPrkY16HC_XgAuQWJ78F0-l_bj7DP1-H9d6d7MG8o/copy
I would say it is far from good but it does solve some issues: it looks for the infobox and it is a bit more resilient to the different names used for the properties in different compound pages.
Hope it helps.
Best,
Jordi
Potential Project: Exploring Chemistry Apps
Increasing number of Chemistry Apps are appearing on tablets and mobile phones. They can be used to view a molecule in 3D format, to do molecular simulation, to manage literature, to work as interactive learning tool, to act as lab reference and tool. In this project, a participant can pick one of the six categories of Chemistry Apps (reference/study guide, molecular viewer, research, utilities, periodic table, games), find the best app(s) and critique. The participant can find an scenario that could be helpful in a particular Chemistry course, a lab environment (for a specific experiment) or a research project where chemistry apps can be used extensively and effectively. One JChemEd review paper, a book chapter and a website with Chemistry apps review table will be provided. The student is encouraged to contribute to a wiki-like website to review the latest chemistry apps, update information, and correct any errors on the wiki-site.
updated permissions
OK, I think you can now edit. What I suggest/request, is that anyone who wants to edit make a duplicate of the sheet to that (tabs at the bottom), and play around, and don't worry about messing anything up.
I had an old version that used 2 columns for every chemical, which was much less elegant, but could take data from multiple tables in a page.
Cheers,
Bob
Cheers,
Bob
Google Sheet issues
Bob,
This sounds really cool! Unfortunately the behavior of the Google Sheet is not the same as you've described. I don't see a dropdown box in cell C1. Maybe that's because I don't have full permission to edit the page. The URL you posted says edit in there, but the permission I see at the top of the page says I only have permission to view.
Jennifer
Need Help!
Hi All,
I think this is mostly directed at Jordi, but thought I'd post it here, so the discussion is public. The jist of this email is that I am pulling data from one table, but would like to pull from more than one.
I have been working on cleaning up a sheet for webscraping WikiPedia Chemboxes, and the following link should be public.
https://docs.google.com/spreadsheets/d/11iWH9L8T7Kyue3UYg4ZUiYZ47LlBeNZPWGfIlEFxyrk/edit#gid=1454316265
If you click cell [C1] a drop down box created by data validation allows you to choose a property from the Wikipedia Chembox, which is then uploaded through the following query
=QUERY(IMPORTHTML(B2,"table",1),"select Col2 where Col1='"&$D$1&"'",0)
Note, as I had to use a filter in [D1] to pull the value out of the validation box in [C1], and essentially said that if the dropdown box says "density", set D1 to "Density", and then Density was used in the query.
the IMPORTHTML command takes data from the first table, and for the compounds in red, the chembox is the second table (the first is stuff from the wikipedia editors.)
How can I get the above script to pull from the first or second table?
In can use this and it works by itself, but not in the query.
={IMPORTHTML(URL, "TABLE", 7) ; IMPORTHTML(URL,"TABLE",8) ; IMPORTHTML(URL,"TABLE",9) }
I can bring in two tables, but I can't get that to work in the query.
I did go in and change the index for glucose in [C20] from 1 to 2, and now it works, but that is only a short term fix, and what is really needed is the ability to pick from the first or second table, as we have no idea when Wikipedia editors will be placing their message/comment tables on pages.
Any help is appreciated, and I was thinking this might morph into a project. For example, I think I have a strategy that can pull from multiple infoboxes
chapter from Judith Currano?
Anja,
I share your interest in teaching information literacy, so I was hoping to read the chapter by Judith Currano. But I don't see a file uploaded to the page on Drupal. Maybe something happened to the attachment?
Jennifer
I would be interested in working on this project. I am a student at SDSU.