hdkmraf

Data Science Challenge

The purpose of this challenge is to assist us in evaluating candidates for a role in our Data Science team. We only pass this challenge to candidates that we feel have a solid background and could be a good fit for our team. We appreciate you taking this time to help ensure we are a good match for each other.

Tips

Include code, graphics and text in a combined output. Tell a story, and let us understand as clearly as possible your thoughts and analytical process.

Part 1: Experiment design

hdkmraf

Convert sequence of JPEG images to MP4 video

ffmpeg -r 24 -pattern_type glob -i '*.JPG' -i DSC_%04d.JPG -s hd1080 -vcodec libx264 timelapse.mp4

• -r 24 - output frame rate
• -pattern_type glob -i '*.JPG' - all JPG files in the current directory
• -i DSC_%04d.JPG - e.g. DSC_0397.JPG
• -s hd1080 - 1920x1080 resolution

Slower, better quality

hdkmraf

#!/bin/bash

# Converts txt files to mp3, output goes into same directory as input
# Usage:
#   ./text_to_mp3.sh input_file
# Requirements:
#   say, ffmpeg
# $1 - filepath
echo "Input text $1"
say -f $1 -o "$1.aiff"

hdkmraf

import itertools
import MySQLdb
import pp
from operator import truediv, mul
from itertools import starmap
from functools import reduce


def writeCreateQuery (tableId, columns, table_name, connect_data, label):
    conn = MySQLdb.connect (connect_data[0], connect_data[1], connect_data[2], connect_data[3])