Skip to content
Topic modelling using python, R and Tableau
Jupyter Notebook R
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Type Name Latest commit message Commit time
Failed to load latest commit information.
Mimno Coherence and Exclusivity Measures.pdf
Roberts Topic Models and Big Data.pdf
Topic Modelling of Building Incidents with Injuries 3.pptx
Topic Modelling of Incidents (5) (1).ipynb
stmVignette (2).pdf
text as data grimmer stewart.pdf
topic models open ended experiments.pdf

A time-series analysis of the main themes related to building injuries.

Data and Methods

All incidents with one or more injuries from January 2007 through October 2016.

Total of 4839 incidents with injuries.

Text that briefly describes the incident.

Method: Topic modelling, an unsupervised machine learning algorithm, used to uncover main themes in the text.

The method automatically develops “topics” from the text.

Programming Languages and Software

Python, R, Tableau

Quality Control

Topic modelling is good at finding themes in text, but has issues with accuracy:

  1. Sometimes text not classified properly

  2. Topics can be ambiguous

Accuracy Improvement:

  1. Top words created by the algorithm for each topic were used as key words in an algorithm I developed to recode the text.

  2. Algorithm developed in python.

  3. Key words were grouped and used conditionally to code the text according to the key words in the topic.

  4. Increased accuracy: when text was recoded, tested the quality of algorithm by drawing sample and checking accuracy.

  5. When error found, tweaked the algorithm to improve accuracy.

  6. Implemented automatic spell corrector on misspelled words, improved accuracy by about 10%


92% of the incidents were classified into 20 topics, 8% of the incidents could not be classified.

The 20 topics fit into 2 main categories:

  1. Workers injured on the job, i.e. worker falling from structure, cuts to body, heart attack, etc. The titles of all of these topics begin with “worker”.

  2. Building related incidents – Partial building collapse, vehicle hitting building, falling debris, etc.

Heat map of the count of topics by year created in Tableau:

heat map of topics w title 2007 - 2016

You can’t perform that action at this time.