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
720
迎戰壞資料 @ dbootcamp Taipei
by tkirby, openrefine & spreadsheet essential
tkirby
August 21, 2015
Tweet
Share
More Decks by tkirby
See All by tkirby
前端網頁資料視覺化設計
tkirby
1
430
Theory of Graphical Perception
tkirby
0
450
Open Refine Course
tkirby
0
180
Language Reference
tkirby
0
96
新聞記者的程式設計第一課
tkirby
0
510
Visualization over Web
tkirby
0
110
Rasterize D3.js
tkirby
7
1.6k
SVG + D3.JS Course Slide
tkirby
0
200
資料新聞學手冊導讀
tkirby
0
240
Other Decks in Education
See All in Education
week@tcue2024
nonxxxizm
0
510
Amazon Connectを利用したCloudWatch Alarm電話通知
junghyeonjae
0
230
White Snake: Qing's Mission
movingcastal
0
250
HCI Research Methods - Lecture 7 - Human-Computer Interaction (1023841ANR)
signer
PRO
0
670
Requirements Analysis and Prototyping - Lecture 3 - Human-Computer Interaction (1023841ANR)
signer
PRO
0
770
ブームだけで終わらせない、組織内でコーチングを活用する方法/How to Use Coaching in Your Organization Without It Being Just a Fad
yuko_yokouchi
1
280
困ったときのガイドライン / We Support You in Any Situation
yasulab
2
3.8k
Web Architectures - Lecture 2 - Web Technologies (1019888BNR)
signer
PRO
0
2.6k
construindo uma carreira com opensource
caarlos0
0
210
本の虫になろう
kenjiro56
0
140
week15@tcue2024
nonxxxizm
0
560
XML and Related Technologies - Lecture 7 - Web Technologies (1019888BNR)
signer
PRO
0
2.5k
Featured
See All Featured
Six Lessons from altMBA
skipperchong
26
3.5k
Optimising Largest Contentful Paint
csswizardry
33
2.9k
Gamification - CAS2011
davidbonilla
80
5k
Designing the Hi-DPI Web
ddemaree
280
34k
Fantastic passwords and where to find them - at NoRuKo
philnash
50
2.8k
Navigating Team Friction
lara
183
14k
VelocityConf: Rendering Performance Case Studies
addyosmani
325
24k
For a Future-Friendly Web
brad_frost
175
9.4k
Facilitating Awesome Meetings
lara
49
6k
Art, The Web, and Tiny UX
lynnandtonic
296
20k
The Invisible Side of Design
smashingmag
297
50k
The Power of CSS Pseudo Elements
geoffreycrofte
72
5.3k
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