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.
32
|
第三章：資料是要給人類使用，而非給機器使用
範例
3-1 2010
年不同年級以及
NCEA
層級的學生數量
Year 11 Year 12 Year 13
NCEA (Level 1) 41072 46629 40088
NCEA (Level 2) 1050 37513 38209
NCEA (Level 3) 91 451 24688
問題：給人類使用的資料格式
NCEA 結果的表格可以由 Excel 電子試算表的格式被取得，裡面包含多個過濾器以及分
析。
1
圖 3-1 呈現這個範例。在這個範例中，資料是從男校來的，裡面有每個年級與每個
NCEA 層級的組合，並且將男學生與女學生分開計算。
圖 3-1 2010 年男校完成 NCEA 的學生數量
這個資料是 Microsoft Office Excel 97-2003 工作表的格式，所以這個檔案需要藉由特定
的軟體來開啟，最好就是 Microsoft Excel。然而，因為 Microsoft Excel 以及 Excel 電子
試算表的普及，有許多其他的軟體工具都能夠開啟並且使用這類的檔案，所以我們不討
論這個特定的問題。
在此，我們希望提出的重點是在這張電子試算表中資料的
版面設計
。
1 The New Zealand Qualifications Authority
http://www.nzqa.govt.nz/qualications/ssq/statistics/providerselected-
report.do?reportID=1 ...
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.