Converting A Datetime Column To A Datetimeindex In Pandas

There are so many questions that revolve around converting dates to a datetimeindex. I personally need a datetimeindex to work with the Calmap package that requires the datetimeind

Solution 1:

Try concat Date and Time before setting index. Use df.column.str.cat(colum1, sep=' ')

print(df)

NameTimeDate0FNameLName12:00PM10/5/201FNameLName12:00PM10/5/202FNameLName12:00PM10/5/203FNameLName12:00PM10/5/204FNameLName12:00PM10/5/205FNameLName12:00PM10/5/206FNameLName12:00PM10/5/20df['datetime']=pd.to_datetime(df['Date'].str.cat(df.Time,sep=''))
df.set_index(df['datetime'],inplace=True)print(df)NameTimeDatedatetimedatetime2020-10-05 12:00:00  FNameLName12:00PM10/5/202020-10-05 12:00:002020-10-05 12:00:00  FNameLName12:00PM10/5/202020-10-05 12:00:002020-10-05 12:00:00  FNameLName12:00PM10/5/202020-10-05 12:00:002020-10-05 12:00:00  FNameLName12:00PM10/5/202020-10-05 12:00:002020-10-05 12:00:00  FNameLName12:00PM10/5/202020-10-05 12:00:002020-10-05 12:00:00  FNameLName12:00PM10/5/202020-10-05 12:00:002020-10-05 12:00:00  FNameLName12:00PM10/5/202020-10-05 12:00:00