troubleshooting Question
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(co
return results
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(co
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.
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.