2. Functions and packages

Question 1

numbers = [1, 2, 3, 4, 5]

list(filter(lambda x: x % 2 == 0, numbers))

Answer 1

Filtert de even getallen

Question 2

df_cloth.loc[:,’Shirt’:’Dress’]

Answer 2

Selecteren van kolommen ‘shirt’ en ‘dress’
.loc = selecteren op label

Question 3

df_cloth.loc[‘Expensive’:’Hat’]=8.99

Answer 3

Prijs aanpassen van expensive hat via loc functie

Question 4

‘Category’: [‘A’, ‘B’, ‘A’, ‘B’, ‘A’, ‘B’]
‘Value’: [10, 20, 30, 40, 50, 60]

df.groupby(‘Category’)[‘Value’].mean()

Answer 4

Groeperen op ‘Category’ en het gemiddelde van ‘Value’ berekenen

Question 5

get_group(‘Cheap’)

Answer 5

De specifieke groep ‘cheap’ oproepen obv naam

Question 6

df_cloth.iloc[0:2,1:3]

Answer 6

Selecteren van rijen 0-1 en kolommen 1-2
.iloc = selecteren op index

Question 7

numbers = [1, 2, 3, 4, 5]
list(map(lambda x: x ** 2, numbers))

Answer 7

Berekent de kwadraten van de getallen

Question 8

‘Category’: [‘A’, ‘B’, ‘A’, ‘B’, ‘A’, ‘B’]
‘Value’: [10, 20, 30, 40, 50, 60]

df.groupby(‘Category’)[‘Value’].agg([‘sum’, ‘mean’, ‘min’])

Answer 8

Groeperen op ‘Category’ en verschillende aggregatiefuncties toepassen

Question 9

df.drop()

Answer 9

Verwijderen van rijen of kolommen

Question 10

df.describe()

Answer 10

Basisstatistieken berekenen

Question 11

df.sort_values(ascending=false)

Answer 11

Aflopend sorteren