Hi All, I have 7000+ records in a SQL Server table with 3 columns, which uniquely identify each record (I didn't define them as composite primary key).
I load these 7000+ records into a Pandas DataFrame and update a subset of these records. What's the optimal way to update this subset of records to SQL table? I'm hesitant to using DataFrame.to_sql(...., if_exists="replace") as it removes unchanged records too and adds them alongwith the updated ones. Please advise. Thank you! Venkat Kolla _______________________________________________ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: https://mail.python.org/mailman/listinfo/tutor
