python - Dataframe to SQL server

import numpy as np  import pandas as pd    df = pd.DataFrame({'num_legs': [2, 4, 8, 0],                 'num_wings': [2, 0, 0, 0],                 'num_specimen_seen': [8, 2, 5, 6]},               )  print(df)  

I have a table in SQL server called : Animal columns : Legs,wings,SpecSeen

ServerName: SQL15A  Database: Habitat  SQL username: QATuser  Password: pswd2    I need to insert this dataframe to sql server table, also dataframe index   column need not to be inserted to database  

https://stackoverflow.com/questions/66072844/python-dataframe-to-sql-server February 06, 2021 at 09:52AM