mardi 27 octobre 2020

How to select a set of data from a column in DataFrame with specific condition?

Please find the below columnn data , I want to select the entire data where Column DISC does not contain the value AA in it . In the below data , I want to display the data of JOSE , YEN and REX.

Name ---------Disc -------- Class
GINA ------ - AA BB CC ----- 10
JOSE ------ - TT YY ----- ---- 10
TOM ------- - AA TT ---------- 15
YEN -------- HH UJ II -------- 15
REX ----------- KK ------------- 15

How can I select the data? The value 'AA BB CC' is a string and has white spaces in between .

Aucun commentaire:

Enregistrer un commentaire