Hackpads are smart collaborative documents. Join Hackpad Now.
d|Bootcamp Taipei 共筆 - 資料在哪裡?
時間:2015/08/21 13:00 - 14:00
講師:王向榮 / SheetHub.com 共同創辦人

  • 找資料是第一步,也是最重要的一步。之前台大新聞社的同學還帶了攜帶式的掃瞄器進中選會蒐集選舉的數據,因為這些數據網路上找不到(?)
  • 資訊公開 vs 開放資料 差別在哪呢?
  • 資訊公開:政府把資料拿出來,讓民眾看得到(但不一定適合進行後續的資料處理)
  • 開放資料:政府把資料用特定方式,使民眾可以運用資料處理技術處理資料
eg. 內政部實價登錄網站
資訊:已經做好的菜,沒有辦法選擇菜色
資料:原料,可以做出任何菜
(以肉絲炒飯及肉絲炒麵為例)
google search 可以”site:gov.tw" 只搜尋政府網站

JSON的優點:可存放較複雜的資料
缺點:檔案較大(但一定比XML小)


連結:
  • Google: "google public data"
  • Google: "world bank data"
  • Google "主計處"
  • Google "社會經濟資料庫"  --> 社會經濟資料庫共通平台 (需註冊)
  • 密碼是用明碼記
  • Google "中選會資料庫"

練習範例1:

練習範例2:
  • Google 搜尋 "json to csv"
  • From storymap:
  • from 政誌
練習範例3: 擷取分析PDF文件資料
  • 用來把 pdf 裡面的表格資料轉化成CSV
  • 選取表格時,範圍一定要大於表格。
  • Reapeat Selection(Reapeat this Selection)功能(在選取範圍的右下角會出現),用於若一頁表格的範圍/位置都是一樣時,可以重複選取範圍。





Latest change 10 years ago

Reconnecting...

Disconnected

No Authorization

Connecting...
Reestablishing connection...

We're having trouble talking to the Hackpad synchronization server. You may be connecting through an incompatible firewall or proxy server.

We were unable to connect to the Hackpad synchronization server. This may be due to an incompatibility with your web browser or internet connection.

Lost connection with Hackpad. This may be due to a loss of network connectivity. If you close this window you may lose up to 30 seconds of unsaved work.

Server not responding. This may be due to network connectivity issues or high load on the server.

You are no longer allowed to access this pad. Reconnect to request access.

Failed to reconnect.

If this continues to happen, please let us know (opens in new window).

How embarrassing...

We experienced an error on the page that is causing problems with saving your work. Continuing to edit on the page without refreshing your browser would lead to some loss of your work.

If this continues to happen, please let us know (opens in new window).

Heads Up!

This pad is moderated. Your changes will require owner approval.

Insert an Image


or
Tip: you can simply drag&drop images into the editor from your desktop!

Cancel

Stop sharing with ?

This pad is shared with "", so will still be able to access it.
Cancel

Embed This Pad


Embed as

Log in / Sign up

Signing in using Facebook...

Contact Support



Please check out our How-to Guide and FAQ first to see if your question is already answered! :)

If you have a feature request, please add it to this pad. Thanks!