¶ Comparing the difference between two columns of text
wrangles:
- compare.text:
input:
- col1
- col2
output: Difference
method: difference
| | |
|---|
| Col1 |
Col2 |
| Large Oak Wood White Marble Top Bookshelf |
Large Pine Wood Black Marble Bottom Bookshelf |
| Medium Oak Wood White Marble Top Coffee Table |
Medium Maple Wood Orange Steel Top Coffee Table |
| Small Oak Wood White Marble Top Console Table |
Small Normal Wood Blue Plastic Top Console Table |
|
→
|
| Difference |
| Pine Black Bottom |
| Maple Orange Steel |
| Normal Blue Plastic |
|
¶ Comparing the intersection of two columns of text
wrangles:
- compare.text:
input:
- col1
- col2
output: Intersection
method: intersection
| | |
|---|
| Col1 |
Col2 |
| Large Oak Wood White Marble Top Bookshelf |
Large Pine Wood Black Marble Bottom Bookshelf |
| Medium Oak Wood White Marble Top Coffee Table |
Medium Maple Wood Orange Steel Top Coffee Table |
| Small Oak Wood White Marble Top Console Table |
Small Normal Wood Blue Plastic Top Console Table |
|
→
|
| Intersection |
| Large Wood Marble Bookshelf |
| Medium Wood Top Coffee Table |
| Small Wood Top Console Table |
|
¶ Comparing the overlap of two columns of text
wrangles:
- compare.text:
input:
- Part Code1
- Part Code2
output: Overlap
method: overlap
| | |
|---|
| Part Code1 |
Part Code2 |
| SKF6202 |
TMKN6202 |
| X06-02-000 |
X06-81-000 |
| 7100E15-V-230/3 |
7100E15-V-120/1 |
|
→
|
| Overlap |
| ****6202 |
| X06-**-000 |
| 7100E15-V-**0/* |
|