text analysis

Using the excel attached below, i'd like a clean data using regex and build a function that does the following.

load data and clean it
look at the text column in the spreadsheet. i want to label it 0 for being a specific description and 1 for being a general description (having other)

function 1 - general function of instances of other
if it has OTHER, OTHER/OTHER, OTHER:OTHER, OTH label 0 else 1 in a new column

function 2 a function to show change from 0 to 1 , 0 to 0, 1 to 0 and 1 to 1

function 3/ a function showing how general the text is.

if it has other or OTH it is 0 and Low
if it has other:other or other:other:other it is 0 Medium
if it has more than 3 others in per row then it's 0 Maximum
else it is specific