I am new to python and my test report is a .csv file like this :
Stream play pause seek
1.mp3 PASS FAIL FAIL
1.ac3 PASS PASS FAIL
2.mp3 FAIL PASS PASS
3.mp3 PASS PASS FAIL
4.mp4 FAIL FAIL PASS
I want to get total number of "PASS" from all the columns.
Reslult should be like : Total tests : 15 No. of pass : 8 No of Fail : 7
Please suggest how to extract the string "PASS" from the columns "play" "pause" and "seek".
I could do it using pandas module. Here is the code below: