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(conn)
return results
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.