DEV Community

Cover image for Solving Pandas .to_sql Double Quotes Issue When Writing to Database
Luca Liu
Luca Liu

Posted on • Edited on

Solving Pandas .to_sql Double Quotes Issue When Writing to Database

#python #database #dataengineering #tutorial

I have found a solution to the frustrating issue of using pandas to save a dataframe into a database and finding that the column names are encased in double quotes.

By setting the column names to uppercase before writing the dataframe to the database, the double quotes problem can be completely circumvented. 



df.columns.str.upper()
Enter fullscreen mode Exit fullscreen mode

When creating the table structure in the database, please ensure that your column names are in uppercase.



CREATE TABLE table_name
(
    COLUMN1     VARCHAR2(50),
    COLUMN2     VARCHAR2(50),
    COLUMN3     Integer
);
Enter fullscreen mode Exit fullscreen mode

Explore more

luca1iu image

Luca Liu

Hello there! 👋 I'm Luca, a Business Intelligence Developer with passion for all things data. Proficient in Python, SQL, Power BI, Tableau, SAP Business Objects.

Thank you for taking the time to explore data-related insights with me. I appreciate your engagement.

🚀 Connect with me on LinkedIn

🎃 Connect with me on X

🌍 Connect with me on Instagram

Top comments (0)

Read next

punkpeye profile image

Building ask-PDF service using LLMs

Frank Fiegel -

krillinkills profile image

Mastering Dynamic Allocation in Apache Spark: A Practical Guide with Real-World Insights

Vaibhav Shirpurkar -

webjose profile image

How to Use TypeScript to Accumulate Types: Typing ALL possible fetch() Results

José Pablo Ramírez Vargas -

manjushsh profile image

Setup Elementum addon on Kodi - Basic

Manjush -