September 2013
Intermediate to advanced
264 pages
5h
Chinese
Content preview from Bad Data 技術手冊
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
38
|
第三章：資料是要給人類使用，而非給機器使用
這個資料顯示有兩個在女校的男學生參加 NCEA—關於這點並沒有簡單的解釋。並且，
這個結果自然的會導致下一個問題，例如為什麼會有男學生在女校就讀？
好消息是我們能夠調查這個問題，因為取得紐西蘭每個學校統計結果的電子試算表是可
行的，如圖 3-5 所示 Kappa College 的統計結果。這代表我們能夠藉由查看個別學校的
電子試算表，然後確認在 13 年級擁有 1 個或 2 個男學生的學校來回答這個問題。
壞消息是在紐西蘭有超過 490 間學校，而每個學校的電子試算表中並沒有告訴我們該所
學校是男女合校、男校或是女校。為了要找出哪些學校造成這個奇怪的結果，我們必須
要查看超過 490 張電子試算表！
其中一個現在面臨到的問題，就是我們要使用的資料集合是散佈在大數量的不同檔案
中。而且我們還有個問題，就是在每個檔案中，資料的版面設計是沒什麼幫助的。
已經有夠多的問題了！是時候來看看解決方案了。
答案：撰寫程式
簡短版本的答案其實就是：撰寫程式。
我們想要確認每個紐西蘭的學校，來看我們是否能夠發現這些非常少數的男學生就讀於
非常多女學生的學校。直接查看超過 490 張電子試算表並不是個選項。扣除過於沈悶的
理由，這樣做也很容易發生錯誤，特別是跟電腦的準確度相比時。
所以我們將要撰寫程式來回答問題，因為這樣將會更有效率—倘若我們必須要用眼睛查
看每張電子試算表，那麼電腦一定會比我們更快的完成任務。並且因為撰寫程式也會更
精確，電腦將不會犯一些愚蠢的錯誤，如不小心將男學生與女學生的數量搞混。 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.