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.
｜
75
处理字符串数据
图
9
-
1
：Tableau 中的字符串字段用 Abc 图标表示
9.2
字符串数据有何不同
我们清理字符串字段的方法与清理数字字段的方法截然不同。本节将介绍它们的一
些独特属性。
9.2.1
字符顺序
当我们分析字符串数据字段时，字符的顺序是非常重要的，我们需要关注哪个字符
在字符串中占据哪个位置。图
9-2
展示了一个字符串“
Preppin' Data
”的例子。
图
9
-
2
：显示位置值的字符串
从左边数起，你可以看到这个字符串中的第一个字母是大写的
P
，让我们看看这个
字符串的其他方面：
•
最后一个字母在左起第
13
位，是小写的
a
。
76
｜
第
9
章
•
撇号（单引号）“
'
”在字符串中占据了自己的位置。
•
两个单词之间的空格在字符串中也占有一定的位置。
9.2.2
字符串格式化注意事项
在处理字符串数据时，还需要考虑一些独特的格式化相关问题。
名字问题
分割
有时，姓名在一列（字段）数据中，你需要将它们分成两列，即名和姓。这可
能是一个难题，因为名字的长度通常不同。有些人有两个、三个或四个名字，
因此很难指定一个姓
/
家族名称。
首字母
如果你的数据集中有一个完整的名字，你可能希望只使用首字母来代替。
大小写敏感问题
大写
/
小写
很多数据工具都是区分大小写的，也就是说“
THIS
”和“
this
”及“
This
”对这 ...
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.