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.
230
｜
第
25
章
图
25
-
11
：用逗号分隔的地址数据
如果你想解决这个问题，可以去参加
Peppin
’
Data 2019
年：第
46
周挑战
赛（
https://oreil.ly/y4Sx_
），可以利用拆分来解决问题。解决方法可以在
Preppin
’
Data
网站上找到，供你检查自己的流程，不过正确答案往往不止一个，
我们主要关心的是是否在给出的输出中实现了数据集，而不是如何实现。
25.3.2
没有明确的定界符
如果没有明确的逻辑分隔符来分割，那么拆分技术肯定是不合适的。在这种情况
下，像
FIND()
或
FINDNTH()
这样更高级的字符串函数可能是一个好办法。这些函
数允许通过字符串的位置找出字符串中是否存在一个字符或子串。然后，可以将这
些函数与
LEFT()
、
RIGHT()
或
MID()
配合使用，以拆分出所需的部分字段。这些函
数在第
9
章有更详细的介绍。在这种情况下，另一种选择是使用正则表达式（或
regexes
），这将在第
31
章中介绍。
25.4
小结
最后要说的是，
SPLIT()
是第一个通过拆分数据列以帮助分析的很好的函数。
Table
Prep
有几个很好的选项，但可能并不总是提供正确的解决方案，在这种情况下，你
需要自己建立逻辑。幸运的是，
SPLIT()
生成了计算逻辑，并在
Changes
（更改）窗
格中提供了计算结果以供编辑，所以很容易做出所需要的调整。
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.