import pandas as pd
def nth_highest_salary(employee: pd.DataFrame, N: int) -> pd.DataFrame:
employee=employee.sort_values(by='salary',ascending=False)#先排序
employee=employee.drop_duplicates(subset='salary')#再删除重复值
if len(employee)>=N:
output=pd.DataFrame([employee['salary'].iloc[N-1]],columns=[f'getNthHighestSalary({N})'])#构建输出列表
#employee['salary'].iloc[N-1]表示salary这一列的第N-1个数据
else:
output=pd.DataFrame([None],columns=[f'getNthHighestSalary({N})'])#null用None表示
return output