troubleshooting Question

dataframe python

Avatar of ocean O
ocean O asked on
* python3Python
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):
        conn = get_connection_handle()
        conn.autocommit = True
        cursor = conn.cursor()
        if execution_type == _READ:
            while True:
                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?

        return results
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
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