类比MySQL，学习Tableau

深藏阁楼爱情的钟 2023-07-13 12:18 14阅读 0赞

↑ 关注 + 星标 ~ 有趣的不像个技术号

每晚九点，我们准时相约  ![format_png][]

![format_png 1][]

大家好，我是黄同学![format_png 2][]

今天带大家通过类比MySQL，来学习Tableau。

**tableau连接mysql**

主机：localhost，端口口：3306，用户名：root，密码：123456。

![format_png 3][]

## 1）连接MySQL ##

连接MySQL一般很简单，只需要填写主机、端口号、用户名、密码就可以。

对于连接其它不同的数据系统，有可能需要另外安装驱动包，等有需求的时候，就自行百度即可。

## 2）选择数据库、数据表 ##

![format_png 4][]

## 3）不同数据源进行表连接 ##

一个来自mysql表，一个来自excel表

将mysql中的dept表，和excel的emp表进行表连接。

连接方式有：内连接、左连接、右连接。

① 导入mysql中的dept表

![format_png 5][]

② 在原来基础之上：将emp.xls表添加进来。

![format_png 6][]

③ 选择是使用“内连接”，“左连接”，还是“右连接”

![format_png 7][]

**tableau常用组件的学习**

## 1）基本筛选器(类似mysql中的where) ##

① 基本筛选器——维度筛选器

![format_png 8][]

注意：将维度指标，拖动到右侧的“筛选器”窗口中，就叫做“维度筛选器”。

② 基本筛选器——度量筛选器

Ⅰ 依次点击1→2→3步骤

![format_png 9][]

Ⅱ 当出现如下界面后，依次点击1→2步骤

![format_png 10][]

Ⅲ 当出现如下界面后，双击红色方框中这个按钮

![format_png 11][]

Ⅳ 当出现如下界面后，可以选择平均值的范围大小

![format_png 12][]

③ 基本筛选器——日期筛选器(实际就是维度筛选器)

![format_png 13][]

Ⅰ 直接将这个日期字段拖动到“筛选器”中，再点击季度这个字段

![format_png 14][]

Ⅱ 当出现如下界面，勾选我们想要的第2、3季度，点击确定即可

![format_png 15][]

Ⅲ 最终效果如下

![format_png 16][]

## 2）上下文筛选器(类似于mysql中的and) ##

案例：选择家具类产品并且销售额大于100000元的商品

① 先列出不同产品名称下，不同类别的销售额

![format_png 17][]

② 先筛选出所有“家具类”产品，依次点击1→ 2→3

![format_png 18][]

③ 再将“销售额”拖动到“筛选器”中，在选择“总和”，再点击“下一步”

![format_png 19][]

④ 当出现如下这个界面，选择“至少”，在填写100000，最后点击“确定”

![format_png 20][]

⑤ 最终效果如下

![format_png 21][]

## 3）条件筛选器 ##

案例：只显示家具类，只含“书架”、“桌子”子类并且销售总额大于1000000元并且利润大于300000元的子类。

① 先给出不同类别、不同子类别下的利润和销售额

![format_png 22][]

② 选择类别是“家具”类的产品：

![format_png 23][]

③ 选择子类别是“书架”、“桌子”类的产品：

![format_png 24][]

④ 当出现如下界面时，对“条件筛选器”使用公式，筛选出销售总额大于1000000元并且利润大于300000元的子类。

![format_png 25][]

## 4）tableau顶部筛选器(类似于mysql中的limit) ##

案例：显示家具类产品中，销售额最好的前3个子类别

① 先列出不同类别、不同子类别下的销售额情况

![format_png 26][]

② 选择家具类别的产品

![format_png 27][]

③ 使用顶部筛选器：顶部代表展示最大的几条记录；底部代表展示最小的几条记录

注意：这个并不表示排序，排序在下面会讲到。

![format_png 28][]

④ 上述操作的结果有一个缺陷：应该是3条结果，但是只展示了2条结果。

![format_png 29][]

⑤ 点击常规，并完成如下操作

![format_png 30][]

⑥ 最终效果如下

![format_png 31][]

## 5）tableau通配符筛选器(类似于mysql中的like) ##

案例：以“罗枝”打头的产品并且销售额大于5000的产品名称

① 展示不同产品名称的销售额

![format_png 32][]

② 使用“通配符”筛选器，找出以“罗技”打头的产品。

![format_png 33][]

③ 再筛选销售额大于5000的产品

![format_png 34][]

④ 最终效果如下

![format_png 35][]

## 6）tableau中的排序问题(类似于mysql中的order by) ##

案例：可以按照字段排序，也可以手动排序

① 完成如下操作

![format_png 36][]

② 选择“手动排序”

![format_png 37][]

③ 当出现如下界面，将家具移动到首行位置

![format_png 38][]

注意：对于按照不同字段排序，这里就不讲述了，自行下去尝试。很简单。

## 7）字段的合并、拆分与分层 ##

① 合并字段

案例：将国家、地区和城市三个字段，合并到一起

Ⅰ 按住ctrl键，选中国家、地区和城市，依次点击创建→合并字段

![format_png 39][]

Ⅱ 当出现如下界面的时候，点击“编辑合并字段”当出现绿色方框的时候，修改名称为“地址”，调整字段的顺序，为国家、地区、城市。

![format_png 40][]

Ⅲ 最终效果如下

![format_png 41][]

② 拆分字段(自动拆分与自定义拆分)

Ⅰ 自动按照同一个分隔符，进行拆分

![format_png 42][]

Ⅱ 自定义拆分

![format_png 43][]

Ⅲ 当出现如下界面时，填入分隔符，保留2列

![format_png 44][]

Ⅳ 最终效果如下

![format_png 45][]

③ 分层(下钻)

Ⅰ分别完成如下的1，2，3步操作

![format_png 46][]

Ⅱ 当出现如下界面，给分层取一个名称。

![format_png 47][]

Ⅲ 完成1，2，3步操作，完成“下钻”。

![format_png 48][]

Ⅳ 最终效果如下

![format_png 49][]

注意：“年月日”的下钻，这个字段自动就会分层，自己下去试试。

## 8）分组：数据源分组、文件夹分组 ##

这里讲述的分组，不同于MySQL中的分组。分组分为“数据源分组(不同的数据源)”，“文件夹分组(同一个数据源)”。以文件夹分组来说，这里的分组指的是把相似的字段放到同一个文件夹下面，当字段很多的时候，拖动起来不方便，创建了文件夹以后，方便我们管理和使用每个字段。

① 文件夹分组为例说明

Ⅰ 选择“按文件夹分组”

![format_png 50][]

Ⅱ 选择“创建文件夹”

![format_png 51][]

Ⅲ 给文件夹命名

![format_png 52][]

Ⅳ 将“订单名称”、“订单ID”拖动到文件夹中，最终效果如下

![format_png 53][]

## 9）计算字段(很重要) ##

计算字段，指的就是为某些字段做数据运算、逻辑运算等操作。

① 案例说明：利润＜100，返回低利润；利润>100，返回高利润。

![format_png 54][]

② 点击“创建字段”

![format_png 55][]

③ 完成1，2，3步骤

![format_png 56][]

④ 然后可以看到，字段栏多了一个“利润评价”字段

![format_png 57][]

⑤ 最终可以去查看一下“数据源”，最终效果如下

![format_png 58][]

## 10）参数的使用 ##

针对上面“计算字段”中的案例，如果利润＜100，返回低利润；利润>100，返回高利润。很显然上述分类不符合规范，你卖一个铅笔，大于100肯定是高利润。但是你卖一个飞机，你就要动态调节这个利润平衡点了。这就是下面要讲述的参数。

① 创建参数

![format_png 59][]

② 完成如下的1，2，3，4步骤

![format_png 60][]

③ 然后可以看到，字段栏左下角多了一个“利润平衡点”字段

![format_png 61][]

④ 右击鼠标，选择显示控件参数

![format_png 62][]

⑤ 重新编辑之前的“利润评价”计算字段

![format_png 63][]

⑥ 当我们修改这里，源数据也会跟着变化。

![format_png 64][]

⑦ 当我们选择500以后，看看效果

![format_png 65][]

注意：以前的172.76是高利润。当换成500以后，这里就变成了低利润。

## 11）集合的使用 ##

用一个案例讲述：有哪些客户在2016年，2017年都购买过我的产品。

① 先展示出所有客户，在不同年份的购买订单数据

![format_png 66][]

② 只选择2016年购买过的客户：将“年(订单日期)”拖动到筛选器中，进行选择过滤

![format_png 67][]

③ 当出现如下界面，勾选2016年

![format_png 68][]

④ 完成如下步骤

![format_png 69][]

⑤ 完成如下步骤

![format_png 70][]

⑥ 重复上述步骤，筛选207年购买过的客户。(这里不说明了)，最终效果如下

![format_png 71][]

⑦ 最关键的一步：完成如下步骤

![format_png 72][]

⑧ 将创建好的集合，拖动到筛选字段中，就大功告成了

![format_png 73][]

如果大家觉得文章对你有帮助，欢迎扫描下方二维码关注黄同学的CSDN博客

![format_png 74][]

![format_png 75][]

**后台回复关键词「****进群****」，即刻加入读者交流群~**

![format_png 76][]

**五**

只能建议收藏~

![format_png 77][]

朱小五

[format_png]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9VUzEwR2NkMHRRRUJOaG4xdUhWYlZMOTYwNFN5U0NoQ1hNemxGNmljb1JMNXd4dnFUTXhwWElvNURLaWFyMTFIamlhU2Z3QjhJZDBrUFl5SmxUZmNzSDNnUS82NDA?x-oss-process=image/format,png
[format_png 1]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X2pwZy9ZblYxaWNma2NOOFlBUGhSU2FsaWI5UnZBZHhISmVDVE16Z1pMMDJyaWJWQ0RCYUhmRlNRalE3S3ZVQkM3Sk5VcmppY0RoSmlhaWFhSk9sWTNENlZpY3FJN3FJU0EvNjQw?x-oss-process=image/format,png
[format_png 2]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9yZXMud3gucXEuY29tL21wcmVzL2h0bWxlZGl0aW9uL2ltYWdlcy9pY29uL2NvbW1vbi9lbW90aW9uX3BhbmVsL3NtaWxleS9zbWlsZXlfNC5wbmc?x-oss-process=image/format,png
[format_png 3]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjOERUUElUZ1Q5ODF3bkJJamx1b3NuUTdEWVE5OTQ5cnZBeDJCTWRhcmdCRXNoN3ZUQWxaZFJRLzY0MA?x-oss-process=image/format,png
[format_png 4]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjWmdCWDJkMFowaWFXOWhNRlV0MkNXUFhSSGlhNHRJYndrcGFORk1JRDF5NkVibkJmU0JUbXB1eVEvNjQw?x-oss-process=image/format,png
[format_png 5]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjZzUzRGVnYWZ2M0dJMmUxdXdNS2NpYXFvclM5dW1KVjB2Tkc0c2ljQkRUV1Z3OVBWT1RnOW5YZWcvNjQw?x-oss-process=image/format,png
[format_png 6]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjNUN1bWFEc3NoMVNzYzBGUWdVRm8waWFpYmZZUHRYWVdUdklueUZJZGxqYkR1QXY5S2ZoZFJrV3cvNjQw?x-oss-process=image/format,png
[format_png 7]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjbG9hMWVJcmNmaWJPR2lhRVk2MTJxd1hiY3VDUWliOHEzd0tpY0FDZFp1WGJ2bXFsSzBkclZYb0pIdy82NDA?x-oss-process=image/format,png
[format_png 8]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjWjJrQ2w4eFdidmRrVzNwZWliYWV6M0FaSUhRaE41bk52d2w3S0N5V1lZSklSY3RaVk1KdzB1Zy82NDA?x-oss-process=image/format,png
[format_png 9]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjYnMzN3g0ZGljdFdTSGNpY0ZodlpKOFdKV1VubWlidFlMUEVoeWJVdERXcUhQajBkRXYxRFB5MXlRLzY0MA?x-oss-process=image/format,png
[format_png 10]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjcWJYblFUQ2NNNGNsd0lMaWJRWWVrbnRpYUFhTkFGa1BPakNzT0hEQzJtRGljaWE1VlBBRnBGckFZdy82NDA?x-oss-process=image/format,png
[format_png 11]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjZ2pCQnNzbnZIbGFtbUJDNHlFVXoxTG9aakRFaWFSRE5qZWNPaWFmVXVqeVRQamliYzdCU1I4WVh3LzY0MA?x-oss-process=image/format,png
[format_png 12]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjWXdhTlFlZ0k2ZWdPNks5d25lT2ljdnZFaWJJV3Z6bjRSNVVNMTlXazRYNmFnSXJGSGxIb1JpYnNRLzY0MA?x-oss-process=image/format,png
[format_png 13]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjaFROUjczc1VhZFNoTVlDblFNZ0s5bDlpY3NpYWFlU0xXSzM1TjNIb0tzdjg4QW1PU0dvMFp6UmcvNjQw?x-oss-process=image/format,png
[format_png 14]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjcm9GWlJIVDV1bFpTbzFiTkgwbFk0bDJKRFhUbUlpYXY0WUE4cnM2U3hQVDBmanJ0cHpzckZPQS82NDA?x-oss-process=image/format,png
[format_png 15]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjbk00UnVwZjBOaWFCWTloUmhtaWFxREFkTjYyZ2EyaWJMaGlhRnhOVm1sTFgyUHFKOXRCdjM0elNmdy82NDA?x-oss-process=image/format,png
[format_png 16]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjQTVNT3BqQXVmcEt5ZlprTmJvaWI5RXhKMW9lbGlienZ5UHNvUWswUm1iMlNTZFZRaWN4YWtqVklBLzY0MA?x-oss-process=image/format,png
[format_png 17]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjS2licEVja2lhaGlhamdmT1pmaWIycGVReFdLTHhMM1ZMeWpYdXZHU2VRWm1Jc1dWaWJBdEh5NFlqZGcvNjQw?x-oss-process=image/format,png
[format_png 18]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjRTEySVRNOWlhN3JZTU9pYWRDankzTzlQenVSVlZBZU14Z3hISG51QVZCQno0WU84aWFtVXNWU1J3LzY0MA?x-oss-process=image/format,png
[format_png 19]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjRTBnOG1rZUM0NWliZ0tGM2lhcGFWUDJ0NTc3cHJSZ0JwZ2M2cEdCM25uVHRCV2libFNxSDNZeDVRLzY0MA?x-oss-process=image/format,png
[format_png 20]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjUElqZnpXZHlTUlY3cndRTmJ2Q0xteGljOUpiNEl4MlhhMGlhNTVCU1dEYmtwU2w1YXVlZWIwdUEvNjQw?x-oss-process=image/format,png
[format_png 21]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjRWFPSXZ5UTV0MUo0WVRpY09ZS0dmTDlpY0NTM29hTEFyNjJ5VjN5dTRac0tWWlduM0FYM0hIaWFBLzY0MA?x-oss-process=image/format,png
[format_png 22]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjaWNaWXV1ZGVMaWFVanFVdEpERVRQd3I1S3Fldjg1dDhKR3lSbW5iWkJHTGlicTVqbmVsZkROc3l3LzY0MA?x-oss-process=image/format,png
[format_png 23]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjaWNFVm95Z3BKMlhPRUFyWkI3STNacG9CQ1dzd3lyZTFSTnlzNEg2RjVWZmVFVlNZc3VldWE1dy82NDA?x-oss-process=image/format,png
[format_png 24]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjNHJVSzNpY1o4MWozMU1UYThvWElXNmlhV1E5UFFjWEtaVnRaR0RDUFFEOU9KU09NdU0zeGlhSHRRLzY0MA?x-oss-process=image/format,png
[format_png 25]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjSmFMRzBIWjRrbzJXV1FjZFdyZ1lCTGJCUHp6eUVYc2dhbDNFalFCWDZFT3lrYjJubzRPSmF3LzY0MA?x-oss-process=image/format,png
[format_png 26]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjcWJhc3hpYlY2U1lka2tjWFZFTThFNWliTFhHaWFvMmVFNXV0enpZRURXVkkwejJla2JSNmVJRWtBLzY0MA?x-oss-process=image/format,png
[format_png 27]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjenZpYmN0YWJiWG1pYnl3WmtXcEs5dE1QOVVsS2p0T3ZSd2liWjBCaWM1TG1mTGw1SHI4dVRHSmxhQS82NDA?x-oss-process=image/format,png
[format_png 28]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjWldiQ0RLZmYwWU1BbnVwRGJkaE9KQU1tYkswaDN3aWIwaWI1ZzB3Q2JoeENxMzNpYmljSzRrYzZpYmcvNjQw?x-oss-process=image/format,png
[format_png 29]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjakpBeUc1Q0dZQWhud3QycTVUQUlsUXdqUFpVRzBGVm1hNmlhRHlETHhGM1c0QklqSVNZYWliZEEvNjQw?x-oss-process=image/format,png
[format_png 30]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjTWo1dnBzdFZlaWFIOTdZU21Nb0lDQ24yZUpZSzhyelp5a2ljNkZKMXhoZ2NYSjI1RnNyWEpzc3cvNjQw?x-oss-process=image/format,png
[format_png 31]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjT2VLdnRtU3dHUHRYUkxleWpJZG5XYmRCcmliT3N4QTk1dWdocG5FM1RtTGljTUtXUW95aHFBekEvNjQw?x-oss-process=image/format,png
[format_png 32]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjMkRxYWN3Unh6Q0RySWdtbks5WThKQWNmZEdPa3JxNGVpYzFVeGVtbVVvMjhOTEQ0Vk9JUjBpY1EvNjQw?x-oss-process=image/format,png
[format_png 33]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjR2FNakx1UlN0dUdaOVlSak9wUks0YWljTWliR2E2WVlzV0o0WnhwekFYUkRpYWJBZUd1aWJqRXVnZy82NDA?x-oss-process=image/format,png
[format_png 34]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjYlpOOE5yOUNkbkZya290NVJrbHFibGRYTWliREhMZTUycW9ZVHg4WnJyZTdKQ3E3d1ZnbGljaGcvNjQw?x-oss-process=image/format,png
[format_png 35]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjMElCNzFGOXYyRGNLY2tlaGs3amJ1clBNUjRxZThjeXhIRGtRTTk2aWFJU1R1RVBkZ3AyMlBoQS82NDA?x-oss-process=image/format,png
[format_png 36]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjQlRWOVZkODNjWWtlUTdHaDloSEVpYzVpYjB4aWNSN25yMUp6SVg1REVGeEFwYWZpY0Y3UFBVdHJxQS82NDA?x-oss-process=image/format,png
[format_png 37]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjQjlqQmljSUJaejQ3SXlaSmliaWFESXU1bWhQRnA3QTlxYjF2MkFzRXJERjVHZGlidUNKWGRYNVlkZy82NDA?x-oss-process=image/format,png
[format_png 38]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjTG9pYnNkNWNEYm1vbkVpYnRJekZ4OWpTaHdvRWdpYjdIc0c5VjBkYmdTOWliMmtXNkR0OUtuRlN3QS82NDA?x-oss-process=image/format,png
[format_png 39]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjTThKUjJzZ3NKZFVYMHRnaWMzSXkyQWFVSDdZREhLWFM0Q0ZDeU9VMkpmMWljMDhzY2hTaHFmNEEvNjQw?x-oss-process=image/format,png
[format_png 40]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjelNZcjIxc2libklCOXA5RVd4SkpBTjVXaklkaWFpY01lbUg1aEVKVEFYTWJCWlFTU3FIUll3cVZ3LzY0MA?x-oss-process=image/format,png
[format_png 41]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjcFBFS2JZdWdlc2dwR1lzTFp1WkxPSjU3eWljUExxTUNDTUxkam9xZE9ieVVjNTE4Y1RpYng4SVEvNjQw?x-oss-process=image/format,png
[format_png 42]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjampBMGljbzJmclZJWVlKUG9EUzNkTjZPQ2FXSVE4SjFBWjhiMHppYklYTXJ6bmp0SnU2MEVkRGcvNjQw?x-oss-process=image/format,png
[format_png 43]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjalBLTXpqZnNzSDRGc3hlcDNMRDZlY0lBZ3ZlUWljN0U5OXpqdFJjdWc5VGFIemlhSno0emljT2F3LzY0MA?x-oss-process=image/format,png
[format_png 44]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjRUN4TUhIdWljV0xpYkJWSHZtOEQzejMwcTdERUgyWmNwV0FDR0NpYWljcUtjMnA2QlViN3ZaQUZpYXcvNjQw?x-oss-process=image/format,png
[format_png 45]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjdG9mb0pFdWFyQms4ejZmSkJscFJRODE2OVNpYnpwbFFENzhDR2toOGJKR2M4eDRQZngySlZ3QS82NDA?x-oss-process=image/format,png
[format_png 46]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjQ0xZQkpnT1l3cWlhaGlidTdnWEcyMFVtZ1BpYzU2V0dLRXoyOTJhMU0zU0RmNGlhYkdsYmJPb05tQS82NDA?x-oss-process=image/format,png
[format_png 47]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjVjh1SE82Q0M2WTVyZGJ0QjhpYUQzZzBLenFpYXpCdnZEbW9YV2FlVmVPdVVpYjZIVDZ0V1Z3aWFuZy82NDA?x-oss-process=image/format,png
[format_png 48]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjNE9NTTVRMEVtbFdOOHBHbmlibzBrekltREk0MFdPZUdzbUJJWnEwRlZVOWdSSWljcDNtczVJZFEvNjQw?x-oss-process=image/format,png
[format_png 49]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjRHNicTl6aWJsQTBka3p4MlVtdkV6QXdyYXZyNnMzQnFSeWM3WEp4NVkwTXhUaWFLU3U2VTRVWEEvNjQw?x-oss-process=image/format,png
[format_png 50]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjc0JsWDlRSzh5ZmliaWNQUUNMMU9sMTN5bkpURElsSHJsOGZwbnBUdGljdGliankyTlQxazcxdTNsZy82NDA?x-oss-process=image/format,png
[format_png 51]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjOWtoeFJ6RUFpY0hRdjkydkI2Mlg0UzV1QU5RbXhjemlhYldzVWIwd2pqZmY1R2lic3ZQcmdNNU1RLzY0MA?x-oss-process=image/format,png
[format_png 52]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjYWZTUEhNVnZxVHBldkF4Z1BpY0xRS0tlUGJPcGlhT00xSExxNjJyRGljMGVCMWszZ2RaMW1GOVF3LzY0MA?x-oss-process=image/format,png
[format_png 53]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjMWwzQmVIazV6enRkVUtFNzdXY2x4NTlrOW9xdlF0bUM0N2t2TDZBTVlDOXlGbmYzUnZEdUJBLzY0MA?x-oss-process=image/format,png
[format_png 54]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjWld5UldJaGliUzg1WldFakk0MEt0aWJVRVFCbklEZU1BZGhjNFZpY055VFpmMUZmTHVlNmg0NEd3LzY0MA?x-oss-process=image/format,png
[format_png 55]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjUFZnUW5OU0RCSnBkUkRsVWZZYVo5NFlIRlAwY01UbEVscFdRMkhWS1B4dnZQbEc3aWJOQ2RSZy82NDA?x-oss-process=image/format,png
[format_png 56]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjeUY1TG5oSGtYTjY4T1YxdUQ1NmVKdlc1OTJNblM2UlBvVUlGUVJWbGVnUVVkZFE5MG1ac0xRLzY0MA?x-oss-process=image/format,png
[format_png 57]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjVkp4YXdZOFFTbThINUtDY1p1WnprRDg3NVpyZHJpY2F6OThHR1VpY0RRR1h6Y3RhS3Z1R0JBNVEvNjQw?x-oss-process=image/format,png
[format_png 58]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjMnNrY0NpYTZ5S0s4d0NkUzJJaWFBdWZqaWJpY0NXcWs0WlYzM0ZtTzJheEJRZ0ZKTUZQcTVoSXB1US82NDA?x-oss-process=image/format,png
[format_png 59]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjb1c2cDRpYnFtdWcyaWM2UXdNSEZjM2V0TG1KU29ob2lha0Fqa3FidzF3TUhpYjl3azd3U1ozbUJNQS82NDA?x-oss-process=image/format,png
[format_png 60]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjbUpOcUNoY3RhdXpUanEwSkUxSUVkMUlIaDFyZ2QxdElFZTV6cFBNYTBLSnNERWRsSlhQSTFnLzY0MA?x-oss-process=image/format,png
[format_png 61]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjTWJiSXBpY2RHbm5KZkhCcUZRTXR5QTFIUkg0UnVPQnVFOWx1UWliT2tHNUZidmIyQ0JiOXJBa2cvNjQw?x-oss-process=image/format,png
[format_png 62]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjYzNpY3J5cDdyVXhtUmRLajJrVk1QTzJiRjJXQmtpYVdtMENsb0Q4czRrSld0aWNZdlQzZzJOZ1dBLzY0MA?x-oss-process=image/format,png
[format_png 63]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjNU9jTGdhMFdFMEtmM0NxaWJ2TEJvSmhEM0xWbVBzenhlZm9YYkdONFFhd092MlB5bUFkbkhYZy82NDA?x-oss-process=image/format,png
[format_png 64]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjaGZsaWFKaWFWU0FMTjJFZmljQWlhazRPektqT0J3SWtOWjhpY1I1MlRrYzNnVGlhdGhnYzJrTzBpYnp5QS82NDA?x-oss-process=image/format,png
[format_png 65]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjeERUZFhLSlRrUHhNeGliUVpUaWE3OW9xRnN4azBxTHQwaWFsTkRiMTFkbFNmNXZ1d2ljbVg3V0xjdy82NDA?x-oss-process=image/format,png
[format_png 66]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjUW92VmsyeUJwaWFCY2IxdzJla3JBWXdHZXdMUWNQcTZmaWIzWXNsTzVNYU5LVzVjaWNSTFJuWHB3LzY0MA?x-oss-process=image/format,png
[format_png 67]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjaWNpYmtYWnB5NWUyNFBGOFFBWVhHRzJlc05jN1lzZkE5NEJPc0E2TGg3T1o4cUZxa3c2QkRQNmcvNjQw?x-oss-process=image/format,png
[format_png 68]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjRnE3bkc3aWJvQnhSeWI4azBCaG50TEpoYnJuMlNTc0dLZ0lQYmliaWNBUGtTcllGRlZJdVdjbWlhZy82NDA?x-oss-process=image/format,png
[format_png 69]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjNjNmUWZ5R2s4bXRndEVwVjF0Uk1MWjhpYzlOMGlhcU5yakhCWU1TYVhaS2VYOVkzWkxobmxnc2cvNjQw?x-oss-process=image/format,png
[format_png 70]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjUFp4NWtNbEpsOTlMcHVGMWZic2JpYWlha0ZsemNKUkRCdXcxUWlhcmFlSXVldEFBaWN3VWxRWlNPdy82NDA?x-oss-process=image/format,png
[format_png 71]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjUHcxaWN2QjdGQ21ZSzJvZHJZaWN6akZpY3BySTFmNGY4TDhub0RpYU5vM3c2Tm40bzdkWDNnY2liRFEvNjQw?x-oss-process=image/format,png
[format_png 72]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjUUVheGVJN2RxYjZVODAzeWd4bVNnWVN5bDdBeHl6RzRsMFhrZUt5bVZPYzVWeHBYemFEUzV3LzY0MA?x-oss-process=image/format,png
[format_png 73]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGhhYWljeDdtRVZET2VRQ0pFRnVyeGdjRVByUzhHd1RJNm9NZUNxWHNQTjJlekNCdm1aUGNuOXdZNExkS0ZPaWJNZWQ0a1JqaWFGajhpYTBRLzY0MA?x-oss-process=image/format,png
[format_png 74]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGpJQXptTTBpYVdLQUNlYXFjZmtFOUx2UllTTnVmQm02eXlDNW9pYXZoaWNsUGxtMUVpY3VpYWFtUlFJVURYcjBxa25ZTndlbXR0TUN2MHpQQS82NDA?x-oss-process=image/format,png
[format_png 75]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9iOTZDaWJDdDcwaWFiaWFuSUhpYzFoQkFBcDg0aHBNQ2R6NVZpYWFqR3Q2QzJsWGFBWDNpYTExbXR5bnVlQndDckMyRHd1M0FGRmRJd1J3bjM0czJSTUdTMmtWQS82NDA?x-oss-process=image/format,png
[format_png 76]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X2dpZi90WFlpY3Q0MHhmTGdpYWZHRm1XdFZWSEZWSzdpYlJ0eUVKT1hNczV2VjJBdVZIOFhVOTJKSlA0Y3dxbHRVSzBTTndDS01hZkNsMm9ZV3B4NjN1RXkyWDE5dy82NDA?x-oss-process=image/format,png
[format_png 77]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy90WFlpY3Q0MHhmTGpPSDhIaFM5TEU4cFVpY3hZSHBDbkt0VWJoZER6TnFaak95UGtvYkxpY1h3eHlTbFREdmtBdEc4YjJHbnNzdERWSGx4amV1dTl3N0FrZy82NDA?x-oss-process=image/format,png