Computer scienceData scienceInstrumentsPandasData analysis with pandas

Grouping and aggregating data in pandas

Penguin species

Report a typo

Let's continue to work with the dataset from the theory.

 	species    island 	bill_length_mm 	bill_depth_mm 	flipper_length_mm 	body_mass_g 	sex
0 	Adelie 	Torgersen 	          39.1 	         18.7 	            181.0 	     3750.0    MALE
1 	Adelie 	Torgersen 	          39.5 	         17.4 	            186.0 	     3800.0  FEMALE
2 	Adelie 	Torgersen 	          40.3 	         18.0 	            195.0 	     3250.0  FEMALE

Find the line that outputs a table with the penguin species grouped by islands, like this:

                       species
island                        
Biscoe        [Adelie, Gentoo]
Dream      [Adelie, Chinstrap]
Torgersen             [Adelie]

Select one option from the list

df.groupby('species').agg({'island': 'unique'})

df.groupby('island').agg({'species': unique})

df.groupby('species').agg({'species': 'unique'})

df.groupby('species').agg({'island': 'nunique'})

df.groupby('island').agg({'species': 'nunique'})

df.groupby('island').agg({'species': 'unique'})

___

Create a free account to access the full topic