Python Script 2: IRR Calculation

[mattm401]

I need a python script that can convert the export from the database into the document that we need to run our IRR calculations. I will push some example files to our repository in my next push.

• IRR1_189_Exported.csv: This file is what I am able to extract from the database using the following SQL SELECT elements.externalId, elementLabels.elementId, elementLabels.labelId, elementLabels.userId FROM elementLabels join elements on elementLabels.elementId = elements.elementId order by elementLabels.elementId ASC

I need the python script to convert this out CSV into the following XLS file: IRR1_Recal_Input.xls

Then, save copy of the file without the first element column in it and as a CSV.

You should then be able to run this csv file through the following website: http://dfreelon.org/utils/recalfront/recal2/

and get the same results as in: IRR1_Recal_Output.csv

• Your script should be able to handle the number of fields (label count x2) automatically if possible.
• Column names with the identification of user is important for verification (e.g., "Product Review (2)" refers to the user_id 2 in the database.

[mattm401]

You should practice running the SQL code in the DB Viewer and exporting the resulting data as a CSV; play around with running other SQL commands (i.e., can you pull only your records)? Can you count the number of times you labeled a video with a 7? Can you tell how many videos were labeled with each label? You can experiment with SQL queries to answer all these questions if you want to become an expert in working with Databases.

[mattm401]

@skushnir123 see my last commit, the output from the script doesn't match.

[mattm401]

@skushnir123 see commit