I have a dataframe that have as its value either a string or a tuple containing multiple strings, like the one bellow:
Country Roles \
0 Shell Record (DSC Payroll Administrator Reporting, DSC HR S...
1 PL (DSC Payroll Administrator Reporting, DSC Payr...
2 ES (DSC HR Business Partner Reporting, DSC HR Bus...
3 Shell Record (DSC HR Business Partner Reporting, DSC HR Bus...
4 Shell Record DSC BPM Worklist Administrator
Role vs Family
0 Do not match
1 (Match, Do not match)
2 Match
3 Do not match
4 Do not match
Is there a way I can remove the values inside the tuple (for example, remove the Match/Do not match so the value in the column would just be the same without the parenthesis). I don't want to use "replace" for that (or even don't know if it is possible).
Thank you!