Below are the solutions to these exercises on manipulating data. ############### # # # Exercise 1 # # # ############### flights%>% select(Dest,ArrDelay,AirTime) ## # A tibble: 6,546,893 × 3 ## Dest ArrDelay AirTime ## <fctr> <dbl> <dbl> ## 1 TPA -14 116 ## 2 TPA 2 113 ## 3 BWI 14 76 ## 4 BWI […]

## Descriptive Analytics-Part 4 : Data Manipulation

Descriptive Analytics is the examination of data or content, usually manually performed, to answer the question “What happened?”. In order to be able to solve this set of exercises you should have solved the part 0, part 1, part 2 ,and part 3 of this series but also you should run this script which contain […]

## Descriptive Analytics-Part 3 : Outlier treatment

Descriptive Analytics is the examination of data or content, usually manually performed, to answer the question “What happened?”. In order to be able to solve this set of exercises you should have solved the part 0 and’part 1 , and part 2 of this series but also you should run this script which contain some […]

## Descriptive Analytics-Part 3 : Outlier treatment Solutions

Below are the solutions to these exercises on outlier treatment. ############### # # # Exercise 1 # # # ############### str(flights) ## ‘data.frame’: 6370961 obs. of 29 variables: ## $ Year : int 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 … ## $ Month : int 1 1 1 1 1 1 […]

## Descriptive Analytics-Part 2 : Data Imputation Solutions

Below are the solutions to these exercises on data imputation. #################### # # # Exercise 1 # # # #################### summary(flights) ## ## 844 values imputed to 110 ## ## ## 154699 values imputed to 8.168452 ## Year Month DayofMonth DayOfWeek ## Min. :2008 Min. : 1.000 Min. : 1.00 Min. :1.000 ## 1st Qu.:2008 […]

## Descriptive Analytics-Part 2 : Data Imputation

Descriptive Analytics is the examination of data or content, usually manually performed, to answer the question “What happened?”. In order to be able to solve this set of exercises you should have solved the part 0 and’part 1 of this series, in case you haven’t you can find the solutions to run them in your […]

## Descriptive Analytics-Part 1: Data Formatting Exercises

Descriptive Analytics is the examination of data or content, usually manually performed, to answer the question “What happened?”. In order to be able to solve this set of exercises you should have solved the ‘part 0’ of this series, in case you haven’t you can find the solutions to run them in your machine here. […]

## Descriptive Analytics-Part 1: Data Formatting Solutions

Below are the solutions to these exercises on data formatting. ############### # # # Exercise 1 # # # ############### head(flights[name]) # The date format makes sense to us , but not to R, if we just proceed to analysis without the data cleansing the result will make no sense or be quite biased. ## […]

## Descriptive Analytics – Part 0 : data exploration

Descriptive Analytics is the examination of data or content, usually manually performed, to answer the question “What happened?”. 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 here. Download it and save it as a csv file. This […]

## Descriptive Analytics – Part 0 : data exploration – solution

Below are the solutions to these exercises on data exploration. #################### # # # Exercise 1 # # # #################### str(flights) # too many variables ## ‘data.frame’: 7009728 obs. of 29 variables: ## $ Year : int 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 … ## $ Month : int 1 1 […]