title: Excel group by substring
body: <p>I am extremely new into Machine learning Feature of Python. I wanted to group i.e. create a cluster based on specific texts from rows. In <img src="https://i.stack.imgur.com/CHK3n.png" alt="Input Excel"> there are 3 columns Sr no, Name and Summary. I wanted to create a cluster based on the specific values from the summary text i.e. if the summary contains the text "<strong><em>Veg</em></strong>", then it should be in one cluster and if the text contains "<strong><em>Non Veg</em></strong>", then it should be in another cluster. Expected Output <img src="https://i.stack.imgur.com/7vd2Y.png" alt="Output Excel">, where the third column will contain the clustered value. <strong><em>All veg are grouped to Cluster 0 and Non Veg to cluster 1</em></strong></p>
  
  <p>K-means can solve this for me. But how to cluster based on the text from the summary. Kindly help. Thanks in advance.</p>