This is my data
No Text
1 You are smart
2 You are beautiful
3 I am very smart
4 I love smart girl
I want to return column Subject
as 1 if the sentence contains You are
, or I am
, 0 otherwise and columns smart as smart
if the sentence contains smart
My expected output
No Text Subject smart
1 You are smart 1 1
2 You are beautiful 1 0
3 I am very smart 1 1
4 I love smart girl 0 1
Comments
Post a Comment