You can't delete the products via the csv file but it is quite quick via the quick entry feature in the product admin page. The only way really would be by keyword or by category if they are grouped that way, there isn't a feature to select drop shippers from the product admin page. Via the csv file you could set them not to display and then delete those via the admin for example.