The names of the columns are not displayed because you didn’t use the print function.
This code is incorrect. You’re trying to select all the rows of the DataFrame where the value in the SeparationType column is a specific list. None of the values in this column is equal to this list and therefore you get an empty DataFrame.
This is the correct sintaxx for this kind of filtering:
This code only selects the separationtype column. It filters this column selecting only values with the Resignation word in it, yes, but it returns only the filtered column and not the entire DataFrame filtered by this column.