How to remove the date information in a column, just keep time
pandas, python
Solution
The following will convert what you have to datetime.time() objects:
dataset['TimeStamp'] = pd.Series([val.time() for val in dataset['TimeStamp']])
Output
TimeStamp
0 05:15:00
1 05:28:00
2 06:15:00
Problem
I am using pandas dataframe. there is a specific column has time information. the raw data likes this: ``` 5:15am 5:28am 6:15am ``` so I need to convert the raw data into datetime format: ``` format = '%I:%M%p' dataset['TimeStamp'] = pd.to_datetime(dataset['TimeStamp'],format) ``` However, I got: ``` 2014-07-04 05:15:00 2014-07-04 05:28:00 2014-07-04 06:15:00 ``` I don't want the year and date information, just want time. How can I remove it. Thanks.