比较 Python 中的时间戳 – Pandas

为了比较时间戳,我们可以使用索引运算符,即方括号。首先,导入所需的库 -

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-10"),

          pd.Timestamp("2021-12-11"),

          pd.Timestamp("2021-11-25"),

          pd.Timestamp("2021-11-29"),

          pd.Timestamp("2021-08-20"),

      ]

   })

现在让我们比较两个日期列中的一些时间戳 -

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])

比较所有时间戳 -

timestamp_diff = abs(dataFrame['Date_of_Purchase']-dataFrame['Date_of_Service'])

示例

以下是完整的代码 -

import pandas as pd

# create a dataframe with 3 columns

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-10"),

         pd.Timestamp("2021-12-11"),

         pd.Timestamp("2021-11-25"),

         pd.Timestamp("2021-11-29"),

         pd.Timestamp("2021-08-20"),

      ]

   })

print"DataFrame...\n", dataFrame

# compare specific timestamps

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])

print"\nDifference between Car 1 Date of Purchase and Service \n",timestamp1_diff

print"\nDifference between Car 2 Date of Purchase and Service \n",timestamp2_diff

# compare all timestamps by finding difference

timestamp_diff = abs(dataFrame['Date_of_Purchase']-dataFrame['Date_of_Service'])

print"\nDifference between two Timestamps: \n",timestamp_diff

输出结果

这将产生以下输出 -

DataFrame...

        Car   Date_of_Purchase   Date_of_Service

0      Audi         2021-06-10        2021-11-10

1     Lexus         2021-07-11        2021-12-11

2     Tesla         2021-06-25        2021-11-25

3  Mercedes         2021-06-29        2021-11-29

4       BMW         2021-03-20        2021-08-20

Difference between Car 1 Date of Purchase and Service

153 days 00:00:00

Difference between Car 2 Date of Purchase and Service

153 days 00:00:00

Difference between two Timestamps:

0   153 days

1   153 days

2   153 days

3   153 days

4   153 days

dtype: timedelta64[ns]

以上是 比较 Python 中的时间戳 – Pandas 的全部内容, 来源链接: utcz.com/z/362237.html

回到顶部