[Week3] clean & correct data with OpenRefine
11 likes1,451 views
蟲蠍 ろ襴(openrefine) 牛 一危 https://www.facebook.com/datadesigner2015
![OpenRefine
City - Edit cells - transform
value + , + cells[state].value](https://image.slidesharecdn.com/week3cleancorrectdata-150124002827-conversion-gate02/85/Week3-clean-correct-data-with-OpenRefine-39-320.jpg)
[Week3] clean & correct data with OpenRefine
- 2. Chapter1 Getting started with OpenRefine OpenRefine
- 3. 1 Diving into OpenRefine OpenRefine
- 4. OpenRefine 1. http://openrefine.org/download.html 1. http://openrefine.org/download.html 2. Mac kit れ企 3. dmg 願 OpenRefine 伎 application 启襦 蠏 4. ろ 2. ZIP れ企蠍 3. OpenRefine ろ
- 5. OpenRefine OpenRefine Google Chrome襷 ろ 螳 Internet Explorer X
- 7. OpenRefine 覦 一危磯ゼ る蠍一 螻殊 蟲 Free & OpenSource Desktop based Facet朱 一危一 れ螳 螳 れ input & output 一危 襷 一危 覲 API襯 牛 一危 覲 螳
- 8. OpenRefine Google Refine Spreadsheets Databases 1. Batch editing of rows and columns possible 2. Used for exploring and transforming data. 3. No Schema Required 4. Data is always visible at each step of editing. 5. More interactive and visual. 1. Editing of one cell at a time. 2. Used for entering data and performing calculations, functions. 3. No Schema Required 4. Data is always visible 5. Visual is not impressive. 1. Schema and programming language required for editing. 2. Data is out of sight unless script is run to view it. 觜訣 蟲り骸 觜蟲
- 9. OpenRefine 2.Creating & Setting a new project 襦 襦 襷り鍵
- 11. OpenRefine Create Project 殊 Next Creating & Setting a new project 1 2 3 れ旧 : RatesSweden.csv
- 12. OpenRefine 一危 誤 螻 CSV, TSV れ螻 覓語 語 ∬係襴螻 襦 語蟆 れ 襦碁 れ Main setting
- 13. OpenRefine Check List Row 螳 伎 覈 螳 row襯 覲 蟆語? previous / next 伎 れ Open Project Export
- 14. OpenRefine 3 Correct bad formatting 覈視 覦襦♀鍵 replace(orginal value, replaceable text, new text) To Number Numeric Facet : RatesSweden.csv
- 15. OpenRefine replace(orginal value, replaceable text, new text) To Number Numeric Facet
- 16. OpenRefine rate 蟆曙 狩螳 襷豺襦 蟲覿蟆 覲危ｸ 蠏碁る 企至 覯 狩襷 襷豺襦 覦蠖 蟾? Edit cells - transform replace(value, , , .)
- 18. OpenRefine replace(orginal value, replaceable text, new text) To Number Numeric Facet
- 19. OpenRefine Edit Cells - Common Transforms - To number ∬螳 蟆 轟朱 覲伎 襦 語
- 20. OpenRefine replace(orginal value, replaceable text, new text) To Number Numeric Facet
- 21. OpenRefine Numeric Facet襯 牛 一危一 Scale 譟一 牛 蟲螳 覦 sorting
- 22. OpenRefine 4 Correct Misspellings 覈視 る 覦襦♀鍵 Trim To Uppercase or To lowercase Clustering Merge columns : slategundeath.csv
- 23. OpenRefine Trim To Uppercase or To lowercase Clustering Merge columns
- 25. OpenRefine Facet - Text facet facet襯 牛 city 一危
- 26. OpenRefine 狩 一危郁 るジ 一危磯 語 伎郁鍵螳 蠍 覓語 狩 一危磯 語貅 譴 (trim)
- 27. OpenRefine city - Edit cells value.trim()
- 28. OpenRefine city - Edit cells - value.trim() Albuquerque襯 觜襦 伎郁鍵螳 螳れ 襴 Albuquerque 螳螳 2,071螳 -> 2,063襦 覦
- 29. OpenRefine Trim To Uppercase or To lowercase Clustering Concatenation
- 30. OpenRefine 覩瑚記 54螳 譯? 覩瑚記 燕 D.C襯 豎 51螳 伎 ろ伎れ手 /覓語襦 誤 るジ 一危磯 語 ∬係 覦 るジ 譯朱 /覓語 蟲覲 讌 一危
- 31. OpenRefine Edit cells - Common transform - To uppercase 覓語襦 旧 1 2 3
- 33. OpenRefine Trim To Uppercase or To lowercase Clustering Concatenation
- 34. OpenRefine Oklahoma City vs. Oklahoma city Cluster and edit 覃企ゼ 牛 企ろ磯 OpenRefine 伎 螻襴讀 覿 1 2 3
- 35. OpenRefine 企ろ磯 牛 螳れ 覲伎譴 燕, 煙 覿覦覯朱 覿 蟆 一危一 , 覲伎朱
- 36. OpenRefine Trim To Uppercase or To lowercase Clustering Concatenation
- 37. OpenRefine 覩瑚記 譯朱 豐蠍一蟇伎 觜蟲 9 貊朱る 72蟇 ∬骸 蠏碁願?
- 38. OpenRefine 狩 企 Columbus 企 譯朱 OH, GA, IN るゴ 讀 襷讌 豐蠍一蟇伎螳 豺伎危 蟆朱 ∬係る, city + state襯 覲 蟲 襷れ伎
- 39. OpenRefine City - Edit cells - transform value + , + cells[state].value
- 40. OpenRefine Text facet朱 れ 覿 蟆郁骸 襴 覿
- 41. OpenRefine 5 Invalid values and duplicates 讌 螳螻 譴覲糾 : (re)titanic.csv 一危一 危企 蠏狩蠍 る一危一 伎 覿螻
- 42. OpenRefine : (re)titanic.csv 一危一 危企 蠏狩蠍 る一危一 伎 覿螻
- 43. OpenRefine Titanic 轟 覲 一危 る 蟾? 一 sex facet襯 牛 一危
- 44. OpenRefine 炎骸 煙 覃? ∬鍵覲語朱 一危 る手 豢
- 45. OpenRefine 煙 企 Miss 煙朱 螳譯
- 47. OpenRefine : (re)titanic.csv 一危一 危企 蠏狩蠍 る一危一 伎 覿螻
- 48. OpenRefine Facet - Numeric facet Scale 覯 譟一朱 る 一危 ′願鍵 490 る 一危 49伎企手 ロ伎 蟆 覈 ロり 49企 , number襦 れ
- 49. OpenRefine 6 Exporting a project 襦 企慨願鍵
- 51. OpenRefine Practice hokuk.xls 殊 openrefine 覲伎語 Concatenation, value.round(), trim() 煙
- 52. OpenRefine