Created
February 9, 2020 01:41
-
-
Save e96031413/eb8f5538769dafcba6b070a827529a43 to your computer and use it in GitHub Desktop.
大數據時代一定要會的資料蒐集術筆記
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
**1 - 爬蟲時若使用Chrome瀏覽器的XPath抓取套件,出現tbody要自行刪除** | |
**2 - Google試算表的ImportXML函數抓取資料** | |
=importxml(URL, XPath_query) | |
#URL為目標頁面 | |
#XPath_query為透過XPath套件抓取的路徑 | |
#以 &儲存格位置來代表數值變數,如&B1 | |
**2.1 - Google試算表的ImportFeed函數讀取RSS** | |
=IMPORTFEED(RSS_URL) #查詢所有資料 | |
=IMPORTFEED(RSS_URL,查詢,標題,數量) 所有參數 | |
=IMPORTFEED(RSS_URL,"items url",true) #true代表附上標題 | |
**3 - Google My Maps** | |
Google My Maps可以製作座標地圖,先在雲端硬碟將我們的經緯度資料製作成試算表檔案,再到My Maps裡面進行匯入,選擇經度與緯度、需要的標籤。就可以完成自定義的地圖 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment