31:[] 2f:{"title":"Parsing Wikipedia Tables","cells":[{"id":0,"value":"md`# Parsing Wikipedia Tables\n\nhere, we'll show how to parse the tables from the [List of Apollo astronauts](https://en.wikipedia.org/wiki/List_of_Apollo_astronauts) into JSON, using [wtf_wikipedia](https://github.com/spencermountain/wtf_wikipedia/)\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2,"value":"data = {\n let opts = {'Api-User-Agent': 'wtf_wikipedia example'}\n //fetch the page from the API\n let doc = await wtf.fetch('List of Apollo astronauts', opts)\n\n //grab the first table\n let s = doc.sections('Apollo astronauts who walked on the Moon')\n let list = s.tables()[0].json()\n\n //grab the second table\n s = doc.sections('Apollo astronauts who flew to the Moon without landing')\n let list2 = s.tables()[0].json()\n\n //combine them together\n list = list.concat(list2)\n\n //grab the data we want\n let data = list.map(row => {\n let result = {\n name: '',\n mission: ''\n }\n console.log(row)\n if (row.Name) {\n result.name = row.Name.text\n //get the actual wikipedia page..\n if (row.links) {\n result.name = row.links[0].page\n }\n }\n //get their mission(s)\n if (row.Mission) {\n result.mission = row.Mission.text\n }\n return result\n })\n return data\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":27,"value":"md`---\nonce we have the json, we can pretty-print the data, back into an html table:\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":29,"value":"html`\n ${data.map((o)=> '').join('\\n')}\n

'+o.name+'

'+o.mission+'

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":13,"value":"wtf=require('wtf_wikipedia')","pinned":false,"hidden":false,"mode":"ojs"},{"id":40,"value":"wtf.version","pinned":false,"hidden":false,"mode":"ojs"},{"id":37,"value":"style = html``","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}