TextFile: opening file td8_velib.txt
TextFile.guess_columns: processing file td8_velib.txt
TextFile: opening file td8_velib.txt
TextFile.guess_columns: using 101 lines
TextFile: closing file td8_velib.txt
TextFile.guess_columns: sep '\t' nb cols 7 bestnb 101 more {('\t', 6): 101, (' ', 2): 100}
TextFile.guess_columns: header True columns {0: ('collect_date', <class 'str'>), 1: ('last_update', <class 'str'>), 2: ('available_bike_stands', <class 'int'>), 3: ('available_bikes', <class 'int'>), 4: ('number', <class 'int'>), 5: ('heure', <class 'int'>), 6: ('minute', <class 'int'>)}
compiling ^(?P<collect_date>.*)\t(?P<last_update>.*)\t(?P<available_bike_stands>([-]?[1-9][0-9]*?)|(0?))\t(?P<available_bikes>([-]?[1-9][0-9]*?)|(0?))\t(?P<number>([-]?[1-9][0-9]*?)|(0?))\t(?P<heure>([-]?[1-9][0-9]*?)|(0?))\t(?P<minute>([-]?[1-9][0-9]*?)|(0?))$
TextFile.guess_columns: regex ^(?P<collect_date>.*)\t(?P<last_update>.*)\t(?P<available_bike_stands>([-]?[1-9][0-9]*?)|(0?))\t(?P<available_bikes>([-]?[1-9][0-9]*?)|(0?))\t(?P<number>([-]?[1-9][0-9]*?)|(0?))\t(?P<heure>([-]?[1-9][0-9]*?)|(0?))\t(?P<minute>([-]?[1-9][0-9]*?)|(0?))$
TextFile.guess_columns: header True columns {0: ('collect_date', (<class 'str'>, 52)), 1: ('last_update', (<class 'str'>, 38)), 2: ('available_bike_stands', <class 'int'>), 3: ('available_bikes', <class 'int'>), 4: ('number', <class 'int'>), 5: ('heure', <class 'int'>), 6: ('minute', <class 'int'>)}
[_guess_columns] sep=['\t']
TextFile: closing file td8_velib.txt
[_guess_columns] columns_name=None
guess with 1001 lines
count_types {0: {<class 'str'>: 1000}, 1: {<class 'str'>: 1000}, 2: {<class 'int'>: 1000}, 3: {<class 'int'>: 1000}, 4: {<class 'int'>: 1000}, 5: {<class 'int'>: 1000}, 6: {<class 'int'>: 1000}}
columns {0: ('collect_date', <class 'str'>), 1: ('last_update', <class 'str'>), 2: ('available_bike_stands', <class 'int'>), 3: ('available_bikes', <class 'int'>), 4: ('number', <class 'int'>), 5: ('heure', <class 'int'>), 6: ('minute', <class 'int'>)}
guess {0: ('collect_date', (<class 'str'>, 52)), 1: ('last_update', (<class 'str'>, 38)), 2: ('available_bike_stands', <class 'int'>), 3: ('available_bikes', <class 'int'>), 4: ('number', <class 'int'>), 5: ('heure', <class 'int'>), 6: ('minute', <class 'int'>)}
SQL 'CREATE TABLE td8_velib(collect_date TEXT,'
' last_update TEXT,'
' available_bike_stands INTEGER,'
' available_bikes INTEGER,'
' number INTEGER,'
' heure INTEGER,'
' minute INTEGER);'
column_has_space False ['collect_date', 'last_update', 'available_bike_stands', 'available_bikes', 'number', 'heure', 'minute']
changes {}
TextFileColumns (2): regex: {0: ('collect_date', (<class 'str'>, 52)), 1: ('last_update', (<class 'str'>, 38)), 2: ('available_bike_stands', <class 'int'>), 3: ('available_bikes', <class 'int'>), 4: ('number', <class 'int'>), 5: ('heure', <class 'int'>), 6: ('minute', <class 'int'>)}
TextFile.guess_columns: processing file td8_velib.txt
TextFile: opening file td8_velib.txt
TextFile.guess_columns: using 101 lines
TextFile: closing file td8_velib.txt
TextFile.guess_columns: sep '\t' nb cols 7 bestnb 101 more {('\t', 6): 101, (' ', 2): 100}
TextFile.guess_columns: header True columns {0: ('collect_date', <class 'str'>), 1: ('last_update', <class 'str'>), 2: ('available_bike_stands', <class 'int'>), 3: ('available_bikes', <class 'int'>), 4: ('number', <class 'int'>), 5: ('heure', <class 'int'>), 6: ('minute', <class 'int'>)}
compiling ^(?P<collect_date>.*)\t(?P<last_update>.*)\t(?P<available_bike_stands>([-]?[1-9][0-9]*?)|(0?))\t(?P<available_bikes>([-]?[1-9][0-9]*?)|(0?))\t(?P<number>([-]?[1-9][0-9]*?)|(0?))\t(?P<heure>([-]?[1-9][0-9]*?)|(0?))\t(?P<minute>([-]?[1-9][0-9]*?)|(0?))$
TextFile.guess_columns: regex ^(?P<collect_date>.*)\t(?P<last_update>.*)\t(?P<available_bike_stands>([-]?[1-9][0-9]*?)|(0?))\t(?P<available_bikes>([-]?[1-9][0-9]*?)|(0?))\t(?P<number>([-]?[1-9][0-9]*?)|(0?))\t(?P<heure>([-]?[1-9][0-9]*?)|(0?))\t(?P<minute>([-]?[1-9][0-9]*?)|(0?))$
TextFile.guess_columns: header True columns {0: ('collect_date', (<class 'str'>, 52)), 1: ('last_update', (<class 'str'>, 38)), 2: ('available_bike_stands', <class 'int'>), 3: ('available_bikes', <class 'int'>), 4: ('number', <class 'int'>), 5: ('heure', <class 'int'>), 6: ('minute', <class 'int'>)}
TextFile: opening file td8_velib.txt
adding 100000 lines into table td8_velib
adding 200000 lines into table td8_velib
adding 300000 lines into table td8_velib
adding 400000 lines into table td8_velib
adding 500000 lines into table td8_velib
adding 600000 lines into table td8_velib
adding 700000 lines into table td8_velib
adding 800000 lines into table td8_velib
adding 900000 lines into table td8_velib
adding 1000000 lines into table td8_velib
adding 1100000 lines into table td8_velib
^(?P<collect_date>.*)\t(?P<last_update>.*)\t(?P<available_bike_stands>([-]?[1-9][0-9]*?)|(0?))\t(?P<available_bikes>([-]?[1-9][0-9]*?)|(0?))\t(?P<number>([-]?[1-9][0-9]*?)|(0?))\t(?P<heure>([-]?[1-9][0-9]*?)|(0?))\t(?P<minute>([-]?[1-9][0-9]*?)|(0?))$
error regex 0 unable to interpret line 1103788 : ''
TextFile: closing file td8_velib.txt
1103787 lines imported
TextFile: opening file stations.txt
TextFile.guess_columns: processing file stations.txt
TextFile: opening file stations.txt
TextFile.guess_columns: using 101 lines
TextFile: closing file stations.txt
TextFile.guess_columns: sep '\t' nb cols 6 bestnb 101 more {('\t', 5): 101, (' ', 13): 3, (' ', 21): 1, (' ', 14): 2, (' ', 12): 11, (' ', 16): 2, (' ', 9): 24, (' ', 10): 21, (' ', 8): 13, (' ', 11): 10, (' ', 7): 12, (' ', 6): 1}
TextFile.guess_columns: header True columns {0: ('address', <class 'str'>), 1: ('contract_name', <class 'str'>), 2: ('lat', <class 'float'>), 3: ('lng', <class 'float'>), 4: ('name', <class 'str'>), 5: ('number', <class 'int'>)}
compiling ^(?P<address>.*)\t(?P<contract_name>.*)\t(?P<lat>[-]?[0-9]*?([.][0-9]*?)?([eE][-]?[0-9]{0,4})?)\t(?P<lng>[-]?[0-9]*?([.][0-9]*?)?([eE][-]?[0-9]{0,4})?)\t(?P<name>.*)\t(?P<number>([-]?[1-9][0-9]*?)|(0?))$
TextFile.guess_columns: regex ^(?P<address>.*)\t(?P<contract_name>.*)\t(?P<lat>[-]?[0-9]*?([.][0-9]*?)?([eE][-]?[0-9]{0,4})?)\t(?P<lng>[-]?[0-9]*?([.][0-9]*?)?([eE][-]?[0-9]{0,4})?)\t(?P<name>.*)\t(?P<number>([-]?[1-9][0-9]*?)|(0?))$
TextFile.guess_columns: header True columns {0: ('address', (<class 'str'>, 134)), 1: ('contract_name', (<class 'str'>, 10)), 2: ('lat', <class 'float'>), 3: ('lng', <class 'float'>), 4: ('name', (<class 'str'>, 98)), 5: ('number', <class 'int'>)}
[_guess_columns] sep=['\t']
TextFile: closing file stations.txt
[_guess_columns] columns_name=None
guess with 935 lines
count_types {0: {<class 'str'>: 934}, 1: {<class 'str'>: 934}, 2: {<class 'float'>: 934}, 3: {<class 'float'>: 934}, 4: {<class 'str'>: 934}, 5: {<class 'int'>: 934}}
columns {0: ('address', <class 'str'>), 1: ('contract_name', <class 'str'>), 2: ('lat', <class 'float'>), 3: ('lng', <class 'float'>), 4: ('name', <class 'str'>), 5: ('number', <class 'int'>)}
guess {0: ('address', (<class 'str'>, 152)), 1: ('contract_name', (<class 'str'>, 10)), 2: ('lat', <class 'float'>), 3: ('lng', <class 'float'>), 4: ('name', (<class 'str'>, 98)), 5: ('number', <class 'int'>)}
SQL 'CREATE TABLE stations(address TEXT,'
' contract_name TEXT,'
' lat FLOAT,'
' lng FLOAT,'
' name TEXT,'
' number INTEGER);'
column_has_space False ['address', 'contract_name', 'lat', 'lng', 'name', 'number']
changes {}
TextFileColumns (2): regex: {0: ('address', (<class 'str'>, 152)), 1: ('contract_name', (<class 'str'>, 10)), 2: ('lat', <class 'float'>), 3: ('lng', <class 'float'>), 4: ('name', (<class 'str'>, 98)), 5: ('number', <class 'int'>)}
TextFile.guess_columns: processing file stations.txt
TextFile: opening file stations.txt
TextFile.guess_columns: using 101 lines
TextFile: closing file stations.txt
TextFile.guess_columns: sep '\t' nb cols 6 bestnb 101 more {('\t', 5): 101, (' ', 13): 3, (' ', 21): 1, (' ', 14): 2, (' ', 12): 11, (' ', 16): 2, (' ', 9): 24, (' ', 10): 21, (' ', 8): 13, (' ', 11): 10, (' ', 7): 12, (' ', 6): 1}
TextFile.guess_columns: header True columns {0: ('address', <class 'str'>), 1: ('contract_name', <class 'str'>), 2: ('lat', <class 'float'>), 3: ('lng', <class 'float'>), 4: ('name', <class 'str'>), 5: ('number', <class 'int'>)}
compiling ^(?P<address>.*)\t(?P<contract_name>.*)\t(?P<lat>[-]?[0-9]*?([.][0-9]*?)?([eE][-]?[0-9]{0,4})?)\t(?P<lng>[-]?[0-9]*?([.][0-9]*?)?([eE][-]?[0-9]{0,4})?)\t(?P<name>.*)\t(?P<number>([-]?[1-9][0-9]*?)|(0?))$
TextFile.guess_columns: regex ^(?P<address>.*)\t(?P<contract_name>.*)\t(?P<lat>[-]?[0-9]*?([.][0-9]*?)?([eE][-]?[0-9]{0,4})?)\t(?P<lng>[-]?[0-9]*?([.][0-9]*?)?([eE][-]?[0-9]{0,4})?)\t(?P<name>.*)\t(?P<number>([-]?[1-9][0-9]*?)|(0?))$
TextFile.guess_columns: header True columns {0: ('address', (<class 'str'>, 134)), 1: ('contract_name', (<class 'str'>, 10)), 2: ('lat', <class 'float'>), 3: ('lng', <class 'float'>), 4: ('name', (<class 'str'>, 98)), 5: ('number', <class 'int'>)}
TextFile: opening file stations.txt
^(?P<address>.*)\t(?P<contract_name>.*)\t(?P<lat>[-]?[0-9]*?([.][0-9]*?)?([eE][-]?[0-9]{0,4})?)\t(?P<lng>[-]?[0-9]*?([.][0-9]*?)?([eE][-]?[0-9]{0,4})?)\t(?P<name>.*)\t(?P<number>([-]?[1-9][0-9]*?)|(0?))$
error regex 0 unable to interpret line 1232 : ''
TextFile: closing file stations.txt
1231 lines imported