Link to home
Start Free TrialLog in
Avatar of ocean O
ocean OFlag for United States of America

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(conn)
        return results
ASKER CERTIFIED SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ocean O

ASKER

Thank you very much!
Avatar of ocean O

ASKER

Thank you very much!