DatetimeIndex with time part only: is it possible
No, it is not possible, only with datetime or with float index.
However, variant offered by unutbu is very useful.
I've stuck with such a problem.
I have a set of observation of passenger traffic. Data is stored in .xlsx file with the following structure: date_of_observation, time, station_name, boarding, alighting.
I wonder if it's possible to create Dataframe with DatetimeIndex from such data if I need only 'time' component of datetime. (No dublicates of time is presented in dataset).
The reason for this requirement is that I use specific logic based on circular time (for example, 23.00 < 0.00, but 0.01 < 0.02 when compared), so I don't want to convert them to datetime.