Icon

Rock Climbing Accident Data

<p>A workflow designed to answer the question: What impact did Todd Skinner's death in 2006, by failure of soft equipment, have on rock climbing accidents? I aim to analyze data and see if there is any decrease in soft equipment failure-related accidents from 2007 on, as compared to before 2006.</p>

A workflow designed to answer the question: What impact did Todd Skinner's death in 2006, by failure of soft equipment, have on rock climbing accidents? I aim to analyze data and see if there is any decrease in soft equipment failure-related accidents from 2007 on, as compared to before 2006.

Reading the Data

Looks like there are 2770 rows, and 96 columns. A few of these columns should be removed, and most of the columns should be rennamed

2007-2016 Subset

Subsetting the data into the group of data following Todd Skinner's death in 2006

1996-2005 Subset

Subsetting the data into the group of data following Todd Skinner's death in 2006

Ingestion and Scoping

Ingestion and Scoping

Cleaning and Preprocessing

Cleaning and Preprocessing

Manipulation of Data - Investigating patterns in 'Text' values for different values in 'Tags_Applied'

Manipulation of Data - Investigating patterns in 'Text' values for different values in 'Tags_Applied'

Work Log

9/24/2025: Just finished a few of the rows in the Belay_Error column, trying to assign queries in the Rule Engine node for 'Detailed_Cause' column

Reading the data from the Excel file
Excel Reader
Dropping all rowsnot in the 1996-2005publication year range
Row Filter
Excluding ToddSkinner's record,which has apublication yearof 2007, when theevent actuallyoccurred in 2006
Rule Engine
Dropping all rowsnot in the 2007-2016publication year ragne
Row Filter
Removingexcess columnsfrom analysis
Column Filter
Making the 'Text' columnvalues lowercase
String Manipulation
Making the 'Text' column values lowercase
String Manipulation
Making column namesseparated with '_'
Column Name Replacer
Appending column"Detailed_Cause"based on queriesthat check text ofeach record for keycause words
Rule Engine
Component creates a subset excluding Solo, Gear Broke, and Belay Error tags from our Roped tagged subset
Roped Component
Component creates a subset excluding Gear Broke and Belay Error tags from our Solo tagged subset
Solo Component
Appending column"Detailed_Cause"based on queriesthat check text ofeach record for keycause words
Rule Engine
Rule Engine
Component creates a subset excluding Gear Broke and Belay Error tags from our Solo tagged subset
Solo Component
During my analysisof the "Gear Broke"column, I found thatthis was a duplicaterecord in the data.Removing it from all analysis
Row Filter
Component creates a subset excluding Belay Error tags from our Gear Broke tagged subset
Gear Broke Component
Component creates a subset excluding Solo, Gear Broke, and Belay Error tags from our Roped tagged subset
Roped Component
Component creates a subset excluding Belay Error tags from our Gear Broke tagged subset
Gear Broke Component
Appending column"Detailed_Cause"based on queriesthat check text ofeach record for keycause words
Rule Engine
Row Filter
Value Counter
Row Filter
Making column namesseparated with '_'
Column Name Replacer
Filtering for"Belay Error"tags
Row Filter
Appending column"Detailed_Cause"based on queriesthat check text ofeach record for keycause words
Rule Engine
Rule Engine
Filtering datasetfor Belay Errorsto create some baselinemetrics for queries
Row Filter
Appending column"Detailed_Cause"based on queriesthat check text ofeach record for keycause words
Rule Engine
Appending column"Detailed_Cause"based on queriesthat check text ofeach record for keycause words
Rule Engine

Nodes

Extensions

Links