Pandas how to append data in the same DataFrame using a for loop? [duplicate]

Question

For now my code looks like this:

conn = psycopg2.connect("dbname=monty user=postgres host=localhost password=postgres")
cur = conn.cursor()
cur.execute("SELECT * FROM binance.zrxeth_ob_indicators;")
for row in cur:
  df = pd.DataFrame(row,columns=['timestamp', 'topAsk', 'topBid', 'CPA', 'midprice', 'CPB', 'spread', 'CPA%', 'CPB%'])

But the data are not added to the dataframe, it just creates a new one? Any idea on how to append to the existing same DataFrame? Thanks!

Do you mean for row in cur.fetchall()?

Mortz
– Mortz

2019-01-04 12:19:48 +00:00
Commented Jan 4, 2019 at 12:19 — Mortz
– Mortz, Commented Jan 4, 2019 at 12:19

Bruno Carballo · Accepted Answer · 2019-01-04 12:27:39Z

0

Have you tried

df=pd.read_sql_query(“””select * from table “””, conn)

It will read all the the query results directly into a dataframe

answered Jan 4, 2019 at 12:27

Bruno Carballo

1,20610 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Pandas how to append data in the same DataFrame using a for loop? [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related