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):
conn = get_connection_handle()
conn.autocommit = True
cursor = conn.cursor()
if execution_type == _READ:
results = cursor.fetchmany(4000)
if not results:
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?