比较Pandas DataFrame中的特定时间戳 ŌĆō Python

要比较特定的时间戳，请在方括号中使用索引号。首先，导入所需的库-

import pandas as pd

创建一个具有3列的DataFrame。我们有两列包含时间戳的日期列-

dataFrame = pd.DataFrame(
   {
      "Car": ["Audi", "Lexus", "Tesla", "Mercedes", "BMW"],
      "Date_of_Purchase": [
         pd.Timestamp("2021-06-10"),
         pd.Timestamp("2021-07-11"),
         pd.Timestamp("2021-06-25"),
         pd.Timestamp("2021-06-29"),
         pd.Timestamp("2021-03-20"),
      ],
     "Date_of_Service": [
         pd.Timestamp("2021-11-05"),
         pd.Timestamp("2021-12-03"),
         pd.Timestamp("2021-10-30"),
         pd.Timestamp("2021-11-29"),
         pd.Timestamp("2021-08-20"),
      ]
})

查找特定的时间戳，例如1到3行-

timestamp1_diff = abs(dataFrame['Date_of_Purchase'][0]-dataFrame['Date_of_Service'][0])
timestamp2_diff = abs(dataFrame['Date_of_Purchase'][1]-dataFrame['Date_of_Service'][1])
timestamp3_diff = abs(dataFrame['Date_of_Purchase'][2]-dataFrame['Date_of_Service'][2])

示例

以下是代码-

import pandas as pd

#创建3列的dataframe
dataFrame = pd.DataFrame(
   {
      "Car": ["Audi", "Lexus", "Tesla", "Mercedes", "BMW"],
      "Date_of_Purchase": [
         pd.Timestamp("2021-06-10"),
         pd.Timestamp("2021-07-11"),
         pd.Timestamp("2021-06-25"),
         pd.Timestamp("2021-06-29"),
         pd.Timestamp("2021-03-20"),
      ],
      "Date_of_Service": [
         pd.Timestamp("2021-11-05"),
         pd.Timestamp("2021-12-03"),
         pd.Timestamp("2021-10-30"),
         pd.Timestamp("2021-11-29"),
         pd.Timestamp("2021-08-20"),
      ]
})

print"DataFrame...\n", dataFrame

#比较特定的时间戳
timestamp1_diff = abs(dataFrame['Date_of_Purchase'][0]-dataFrame['Date_of_Service'][0])
timestamp2_diff = abs(dataFrame['Date_of_Purchase'][1]-dataFrame['Date_of_Service'][1])
timestamp3_diff = abs(dataFrame['Date_of_Purchase'][2]-dataFrame['Date_of_Service'][2])

print"\n Car 1日期购买和服务之间的差异\n",timestamp1_diff
print"\n Car 2日期购买和服务之间的差异\n",timestamp2_diff
print"\n Car 3日期购买和服务之间的差异\n",timestamp3_diff

输出

将产生以下输出-

DataFrame...
        Car   Date_of_Purchase   Date_of_Service
0      Audi        2021-06-10        2021-11-05
1     Lexus        2021-07-11        2021-12-03
2     Tesla        2021-06-25        2021-10-30
3  Mercedes        2021-06-29        2021-11-29
4       BMW        2021-03-20        2021-08-20

差异 between Car 1日期购买和服务之间
148 days 00:00:00

差异 between Car 2日期购买和服务之间
145 days 00:00:00

差异 between Car 3日期购买和服务之间
127 days 00:00:00