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
540
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
検索/ディスプレイ/SNS
takenawa
0
14k
令和政経義塾第2期説明会
nxji
0
160
2025年度春学期 統計学 第6回 データの関係を知る(1)ー相関関係 (2025. 5. 15)
akiraasano
PRO
0
180
20250611_なんでもCopilot1年続いたぞ~
ponponmikankan
0
150
H5P-työkalut
matleenalaakso
4
39k
万博マニアックマップを支えるオープンデータとその裏側
barsaka2
0
760
仮説の取扱説明書/User_Guide_to_a_Hypothesis
florets1
4
340
人になにかを教えるときに考えていること(2025-05版 / VRC-LT #18)
sksat
4
1.1k
技術勉強会 〜 OAuth & OIDC 入門編 / 20250528 OAuth and OIDC
oidfj
5
1.7k
GitHubとAzureを使って開発者になろう
ymd65536
1
160
実務プログラム
takenawa
0
14k
生成AIとの上手な付き合い方【公開版】/ How to Get Along Well with Generative AI (Public Version)
handlename
0
600
Featured
See All Featured
Reflections from 52 weeks, 52 projects
jeffersonlam
351
21k
Done Done
chrislema
185
16k
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
marcduiker
31
2.2k
Six Lessons from altMBA
skipperchong
28
4k
Design and Strategy: How to Deal with People Who Don’t "Get" Design
morganepeng
131
19k
Documentation Writing (for coders)
carmenintech
73
5k
Principles of Awesome APIs and How to Build Them.
keavy
126
17k
実際に使うSQLの書き方 徹底解説 / pgcon21j-tutorial
soudai
PRO
183
54k
Optimizing for Happiness
mojombo
379
70k
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
smashingmag
251
21k
Site-Speed That Sticks
csswizardry
10
780
Put a Button on it: Removing Barriers to Going Fast.
kastner
60
4k
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