进行筛选的时候，显示的结果是空值，python中的excel筛选时间没有值，如何解决？

Question

为什么进行筛选的时候，显示的结果是空值哪里出错了

import pandas as pd
import matplotlib.pyplot as plt

data =pd.read_excel(r'F:/text/京基一百.xlsx',header=0)
print(data)
df1 = data.loc[data['时间']=='10:30:00',['入口车辆']]
df2 = data.loc[data['时间']=='12:00:00',['入口车辆']]
df3 = data[data['时间']=='10:30:00']
print(df1)
print(df2)
print(df3)

Answer 1

import pandas as pd
import matplotlib.pyplot as plt

data = pd.read_excel(r'F:/text/京基一百.xlsx', header=0)
print(data)

data['时间'] = data['时间'].astype(str)

df1 = data.loc[data['时间'] == '10:30:00']
df2 = data.loc[data['时间'] == '12:00:00']
df3 = data[data['时间'] == '10:30:00']
print(df1)
print(df2)
print(df3)

错误是因为从EXCEl读取的数据，自动将时间设置为datetime类型，所以你的过滤条件就不起作用了。