csv_to_ddb.py

import csv

def detect_type(t, s):
    if s is '':
        print(f'{t} is unknown type')
        return {t: 'null'}
    if s.isdigit():
        print(f'{t} is an int')
        return {t: 'int'}
    else:
        try:
            num = float(s)
            print(f'{t} is an float')
            return {t: 'float'}
        except ValueError:
            pass
        if s.lower() in ['true']:
            print(f'{t} is a bool')
            return {t: 'bool'}
        elif s.lower() in ['false']:
            print(f'{t} is a bool')
            return {t: 'bool'}
        else:
            print(f'{t} is a string')
            return {t: 'string'}



with open('people.csv') as convert_file:
    reader = csv.DictReader(convert_file)
    examples = next(reader)
    convert_file.seek(0)
    next(reader)
    types = {}
    [types.update(d) for d in [detect_type(d, examples[d]) for d in examples]]
    print(types)
    with open('table_map.csv', 'w') as table_map:
        writer = csv.DictWriter(table_map, fieldnames=reader.fieldnames)
        writer.writeheader()
        writer.writerow(types)
        # [detect_type(x) for x in data]

people.csv

table_map.csv