Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
迎戰壞資料 @ dbootcamp Taipei
Search
tkirby
August 21, 2015
Education
0
750
迎戰壞資料 @ dbootcamp Taipei
by tkirby, openrefine & spreadsheet essential
tkirby
August 21, 2015
Tweet
Share
More Decks by tkirby
See All by tkirby
前端網頁資料視覺化設計
tkirby
1
490
Theory of Graphical Perception
tkirby
0
510
Open Refine Course
tkirby
0
190
Language Reference
tkirby
0
110
新聞記者的程式設計第一課
tkirby
0
560
Visualization over Web
tkirby
0
120
Rasterize D3.js
tkirby
7
1.7k
SVG + D3.JS Course Slide
tkirby
0
220
資料新聞學手冊導讀
tkirby
0
260
Other Decks in Education
See All in Education
家族をスクラムチームに! アジャイルで取り組む家事と育児 | Install Scrum to Family
coosuke
PRO
1
240
Gesture-based Interaction - Lecture 6 - Next Generation User Interfaces (4018166FNR)
signer
PRO
0
1.6k
R6愛南町事前復興フォーラムリーフレット
bousaichiribu
0
160
失敗しないISMS取得 - コンサルティング会社の選び方_サンプル【LRM 情報セキュリティお役立ち資料】
lrm
0
250
Adobe Express
matleenalaakso
1
7.8k
ワクワク発見資料
akenohoshi
0
210
A Chatbot is Not a Search Engine (it's more like a roleplaying game)
dsalo
0
220
Ch4_-_Cours_2.pdf
bernhardsvt
0
200
SkimaTalk Tutorial for Students
skimatalk
0
1.5k
Information Architectures - Lecture 2 - Next Generation User Interfaces (4018166FNR)
signer
PRO
0
1.4k
系統性を意識したプログラミング教育~ガチャを実装しよう~
asial_edu
0
260
(説明資料)オンラインゆっくり相談室
ytapples613
PRO
0
310
Featured
See All Featured
Faster Mobile Websites
deanohume
306
31k
JavaScript: Past, Present, and Future - NDC Porto 2020
reverentgeek
47
5.3k
jQuery: Nuts, Bolts and Bling
dougneiner
63
7.7k
Fireside Chat
paigeccino
37
3.3k
Visualizing Your Data: Incorporating Mongo into Loggly Infrastructure
mongodb
45
9.5k
The Cult of Friendly URLs
andyhume
78
6.3k
Optimising Largest Contentful Paint
csswizardry
35
3.2k
No one is an island. Learnings from fostering a developers community.
thoeni
21
3.2k
Design and Strategy: How to Deal with People Who Don’t "Get" Design
morganepeng
129
19k
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
eileencodes
33
2.1k
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
smashingmag
251
21k
Rails Girls Zürich Keynote
gr2m
94
13k
Transcript
資料整理真經 快速、有效且簡單的資料整理術
http://data.d3b.info/
Open Refine 清理資料、修正格式、轉換內容、利⽤用網路服務
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
None
raw.infographics.tw
None
None
None
None
None
None
None
None
None
None
⾼高中|⾼高職|職業|⼯工商|商⼯工|農⼯工|⼯工專|⾼高商|⼥女中|專科|⾼高級中學|⾼高⼯工|商職|海事 ⼤大學|⼤大專|學院|醫專
None
None
None
substring length replace if isBlank, isNumeric
None
None
None
Let’s Go Deeper • 總⾦金額有多少? • 有多少⼈人捐款? • 多少⼈人不具名?各捐了多少次? •
誰捐了最多錢? • 平均每個⼈人捐了多少錢?捐了幾次? • 哪個⾦金額是⼤大家最愛捐的? • 禮拜幾⼤大家最愛捐錢?
A B 1 10 5 2 20 4 3 30
3 = 10 + 5 = 10 + 20 + 30 = A1 + A2 + A3 = SUM(A1:B3) = SUM(A:A) = SUM( UNIQUE(A:A) )
Let’s Go Deeper • 總⾦金額有多少? • 有多少⼈人捐款? • 多少⼈人不具名?各捐了多少次? •
誰捐了最多錢? • 平均每個⼈人捐了多少錢?捐了幾次? • 禮拜幾⼤大家最愛捐錢?
Functions • SUM • COUNTA • UNIQUE • FILTER •
WEEKDAY • YEAR • MONTH • = (1 + 2) / 3 • =SUM(A:A) • =COUNTA(A1:B2) • FILTER(A:A,A:A = 3) • FILTER(A:A,A:A > 3) • WEEKDAY(A5) • DAY(D1) • = “ABC”
https://goo.gl/s2wZ18 冰桶挑戰芳名錄 Spreadsheet
Exercise • =(1 + 2) / 3 • =SUM(A:A) •
=COUNTA(A1:B2) • =UNIQUE(A:A) • =FILTER(A:A,A:A = 3) • =FILTER(A:A,A:A > 3) • =WEEKDAY(A5) • =YEAR(B5) • =DAY(D1) • 總⾦金額有多少? • 多少⼈人不具名?各捐了多少次? • 誰捐了最多錢? • 哪個⾦金額是⼤大家最愛捐的? • 禮拜幾⼤大家最愛捐錢? • 每⽉月的幾號⼤大家最喜歡捐錢? • 捐款在⼀一萬元以上的有多少⼈人? • 加總 • 算數量 • 扣掉重覆的 • 過濾不要的 • 取出星期幾 • 取出年 • 取出⽇日
https://goo.gl/bE9xLb 第11屆村⾥里⻑⾧長選舉
None
None
None