Set columns.
Eg convert to pandas datetime 64.
df = pd.DataFrame(table, columns=['DateTime', 'Amount', 'Ref', 'DrCode', 'CrCode'])[Image: xW66Og.jpg]
Eg convert to pandas datetime 64.
in [3]: df['DateTime'] = pd.to_datetime(df['DateTime']) In [4]: df.dtypes Out[4]: DateTime datetime64[ns] Amount int64 Ref object DrCode int64 CrCode int64 dtype: object