execute.log

$ spss2py -v 0 execute data/q2-scripts-reduced/reduced/1.hdf data/q2-scripts-reduced/processed/2_statements.csv data/q2-scripts-reduced/processed/2_out.hdf
20170703 21:03:05:root:INFO - ######### STARTING #########
20170703 21:03:05:root:DEBUG - Received command line arguments: 
Namespace(data='data/q2-scripts-reduced/reduced/1.hdf', func=<function execute at 0x7f30159812f0>, output='data/q2-scripts-reduced/processed/2_out.hdf', statements=<_io.TextIOWrapper name='data/q2-scripts-reduced/processed/2_statements.csv' mode='r' encoding='UTF-8'>, verbosity=0)
<class 'pandas.core.frame.DataFrame'>
Int64Index: 72423 entries, 0 to 72422
Columns: 4861 entries, A1 to uid
dtypes: float16(4651), float32(7), int16(1), int8(184), object(18)
memory usage: 667.7+ MB
20170703 21:03:07:spss2py.executer:DEBUG - 
None
20170703 21:03:07:spss2py.executer:DEBUG - Data and statements loaded. Executing statements.
20170703 21:03:07:spss2py.executer:DEBUG - Starting to process dataframe
20170703 21:03:07:spss2py.executer:DEBUG - 0: assign, {'target': 'q2d_1', 'value': 1, 'condition': '(q2d==1)'}
20170703 21:03:07:spss2py.executer:DEBUG - Assigning only to 13693 rows
20170703 21:03:07:spss2py.executer:DEBUG - 1: assign, {'target': 'q2d_2', 'value': 1, 'condition': '(q2d==2)'}
20170703 21:03:07:spss2py.executer:DEBUG - Assigning only to 34702 rows
20170703 21:03:07:spss2py.executer:DEBUG - 2: assign, {'target': 'q2d_3', 'value': 1, 'condition': '(q2d==3)'}
20170703 21:03:08:spss2py.executer:DEBUG - Assigning only to 18195 rows
20170703 21:03:08:spss2py.executer:DEBUG - 3: assign, {'target': 'q2d_4', 'value': 1, 'condition': '(q2d==4)'}
20170703 21:03:08:spss2py.executer:DEBUG - Assigning only to 5833 rows
20170703 21:03:08:spss2py.executer:DEBUG - 4: assign, {'target': 'q1d_1_1', 'value': 1, 'condition': '(q1d_1==1)'}
20170703 21:03:08:spss2py.executer:DEBUG - Assigning only to 40155 rows
... skipping ... 
20170703 21:22:18:spss2py.executer:DEBUG - 737: assign, {'target': 'q21_7_5', 'value': 1, 'condition': '(q21_q21_7==5)'}
20170703 21:22:18:spss2py.executer:DEBUG - Assigning only to 12588 rows
20170703 21:22:19:spss2py.executer:DEBUG - 738: assign, {'value': 'q20_62_1', 'target': 'r2021a_1', 'mapping': {1: 1}}
20170703 21:22:19:spss2py.executer:WARNING - Interpreting q20_62_1 as a column name.
20170703 21:22:19:spss2py.executer:DEBUG - Mapping according to {1: 1}
20170703 21:22:19:spss2py.executer:DEBUG - 739: assign, {'value': 'q20_62_2', 'target': 'r2021b_1', 'mapping': {1: 1}}
20170703 21:22:19:spss2py.executer:WARNING - Interpreting q20_62_2 as a column name.
20170703 21:22:19:spss2py.executer:DEBUG - Mapping according to {1: 1}
20170703 21:22:20:spss2py.executer:DEBUG - 740: assign, {'value': 'q20_62_3', 'target': 'r2021c_1', 'mapping': {1: 1}}
20170703 21:22:20:spss2py.executer:WARNING - Interpreting q20_62_3 as a column name.
20170703 21:22:20:spss2py.executer:DEBUG - Mapping according to {1: 1}
20170703 21:22:20:spss2py.executer:DEBUG - 741: assign, {'value': 'q20_62_4', 'target': 'r2021d_1', 'mapping': {1: 1}}
20170703 21:22:20:spss2py.executer:WARNING - Interpreting q20_62_4 as a column name.
20170703 21:22:20:spss2py.executer:DEBUG - Mapping according to {1: 1}
20170703 21:22:21:spss2py.executer:DEBUG - 742: assign, {'value': 'q20_62_5', 'target': 'r2021e_1', 'mapping': {1: 1}}
20170703 21:22:21:spss2py.executer:WARNING - Interpreting q20_62_5 as a column name.
20170703 21:22:21:spss2py.executer:DEBUG - Mapping according to {1: 1}
20170703 21:22:21:spss2py.executer:DEBUG - 743: assign, {'value': 'q20_22_1', 'target': 'r2021a_2', 'mapping': {1: 1}}
20170703 21:22:21:spss2py.executer:WARNING - Interpreting q20_22_1 as a column name.
20170703 21:22:21:spss2py.executer:DEBUG - Mapping according to {1: 1}
20170703 21:22:22:spss2py.executer:DEBUG - 744: assign, {'value': 'q20_22_2', 'target': 'r2021b_2', 'mapping': {1: 1}}
20170703 21:22:22:spss2py.executer:WARNING - Interpreting q20_22_2 as a column name.
20170703 21:22:22:spss2py.executer:DEBUG - Mapping according to {1: 1}
20170703 21:22:17:spss2py.executer:DEBUG - 736: assign, {'target': 'q21_7_4', 'value': 1, 'condition': '(q21_q21_7==4)'}
20170703 21:22:17:spss2py.executer:DEBUG - Assigning only to 18189 rows
20170703 21:22:18:spss2py.executer:DEBUG - 737: assign, {'target': 'q21_7_5', 'value': 1, 'condition': '(q21_q21_7==5)'}
20170703 21:22:18:spss2py.executer:DEBUG - Assigning only to 12588 rows
20170703 21:22:19:spss2py.executer:DEBUG - 738: assign, {'value': 'q20_62_1', 'target': 'r2021a_1', 'mapping': {1: 1}}
20170703 21:22:19:spss2py.executer:WARNING - Interpreting q20_62_1 as a column name.
20170703 21:22:19:spss2py.executer:DEBUG - Mapping according to {1: 1}
20170703 21:22:19:spss2py.executer:DEBUG - 739: assign, {'value': 'q20_62_2', 'target': 'r2021b_1', 'mapping': {1: 1}}
20170703 21:22:19:spss2py.executer:WARNING - Interpreting q20_62_2 as a column name.
20170703 21:22:19:spss2py.executer:DEBUG - Mapping according to {1: 1}
20170703 21:22:20:spss2py.executer:DEBUG - 740: assign, {'value': 'q20_62_3', 'target': 'r2021c_1', 'mapping': {1: 1}}
20170703 21:22:20:spss2py.executer:WARNING - Interpreting q20_62_3 as a column name.
20170703 21:22:20:spss2py.executer:DEBUG - Mapping according to {1: 1}
20170703 21:22:20:spss2py.executer:DEBUG - 741: assign, {'value': 'q20_62_4', 'target': 'r2021d_1', 'mapping': {1: 1}}
20170703 21:22:20:spss2py.executer:WARNING - Interpreting q20_62_4 as a column name.
20170703 21:22:20:spss2py.executer:DEBUG - Mapping according to {1: 1}
20170703 21:22:21:spss2py.executer:DEBUG - 742: assign, {'value': 'q20_62_5', 'target': 'r2021e_1', 'mapping': {1: 1}}
20170703 21:22:21:spss2py.executer:WARNING - Interpreting q20_62_5 as a column name.
20170703 21:22:21:spss2py.executer:DEBUG - Mapping according to {1: 1}
20170703 21:22:21:spss2py.executer:DEBUG - 743: assign, {'value': 'q20_22_1', 'target': 'r2021a_2', 'mapping': {1: 1}}
20170703 21:22:21:spss2py.executer:WARNING - Interpreting q20_22_1 as a column name.
20170703 21:22:21:spss2py.executer:DEBUG - Mapping according to {1: 1}
20170703 21:22:22:spss2py.executer:DEBUG - 744: assign, {'value': 'q20_22_2', 'target': 'r2021b_2', 'mapping': {1: 1}}
20170703 21:22:22:spss2py.executer:WARNING - Interpreting q20_22_2 as a column name.
20170703 21:22:22:spss2py.executer:DEBUG - Mapping according to {1: 1}
20170703 21:22:22:spss2py.executer:DEBUG - 745: assign, {'value': 'q20_22_3', 'target': 'r2021c_2', 'mapping': {1: 1}}
20170703 21:22:22:spss2py.executer:WARNING - Interpreting q20_22_3 as a column name.
20170703 21:22:22:spss2py.executer:DEBUG - Mapping according to {1: 1}
20170703 21:22:24:spss2py.executer:DEBUG - 746: assign, {'value': 'q20_22_4', 'target': 'r2021d_2', 'mapping': {1: 1}}
20170703 21:22:24:spss2py.executer:WARNING - Interpreting q20_22_4 as a column name.
20170703 21:22:24:spss2py.executer:DEBUG - Mapping according to {1: 1}
20170703 21:22:32:spss2py.executer:DEBUG - 747: assign, {'value': 'q20_22_5', 'target': 'r2021e_2', 'mapping': {1: 1}}
20170703 21:22:33:spss2py.executer:WARNING - Interpreting q20_22_5 as a column name.
20170703 21:22:33:spss2py.executer:DEBUG - Mapping according to {1: 1}
20170703 21:22:53:spss2py.executer:DEBUG - 748: assign, {'value': 'q21a_17_1', 'target': 'r2021a_3', 'mapping': {1: 1}}
20170703 21:22:53:spss2py.executer:WARNING - Interpreting q21a_17_1 as a column name.
20170703 21:22:53:spss2py.executer:DEBUG - Mapping according to {1: 1}
20170703 21:23:04:spss2py.executer:DEBUG - 749: assign, {'value': 'q21a_17_2', 'target': 'r2021b_3', 'mapping': {1: 1}}
20170703 21:23:04:spss2py.executer:WARNING - Interpreting q21a_17_2 as a column name.
20170703 21:23:04:spss2py.executer:DEBUG - Mapping according to {1: 1}
[1]    5081 killed     spss2py -v 0 execute data/q2-scripts-reduced/reduced/1.hdf