Miller: paragrafo join

[aborruso]

Appunti

cat person.csv

id_p,gender
456,F
789,F
123,M

cat weight.csv

id_w,weight
123,200
999,160
789,155

---

left_join

mlr --c2p --barred join --ul -j id_p -l id_p -r id_w -f person.csv then unsparsify weight.csv

+------+--------+--------+
| id_p | gender | weight |
+------+--------+--------+
| 123  | M      | 200    |
| 789  | F      | 155    |
| 456  | F      | -      |
+------+--------+--------+

right_join

mlr --c2p --barred join --ur -j id_w -l id_p -r id_w -f person.csv then unsparsify weight.csv

+------+--------+--------+
| id_w | gender | weight |
+------+--------+--------+
| 123  | M      | 200    |
| 999  | -      | 160    |
| 789  | F      | 155    |
+------+--------+--------+

full_join

mlr --c2p --barred join --ul --ur -j id_p -l id_p -r id_w -f person.csv then unsparsify weight.csv

+------+--------+--------+------+
| id_p | gender | weight | id_w |
+------+--------+--------+------+
| 123  | M      | 200    | -    |
| -    | -      | 160    | 999  |
| 789  | F      | 155    | -    |
| 456  | F      | -      | -    |
+------+--------+--------+------+

semi_join

The first output table of

mlr --c2p --barred join --ul -j id_p -l id_p -r id_w -f person.csv weight.csv

+------+--------+--------+
| id_p | gender | weight |
+------+--------+--------+
| 123  | M      | 200    |
| 789  | F      | 155    |
+------+--------+--------+

+------+--------+
| id_p | gender |
+------+--------+
| 456  | F      |
+------+--------+

anti_join

mlr --c2p --barred join --np --ul -j id_p -l id_p -r id_w -f person.csv then unsparsify weight.csv

+------+--------+
| id_p | gender |
+------+--------+
| 456  | F      |
+------+--------+

[aborruso]

Accoppiare con questo tipo di immagine