wiscbc_dataset_to_td.py

df = pd.read_csv("./datasets/Wisconsin_breast_prognostic.csv")

df.columns = ['radius_mean', 'texture_mean', 'perimeter_mean', 'area_mean',
       'smoothness_mean', 'compactness_mean', 'concavity_mean',
       'concave_points_mean', 'symmetry_mean', 'fractal_dimension_mean',
       'radius_se', 'texture_se', 'perimeter_se', 'area_se', 'smoothness_se',
       'compactness_se', 'concavity_se', 'concave_points_se', 'symmetry_se',
       'fractal_dimension_se', 'radius_worst', 'texture_worst',
       'perimeter_worst', 'area_worst', 'smoothness_worst',
       'compactness_worst', 'concavity_worst', 'concave_points_worst',
       'symmetry_worst', 'fractal_dimension_worst', 'diagnosis']

df = df.reset_index()
df.head()


host = '192.xxx.yyy.zzz'
user = 'sysdba'
pw = 'sysdba'

td_engine = sqlalchemy.create_engine(f"teradatasql://{user}:{pw}@{host}")
df.to_sql('wiscbc', td_engine, if_exists='append', index=False)