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
770
迎戰壞資料 @ dbootcamp Taipei
by tkirby, openrefine & spreadsheet essential
tkirby
August 21, 2015
Tweet
Share
More Decks by tkirby
See All by tkirby
前端網頁資料視覺化設計
tkirby
1
530
Theory of Graphical Perception
tkirby
0
560
Open Refine Course
tkirby
0
210
Language Reference
tkirby
0
110
新聞記者的程式設計第一課
tkirby
0
580
Visualization over Web
tkirby
0
130
Rasterize D3.js
tkirby
7
1.7k
SVG + D3.JS Course Slide
tkirby
0
240
資料新聞學手冊導讀
tkirby
0
280
Other Decks in Education
See All in Education
Info Session MSc Computer Science & MSc Applied Informatics
signer
PRO
0
200
予習動画
takenawa
0
12k
Sponsor the Conference | VizChitra 2025
vizchitra
0
590
2025.05.10 技術書とVoicyとわたし #RPALT
kaitou
1
240
2025/06/05_読み漁り学習
nag8
0
180
Gamified Interventions for Composting Behavior: A Case Study Using the Gamiflow Framework in a Workplace Setting
ezefranca
1
210
Education-JAWS #3 ~教育現場に、AWSのチカラを~
masakiokuda
0
200
20250611_なんでもCopilot1年続いたぞ~
ponponmikankan
0
140
みんなのコード 2024年度活動報告書/ 2025年度活動計画書
codeforeveryone
0
200
2025年度春学期 統計学 第12回 分布の平均を推測する ー 区間推定 (2025. 6. 26)
akiraasano
PRO
0
140
ビジネスモデル理解
takenawa
0
11k
Interaction - Lecture 10 - Information Visualisation (4019538FNR)
signer
PRO
0
2k
Featured
See All Featured
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
rmw
34
3.1k
Become a Pro
speakerdeck
PRO
29
5.5k
jQuery: Nuts, Bolts and Bling
dougneiner
63
7.8k
CSS Pre-Processors: Stylus, Less & Sass
bermonpainter
357
30k
The Cost Of JavaScript in 2023
addyosmani
51
8.7k
How GitHub (no longer) Works
holman
314
140k
Imperfection Machines: The Place of Print at Facebook
scottboms
267
13k
Templates, Plugins, & Blocks: Oh My! Creating the theme that thinks of everything
marktimemedia
31
2.5k
Mobile First: as difficult as doing things right
swwweet
223
9.9k
Dealing with People You Can't Stand - Big Design 2015
cassininazir
367
26k
Practical Tips for Bootstrapping Information Extraction Pipelines
honnibal
PRO
21
1.4k
個人開発の失敗を避けるイケてる考え方 / tips for indie hackers
panda_program
110
19k
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