Taking csv and filter to a Datatabale

Lets say if i have a csv/excel like above, Obviously We can use a read csv and export to a data-table, but how do i read and at same time filter only users with state =“TX” to the data-table or once i read the csv to data-table then filter by state “TX” to another data-table. I used the filter data-table activity but not getting all the “TX” with “Yes” only one.image

@Jay_Chacko Can you please column name and values once again with datatable or CSV?

you mentioned column names like 9 and 7