Python: Adding hours to pandas timestamp

by

I think you can add to column TDate column Hour converted to_timedelta with unit="h":

df = pd.DataFrame({'TDate':['2005-01-03','2005-01-04','2005-01-05'],
                   'Hour':[4,5,6]})

df['TDate'] = pd.to_datetime(df.TDate)
print (df)
   Hour      TDate
0     4 2005-01-03
1     5 2005-01-04
2     6 2005-01-05

df['TDate'] +=  pd.to_timedelta(df.Hour, unit="h")
print (df)
   Hour               TDate
0     4 2005-01-03 04:00:00
1     5 2005-01-04 05:00:00
2     6 2005-01-05 06:00:00

More Related Contents:

  1. How to join two dataframes for which column values are within a certain range?
  2. Filtering Pandas DataFrames on dates
  3. How to print pandas DataFrame without index
  4. datetime dtypes in pandas read_csv
  5. python pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  6. Python Pandas Group by date using datetime data
  7. Removing the timestamp from a datetime in pandas dataframe
  8. Pandas filter dataframe rows with a specific year
  9. Python/Pandas convert string to time only
  10. Convert Pandas Series to DateTime in a DataFrame
  11. Truncate `TimeStamp` column to hour precision in pandas `DataFrame`
  12. Python pandas integer YYYYMMDD to datetime
  13. Group DataFrame in 5-minute intervals
  14. Pandas custom function to find whether it is the 1st, 2nd etc Monday, Tuesday, etc – all suggestions welcome
  15. What values are valid in Pandas ‘Freq’ tags?
  16. pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  17. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13
  18. Get weekday/day-of-week for Datetime column of DataFrame
  19. Plot pandas dates in matplotlib
  20. Rename Pandas DataFrame Index
  21. What is the fastest way to upload a big csv file in notebook to work with python pandas?
  22. Convert row to column header for Pandas DataFrame,
  23. Select multiple ranges of columns in Pandas DataFrame
  24. pandas – filter dataframe by another dataframe by row elements
  25. Left justify string values in a pandas DataFrame
  26. Override global variable inside function not working with Spyder 4
  27. Pandas: Datetime Improperly selecting day as month from date [duplicate]
  28. Pandas Data Frame how to merge columns
  29. Replace NaN with empty list in a pandas dataframe
  30. When is it appropriate to use df.value_counts() vs df.groupby(‘…’).count()?

Leave a Comment