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?