import pandas
from sqlalchemy import create_engine

engine = create_engine("taosrest://root:taosdata@localhost:6041")
df: pandas.DataFrame = pandas.read_sql("SELECT * FROM power.meters", engine)

# print index
print(df.index)
# print data type  of element in ts column
print(type(df.ts[0]))
print(df.head(3))

# output:
# <class 'datetime.datetime'>
# RangeIndex(start=0, stop=8, step=1)
#                                  ts  current  ...          location  groupid
# 0         2018-10-03 14:38:05+08:00     10.3  ...  beijing.chaoyang        2
# 1         2018-10-03 14:38:15+08:00     12.6  ...  beijing.chaoyang        2
# 2  2018-10-03 14:38:16.800000+08:00     12.3  ...  beijing.chaoyang        2