Pandas: Subtracting two date columns and the result being an integer

by

How about:

df_test['Difference'] = (df_test['First_Date'] - df_test['Second Date']).dt.days

This will return difference as int if there are no missing values(NaT) and float if there is.

Pandas have a rich documentation on Time series / date functionality and Time deltas

More Related Contents:

  1. Converting between datetime, Timestamp and datetime64
  2. NumPy or Pandas: Keeping array type as integer while having a NaN value
  3. Pandas: How to create a datetime object from Week and Year?
  4. pd.Timestamp versus np.datetime64: are they interchangeable for selected uses?
  5. Convert a column of timestamps into periods in pandas
  6. Replacing values represented by 'UN' with NaN
  7. How to print pandas DataFrame without index
  8. pandas select from Dataframe using startswith
  9. What’s the fastest way in Python to calculate cosine similarity given sparse matrix data?
  10. Restart cumsum and get index if cumsum more than value
  11. What does the term “broadcasting” mean in Pandas documentation?
  12. Dropping infinite values from dataframes in pandas?
  13. ValueError: numpy.dtype has the wrong size, try recompiling
  14. Convert timedelta64[ns] column to seconds in Python Pandas DataFrame
  15. Splitting timestamp column into separate date and time columns
  16. ‘DataFrame’ object has no attribute ‘sort’
  17. Pandas pd.Series.isin performance with set versus array
  18. Get year, month or day from numpy datetime64
  19. Get week start date (Monday) from a date column in Python (pandas)?
  20. What is dtype(‘O’), in pandas?
  21. pandas distinction between str and object types
  22. Python pandas convert datetime to timestamp effectively through dt accessor
  23. Which is the fastest way to extract day, month and year from a given date?
  24. Locate first and last non NaN values in a Pandas DataFrame
  25. Pandas custom function to find whether it is the 1st, 2nd etc Monday, Tuesday, etc – all suggestions welcome
  26. How to resample a dataframe with different functions applied to each column?
  27. Resample time series in pandas to a weekly interval
  28. Python: Adding hours to pandas timestamp
  29. How to use numpy to get the cumulative count by unique values in linear time?
  30. how to specify the datetime format in read_csv

Leave a Comment