messytest1.py

#!/usr/bin/env python
# run with messytables 0.3.0 and 0.4.0, does not work in 0.4.0
import messytables as ms


def main():
    with open('testdata/xls/simple.xls') as f:
        table_set = ms.excel.XLSTableSet.from_fileobj(f)
        row_set = table_set.tables[0]
        types = ms.types.type_guess(row_set.sample)
        print types


if __name__ == '__main__':
    main()

messytest2.py

#!/usr/bin/env python
# In both 0.3.0 and 0.4.0, types prints what is a DateTime field as String. guess_types gets the field right for a CSV file though.
import messytables as ms


def main():
    with open('testdata/xls/simple.xls') as f:
        table_set = ms.excel.XLSTableSet.from_fileobj(f)
        row_set = table_set.tables[0]
        guess_types = [ms.types.StringType, ms.types.IntegerType, ms.types.FloatType, ms.types.DecimalType, ms.types.DateUtilType]
        types = ms.types.type_guess(row_set.sample)
        print types


if __name__ == '__main__':
    main()

messytest3.py

#!/usr/bin/env python

import messytables as ms


def main():
    with open('testdata/csv/simple.csv') as f:
        table_set = ms.commas.CSVTableSet.from_fileobj(f)
        row_set = table_set.tables[0]
        guess_types = [ms.types.StringType, ms.types.IntegerType, ms.types.FloatType, ms.types.DecimalType, ms.types.DateUtilType]
        types = ms.types.type_guess(row_set.sample, guess_types)
        print types


if __name__ == '__main__':
    main()