VLookup not enough to match records? Need to categorize or transform some messy data? EntityMatcher provides automated cleaning tools for your messy data without having to write any complex logic.
๊ฐœ๋ฐœ์ž:
์ •๋ณด ์—…๋ฐ์ดํŠธ:2024๋…„ 2์›” 26์ผ
ํ˜ธํ™˜ ๊ธฐ๊ธฐ:
๋ฆฌ๋ทฐ ์—†์Œ
19
๊ฐœ์š”
Figuring out whether two entities (people, places, products, etc.) are the same can always be a challenge, particularly when dealing with messy data with no unique identifier. You canโ€™t ignore the problem though, because it can be crucial to joining datasets from different sources or de-duplicating a dataset. Similarly, categorizing and transforming messy data can also be a challenge and require complex logic that is hard to manage or even impossible to define.

EntityMatcher is an application that let's you do these tasks easily and automatically with AI. Simply provide the datasets and EntityMatcher will do the rest. It also provides a UI for reviewing the matches yourself. This add-on allows users to do this all without having to leave sheets by using custom formulas.

For matching, use the ENTITYMATCH formula, where you specify the datasets as ranges, the id columns, and the job name:
=ENTITYMATCH(A1:E51,"id", google!A1:E44, "id", "test_google_sheets_matching")

For transformation, use the ENTITYTRANSFORM formula, where you specify the dataset, id column, instructions for the transformation that needs to take place, and the job name:
=ENTITYTRANSFORM(A1:E44, "id", "get the vendor and indicate whether the product is software or not, two separate fields", "plugin-transform-test-v1")

For categorization, use the ENTITYCATEGORIZE formula, where you specify the dataset, id column, categories, and the job name:
=ENTITYCATEGORIZE(A1:E44, "id", I2:I3, "plugin-categorize-test-v1")

All of these formulas use the EntityMatcher API to run AI models to automatically complete the relevant task. The outputs are displayed directly in the google sheet, and you can use the EntityMatcher UI to review the predictions in more detail if necessary.

Check out https://docs.entitymatcher.com/quickstart for more information.
์ถ”๊ฐ€์ •๋ณด
๊ฐ€๊ฒฉ๋ฌด๋ฃŒ
๊ฐœ๋ฐœ์ž
๋น„์‚ฌ์—…์ž
๊ฐœ์ธ์ •๋ณด์ฒ˜๋ฆฌ๋ฐฉ์นจ
EntityMatcher์—์„œ ์•„๋ž˜์— ํ‘œ์‹œ๋œ ๊ถŒํ•œ์„ ์š”์ฒญํ•ฉ๋‹ˆ๋‹ค. ์ž์„ธํžˆ ์•Œ์•„๋ณด๊ธฐ
EntityMatcher์—์„œ Google ๊ณ„์ •์— ์•ก์„ธ์Šคํ•ด์•ผ ํ•จ
์ด๋ ‡๊ฒŒ ํ•˜๋ฉด EntityMatcher์—์„œ ๋‹ค์Œ ์ž‘์—…์„ ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.
๋ชจ๋“  Google Sheets ์Šคํ”„๋ ˆ๋“œ์‹œํŠธ ํ™•์ธ, ์ˆ˜์ •, ์ƒ์„ฑ, ์‚ญ์ œ
Google ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜ ๋‚ด ๋ฉ”์‹œ์ง€ ๋ฐ ์‚ฌ์ด๋“œ๋ฐ”์— ์™ธ๋ถ€ ์›น ์ฝ˜ํ…์ธ ๋ฅผ ํ‘œ์‹œํ•˜๊ณ  ์‹คํ–‰ํ•ฉ๋‹ˆ๋‹ค.
์™ธ๋ถ€ ์„œ๋น„์Šค์— ์—ฐ๊ฒฐ
๊ธฐ๋ณธ Google ๊ณ„์ •์˜ ์ด๋ฉ”์ผ ์ฃผ์†Œ ํ™•์ธ
๊ฐœ์ธ์ •๋ณด(๊ณต๊ฐœ๋กœ ์„ค์ •ํ•œ ๊ฐœ์ธ์ •๋ณด ํฌํ•จ) ๋ณด๊ธฐ
๋ฆฌ๋ทฐ
์–ธ์–ด:
์ •๋ ฌ ๊ธฐ์ค€:
Google์—์„œ๋Š” ๋ฆฌ๋ทฐ๋‚˜ ํ‰์ ์„ ํ™•์ธํ•˜์ง€ ์•Š์Šต๋‹ˆ๋‹ค. ๋ฆฌ๋ทฐ์— ๋Œ€ํ•ด ์ž์„ธํžˆ ์•Œ์•„๋ณด๊ธฐ
๋Œ“๊ธ€ ์—†์Œ
๊ฒ€์ƒ‰
๊ฒ€์ƒ‰์–ด ์ง€์šฐ๊ธฐ
๊ฒ€์ƒ‰ ๋‹ซ๊ธฐ
Google ์•ฑ
๊ธฐ๋ณธ ๋ฉ”๋‰ด