TypeError: cannot concatenate a non-NDFrame object
If length of df is same as DatetimeIndex and need create index: If not try filter by length of index what is same as length of df: If need new column: If not: If need use only first 5 values: EDIT: I think you need union for concatenate index to dates and then reindex: