title: Filtering dataframe column in list-like format using substring
body: <p>I have the following dataframe of person number (unique and non duplicate) and the roles those people have all condensended in a list-like format (for people with more than 1 role) like this:</p>
  <pre><code>         Person Number                                          Role Name
  0          10000170             [HR Business Partner, HR Administrator, HR Administrator Limited]
  1          10000479             [HR Administrator, HR Administrator Reporting]
  2          10001347             [HR Business Partner, HR Administrator]
  3          10003004             [HR Business Partner Approver, HR Business Partner]
  4          10003048             [HR Administrator, HR Administrator Reporting]
  5          10062441             [HR Business Partner Security Limited, HR Administrator Limited]
  6          10062862             [HR Business Partner, HR Business Partner Approver]
  7          10063101             HR Business Partner
  8          10063833             HR Administrator
  </code></pre>
  <p>I would like to filter this dataframe in the following:</p>
  <p>1- Return all rows where the &quot;Role Name&quot; column is in a list-like format:</p>
  <p>OUTPUT:</p>
  <pre><code>         Person Number                                          Role Name
  0          10000170             [HR Business Partner, HR Administrator, HR Administrator Limited]
  1          10000479             [HR Administrator, HR Administrator Reporting]
  2          10001347             [HR Business Partner, HR Administrator]
  3          10003004             [HR Business Partner Approver, HR Business Partner]
  4          10003048             [HR Administrator, HR Administrator Reporting]
  5          10062441             [HR Business Partner Security Limited, HR Administrator Limited]
  6          10062862             [HR Business Partner, HR Business Partner Approver]
  </code></pre>
  <p>2 - Filter this dataframe in a way that return all employee rows where in their &quot;Role Name&quot; value may contain the word &quot;Business Partner&quot; AND the word &quot;Administrator] returning this:</p>
  <p>OUTPUT:</p>
  <pre><code>         Person Number                                          Role Name
  0          10000170             [HR Business Partner, HR Administrator, HR Administrator Limited]
  2          10001347             [HR Business Partner, HR Administrator]
  5          10062441             [HR Business Partner Security Limited, HR Administrator Limited]
  </code></pre>
  <p>How could I achieve each of the outputs?</p>