Converts a Loop11 data set (CSV) into an SQLite database
Python 3
dateparser pip install dateparser. See docs for more info http://dateparser.readthedocs.io/en/latest/
convert-loop11-csv.py --csv=[file] [--db==[file]]
csv is the Loop11 data, db is output database name
All data from the CSV file is loaded into 5 tables:
- participants
- questions
- tasks
- question_response
- task_response
participants are joined to questions and tasks via the *response tables
Code for adding inserting a usertype column into the participants table based on a prepared csv file.
Usage add-usertype-to-db.py --csv=[file] --db==[file]