search

kennethreitz / records

SQL for Humans™
https://pypi.python.org/pypi/records/
ISC License
7.15k stars 570 forks source link

datetimes lost in conversion #130

Open frenchja opened 6 years ago

frenchja commented 6 years ago

I'm not yet sure if the issue is with records or tablib.

  1. Generate some rows from a query: records.Database().query()
  2. Export to a Pandas DataFrame: rows.export('df')
  3. Resulting timestamps are seen as objects in Pandas.

However, if you instead generate the dataframe directly from the dict, it works:

pandas_table = pd.DataFrame(rows.as_dict())
vlcinsky commented 6 years ago

Could you provide reproducible case with piece of code? Creating the table, query to run.