Guest User

Untitled

a guest
Nov 20th, 2017
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.13 KB | None | 0 0
  1. 2016-02-22 14:59:44.561776
  2.  
  3. df = pd.DataFrame({'my_timestamp': pd.date_range('2016-1-1 15:00', periods=5)})
  4.  
  5. >>> df
  6. my_timestamp
  7. 0 2016-01-01 15:00:00
  8. 1 2016-01-02 15:00:00
  9. 2 2016-01-03 15:00:00
  10. 3 2016-01-04 15:00:00
  11. 4 2016-01-05 15:00:00
  12.  
  13. df['new_date'] = [d.date() for d in df['my_timestamp']]
  14. df['new_time'] = [d.time() for d in df['my_timestamp']]
  15.  
  16. >>> df
  17. my_timestamp new_date new_time
  18. 0 2016-01-01 15:00:00 2016-01-01 15:00:00
  19. 1 2016-01-02 15:00:00 2016-01-02 15:00:00
  20. 2 2016-01-03 15:00:00 2016-01-03 15:00:00
  21. 3 2016-01-04 15:00:00 2016-01-04 15:00:00
  22. 4 2016-01-05 15:00:00 2016-01-05 15:00:00
  23.  
  24. df = pd.DataFrame({'full_date': pd.date_range('2016-1-1 10:00:00.123', periods=10, freq='5H')})
  25. df['date'] = df['full_date'].dt.date
  26. df['time'] = df['full_date'].dt.time
  27.  
  28. In [166]: df
  29. Out[166]:
  30. full_date date time
  31. 0 2016-01-01 10:00:00.123 2016-01-01 10:00:00.123000
  32. 1 2016-01-01 15:00:00.123 2016-01-01 15:00:00.123000
  33. 2 2016-01-01 20:00:00.123 2016-01-01 20:00:00.123000
  34. 3 2016-01-02 01:00:00.123 2016-01-02 01:00:00.123000
  35. 4 2016-01-02 06:00:00.123 2016-01-02 06:00:00.123000
  36. 5 2016-01-02 11:00:00.123 2016-01-02 11:00:00.123000
  37. 6 2016-01-02 16:00:00.123 2016-01-02 16:00:00.123000
  38. 7 2016-01-02 21:00:00.123 2016-01-02 21:00:00.123000
  39. 8 2016-01-03 02:00:00.123 2016-01-03 02:00:00.123000
  40. 9 2016-01-03 07:00:00.123 2016-01-03 07:00:00.123000
  41.  
  42. df["date"] = df["timestamp"].date
  43. dt["time"] = dt["timestamp"].time
  44.  
  45. from datetime import datetime
  46. data1["timestamp"] = df["timestamp"].apply(lambda x:
  47. datetime.strptime(x,"%Y-%m-%d %H:%M:%S.%f"))
  48.  
  49. from datetime import datetime
  50.  
  51. timestamp = '2016-02-22 14:59:44.561776'
  52. dt = datetime.strptime(timestamp, '%Y-%m-%d %H:%M:%S.%f')
  53.  
  54. s = '2016-02-22 14:59:44.561776'
  55.  
  56. date,time = s.split()
  57.  
  58. hour, minute, second = time.split(':')
  59.  
  60. def time_date(datetime_obj):
  61. date_time = datetime_obj.split(' ')
  62. time = date_time[1].split('.')
  63. return date_time[0], time[0]
  64.  
  65. import pandas as pd
  66. df = pd.read_csv(file_path)
  67.  
  68. df['Dates'] = pd.to_datetime(df['date']).dt.date
  69. df['Time'] = pd.to_datetime(df['date']).dt.time
Add Comment
Please, Sign In to add comment