ocean O
asked on
dataframe python
HI, I have a question about dataframe. I had used fetchmany to fetch data from cursor multiple times. Each time after I fetch the data, I need append to a dataframe. How can I do it?
def db_execute(sql, execution_type):
try:
conn = get_connection_handle()
conn.autocommit = True
cursor = conn.cursor()
cursor.execute(sql)
if execution_type == _READ:
while True:
results = cursor.fetchmany(4000)
if not results:
break
data = pd.DataFrame(results)
// how can I append the new dataframe to the previous dataframe, so at the end of the loop, I can get one dataframe with all the data?
cursor.close()
close_connection_handle(co nn)
return results
def db_execute(sql, execution_type):
try:
conn = get_connection_handle()
conn.autocommit = True
cursor = conn.cursor()
cursor.execute(sql)
if execution_type == _READ:
while True:
results = cursor.fetchmany(4000)
if not results:
break
data = pd.DataFrame(results)
// how can I append the new dataframe to the previous dataframe, so at the end of the loop, I can get one dataframe with all the data?
cursor.close()
close_connection_handle(co
return results
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you very much!
ASKER