July 2017
Intermediate to advanced
398 pages
11h 54m
Chinese
Content preview from Python数据处理
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.
处理
Excel
文件
｜
71
data = {}
for
i
in
xrange(14, sheet.nrows):
# 从第14行开始，因为这是国家数据的起点。
➋
row = sheet.row_values(i)
country = row[1]
data[country] = {
'child_labor': {
'total': [row[4], row[5]],
'male': [row[6], row[7]],
'female': [row[8], row[9]],
},
'child_marriage': {
'married_by_15': [row[10], row[11]],
'married_by_18': [row[12], row[13]],
}
}
if
country == 'Zimbabwe':
break
import
pprint
pprint.pprint(data)
➌
➊
多行注释，大致说明脚本的用途。
➋
单行注释，说明我们为什么从第
14
行开始，而不是从前面开始。
➌
从简单的数据解析过渡到数据分析工作时，我们可以也应该删除这两行。
现在我们的输出应该和上一章的数据差不多。在下一章里，我们进一步将相同的数据从
PDF
文件中解析出来。
4.4
小结
Excel
格式是介于机器可读与人工可读之间的奇怪格式，在一定程度上是机器可读的。
Excel
文件本来不是用程序来读取的，但可以被程序解析。
为了处理这种非标准格式，我们需要安装外部库。寻找外部库有两种方法 ...
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.