Python & Pandas : TypeError: to_sql() got an unexpected keyword argument 'flavor' 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?
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.