<p><div><div><div><div data-width="100" data-show-faces="false" data-send="true" data-layout="button_count" data-height="21" data-href="https://www.r-bloggers.com/descriptive-analytics-part-0-data-exploration/"></div></div><div><a data-url="https://www.r-bloggers.com/descriptive-analytics-part-0-data-exploration/" data-counturl="https://www.r-bloggers.com/descriptive-analytics-part-0-data-exploration/" data-count="horizontal" data-text="Descriptive Analytics – Part 0 : data exploration" class="twitter-share-button" data-via="rbloggers" href="https://twitter.com/share"></a></div><div></div></div><div></div></div>
<div>
(This article was first published on <strong><a href="http://r-exercises.com/2016/10/19/descriptive-analytics-part-0-data-exploration/"> R-exercises</a></strong>, and kindly contributed to <a rel="nofollow" href="https://www.r-bloggers.com/">R-bloggers)</a> </div>
<p><a target="_blank" rel="nofollow" href="https://i0.wp.com/r-exercises.com/wp-content/uploads/2016/10/download.jpg?resize=278%2C181"><img alt="download" class="wp-image-2350" src="https://i0.wp.com/r-exercises.com/wp-content/uploads/2016/10/download.jpg?resize=278%2C181" data-recalc-dims="1"></a></p>
<p>Descriptive Analytics is the examination of data or content, usually manually performed, to answer the question “What happened?”.</p>
<p>This is the first set of exercise of a series of exercises that aims to provide a descriptive analytics solution to the ‘2008’ data set from <a target="_blank" rel="nofollow" href="http://stat-computing.org/dataexpo/2009/the-data.html">here</a>. Download it and save it as a csv file. This data set which contains the arrival and departure information for all domestic flights in the US from 2008 has become the “iris” data set for Big Data. In the exercises below we cover the basics of data exploration. I chose it to be the ‘part 0’ of the descriptive analytics solution, because in order to proceed to the data pre-processing and then description you need to get to know your data set while it is not formally on the value chain of descriptive analytics process. Before proceeding, it might be helpful to look over the help pages for the <code>str</code>, <code>summary</code>, <code>dim</code>, <code>nrow</code>, <code>ncol</code>, <code>names</code>, <code>is.na</code>, <code>match</code> functions.</p>
<p>Answers to the exercises are available <a target="_blank" rel="nofollow" href="http://r-exercises.com/2016/10/19/descriptive-analytics-part-0-data-exploration-solution/">here</a>.</p>
<p>If you obtained a different (correct) answer than those listed on the solutions page, please feel free to post your answer as a comment on that page.</p>
<p>Load the data before proceeding. Let’s name the dataset as ‘flights’<br>
<code>flights &lt;- read.csv('2008.csv') </code></p>
<p><strong>Exercise 1</strong><br>
Print the structure of the data. What do you think about it?</p>
<p><strong>Exercise 2</strong><br>
Print the summary statistics of the data. What do you think about the values? (format, consistency, completeness)</p>
<p><strong>Exercise 3</strong><br>
Print the dimensionality of the data (number of rows and columns)</p>
<p><strong>Exercise 4</strong><br>
Print the number of rows. This may seem like a silly command, but it is quite useful for loops and if statements.</p>
<p><strong>Exercise 5</strong><br>
Print the number of columns.</p>
<p><strong>Exercise 6</strong><br>
Print the names of the variables.</p>
<p><strong>Exercise 7</strong><br>
Print whether the first column has missing values (NAs). Try to answer this question with two ways. Hint: %in%</p>
<p><strong>Exercise 8</strong><br>
Print the number of variables that contain missing values.</p>
<p><strong>Exercise 9</strong><br>
Find the portion of the variables that contain missing values. What do you think about it?</p>
<p><strong>Exercise 10</strong><br>
Print the names of the variables that contain missing values.</p>
<p><div><div><div><div data-width="55" data-show-faces="false" data-send="true" data-layout="box_count" data-height="62" data-href="https://www.r-bloggers.com/descriptive-analytics-part-0-data-exploration/"></div></div><div><a data-url="https://www.r-bloggers.com/descriptive-analytics-part-0-data-exploration/" data-counturl="https://www.r-bloggers.com/descriptive-analytics-part-0-data-exploration/" data-count="vertical" data-text="Descriptive Analytics – Part 0 : data exploration" class="twitter-share-button" data-via="rbloggers" href="https://twitter.com/share"></a></div><div></div></div><div></div></div>
<div>
<div>To <strong>leave a comment</strong> for the author, please follow the link and comment on their blog: <strong><a href="http://r-exercises.com/2016/10/19/descriptive-analytics-part-0-data-exploration/"> R-exercises</a></strong>.</div>
<hr>
<a rel="nofollow" href="https://www.r-bloggers.com/">R-bloggers.com</a> offers <strong><a rel="nofollow" href="https://feedburner.google.com/fb/a/mailverify?uri=RBloggers">daily e-mail updates</a></strong> about <a title="The R Project for Statistical Computing" rel="nofollow" href="https://www.r-project.org/">R</a> news and <a title="R tutorials" rel="nofollow" href="https://www.r-bloggers.com/?s=tutorial">tutorials</a> on topics such as: <a title="Data science" rel="nofollow" href="https://www.r-bloggers.com/?s=data%20science">Data science</a>, <a title="Big Data" rel="nofollow" href="https://www.r-bloggers.com/?s=Big%20Data">Big Data, <a title="R jobs" rel="nofollow" href="https://www.r-users.com/">R jobs</a>, visualization (<a title="ggplot and ggplot2 tutorials" rel="nofollow" href="https://www.r-bloggers.com/?s=ggplot2">ggplot2</a>, <a title="Boxplots using lattice and ggplot2 tutorials" rel="nofollow" href="https://www.r-bloggers.com/?s=boxplot">Boxplots</a>, <a title="Maps and gis" rel="nofollow" href="https://www.r-bloggers.com/?s=map">maps</a>, <a title="Animation in R" rel="nofollow" href="https://www.r-bloggers.com/?s=animation">animation</a>), programming (<a title="RStudio IDE for R" rel="nofollow" href="https://www.r-bloggers.com/?s=RStudio">RStudio</a>, <a title="Sweave and literate programming" rel="nofollow" href="https://www.r-bloggers.com/?s=sweave">Sweave</a>, <a title="LaTeX in R" rel="nofollow" href="https://www.r-bloggers.com/?s=LaTeX">LaTeX</a>, <a title="SQL and databases" rel="nofollow" href="https://www.r-bloggers.com/?s=SQL">SQL</a>, <a title="Eclipse IDE for R" rel="nofollow" href="https://www.r-bloggers.com/?s=eclipse">Eclipse</a>, <a title="git and github, Version Control System" rel="nofollow" href="https://www.r-bloggers.com/?s=git">git</a>, <a title="Large data in R using Hadoop" rel="nofollow" href="https://www.r-bloggers.com/?s=hadoop">hadoop</a>, <a title="Web Scraping of google, facebook, yahoo, twitter and more using R" rel="nofollow" href="https://www.r-bloggers.com/?s=Web+Scraping">Web Scraping</a>) statistics (<a title="Regressions and ANOVA analysis tutorials" rel="nofollow" href="https://www.r-bloggers.com/?s=regression">regression</a>, <a title="principal component analysis tutorial" rel="nofollow" href="https://www.r-bloggers.com/?s=PCA">PCA</a>, <a title="Time series" rel="nofollow" href="https://www.r-bloggers.com/?s=time+series">time series</a>, <a title="finance trading" rel="nofollow" href="https://www.r-bloggers.com/?s=trading">trading</a>) and more...
<img height="1" alt="" width="1" src="http://feeds.feedburner.com/~r/RBloggers/~4/3U1o1XhHRAI"></a></div>