Import Pandas
As always, the first step is importing the module that we'll use: Pandas
import pandas as pd
Examine the Structure
From there we can read the .csv file and take a look at the first 5 rows.
colors = pd.read_csv('data/colors.csv')
colors.head()We see that there are 5 columns, which include the name of the colour and its corresponding RGB value. To find the number of unique colours, all we need to do is check if every entry in the name column is unique:
colors['name'].nunique()
This shows us that there are 135 unique colours for LEGO blocks.
Find the number of transparent colours
One way you can do this is through combining our old friend, the .groupby() method, with the .count() method.
colors.groupby('is_trans').count() Here we just group by the is_trans column and count the entries.
But you might have also come across the very handy .value_counts() method in your research.
colors.is_trans.value_counts()
Once again, we select the column (here with the .dot notation) and call the method. The .value_counts() method is a very quick way of finding the number of members of each category.
Do you remember how to work with section headings and images? See if you can tackle the next couple of challenges to make your notebook look like this:
