4 Samenvoegen Flashcards

(7 cards)

1
Q

Inner join

A

alleen rijen met match in beide datasets.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Left join

A

alle rijen uit linker dataset, met aanvulling uit rechter.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Right join

A

alle rijen uit rechter dataset, met aanvulling uit linker.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Outer join

A

alle rijen uit beide datasets, met NaN waar geen match is.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

One-to-one

A

elke waarde komt maar één keer voor in beide datasets.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

One-to-many

A

één waarde in de ene dataset, meerdere in de andere.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Many-to-many

A

meerdere rijen matchen met meerdere rijen.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly