Skip to main content

Return to Question

Notice removed Draw attention by tumultous_rooster
Bounty Ended with alecxe's answer chosen by tumultous_rooster
Notice added Draw attention by tumultous_rooster
Bounty Started worth 50 reputation by tumultous_rooster
edited title
Link
Monica Heddneck
Monica Heddneck
  • 3.2k
  • 11
  • 59
  • 94

create Create a temporary table in MySQL using Pandas

Source Link
Monica Heddneck
Monica Heddneck
  • 3.2k
  • 11
  • 59
  • 94

create a temporary table using Pandas

Pandas has a great feature, where you can write your dataframe to a table in SQL.

df.to_sql(con=cnx, name='some_table_name', if_exists='replace', flavor='mysql', index=False)

Is there a way to make a temporary table this way?

There is nothing in the documentation as far as I can tell.