I have data where one column is a string. This column contains text, such as:

I want a new column that counts how many covenants there are in "financial_covenants". As you can see, the covenants are divided by a comma. I want my final result to look like this:

The data set is large (3000 rows), and these phrases differ among themselves in values, such like: Max. Debt to Cash Flow: Value is 3.00 and Max. Debt to Cash Flow: Value is 6.00. I am not interested in these values, but just want to know how many covenants there are.

Do you have any idea how to do this in Python?

CodePudding user response：

On the assumption that your data is in a pandas DataFrame called df with columns as labelled then you could use:

df['num_of_cov'] = df['financial_covenants'].map(lambda row : len(row.split(',')))

CodePudding user response：

Looks to me that you could use:

counts = [] # structure to store the results
for financial_covenant in financial_covenants: # your structure containing rows
    count = len(financial_covenant.split(','))
    counts.append(count)
print(counts)