Return a dictionary of SQL datatypes inferred from a pandas dataframe for use with df.to_sql()

df_sql_type.py

import sqlalchemy as sa

def sql_type(data_frame):
    """Return a dict of sql types inferred from pandas type"""
    type_dict = {}
    for i, j in zip(data_frame.columns, data_frame.dtypes):
        if 'float' in str(j):
            type_dict.update({i: sa.types.Float(precision=5,
                                                asdecimal=True)})
        elif 'object' in str(j):
            type_dict.update({i: sa.types.NVARCHAR(length=1000)})
        elif 'datetime' in str(j):
            type_dict.update({i: sa.types.DateTime()})
        elif 'int' in str(j):
            type_dict.update({i: sa.types.INT()})
        else:
            type_dict.update({i: sa.types.NVARCHAR(length=1000)})
    return type_dict