blob: eae44af3a1caa03d2faea1c5fd093bc5a635f809 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
import pandas as pd
from db import dbengine
engine = dbengine('serenitasdb')
df1 = pd.read_sql_query("SELECT date FROM test", engine)
df2 = pd.read_sql_query("SELECT date FROM test WHERE date<='2014-10-17'",
engine)
df2bis = pd.read_sql_query("SELECT date FROM test WHERE date<='2014-10-17'",
engine, parse_dates=['date'])
df3 = pd.read_sql_query("SELECT date FROM test", engine,
parse_dates=['date'])
# df4 = pd.read_sql_query("SELECT date FROM index_quotes " \
# "WHERE date BETWEEN '2016-10-01' AND '2016-11-30'", engine,
# index_col='date')
# CREATE TABLE test(date timestamptz);
# INSERT INTO test VALUES('2014-10-16 07:50:49-04'),('2014-11-06 07:42:06-05')
|
