Python & Pandas : TypeError: to_sql() got an unexpected keyword argument 'flavor'

Question

I want to store JSON Data into MySQL Database using Python. I used dataframe of pandas. I found that to_sql() can do this job easily.

Python Code:

jdata=json.loads(json_data)
df=pandas.DataFrame(jdata)
df.to_sql(con=con, name='crashTable', if_exists='replace', flavor='mysql')

Output:

TypeError: to_sql() got an unexpected keyword argument 'flavor'

I got this error message. How to resolve this error?

Answer 1

Based on the documentation 0.22 and 0.24.1, the flavor does not exist in the argument list of the to_sql method. You're probably running the 0.24.1 version which does not need flavor argument.