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
680
迎戰壞資料 @ dbootcamp Taipei
by tkirby, openrefine & spreadsheet essential
tkirby
August 21, 2015
Tweet
Share
More Decks by tkirby
See All by tkirby
前端網頁資料視覺化設計
tkirby
1
380
Theory of Graphical Perception
tkirby
0
360
Open Refine Course
tkirby
0
170
Language Reference
tkirby
0
85
新聞記者的程式設計第一課
tkirby
0
440
Visualization over Web
tkirby
0
94
Rasterize D3.js
tkirby
7
1.5k
SVG + D3.JS Course Slide
tkirby
0
180
資料新聞學手冊導讀
tkirby
0
200
Other Decks in Education
See All in Education
phygital__le_magasin_augmenté.pdf
martine
0
2.6k
インターアクトクラブについて:国際ロータリー第2720地区インターアクト委員会 委員長・大分東ロータリークラブ 阿部 克哉 氏
2720japanoke
0
660
論文の読み方 / How to survey
kaityo256
PRO
175
120k
Best Wedding day perfume
vicjon
0
260
Data Management and Analytics Specialisation
signer
PRO
0
980
アプリ開発を目指した授業づくりについて
asial_corp
0
420
Pen-based Interaction - Lecture 4 - Next Generation User Interfaces (4018166FNR)
signer
PRO
0
1.2k
スクフェスの学びにチームを惹き込め! 社内同時視聴会のすゝめ!
pokotyamu
0
670
保育とふりかえりをコネクト! / connect childcare and retrospectives!
psj59129
1
140
心房細動週間ポスター(2024年3月6日)
japanstrokeassociation
0
250
第33回 JAWS-UG札幌 クラウド女子会コラボ 勉強会
nagisa53
2
350
Поступление в ТОГУ 2024
pnuslide
0
33k
Featured
See All Featured
I Don’t Have Time: Getting Over the Fear to Launch Your Podcast
jcasabona
20
1.6k
Thoughts on Productivity
jonyablonski
57
3.8k
[RailsConf 2023] Rails as a piece of cake
palkan
21
3.9k
BBQ
matthewcrist
79
8.7k
CSS Pre-Processors: Stylus, Less & Sass
bermonpainter
352
28k
Navigating Team Friction
lara
177
13k
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
rmw
24
2.3k
Dealing with People You Can't Stand - Big Design 2015
cassininazir
355
22k
Agile that works and the tools we love
rasmusluckow
323
20k
Rebuilding a faster, lazier Slack
samanthasiow
72
8.2k
Facilitating Awesome Meetings
lara
40
5.6k
10 Git Anti Patterns You Should be Aware of
lemiorhan
645
57k
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