R Tutorial: Filtering and plotting the data

Key Takeaways

good job pre-processing the data this task often takes a lot of time but here you are lucky to work with data that is already in a clean and tidy format in the remainder of this chapter you're going to further explore the relationship between weakly working hours and hourly compensation and the scatterplot is a good visual exploration form to do this before visualizing this relationship you'll need to use the pliers filter function to retain only European countries in the data set that's a good set of countries where data for both 1996 and 2006 are available the years you're going to compare in the second chapter of this course you already know how to use the filter function as shown in the code example here we're only Switzerland is retained however you might not know the so called in operator which often makes queries easier while the Equality operator in the previous example can filter for only one value at a time the in operator can lookup multiple values like in this example here we filter for countries in the vector on the right-hand side of the in operator which is actually equivalent to using the or operator with multiple equality operators so in the following exercise you are going to use this new in operator to only retain European countries in the data set let's look at both labor market indicators with ggplot2 we can quickly create a histogram of both the weekly working hours variable and the hourly compensation variable this shows us the distribution of these values in 2006 however in order to see the relationship between both variables we need to use chichi plots point geometry and this is what you're going to do in the following exercises you're going to create the scatter plot shown here using chichi plots Jian point function still without proper titles and labels the plot is pretty worthless in a follow-up exercise you're to use chichi plots lapse function to provide more information to the readers of your plot you're also going to quickly repeat some deep liar functions like group by and summarize as shown in this example here where we computed the median weekly working hours over all years for every country the result of this is a table which you're going to style in the later parts of this course where you will compile a nice report of your findings now it's your turn