{"id":789,"date":"2012-01-13T11:02:01","date_gmt":"2012-01-13T16:02:01","guid":{"rendered":"http:\/\/rud.is\/b\/?p=789"},"modified":"2017-04-02T22:51:14","modified_gmt":"2017-04-03T03:51:14","slug":"importhtml","status":"publish","type":"post","link":"https:\/\/rud.is\/b\/2012\/01\/13\/importhtml\/","title":{"rendered":"Google Spreadsheet “importHTML” Rocks For Quick Analytics"},"content":{"rendered":"

I usually take a peek at the Internet Traffic Report<\/span> (ITR) a couple times a day as part of my routine and was a bit troubled by all of the red<\/span> today:<\/p>\n

\"\"<\/a><\/center><\/p>\n

I wanted to do some crunching on the data, and I deliberately do not have Word or Excel on my new MacBook Pro (for reasons I can detail if asked). A SELECT \/ CUT \/ PASTE into TextWrangler<\/a> did not really thrill me and I knew there had to be a way to get non-marked-up, columnar data into a format I could mangle and share easily. <\/p>\n

Enter, Google Shreadsheet’s importHTML<\/code> function.<\/p>\n

If you don’t have the forumla bar enabled in Google Spreadsheets, just go to View->Formula Bar<\/code> to enable it. Once there, enter the following in the formula bar to get the data from the ITR into a set of columns that will auto-update<\/i> every time you reference the sheet.<\/p>\n

=importHTML(\"http:\/\/www.internettrafficreport.com\/namerica.htm\",\"table\",0)<\/code><\/center><\/p>\n

\"\"<\/center><\/p>\n

(as you can see, it’s not case sensitive, either)<\/p>\n

Yes, I know Excel can do this. I could have done a quick script whack the pasted data in TextWrangler. You can do something similar in R<\/a> with htmlTreeParse<\/code> + xpathApply<\/code> and Perl has HTML::TableContentParser<\/code> (and other handy modules), but this was a fast, easy way to get me to a point where I could do the basic analytics I wanted to perform (and, sometimes, all you need is quick & easy).<\/p>\n

Official Google Help page on importHTML<\/code><\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

I usually take a peek at the Internet Traffic Report (ITR) a couple times a day as part of my routine and was a bit troubled by all of the red today: I wanted to do some crunching on the data, and I deliberately do not have Word or Excel on my new MacBook Pro […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"activitypub_content_warning":"","activitypub_content_visibility":"","activitypub_max_image_attachments":3,"activitypub_interaction_policy_quote":"anyone","activitypub_status":"","footnotes":""},"categories":[88,47],"tags":[107,244,108,178,620,623,621,622,624,619],"class_list":["post-789","post","type-post","status-publish","format-standard","hentry","category-google-docs","category-metrics","tag-computing","tag-google","tag-html","tag-http","tag-internet-traffic-report","tag-microsoft-excel","tag-perl","tag-spreadsheet","tag-textwrangler","tag-view-formula-bar"],"yoast_head":"\nGoogle Spreadsheet "importHTML" Rocks For Quick Analytics - rud.is<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/rud.is\/b\/2012\/01\/13\/importhtml\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet "importHTML" Rocks For Quick Analytics - rud.is\" \/>\n<meta property=\"og:description\" content=\"I usually take a peek at the Internet Traffic Report (ITR) a couple times a day as part of my routine and was a bit troubled by all of the red today: I wanted to do some crunching on the data, and I deliberately do not have Word or Excel on my new MacBook Pro […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/rud.is\/b\/2012\/01\/13\/importhtml\/\" \/>\n<meta property=\"og:site_name\" content=\"rud.is\" \/>\n<meta property=\"article:published_time\" content=\"2012-01-13T16:02:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-03T03:51:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/rud.is\/b\/wp-content\/uploads\/2012\/01\/Details-for-North-America-___-Internet-Traffic-Report-166x300.png\" \/>\n<meta name=\"author\" content=\"hrbrmstr\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"hrbrmstr\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/rud.is\/b\/2012\/01\/13\/importhtml\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/rud.is\/b\/2012\/01\/13\/importhtml\/\"},\"author\":{\"name\":\"hrbrmstr\",\"@id\":\"https:\/\/rud.is\/b\/#\/schema\/person\/d7cb7487ab0527447f7fda5c423ff886\"},\"headline\":\"Google Spreadsheet “importHTML” Rocks For Quick Analytics\",\"datePublished\":\"2012-01-13T16:02:01+00:00\",\"dateModified\":\"2017-04-03T03:51:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/rud.is\/b\/2012\/01\/13\/importhtml\/\"},\"wordCount\":238,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/rud.is\/b\/#\/schema\/person\/d7cb7487ab0527447f7fda5c423ff886\"},\"image\":{\"@id\":\"https:\/\/rud.is\/b\/2012\/01\/13\/importhtml\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/rud.is\/b\/wp-content\/uploads\/2012\/01\/Details-for-North-America-___-Internet-Traffic-Report-166x300.png\",\"keywords\":[\"Computing\",\"Google\",\"HTML\",\"http\",\"Internet Traffic Report\",\"Microsoft Excel\",\"Perl\",\"Spreadsheet\",\"TextWrangler\",\"View->Formula Bar\"],\"articleSection\":[\"Google Docs\",\"Metrics\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/rud.is\/b\/2012\/01\/13\/importhtml\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/rud.is\/b\/2012\/01\/13\/importhtml\/\",\"url\":\"https:\/\/rud.is\/b\/2012\/01\/13\/importhtml\/\",\"name\":\"Google Spreadsheet \\\"importHTML\\\" Rocks For Quick Analytics - rud.is\",\"isPartOf\":{\"@id\":\"https:\/\/rud.is\/b\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/rud.is\/b\/2012\/01\/13\/importhtml\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/rud.is\/b\/2012\/01\/13\/importhtml\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/rud.is\/b\/wp-content\/uploads\/2012\/01\/Details-for-North-America-___-Internet-Traffic-Report-166x300.png\",\"datePublished\":\"2012-01-13T16:02:01+00:00\",\"dateModified\":\"2017-04-03T03:51:14+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/rud.is\/b\/2012\/01\/13\/importhtml\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/rud.is\/b\/2012\/01\/13\/importhtml\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/rud.is\/b\/2012\/01\/13\/importhtml\/#primaryimage\",\"url\":\"https:\/\/i0.wp.com\/rud.is\/b\/wp-content\/uploads\/2012\/01\/Details-for-North-America-___-Internet-Traffic-Report.png?fit=464%2C835&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/rud.is\/b\/wp-content\/uploads\/2012\/01\/Details-for-North-America-___-Internet-Traffic-Report.png?fit=464%2C835&ssl=1\",\"width\":\"464\",\"height\":\"835\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/rud.is\/b\/2012\/01\/13\/importhtml\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/rud.is\/b\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google Spreadsheet “importHTML” Rocks For Quick Analytics\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/rud.is\/b\/#website\",\"url\":\"https:\/\/rud.is\/b\/\",\"name\":\"rud.is\",\"description\":\""In God we trust. All others must bring data"\",\"publisher\":{\"@id\":\"https:\/\/rud.is\/b\/#\/schema\/person\/d7cb7487ab0527447f7fda5c423ff886\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/rud.is\/b\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/rud.is\/b\/#\/schema\/person\/d7cb7487ab0527447f7fda5c423ff886\",\"name\":\"hrbrmstr\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/i0.wp.com\/rud.is\/b\/wp-content\/uploads\/2023\/10\/ukr-shield.png?fit=460%2C460&ssl=1\",\"url\":\"https:\/\/i0.wp.com\/rud.is\/b\/wp-content\/uploads\/2023\/10\/ukr-shield.png?fit=460%2C460&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/rud.is\/b\/wp-content\/uploads\/2023\/10\/ukr-shield.png?fit=460%2C460&ssl=1\",\"width\":460,\"height\":460,\"caption\":\"hrbrmstr\"},\"logo\":{\"@id\":\"https:\/\/i0.wp.com\/rud.is\/b\/wp-content\/uploads\/2023\/10\/ukr-shield.png?fit=460%2C460&ssl=1\"},\"description\":\"Don't look at me\u2026I do what he does \u2014 just slower. #rstats avuncular \u2022 ?Resistance Fighter \u2022 Cook \u2022 Christian \u2022 [Master] Chef des Donn\u00e9es de S\u00e9curit\u00e9 @ @rapid7\",\"sameAs\":[\"http:\/\/rud.is\"],\"url\":\"https:\/\/rud.is\/b\/author\/hrbrmstr\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Google Spreadsheet \"importHTML\" Rocks For Quick Analytics - rud.is","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/rud.is\/b\/2012\/01\/13\/importhtml\/","og_locale":"en_US","og_type":"article","og_title":"Google Spreadsheet \"importHTML\" Rocks For Quick Analytics - rud.is","og_description":"I usually take a peek at the Internet Traffic Report (ITR) a couple times a day as part of my routine and was a bit troubled by all of the red today: I wanted to do some crunching on the data, and I deliberately do not have Word or Excel on my new MacBook Pro […]","og_url":"https:\/\/rud.is\/b\/2012\/01\/13\/importhtml\/","og_site_name":"rud.is","article_published_time":"2012-01-13T16:02:01+00:00","article_modified_time":"2017-04-03T03:51:14+00:00","og_image":[{"url":"https:\/\/rud.is\/b\/wp-content\/uploads\/2012\/01\/Details-for-North-America-___-Internet-Traffic-Report-166x300.png","type":"","width":"","height":""}],"author":"hrbrmstr","twitter_card":"summary_large_image","twitter_misc":{"Written by":"hrbrmstr","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/rud.is\/b\/2012\/01\/13\/importhtml\/#article","isPartOf":{"@id":"https:\/\/rud.is\/b\/2012\/01\/13\/importhtml\/"},"author":{"name":"hrbrmstr","@id":"https:\/\/rud.is\/b\/#\/schema\/person\/d7cb7487ab0527447f7fda5c423ff886"},"headline":"Google Spreadsheet “importHTML” Rocks For Quick Analytics","datePublished":"2012-01-13T16:02:01+00:00","dateModified":"2017-04-03T03:51:14+00:00","mainEntityOfPage":{"@id":"https:\/\/rud.is\/b\/2012\/01\/13\/importhtml\/"},"wordCount":238,"commentCount":2,"publisher":{"@id":"https:\/\/rud.is\/b\/#\/schema\/person\/d7cb7487ab0527447f7fda5c423ff886"},"image":{"@id":"https:\/\/rud.is\/b\/2012\/01\/13\/importhtml\/#primaryimage"},"thumbnailUrl":"https:\/\/rud.is\/b\/wp-content\/uploads\/2012\/01\/Details-for-North-America-___-Internet-Traffic-Report-166x300.png","keywords":["Computing","Google","HTML","http","Internet Traffic Report","Microsoft Excel","Perl","Spreadsheet","TextWrangler","View->Formula Bar"],"articleSection":["Google Docs","Metrics"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/rud.is\/b\/2012\/01\/13\/importhtml\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/rud.is\/b\/2012\/01\/13\/importhtml\/","url":"https:\/\/rud.is\/b\/2012\/01\/13\/importhtml\/","name":"Google Spreadsheet \"importHTML\" Rocks For Quick Analytics - rud.is","isPartOf":{"@id":"https:\/\/rud.is\/b\/#website"},"primaryImageOfPage":{"@id":"https:\/\/rud.is\/b\/2012\/01\/13\/importhtml\/#primaryimage"},"image":{"@id":"https:\/\/rud.is\/b\/2012\/01\/13\/importhtml\/#primaryimage"},"thumbnailUrl":"https:\/\/rud.is\/b\/wp-content\/uploads\/2012\/01\/Details-for-North-America-___-Internet-Traffic-Report-166x300.png","datePublished":"2012-01-13T16:02:01+00:00","dateModified":"2017-04-03T03:51:14+00:00","breadcrumb":{"@id":"https:\/\/rud.is\/b\/2012\/01\/13\/importhtml\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/rud.is\/b\/2012\/01\/13\/importhtml\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/rud.is\/b\/2012\/01\/13\/importhtml\/#primaryimage","url":"https:\/\/i0.wp.com\/rud.is\/b\/wp-content\/uploads\/2012\/01\/Details-for-North-America-___-Internet-Traffic-Report.png?fit=464%2C835&ssl=1","contentUrl":"https:\/\/i0.wp.com\/rud.is\/b\/wp-content\/uploads\/2012\/01\/Details-for-North-America-___-Internet-Traffic-Report.png?fit=464%2C835&ssl=1","width":"464","height":"835"},{"@type":"BreadcrumbList","@id":"https:\/\/rud.is\/b\/2012\/01\/13\/importhtml\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/rud.is\/b\/"},{"@type":"ListItem","position":2,"name":"Google Spreadsheet “importHTML” Rocks For Quick Analytics"}]},{"@type":"WebSite","@id":"https:\/\/rud.is\/b\/#website","url":"https:\/\/rud.is\/b\/","name":"rud.is","description":""In God we trust. All others must bring data"","publisher":{"@id":"https:\/\/rud.is\/b\/#\/schema\/person\/d7cb7487ab0527447f7fda5c423ff886"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/rud.is\/b\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/rud.is\/b\/#\/schema\/person\/d7cb7487ab0527447f7fda5c423ff886","name":"hrbrmstr","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/i0.wp.com\/rud.is\/b\/wp-content\/uploads\/2023\/10\/ukr-shield.png?fit=460%2C460&ssl=1","url":"https:\/\/i0.wp.com\/rud.is\/b\/wp-content\/uploads\/2023\/10\/ukr-shield.png?fit=460%2C460&ssl=1","contentUrl":"https:\/\/i0.wp.com\/rud.is\/b\/wp-content\/uploads\/2023\/10\/ukr-shield.png?fit=460%2C460&ssl=1","width":460,"height":460,"caption":"hrbrmstr"},"logo":{"@id":"https:\/\/i0.wp.com\/rud.is\/b\/wp-content\/uploads\/2023\/10\/ukr-shield.png?fit=460%2C460&ssl=1"},"description":"Don't look at me\u2026I do what he does \u2014 just slower. #rstats avuncular \u2022 ?Resistance Fighter \u2022 Cook \u2022 Christian \u2022 [Master] Chef des Donn\u00e9es de S\u00e9curit\u00e9 @ @rapid7","sameAs":["http:\/\/rud.is"],"url":"https:\/\/rud.is\/b\/author\/hrbrmstr\/"}]}},"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p23idr-cJ","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":12332,"url":"https:\/\/rud.is\/b\/2019\/06\/15\/introducing-the-ethercalc-package\/","url_meta":{"origin":789,"position":0},"title":"Introducing the {ethercalc} package","author":"hrbrmstr","date":"2019-06-15","format":false,"excerpt":"I mentioned EtherCalc in a previous post and managed to scrounge some time to put together a fledgling {ethercalc} package (it's also on GitLab, SourceHut, Bitbucket and GitUgh, just sub out the appropriate URL prefix). I'm creating a package-specific Docker image (there are a couple out there but I'm not\u2026","rel":"","context":"In "R"","block_context":{"text":"R","link":"https:\/\/rud.is\/b\/category\/r\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/rud.is\/b\/wp-content\/uploads\/2019\/06\/ethercalc-append.png?fit=1200%2C870&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/rud.is\/b\/wp-content\/uploads\/2019\/06\/ethercalc-append.png?fit=1200%2C870&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/rud.is\/b\/wp-content\/uploads\/2019\/06\/ethercalc-append.png?fit=1200%2C870&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/rud.is\/b\/wp-content\/uploads\/2019\/06\/ethercalc-append.png?fit=1200%2C870&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/rud.is\/b\/wp-content\/uploads\/2019\/06\/ethercalc-append.png?fit=1200%2C870&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":2902,"url":"https:\/\/rud.is\/b\/2014\/02\/11\/live-google-spreadsheet-for-keeping-track-of-sochi-medals\/","url_meta":{"origin":789,"position":1},"title":"Live Google Spreadsheet For Keeping Track Of Sochi Medals","author":"hrbrmstr","date":"2014-02-11","format":false,"excerpt":"The \"medals\" R post by [TRInker](http:\/\/trinkerrstuff.wordpress.com\/2014\/02\/09\/sochi-olympic-medals-2\/) and re-blogged by [Revolutions](http:\/\/blog.revolutionanalytics.com\/2014\/02\/winter-olympic-medal-standings-presented-by-r.html) were both spiffy and a live example why there's no point in not publishing raw data. You don't need to have R (or any other language) do the scraping, though. The \"`IMPORTHTML`\" function (yes, function names seem to be ALL\u2026","rel":"","context":"In "Google Docs"","block_context":{"text":"Google Docs","link":"https:\/\/rud.is\/b\/category\/google-docs\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":485,"url":"https:\/\/rud.is\/b\/2011\/04\/16\/dbclone-hack-for-os-x\/","url_meta":{"origin":789,"position":2},"title":"dbClone “hack” for OS X","author":"hrbrmstr","date":"2011-04-16","format":false,"excerpt":"UPDATE: Check out the newer post on additional features. There has been much ado of late about Dropbox security with one of the most egregious issues being how easy it is to surreptitiously \"clone\" someone else's Dropbox by obtaining just one piece of data - the host id - from\u2026","rel":"","context":"In "Development"","block_context":{"text":"Development","link":"https:\/\/rud.is\/b\/category\/development\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2883,"url":"https:\/\/rud.is\/b\/2014\/01\/28\/lies-damn-lies-data-journalism-and-charts-that-dont-start-at-0\/","url_meta":{"origin":789,"position":3},"title":"Lies, Damn Lies, “Data Journalism” and Charts That Don’t Start at 0","author":"hrbrmstr","date":"2014-01-28","format":false,"excerpt":"This tweet by @moorehn (who usually is a superb economic journalist) really bugged me: Alarming chart of employment for people between 25 and 54. It's like a ski jump. #SOTUecon pic.twitter.com\/KNGYmwI88C\u2014 Heidi N. Moore (@moorehn) January 29, 2014 I grabbed the raw data from EPI: (http:\/\/www.epi.org\/files\/2012\/data-swa\/jobs-data\/Employment%20to%20population%20ratio%20(EPOPs).xls) and properly started the\u2026","rel":"","context":"In "Charts & Graphs"","block_context":{"text":"Charts & Graphs","link":"https:\/\/rud.is\/b\/category\/charts-graphs\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1849,"url":"https:\/\/rud.is\/b\/2012\/12\/17\/easier-html-table-scraping-for-scripts-with-google-drive\/","url_meta":{"origin":789,"position":4},"title":"Easier HTML Table-scraping For Scripts With Google Drive","author":"hrbrmstr","date":"2012-12-17","format":false,"excerpt":"We had our first, real, snowfall of the season in Maine today and that usually means school delays\/closings. Our \"local\" station \u2013 @WCHS6 \u2013 has a Storm Center Closings page as well as an SMS notification service. I decided this morning that I needed a command line version (and, eventually,\u2026","rel":"","context":"In "Google Docs"","block_context":{"text":"Google Docs","link":"https:\/\/rud.is\/b\/category\/google-docs\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3364,"url":"https:\/\/rud.is\/b\/2015\/03\/30\/3364\/","url_meta":{"origin":789,"position":5},"title":"A look at airline crashes in R with googlesheets, dplyr & ggplot2","author":"hrbrmstr","date":"2015-03-30","format":false,"excerpt":"Over on The DO Loop, @RickWicklin does a nice job [visualizing the causes of airline crashes](http:\/\/blogs.sas.com\/content\/iml\/2015\/03\/30\/visualizing-airline-crashes\/) in SAS using a mosaic plot. More often than not, I find mosaic plots can be a bit difficult to grok, but Rick's use was spot on and I believe it shows the data\u2026","rel":"","context":"In "Charts & Graphs"","block_context":{"text":"Charts & Graphs","link":"https:\/\/rud.is\/b\/category\/charts-graphs\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/rud.is\/b\/wp-json\/wp\/v2\/posts\/789","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rud.is\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rud.is\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rud.is\/b\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rud.is\/b\/wp-json\/wp\/v2\/comments?post=789"}],"version-history":[{"count":0,"href":"https:\/\/rud.is\/b\/wp-json\/wp\/v2\/posts\/789\/revisions"}],"wp:attachment":[{"href":"https:\/\/rud.is\/b\/wp-json\/wp\/v2\/media?parent=789"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rud.is\/b\/wp-json\/wp\/v2\/categories?post=789"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rud.is\/b\/wp-json\/wp\/v2\/tags?post=789"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}