Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 2016-02-22 14:59:44.561776
- df = pd.DataFrame({'my_timestamp': pd.date_range('2016-1-1 15:00', periods=5)})
- >>> df
- my_timestamp
- 0 2016-01-01 15:00:00
- 1 2016-01-02 15:00:00
- 2 2016-01-03 15:00:00
- 3 2016-01-04 15:00:00
- 4 2016-01-05 15:00:00
- df['new_date'] = [d.date() for d in df['my_timestamp']]
- df['new_time'] = [d.time() for d in df['my_timestamp']]
- >>> df
- my_timestamp new_date new_time
- 0 2016-01-01 15:00:00 2016-01-01 15:00:00
- 1 2016-01-02 15:00:00 2016-01-02 15:00:00
- 2 2016-01-03 15:00:00 2016-01-03 15:00:00
- 3 2016-01-04 15:00:00 2016-01-04 15:00:00
- 4 2016-01-05 15:00:00 2016-01-05 15:00:00
- df = pd.DataFrame({'full_date': pd.date_range('2016-1-1 10:00:00.123', periods=10, freq='5H')})
- df['date'] = df['full_date'].dt.date
- df['time'] = df['full_date'].dt.time
- In [166]: df
- Out[166]:
- full_date date time
- 0 2016-01-01 10:00:00.123 2016-01-01 10:00:00.123000
- 1 2016-01-01 15:00:00.123 2016-01-01 15:00:00.123000
- 2 2016-01-01 20:00:00.123 2016-01-01 20:00:00.123000
- 3 2016-01-02 01:00:00.123 2016-01-02 01:00:00.123000
- 4 2016-01-02 06:00:00.123 2016-01-02 06:00:00.123000
- 5 2016-01-02 11:00:00.123 2016-01-02 11:00:00.123000
- 6 2016-01-02 16:00:00.123 2016-01-02 16:00:00.123000
- 7 2016-01-02 21:00:00.123 2016-01-02 21:00:00.123000
- 8 2016-01-03 02:00:00.123 2016-01-03 02:00:00.123000
- 9 2016-01-03 07:00:00.123 2016-01-03 07:00:00.123000
- df["date"] = df["timestamp"].date
- dt["time"] = dt["timestamp"].time
- from datetime import datetime
- data1["timestamp"] = df["timestamp"].apply(lambda x:
- datetime.strptime(x,"%Y-%m-%d %H:%M:%S.%f"))
- from datetime import datetime
- timestamp = '2016-02-22 14:59:44.561776'
- dt = datetime.strptime(timestamp, '%Y-%m-%d %H:%M:%S.%f')
- s = '2016-02-22 14:59:44.561776'
- date,time = s.split()
- hour, minute, second = time.split(':')
- def time_date(datetime_obj):
- date_time = datetime_obj.split(' ')
- time = date_time[1].split('.')
- return date_time[0], time[0]
- import pandas as pd
- df = pd.read_csv(file_path)
- df['Dates'] = pd.to_datetime(df['date']).dt.date
- df['Time'] = pd.to_datetime(df['date']).dt.time
Add Comment
Please, Sign In to add comment