Merging Datasets with Common Columns in Google Refine
OUseful.Info, the blog… Trying to find useful things to do with emerging technologies in open education and data journalism. Snarky and sweary to anyone who emails to offer me content for the site. It’s an often encountered situation, but one that can be a pain to address – merging data from two sources around a common column. Here’s a way of doing it in Google Refine… Here are a couple of example
Reconciliation Services for OpenRefine
refine.codefork.com This server provides OpenRefine reconciliation services for the following data sources: VIAF - Virtual International Authority File ORCID - digital identifiers for researchers Open Library - an open, editable library catalog (a project of the Internet Archive) more to come... You can use these services to resolve many types of names (i.e. persons, organizations, geographic regi
特許データã®ã‚´ãƒŸå–り（å寄ã›ï¼‰ã¸ã®Open Refineã®åˆ©ç”¨å¯èƒ½æ€§ï¼ˆï¼˜ï¼‰
ã•ã¦ã€ã“ã®ãƒ‡ãƒ¼ã‚¿ã‚’Open Refineã«å–り込んã§ã„ãã¾ã™ã€‚ å–り込んã ã®ãŒã€ã“ã®çŠ¶æ…‹ã€‚ ã“ã“ã‹ã‚‰ã€å‰å›žã¨åŒæ§˜ã«Text Facetã‚’é¸æŠžã—ã¦ã€Clusteringã§Metaphone3ã‚’é¸æŠžã™ã‚‹ã¨ã“ã®ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ ã©ã†ã—よã†ã‚‚ãªã„ã§ã™ã。Clusteringã§Key Collisionç³»ã®å‡¦ç†ã¯è»’並ã¿ãƒ€ãƒ¡ã§ã™ã€‚ Key Collisionç³»ã¯è‹±æ–‡ï¼ˆWord毎ã«ã‚¹ãƒšãƒ¼ã‚¹ãŒå…¥ã‚‹æ–‡ï¼‰å‘ãã§ã€ä¸å›½èªžã‚„日本語ã®ã‚ˆã†ãªæ–‡ã«ã¯å‘ã‹ãªã„よã†ã§ã™ã€‚ ãã“ã§ã€nearest neighborã®levensteinã‚’é¸æŠžã—ã¦ã¿ã¾ã™ã€‚調整値ã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã€‚ å‰å›žã®è‹±æ–‡ã¨æ¯”較ã™ã‚‹ã¨ã‚¢ãƒ¬ã§ã™ãŒã€ã‚る程度ã®ãƒ¬ãƒ™ãƒ«ã§ä¼¼ãŸæ–‡å—列ã®å‡ºé¡˜äººåã‚’å寄ã›å€™è£œã¨ã—ã¦æ示ã—ã¦ãã‚Œã¾ã™ã€‚後ã¯ã©ã‚Œã‚’採用ã™ã‚‹ã‹å€‹åˆ¥ã«é¸æŠžã™ã‚‹ã“ã¨ã«ãªã‚Šã¾ã™ã€‚ã¾ã‚ã¾ã‚使ãˆã‚‹ã¨ã„ã†çµæžœã§ã™ã€‚日本語ã®å‡ºé¡˜äººåã®å ´åˆã«ã‚‚åŒæ§˜ã®æ„Ÿè¦šã§ä½¿ãˆã‚‹ã§ã—ょã†ã€‚ ã•ã¦ã€ä¸€
オープンアクセスリãƒã‚¸ãƒˆãƒªæŽ¨é€²å”会（JPCOAR）
オープンアクセスリãƒã‚¸ãƒˆãƒªæŽ¨é€²å”会（JPCOAR : Japan Consortium for Open Access Repositories）ã¯ã€ãƒªãƒã‚¸ãƒˆãƒªã‚’通ã˜ãŸçŸ¥ã®ç™ºä¿¡ã‚·ã‚¹ãƒ†ãƒ ã®æ§‹ç¯‰ã‚’推進ã—ã€ãƒªãƒã‚¸ãƒˆãƒªã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ã®å¼·åŒ–ã¨ã€æˆ‘ãŒå›½ã®ã‚ªãƒ¼ãƒ—ンアクセス並ã³ã«ã‚ªãƒ¼ãƒ—ンサイエンスã«è³‡ã™ã‚‹ã“ã¨ã‚’目的ã¨ã—ã€å›½å…¬ç§ç«‹å¤§å¦å›³æ›¸é¤¨å”力委員会ã¨å›½ç«‹æƒ…å ±å¦ç ”究所ã®é–“ã®é€£æºãƒ»å”力å”定ã«åŸºã¥ãã€2016å¹´7月ã«è¨ç«‹ã•ã‚ŒãŸã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ã§ã™ã€‚
Apache2 Ubuntu Default Page: It works
This is the default welcome page used to test the correct operation of the Apache2 server after installation on Ubuntu systems. It is based on the equivalent page on Debian, from which the Ubuntu Apache packaging is derived. If you can read this page, it means that the Apache HTTP server installed at this site is working properly. You should replace this file (located at /var/www/html/index.html)
Google Refineã¯ç¥žãƒ„ールã§ã‚ã‚‹ | wrong, rogue and log
Google Refine 2.0 http://code.google.com/p/google-refine/ Googleã®ãƒ‡ãƒ¼ã‚¿ã‚¯ãƒ¬ãƒ³ã‚¸ãƒ³ã‚°ãƒ„ール。ãƒãƒ¼ã‚«ãƒ«webサーãƒãƒ¼ã§å‹•ä½œã™ã‚‹ã‚¢ãƒ—リã§ã‚る。ãªãœãƒãƒ¼ã‚«ãƒ«ã§å‹•ä½œã™ã‚‹webサーãƒã«ã—ã¦ã„ã‚‹ã‹ã¨ã„ã†ã¨ã€ãã‚Œã«ã¯ç†ç”±ãŒã‚ã‚‹ã®ã 。ã»ã‚“ã¨ã€ãƒ“ックリ。 公開ã—ã¦ã„るデータã¯ã‚¿ã‚¤ãƒˆãƒ«ã‚„データ形å¼ãŒãƒžãƒãƒžãƒã§ã€ãれを自分ã®ã¨ã“ã‚ã§çµ±è¨ˆè§£æžã™ã‚‹ã«ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ¬ãƒ³ã‚¸ãƒ³ã‚°ã‚’ã‹ãªã‚Šã‚„らãªã‘ã‚Œã°ã„ã‘ãªã‹ã£ãŸã€‚ãã®ãŸã‚ã«ã¯ã€ã„ã¾ã¾ã§grepã ã¨ã‹findã ã¨ã‹ã®ã‚³ãƒžãƒ³ãƒ‰ã‚„Pythonスクリプトã§åŠç‹‚ä¹±ã«ãªã£ã¦æ±šã‚Œè½ã¨ã—ã‚’ã—ã¦ã„ãŸã‘ã‚Œã©ã€ã“ã®Google Refineを使ã†ã¨ãã†ã„ã†å•é¡ŒãŒã‚¢ãƒ›ã¿ãŸã„ã«ç°¡å˜ã«è§£æ±ºã™ã‚‹ã€‚ 例ãˆã°ã€ã‚«ãƒ†ã‚´ãƒªã‚«ãƒ«ãƒ‡ãƒ¼ã‚¿ãŒã‚»ãƒ«ã«å‰²ã‚Šå½“ã¦ã‚‰ã‚Œã¦ã„ã‚‹ã¨ã™ã‚‹ã€‚記入者ã«ã‚ˆã£ã¦ãã‚ŒãŒç•¥èªžã ã£ãŸã‚Šãƒ•ãƒ«ã®å称ã ã£ãŸã‚Šãƒžãƒãƒžãƒã§ã‚る。ã“れを全ã¦ä¸€ã¤ã®æ–‡å—
1
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
Remove duplicate rows
vlookup in google refine
Fetching URLs From Web Services
StrippingHTML
Using OpenRefine
Parse JSON in Google Refine
GREL Functions
GitHub - isaomatsunami/RegularExp-OpenRefine: データã®æ´—浄
Amazon.co.jp: Using OpenRefine (English Edition): Verborgh, Ruben, Wilde, Max De: Digital Ebook Purchas
Extracting, Augmenting, and Updating Metadata in Fedora 3 and 4 Using a Local OpenRefine Reconciliation Service
https://acrl.ala.org/techconnect/?p=3276
https://acrl.ala.org/techconnect/?p=4253
OpenRefine
{{#tags}}- {{label}}
{{/tags}}