In order to distribute tasks to colleagues, it is necessary to filter out the image data according to the protected areas assigned by colleagues, and finally send the images to colleagues.
I thought of the screening function the first time, but through ordinary screening, you need to check the protection areas one by one. When the protection area and colleagues have a lot of tasks, you have to look blind.
Through advanced screening, it can be easily completed, the specific steps are as follows:
① Select the filter area and click the Advanced Filter Tool button.
② After confirming the condition area and copy location, you can filter out the data.
Of course, advanced screening can also target multiple conditions~
Of course, for me who like to toss, I need to see how Python implements this similar function.
① 1. I store the task in a separate table and read the data.
import pandas as pd data = pd.read_excel('test.xlsx',sheetname='data') task = pd.read_excel('test.xlsx',sheetname='task')
② Through the isin method in Boolean operation, we can easily get the data we want.
data[data['Involved in the protected area'].isin(task['Involved in the protected area'])]