今天就要用閱讀時間8分鐘的文章教你如何用Tableau Public製作一份台灣人口的互動式地圖!
有了Tableau,我們就能輕鬆做出這樣的效果,這是怎麼做到的!?
Step 1: 資料取得
我們先從政府的網頁下載台灣110年6月的各縣市人口資料。
![](https://richard-info.com/wp-content/uploads/2021/07/Screen-Shot-2021-07-11-at-5.08.21-PM-1-1024x640.png)
Step 2: 資料前處理
剛下載的原始資料應該長得像是這樣:
![](https://richard-info.com/wp-content/uploads/2021/07/Screen-Shot-2021-07-11-at-5.30.57-PM-1024x640.png)
不過因為資料量不大,我們就手動簡單整理一下,我們只需要兩欄,縣市、人數,會像這樣子:
![](https://richard-info.com/wp-content/uploads/2021/07/Screen-Shot-2021-07-11-at-5.32.53-PM-1024x640.png)
資料前處理就算完成囉!
Step 3: 資料讀取
首先我們先打開Tableau Public:
![](https://richard-info.com/wp-content/uploads/2021/07/Screen-Shot-2021-07-11-at-4.49.52-PM-1024x640.png)
由於我們的資料是Microsoft Excel 檔案,所以點選左上方的Microsoft Excel。
![](https://richard-info.com/wp-content/uploads/2021/07/Screen-Shot-2021-07-11-at-5.39.10-PM-1024x640.png)
因為我們的Excel 檔案裡面不只一個工作表,因此我們要選擇我們的工作表:「總計」。
![](https://richard-info.com/wp-content/uploads/2021/07/Screen-Shot-2021-07-11-at-5.40.45-PM-1024x640.png)
接下來要將縣市欄位的資料型態改為地理角色->州/省
![](https://richard-info.com/wp-content/uploads/2021/07/Screen-Shot-2021-07-11-at-5.42.25-PM-1024x640.png)
這樣我們的資料讀取就大功告成啦!
Step 4: 圖表製作
首先先按左下方的工作表1
![](https://richard-info.com/wp-content/uploads/2021/07/Screen-Shot-2021-07-11-at-5.44.35-PM-1024x640.png)
接下來我們要先拉出我們的世界地圖,將經度拖曳到欄,緯度拖曳到列。
![](https://richard-info.com/wp-content/uploads/2021/07/Screen-Shot-2021-07-11-at-5.46.11-PM-1024x640.png)
再來將縣市拖曳到這裡
![](https://richard-info.com/wp-content/uploads/2021/07/Screen-Shot-2021-07-11-at-5.47.08-PM-1024x640.png)
但我們會發現右下角有好多未知
![](https://richard-info.com/wp-content/uploads/2021/07/Screen-Shot-2021-07-11-at-5.48.21-PM-1024x640.png)
我們將未知點開,案編輯位置
![](https://richard-info.com/wp-content/uploads/2021/07/Screen-Shot-2021-07-11-at-5.49.21-PM-1024x640.png)
原來是國家選錯了,我們先將USA改為Taiwan
![](https://richard-info.com/wp-content/uploads/2021/07/Screen-Shot-2021-07-11-at-5.49.59-PM-1024x640.png)
接下來我們還是會發現總計、台灣省、福建省抓不到,不過沒有關係,台灣各縣市都抓到了,點選確定
![](https://richard-info.com/wp-content/uploads/2021/07/Screen-Shot-2021-07-11-at-5.51.51-PM-1024x640.png)
他果然跳到台灣地區了,看來我們離地圖製作不遠囉!
![](https://richard-info.com/wp-content/uploads/2021/07/Screen-Shot-2021-07-11-at-5.52.28-PM-1024x640.png)
我們將原本縣市的自動改為地圖
![](https://richard-info.com/wp-content/uploads/2021/07/Screen-Shot-2021-07-11-at-5.54.07-PM-1024x640.png)
再來把人數拉到也拉進標記
![](https://richard-info.com/wp-content/uploads/2021/07/Screen-Shot-2021-07-11-at-5.55.09-PM-1024x640.png)
你的第一個互動式台灣地圖就完成啦!
![](https://richard-info.com/wp-content/uploads/2021/07/Screen-Shot-2021-07-11-at-5.56.32-PM-1024x640.png)