开始使用免费开始使用

How big are Jupiter's moons?

Categorical data is everywhere! It consists of a finite number of distinct values, called categories. When you're working with categorical data, understanding the different categories present in the data is an important first data exploration step. When looking at the unique categories, you might identify data quality issues, such as typos, which will mistakenly be identified as a distinct category.

Once you understand the different categories, you can filter your dataset on the categories to zoom-in and begin exploring your dataset on smaller scales.

In this exercise, you'll find the unique values in the Parent column as a data quality check, then use your new-found filtering skills to begin exploring the 79 moons of Jupiter!

本练习是课程的一部分

Google Sheets 数据分析

查看课程

练习说明

  • In column E, find the unique values in the Parent column.
  • In column F, filter the Mean radius (km) column to return rows containing the moons of Jupiter.
  • In G2, calculate the median of the radius values in column F.

动手互动练习

通过我们的互动练习之一,将理论转化为实践

开始练习