Solving Pandas .to_sql Double Quotes Issue When Writing to Database

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()

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
);

Explore more

Luca LiuFollow

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