troubleshooting Question

dataframe python

Avatar of ocean O
ocean O asked on
Python* python3
3 Comments1 Solution33 ViewsLast Modified:
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
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros