August 2022
Beginner to intermediate
463 pages
9h 22m
Chinese
Content preview from Tableau Prep即学即用
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.
67
第
8
章
处理日期问题
如果是在寻找约会（
date
，既是约会的意思，也有日期的含义）的建议，不好意思，
这一章不适合你。而对于那些正在与数据集中的日期作斗争的人来说，这正是为你
准备的。在这一章中，我们将探讨为什么日期在数据世界中很重要、如何分解日期、
可能会遇到什么不同类型的日期数据需要准备，以及如何使用
Prep Builder
中的日
期函数来清理日期数据，使它们为数据分析做好准备。
8.1
为什么日期很重要？
一个基本的日期字段可以告诉我们这些信息：
•
星期六的销售额如何？
•
这个学期有多少学生加入了这个项目？
•
我的团队这个月要打多少场比赛？
我们可以通过计算数据的行数并按日期的不同部分进行细分来回答所有这些问题。
8.2
日期的各个部分
当我们大多数人想到日期时，我们想到的是日、月、年。我们身处大西洋的哪一边
通常决定了是先列出月还是日。由于我是英国人，这一章（和本书）的其余部分将
毫不避讳地把日放在月的前面。
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.