Data News of the Week | Nobel Prize and Hong Kong Chief Executive Policy Address

Noble Prize and Policy Address 2017.

Nobel Prize. Michael Greshko from National Geographic finds out that Nearly 900 People Have Won Nobel Prizes. Only 48 Were Women. The gender gap exists, regardless that female winners are increasing in recent years.


Nobel Prize

Continue reading “Data News of the Week | Nobel Prize and Hong Kong Chief Executive Policy Address”

Data Journalism Open Lecture 11/11/2017

Title:Environment Issue, Open Technology and Data Visualisation

Speaker: Shan HE
Date: November 11 (Sat.)
Time: 11:30 a.m.-12:10 p.m.
Venue: CVA 506, HKBU

Shan HE 2017.10.18



Continue reading “Data Journalism Open Lecture 11/11/2017”

Data Journalism Boot Camp in Hong Kong

Dear all,

We are honoured to introduce you a one and a half day Data Journalism Boot Camp in Hong Kong.

Location (Map): Room 506, 5/F, Communication and Visual Arts Building (CVA), Hong Kong Baptist University. 

Time: Oct. 26 (Thursday) 9am-5pm & Oct. 27 (Friday) 9am-3pm.

Interested applicants should fill in the online form in this (deadline for applications to be 13 Oct.) link:

The workshop will be run by a pair experienced trainers from DataLEADS including the founder and Editor-in-Chief of the Indian Centre for Investigative Journalism.


Continue reading “Data Journalism Boot Camp in Hong Kong”

100 Year’s Earthquake around Sichuan in D3

Jiuzhaigou, a world-class scenic spot in Sichuan, China, suffered a drastic earthquake on 2017-08-08 21:19:46. People still remember the Wenchuan earthquake that caused thousands of deaths and loss of enormous properties. Does Sichuan have a lot of earthquakes in history? Which counties suffered most from the earthquakes? Pili Hu made this animated chart in D3 overnight for an overview of earthquakes happened in or around Sichuan region in the past 100 years. The data source is See the project in full page here: Sichuan Earthquake in 100 years.

Map Visualisation for Panama Papers and Offshore Leaks in R

(This is a repost from by Charlie Chen, Chao Tianyi, click the link to read the original: Map Visualisation for Panama Papers and Offshore Leaks in R)

On May 9, 2016, the International Consortium of Investigative Journalists (“ICIJ” in short), a global network of journalists who collaborates on in-depth and investigative stories, released the long awaited offshore entities database behind Panama Papers Investigation.

So far, the offshore leaks database published by ICIJ includes at least 200,000 offshore entities from Panama Papers, and over 100,000 records from ICIJ’s previous investigations.

The offshore leaks database contains detailed contact postal address of all kinds of entities, offshore or non-offshore ones, officers and intermediaries, based on which we made colored maps revealing the distribution of postal address of people or companies involved in the offshore industry.

Continue reading “Map Visualisation for Panama Papers and Offshore Leaks in R”


(This is a repost from, click the link to read the original: 小工具有大作用-輕鬆截屏剪裁)





第一步:打開 Firefox,打開目標網頁,調整到理想的視窗比例。

第二步:進 Tools -> Web Developer -> Toggle ToolsFirefox-capture-1.png

第三步:在彈出的窗口點擊小齒輪,選擇「Take a fullpage screenshot」,然後點擊「照相機」按鈕。

第四步:從此之後,只要打開控制台,點選照相機即可。文件會下載到 Downloads 文件夾內。

Continue reading “小工具有大作用-輕鬆截屏剪裁”

Time Saving One-Liners for Journalists

(This is a repost from, click the link to read the original: Time Saving One-Liners for Journalists)

For journalists who do not code, after reading this article, you will master 15 one-line commands that can help you handle complex problems in seconds.

Initium Lab has collected various command line tricks as we hack journalism with technology. Here is our editor’s choice so far including: image processing, video processing, PDF manipulation, social network hacking and other useful one-liners. Just open your Terminal, and follow the steps.

1.png Continue reading “Time Saving One-Liners for Journalists”

關係圖表速成方案:Google Fusion Tables & Kumu

(This is a repost from by Chao Tianyi, click the link to read the original: 關係圖表速成方案:Google Fusion Tables & Kumu)


如何迅速製作出一張圖呢?本文會提供 Google Fusion Tables 和 Kumu 兩種方案。

不論採用哪種工具製作,最初都需要將原始資料從 research notes 整理成結構化的信息。


Continue reading “關係圖表速成方案:Google Fusion Tables & Kumu”


(This is a repost from by Chao Tianyi, click the link to read the original: 整日做表沒思路?Google幫你開腦洞)


Google Sheets 最近推出了一項新功能 Explore,或許能成為探索陌生數據的第一步。Google 介紹稱,Explore 能根據表格內容自動生成盡可能多的圖表,還順帶做些數據分析,挖掘數據的關聯和趨勢[1]。

Explore 的使用方法很簡單,一次點擊就能自動出圖,不時還會附上(它認為)有趣的發現,例如列舉最大值和最小值等。


Continue reading “整日做表沒思路?Google幫你開腦洞”

Google Sheets 技巧總結

(This is a repost from by Chao Tianyi, click the link to read the original: Google Sheets 技巧總結)

與 Excel 一樣,Google Sheets 也是常用的數據清洗和分析工具,不同的是, Google Sheets 還支持在線協操和實時保存功能。當需處理的數據量級不是特別大,或是分析難度不是特別高時,Google Sheets 可以算作最順手、最高效的工具了。以下,我們總結出6個 Google Sheets 的使用技巧,幫助大家更加熟練地掌握它。

Copy and Paste Special

在 Google Sheets 的每個格子裡,數據存在的格式並不僅僅是文字或數字這麼簡單,有時它可能是一串公式,有時又會是邏輯判斷。所以,當需要使用複製粘貼功能時,別忘記確認你粘貼過去的內容是什麼。如果你需要的只是格子裡的值(value,即數字或文字)而非一串公式,那你需要在粘貼時點選「Paste Special」-「Values Only」(或者採用 Command+Shift+V),這樣,就可以防止粘貼一堆亂碼去新的表格了。


Continue reading “Google Sheets 技巧總結”