KeyError:"筛选器"(从数据帧接收特定数据)



所以,顺序是"要求用户输入他/她希望接收数据的对象的名称和过滤器的名称;需要的数据(可以引入多个过滤器)。">

这是我的数据:

<表类> 对象 HJD 24… 过滤器 大小 tbody><<tr>SU_Hor55896.30476B14.877SU_Hor55896.27438Ic13.885SU_Hor55896.27349B14.809SU_Hor55896.27397 V14.434SU_Hor55896.40882Ic14.033SU_Hor55896.40829 V14.540SU_Hor55896.40770B14.941SU_Hor55896.34973Ic13.958SU_Hor55896.34943 V14.494SU_Hor55896.34906B14.861SU_Hor55896.30542Ic13.912SU_Hor55896.30512 v14.440SU_Hor55897.38547 V14.536SU_Hor55897.28281B14.882SU_Hor55897.28317 V14.428SU_Hor55897.28347Ic13.927RZ_Lyr27359.3030 V10.630RZ_Lyr27684.4510 V10.610RZ_Lyr27685.4780 V10.580RZ_Lyr27701.3150 V10.700RZ层27934.4560 V10.660RZ层27955.4100 V10.570rzlyr30604.2000 V11.030RZ_Lyr55314.5695B12.047RZ_Lyr55314.5724B12.036RZ_Lyr55314.5900B12.042RZ_Lyr55314.6105B12.045RZ_Lyr55314.6163B12.027RZ_Lyr55342.3509B12.057RZLyr55342.3557B12.058RZ_Lyr55342.3606B12.052RZ_Lyr55342.3654B12.058

我运行了下面的代码,一切都为我工作

import pandas as pd
def searchByFilter():
filter = input('Enter filter to show data n')
df = pd.DataFrame({"Dummy":[1,2,3,4,5],
"Filter":["A","B","C","D","E"]})
print(df.loc[df['Filter'] == filter,:])

print('Enter 1 to search by object name')
print('Enter 2 to search by filter')
src = (input('Enter here: '))
if src == '1':
None
elif src == '2':
searchByFilter()
else:
print('Sorry, invalid input')
-----------------------------------
Enter 1 to search by object name
Enter 2 to search by filter
Enter here: 2
Enter filter to show data 
B
Dummy Filter
1      2      B

关键错误表明您的'Python_2ndLab.csv'文件头可能没有完全按照预期格式化。再次检查文件,确保没有任何可能导致这种情况的前导或尾随空格。在文本编辑器中打开CSV而不是excel,可以更容易地发现这些。

最新更新