Pandas以NaT和nan的形式读取数据

Question

我正在尝试读取CSV文件中的一些示例数据，该文件包含以下内容。但是，当我打印数据框中的数据时，许多列都是空的。我手动设置列数据类型，因为我认为这可能是问题所在，但这并没有解决问题。我们将非常感谢您的帮助

数据：

People_id,datetime,First Name,Last Name,Utilization,Chargeability,Target,Employee Type,Business Unit,Business Group
2222,2020-05-03,FirstName,LastName,0.8,0.9,0.4,Employee,GGGG,G1

代码：

import pandas as pd



data = pd.read_csv (r'C:\Users\Name\Documents\testdata.csv')   
df = pd.DataFrame(data, columns= ['People_id', 'WeekEnding', 'FirstName', 'LastName', 'Utilization', 'Chargeability', 'Target', 'EmployeeType', 'BusinessUnit', 'BusinessGroup'])

df.dropna(subset=['People_id', 'Utilization', 'Chargeability', 'Target'])

df.FirstName = df.FirstName.astype(str)
df.LastName = df.LastName.astype(str)
df.EmployeeType = df.EmployeeType.astype(str)
df.BusinessUnit = df.BusinessUnit.astype(str)
df.BusinessGroup = df.BusinessGroup.astype(str)
df['WeekEnding'] = pd.to_datetime(df['WeekEnding'])

for row in df.itertuples():
    print (row.People_id)
    print (row.WeekEnding)
    print (row.FirstName)
    print (row.LastName)
    print (row.Utilization)
    print (row.Chargeability)
    print (row.Target)
    print (row.EmployeeType)
    print (row.BusinessUnit)
    print(row.BusinessGroup)

输出：

2222
NaT
nan
nan
0.8
0.9
0.4
nan
nan
nan