Add column with number of days between dates in DataFrame pandas

by

To remove the ‘days’ text element, you can also make use of the dt() accessor for series: https://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.dt.html

So, 

df[['A','B']] = df[['A','B']].apply(pd.to_datetime) #if conversion required
df['C'] = (df['B'] - df['A']).dt.days

which returns:

             A          B   C
one 2014-01-01 2014-02-28  58
two 2014-02-03 2014-03-01  26

More Related Contents:

  1. Renaming column names in Pandas
  2. Filtering Pandas DataFrames on dates
  3. What’s the fastest way in Python to calculate cosine similarity given sparse matrix data?
  4. Seaborn Barplot – Displaying Values
  5. How can I map True/False to 1/0 in a Pandas DataFrame?
  6. Pandas create new column with count from groupby
  7. Pandas dataframe with multiindex column – merge levels
  8. How to qcut with non unique bin edges?
  9. Search for “does-not-contain” on a DataFrame in pandas
  10. Pandas select rows and columns based on boolean condition
  11. Changing multiple column names but not all of them – Pandas Python
  12. python pandas flatten a dataframe to a list
  13. creating multiple excel worksheets using data in a pandas dataframe
  14. Python Pandas Conditional Sum with Groupby
  15. Get all combinations of elements from two lists?
  16. How to create a dictionary of two pandas DataFrame columns
  17. Can You Consistently Keep Track of Column Labels Using Sklearn’s Transformer API?
  18. Using conditional to generate new column in pandas dataframe
  19. AttributeError: ‘DataFrame’ object has no attribute ‘ix’
  20. What is dtype(‘O’), in pandas?
  21. Counting the Frequency of words in a pandas data frame
  22. UnicodeDecodeError: ‘utf-8’ codec can’t decode byte 0x96 in position 35: invalid start byte
  23. Co-occurrence matrix from nested list of words
  24. How to increment a row count in groupby in DataFrame
  25. Identifying consecutive NaNs with Pandas
  26. How to merge a Series and DataFrame
  27. Custom sorting with Pandas
  28. Python making combined bar and line plot with secondary y-axis
  29. Round float columns in pandas dataframe
  30. Converting PANDAS dataframe from monthly to daily

Leave a Comment