{"id":244,"date":"2017-01-11T08:55:23","date_gmt":"2017-01-11T08:55:23","guid":{"rendered":"https:\/\/sqlshep.com\/?p=244"},"modified":"2017-01-11T22:29:24","modified_gmt":"2017-01-11T22:29:24","slug":"r-markdown","status":"publish","type":"post","link":"https:\/\/sqlshep.com\/?p=244","title":{"rendered":"R Markdown"},"content":{"rendered":"

This is a slight diversion into a tool built into R called R Markdown<\/a>, and Shiny will be coming up in a few days. Why is this important? It gives you a living document you can add text and r scripts to to produce just the output from R. I wrote my Stats grad project using just R Markdown and saved it to a PDF, no Word or open office tools. <\/p>\n

Its a mix of HTML and R, so if you know a tiny bit about HTML programing you will be fine, otherwise, use the R Markdown Cheat sheet<\/a> and Reference Guide<\/a> which i just annoyingly found out existed… <\/p>\n

I am going to give you a full R Markdown document to get you started.<\/p>\n

Create a new R Markdown file;<\/p>\n

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

Then Run it by selecting the “Knit” drop down in the middle left of the toolbar and selecting Knit to HTML.<\/p>\n

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

This will create an html document that you can open in a browser, it comes with some default mtcars data just so you can see some output. Try out some R commands and doodle around a bit before starting the code below. This is the file data file we will be using, US-Education.csv<\/a> It contains just the 2010-2014 educational attainment estimates per count in the US. <\/p>\n

In the code books below i will put in each section of the R Markdown and discuss it, each R code block can me moved to r console to be run. <\/p>\n

The first section Is the title that will show up on the top of the doc, copy this into the markdown file and run it by itself. I am using an html style tag as i want some of the plots to be two columns across. <\/p>\n

You will also see the first R command in an “R” block identified by ““`{r} and terminated with ““`”. Feel free to remove options and change options to see what happens. <\/p>\n

Notice below the style tag is wrong, when you copy it out you will need to put the “<\" back in from of the style tag.<\/strong> If i format it correctly wordpress takes it as an internal style tag to this post. <\/p>\n

\r\n---\r\ntitle: \"Educational Attainment by County\"\r\n\r\noutput: html_document\r\n---\r\n\r\nstyle>\r\n  .col2 {\r\n    columns: 2 200px;         \/* number of columns and width in pixels*\/\r\n    -webkit-columns: 2 200px; \/* chrome, safari *\/\r\n    -moz-columns: 2 200px;    \/* firefox *\/\r\n     line-height: 2em;\r\n     font-size: 10pt;\r\n\r\n  }\r\n\r\n\/style>\r\n\r\n```{r setup, include=FALSE}\r\nknitr::opts_chunk$set(echo = FALSE,warning=FALSE)\r\n\r\n#require is the fancy version of install package\/library\r\nrequire(choroplethr)\r\n\r\n```\r\n<\/code><\/pre>\n
This will be the next section in the markup, load a dataframe for each of the four educational attainment categories. <\/p>\n
\r\n```{r one}\r\n\r\n#Load data\r\n setwd(\"\/data\/\")\r\n usa <- read.csv(\"US-Education.csv\",stringsAsFactors=FALSE)\r\n\r\n#Seperate data for choropleth \r\n lessHighSchool <- subset(usa[c(\"FIPS.Code\",\"Percent.of.adults.with.less.than.a.high.school.diploma..2010.2014\")],FIPS.Code >0)\r\n \r\nhighSchool <- subset(usa[c(\"FIPS.Code\",\"Percent.of.adults.with.a.high.school.diploma.only..2010.2014\")],FIPS.Code >0) \r\n \r\nsomeCollege <- subset(usa[c(\"FIPS.Code\",\"Percent.of.adults.completing.some.college.or.associate.s.degree..2010.2014\")],FIPS.Code >0)\r\n \r\ncollege <- subset(usa[c(\"FIPS.Code\",\"Percent.of.adults.with.a.bachelor.s.degree.or.higher..2010.2014\")],FIPS.Code >0)\r\n\r\n#rename columns for Choropleth\r\n \r\n colnames(lessHighSchool)[which(colnames(lessHighSchool) == 'FIPS.Code')] <- 'region'\r\n \r\n colnames(lessHighSchool)[which(colnames(lessHighSchool) == 'Percent.of.adults.with.less.than.a.high.school.diploma..2010.2014')] <- 'value'\r\n\r\n# \r\n# or\r\n#\r\n names(highSchool) <-c(\"region\",\"value\")\r\n names(someCollege) <-c(\"region\",\"value\")\r\n names(college) <-c(\"region\",\"value\")\r\n \r\n \r\n```\r\n<\/code><\/pre>\n
The next section will create four histograms of the college attainment by category.  Notice the distribution of the data, normal distribution, right skew, left skew, bimodal?  We will discuss them next blog. <\/p>\n
Notice for the next section i have the \"div\" without the left \"<\", be sure to put those back. \n\n\n\n
\r\n\r\ndiv class=\"col2\">\r\n\r\n```{r Histogram 1}\r\n hist(lessHighSchool$value,xlim=c(0,60),breaks=30, xlab = \"Percent of High School Dropouts\", ylab=\"Number of Counties\",main=\"\",col=\"lightblue\")\r\n\r\n\r\n hist(highSchool$value,xlim=c(0,60),breaks=30, xlab = \"Percent Completed High School \", ylab=\"Number of Counties\",main=\"\",col=\"lightblue\")\r\n \r\n```\r\n \r\n \r\n```{r Histogram 2}\r\n\r\n hist(someCollege$value,xlim=c(0,50),breaks=30, xlab = \"Percent Completed Associates or Some College \", ylab=\"Number of Counties\",main=\"\",col=\"lightblue\")\r\n \r\n hist(college$value,xlim=c(0,90),breaks=30, xlab = \"Percent Completed Bachelors Degree or Higher \", ylab=\"Number of Counties\",main=\"\",col=\"lightblue\")\r\n\r\n\r\n```\r\n\r\n\/div>\r\n\r\n\r\n<\/code><\/pre>\n
The next section is the choropleth, for the high school dropouts, notice the R chunk parameters to size the plot area.  <\/p>\n
\r\n\r\n```{r two, fig.width=9, fig.height=5, fig.align='right'}\r\n\r\n\r\n county_choropleth(lessHighSchool,\r\n                  \r\n                   title = \"Proportion of High School Dropouts\",\r\n                   legend=\"Proportion\",\r\n                   num_colors=9)\r\n \r\n```\r\n\r\n<\/code><\/pre>\n
There are three more choropleths that you will have to do on your own!  you have the data, and the syntax.  If you have trouble with this, the red file i used is here Education.rmd<\/a><\/p>\n
In the end, you should have a histogram looking like this;<\/p>\n
\"\"<\/a><\/p>\n
And if you make it to the first choropleth, Percentage that did not complete high school;<\/p>\n
\"\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
This is a slight diversion into a tool built into R called R Markdown, and Shiny will be coming up in a few days. Why is this important? It gives you a living document you can add text and r scripts to to produce just the output from R. I wrote my Stats grad project […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,9,15,11],"tags":[14,17,10,16,13],"class_list":["post-244","post","type-post","status-publish","format-standard","hentry","category-choropleth","category-r","category-statistics","category-visualization","tag-choroplethr","tag-histogram","tag-r","tag-statistics","tag-visualization"],"_links":{"self":[{"href":"https:\/\/sqlshep.com\/index.php?rest_route=\/wp\/v2\/posts\/244","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlshep.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlshep.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlshep.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlshep.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=244"}],"version-history":[{"count":10,"href":"https:\/\/sqlshep.com\/index.php?rest_route=\/wp\/v2\/posts\/244\/revisions"}],"predecessor-version":[{"id":258,"href":"https:\/\/sqlshep.com\/index.php?rest_route=\/wp\/v2\/posts\/244\/revisions\/258"}],"wp:attachment":[{"href":"https:\/\/sqlshep.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=244"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlshep.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=244"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlshep.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=244"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}