问Python -如何在Excel中筛选出数据

EN

import pandas as pd
from openpyxl import load_workbook
df = pd.read_excel('Path/to/folder/filename.xlsx')
filtered_df = df[df['Country']=='UK' & df['Status']=='Yes']
book = load_workbook('Path/to/folder/filename.xlsx')
writer = pd.ExcelWriter('Path/to/folder/filename.xlsx', engine = 'openpyxl')
writer.book = book
filtered_df.to_excel(writer, sheet_name = 'sheet2')
writer.save()
writer.close()

import pandas as pd

df = pd.read_excel('file.xlsx', sheet_name=0) #reads the first sheet of your excel file

df = df[(df['Country']=='UK') & (df['Status']=='Yes')] #Filtering dataframe

df.to_excel('file.xlsx', sheet_name='Filtered Data') #Saving to a new sheet called Filtered Data