• Transforming data:
  • aggregate
  • collect
  • window
  • filter
• Building bar plots with transformed data

We will be working with data on Ferris Wheels from Tidy Tuesday.

Download starter project.

Question: What is the top 5 countries with the most Ferris Wheels?

Four transform objects:

1. aggregate by country
2. sort by the new variable count in descending order
3. create a new variable called rank
4. filter to keep the top 5 observations

Create two scales, one of type band and another linear to map the variables country and count

Add axes to your spec so that you can check your work.

1. Add rectangles from the count data you created
2. Map x and y to your variables
3. If you have vertical bars, include y2 and width
4. If you have horizontal bars, include x2 and height

1. Add text from the count data you created
2. Map x and y to your variables
3. For the property text use your numeric variable
4. Add the dx and dy properties to adjust the text position
5. You can also change the default for fill

Add all the titles you deem necessary

1. add an update element to the rect marks for color
2. add a hover element as well

update: {
  fill: { value: "black" }
},
hover: {
  fill: { value: "LightGray" },
  strokeWidth: { value: 2 },
  stroke: { value: "black" }
  
}

{
  name: "aggregated",
  source: "ferrisWheels",
  transform: [
    {
      type: "aggregate",
      groupby: ["country"],
      fields: ["height"],
      ops: ["mean"],
      as: ["m"]
    }
  ]
}