pandas to_sql incorrect column name error

Question

data.to_sql('sample_table',mysql_engine, if_exists= 'replace', index = False)

When I run the above line, I get the error:

error_message

Why am I getting this? I am trying to write data to a mysql_db.

In the future please include the full error message as text. — IanS
– IanS, Commented Dec 14, 2016 at 10:30

IanS · Accepted Answer · 2016-12-14 10:26:35Z

2

Your data has a column 'Point_of_reference ' with a trailing space at the end that makes the name invalid.

To fix it, remove all trailing and leading whitespace from your column names:

data.columns = data.columns.str.strip()

answered Dec 14, 2016 at 10:26

IanS

16.3k9 gold badges64 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thanks Ian and sorry for posting the question improperly, have not used much of stack overflow, but thanks for the help.