<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-4-data-manipulation/"></div></div><div><a data-url="https://www.r-bloggers.com/descriptive-analytics-part-4-data-manipulation/" data-counturl="https://www.r-bloggers.com/descriptive-analytics-part-4-data-manipulation/" data-count="horizontal" data-text="Descriptive Analytics-Part 4 : Data Manipulation" 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/11/21/descriptive-analytics-part-4-data-manipulation/"> 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>Descriptive Analytics is the examination of data or content, usually manually performed, to answer the question “What happened?”.</p>
<p>In order to be able to solve this set of exercises you should have solved the <a target="_blank" rel="nofollow" href="http://r-exercises.com/2016/10/19/descriptive-analytics-part-0-data-exploration/">part 0</a>, <a target="_blank" rel="nofollow" href="http://r-exercises.com/2016/10/26/descriptive-analytics-part-1-data-formatting/">part 1</a>, <a target="_blank" rel="nofollow" href="http://r-exercises.com/2016/11/02/descriptive-analytics-part-2-data-imputation/">part 2</a> ,and <a target="_blank" rel="nofollow" href="http://r-exercises.com/2016/11/10/descriptive-analytics-part-3-outlier-treatment/">part 3</a> of this series but also you should run this <a target="_blank" rel="nofollow" href="https://github.com/VasTsak/r-exercises/blob/master/descriptive-analytics-part-3-completed">script</a> which contain some more data cleaning. In case you haven’t, run this <a target="_blank" rel="nofollow" href="https://github.com/VasTsak/r-exercises/blob/master/data_manipulation_prerequisite.R"> script</a> in your machine which contains the lines of code we used to modify our data set. This is the fifth 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>. 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. Descriptive analytics is all about answering questions, the goal of this set of exercises is to ‘answer’ questions with very few lines of code using the dplyr package. The dplyr is a great package for data manipulation ( if you are familiar with sql , it will be a piece of cake for you). Before proceeding, it might be helpful to look over the help pages for the <code> select</code>, <code>contains</code>, <code> filter</code>,<code>summarise</code>, <code> mutate</code>, <code> group_by</code>, <code> arrange</code>.</p>
<p>For this set of exercises you will need to install and load the package <code> rapportools</code>,<code> outliers</code>.</p>
<p><code>install.packages('dplyr')</code><br>
<code>library(dplyr)</code><br>
<code>install.packages('chron')</code><br>
<code>library(chron)</code></p>
<p>Since we use the <code>dplyr</code> package, we will also make the our data frame a local data frame.<br>
<code>flights &lt;- tbl_df(flights) </code><br>
The reason we do that is because it has some cool properties that can be useful. First of all, if we type ( accidentally) ‘flights’ as a local data frame it will print only the first 10 rows , while as a data frame it will print as many as your screen can fit, which can be both disturbing or have RAM issues may occur down the road. Another reason is that when we type the name of the data frame , it provides us with some information regarding the number of rows and columns and the type of variable that each column is.</p>
<p>Answers to the exercises are available <a target="_blank" rel="nofollow" href="http://r-exercises.com/2016/11/21/descriptive-analytics-part-4-data-manipulation-solutions/">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><strong>Exercise 1</strong><br>
Print the destination, the delay of arrivals and the air time of each flight.<br>
Hint: use <code>select</code> function</p>
<p><strong>Exercise 2</strong><br>
Print the columns that their name contains the word ‘Delay’.</p>
<p><strong>Exercise 3</strong><br>
Print the names of carrier, the month and the day of the week that the delay of carrier is higher than 180. </p>
<p><strong>Exercise 4</strong><br>
Print out all the flights grouped by carrier names.</p>
<p><strong>Exercise 5</strong><br>
Print out the mean of the arrival delay using the <code>summarise</code> function.</p>
<p><strong>Exercise 6</strong><br>
Print out the minimum,mean,median,variance,standard deviation,maximum,and counts of <code>AirTime</code>.</p>
<p><strong>Exercise 7</strong><br>
Print out the mean delay and the number of flights of each carrier.</p>
<p><strong>Exercise 8</strong><br>
Print out the mean delay and the number of flights of each carrier in descending order.</p>
<p><strong>Exercise 9</strong><br>
This exercise is a bit out of context, but it will demonstrate a great way of manipulating data and it is a prerequisite for the next exercise. </p>
<p>Create a new column code>Full_Date which will contain the date of each flight and then print it out.<br>
Hint: Use the <code>mutate</code> function.</p>
<p><strong>Exercise 10</strong><br>
Print out the dates that had the most flights and then print out the dates that had the highest ratio of cancelled flights.</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-4-data-manipulation/"></div></div><div><a data-url="https://www.r-bloggers.com/descriptive-analytics-part-4-data-manipulation/" data-counturl="https://www.r-bloggers.com/descriptive-analytics-part-4-data-manipulation/" data-count="vertical" data-text="Descriptive Analytics-Part 4 : Data Manipulation" 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/11/21/descriptive-analytics-part-4-data-manipulation/"> 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/y6tma1Ebr6k"></a></div>