In this scenario, the sequence determines and counts if there is a word “Absent” in the column. However, in the given column there is a word “Absent” but the output is still zero. How can I solve this? Has it something to do with the data types of the variables?
can you show the regex which you are matching
Are you converting the whole column into string?
I want to count the number of absences in the column.
Try this by giving your column name and the string which you want to search
Thank you so much and I will work on it.