0
votes

I have the following dataframes with many dates. I want to:

sales_agents["hire_date"]


  0    2017-04-01 00:00:00

  1    2017-05-03 00:00:00

  2    2017-10-17 00:00:00

  Name: hire_date, dtype: object

I would like to obtain the difference in DAYS from row 0 to row n:

output = [(2017-04-01 - 2017-05-03), (2017-04-01 - 2017-10-17), (2017-05-03 - 2017-10-17)]

The result should be in DAYS and I want to get the difference of all possible combinations except itself.

Can you help?