How are you! First off, why do you need de time as index, maybe you can reconsider that idea?
Anyway using datetime should work and the chances to get a duplicate record is minimal
In timeseries analysis I want to set date as an index but one date has 500 entries 50 for each item and 10 for each store. In such case how can I make date as an index.
How to make date as an index in timeseries analysis if I have duplicate dates for each item and store in dataset