Assignment on Programming Techniques for Big Data

Yoshi van den Akker and Georgios Gousios

Functional programming is the basis of most modern Big Data processing systems. Before going forward to the course, it is important to master data processing techniques using a functional programming style. In this assignment, your task is to train yourselves in thinking in a functional way when processing data.

Many of the the tasks below are easy, but some are not and require many iterations (and extensive testing!) to get right. For some of them, you can find ready-made solutions on the internet. Even though it may be tempting, we advise you against copying and pasting them here, as you will regret it later on in the course. Wax on, wax off!

This assignment has a total of 115 points. Your grade is calculated with min(points/11, 10), i.e. you need 110 points for a 10.

A few notes:

  • For each function you define, you also need to define at least one working example.
  • Do not change the given function signatures, otherwise automated tests will fail.
  • The tests will run every cell. Make sure no errors occur by testing this via Cell -> Run All.
  • The tests will call every function we ask you to implement. If you are skipping a question, make sure it still compiles. The way we provided this notebook works.
  • Use functional programming for every question (besides the first section).

Foundation of functional programming

In this part you will implement core functions that are vital to functional programming.

T (5pts): Implement map using iteration for lists/arrays

In [ ]:
def map[A,B](func: (A => B), xs: List[A]): List[B] = {
    return null
}

map((x:Int) => x*2, List.range(0,10))

T (5pts): Implement filter using iteration for lists/arrays

In [ ]:
def filter[A](func: (A => Boolean), xs: List[A]): List[A] = {
    return null
}

filter((x: Int) => (x % 2 == 0), List.range(0, 10))

T (5pts): Implement reduceR using iteration for lists/arrays

In [ ]:
def reduceR[A, B]( f : (A,B) => B, list: List[A], init: B) : B = {
    return init
}

reduceR((x: Int, y: Int) => x-y, List.range(0, 7), 0)

T (5pts): Implement a function flatten(xs: [[A]]): [A] that converts a list of lists into a list formed by the elements of these lists. For example:

>>> a = List(List(1,2,3),List(4,5), List(6), List(7,List(8,9)))
>>> flatten(a)
List(1, 2, 3, 4, 5, 6, 7, List(8, 9))
In [ ]:
def flatten[A](xs: List[List[A]]): List[A] = {
    return null
}


flatten(List(List(1,2,3),List(4,5), List(6), List(7,List(8,9))))

More basic functions

In every implementation from now (also in next steps)on you should reuse at least one of your answers to an earlier question.

T (5pts): Implement reduceL by reusing reduceR

In [ ]:
def reduceL[A, B](func: (B, A) => B, xs: List[A], init: B): B = {
    return init
}

reduceL((x: Int, y: Int) => x-y, List.range(0,7), 0)

T (10pts): Implement group_by by reusing reduceL.

In [ ]:
def group_by[A,B](theKeyFunction : (A) => B, xs: List[A]) : Map[B, List[A]] = {
    return null
}

group_by((x: Int) => if (x % 2 == 0) "even" else "odd", List.range(0,10))

Simple data processing

T (5pts): Implement distinct using reduceL.

In [ ]:
def distinct[A](xs: List[A]): List[A] = {
    return null
}

val a = List(1,2,3,1,2,3,4,5,6,5,4,3,2,1)
distinct(a)

T (5pts): Implement flatmap.

In [ ]:
def flatmap[A,B](func: A => List[B], xs: List[A]): List[B] = {
    return null
}

flatmap((x: Int) => List.range(0,x), List.range(0,5))

T (5pts): Implement max(xs: [Integer]): Integer that finds the largest value in xs. You can assume the list is non-empty.

In [ ]:
def max(xs: List[Int]): Int = {
    return 0
}

max(List(1,59,42,27,38))

Higher-order functions

T (10pts): Implement a function called drop_while(f: A -> Boolean, xs: [A]) : [A] that drops the longest prefix of elements from xs that satisfy f.

>>> a = List(1,2,3,4,3,2,1)
>>> dropWhile((x: Int) => x <= 3, a)
List(4,3,2,1)
In [ ]:
def drop_while[A](func: A => Boolean, xs: List[A]): List[A] = {
    return null
}

drop_while((x: Int) => x <= 3, List(1,2,1,3,5,3,1,4,1,5,6))

T (10pts): Implement a function zip(xs: [A], ys: [B]): List[(A,B)] that returns a list formed from this list and another list by combining the corresponding elements in pairs. If one of the two lists is longer than the other, its remaining elements are ignored.

>>> a = List(1,2,3,4)
>>> b = List(a,b,c,d,e)
>>> zip(a,b)
List((1,a),(2,b),(3,c), (4, d)]
In [ ]:
def zip[A,B](list1: List[A], list2: List[B]) : List[(A, B)] = {
    return null
}

val list1 = List(1, 2, 3, 4, 5, 6, 7)
val list2 = List('a', 'b', 'c', 'd')
zip(list1, list2)

T (10pts): Implement a function scanL(f: (acc: B, x: A) -> B, xs: [A], init: B) -> [B] that works like reduceL but instead of producing one final result, it also returns all the intermediate results.

>>> a = List(2,3,4)
>>> scanL((x: Int, y: Int) => x + y, a, 0)
List(0, 2, 5, 9)
In [ ]:
def scanL[A,B](f: (B, A) => B, xs : List[A], init: B) : List[B] = {
    return null
}
    
scanL((x: Int, y: Int) => x + y, List(2,3,4), 0)

Real life application

In the following questions you will solve realistic problems with the techniques you learned in this assignment. You will be working with data of San Francisco Library patrons. You can find the data file here. Below you can find what each field means.

  • Id: Id of patron
  • Patron Type Definition: Description of patron (adult, teen, child, senior, etc.).
  • Total Checkouts: Total number of items the patron has checked out from the library since the record was created.
  • Total Renewals: Total number of times the patron has renewed checked-out items.
  • Age Range: Age ranges: 0 to 9 years, 10 to 19 years, 20 to 24 years, 25 to 34 years, 35 to 44 years, 45 to 54 years, 55 to 59 years, 60 to 64 years 65 to 74 years, 75 years and over. Some blank.
  • Home Library Definition: Description of the branch library where the patron was originally registered.
  • Circulation Active Month: Month the patron last checked out library materials, or last logged into the library’s subscription databases from a computer outside the library.
  • Circulation Active Year: Year the patron last checked out library materials, or last logged into the library’s subscription databases from a computer outside the library.
  • Notice Preference Definition: Description of the patron’s preferred method of receiving library notices.
  • Provided Email Address: Indicates whether the patron provided an email address.
  • Year Patron Registered: Year patron registered with library system. No dates prior to 2003 due to system migration.
  • Outside of County: If a patron's home address is not in San Francisco, then flagged as true, otherwise false.
  • Supervisor District: Based on patron address: San Francisco Supervisor District. Note: This is an automated field, please note that if "Outside of County" is true, then there will be no supervisor district. Also, if the input address was not well-formed, the supervisor district will be blank.

Solve the following questions using functions you implemented earlier. The code for reading the file is already given. Hint: for testing purposes it could be beneficial to only use a small part of the dataset.

In [ ]:
// This snippet imports the csv file to a List[Array[String]]

var patrons: List[Array[String]] = Nil
try {
    patrons = scala.io.Source.fromFile("library.csv").getLines().drop(1).map(_.split(",")).toList
} catch {
    case e : Throwable => println("Library data file not found")
}

T (10pts) Some patrons have indicated that they want to receive notices via email, but have not provided their email address. Implement a function that outputs a list of the IDs of these patrons.

In [ ]:
def missing_email(xs: List[Array[String]]): List[String] = {
    return null
}

missing_email(patrons)

T (10pts) Implement a function that outputs the total amount of checkouts from members originally registered at a given location.

>>> checkouts(patrons, "Noe Valley/Sally Brunn")
1355624
In [ ]:
def checkouts(xs: List[Array[String]], location: String): Int = {
    return 0
}

checkouts(patrons, "Mission")

T (15pts) Implement a function that lists the number of renewals per location in a map. Example output for part of the dataset:

>>> number_renewals(patrons)

Map(Presidio -> 431988),
 (Mission -> 1218976))
In [ ]:
def number_renewals(xs: List[Array[String]]): Map[String, Int] = {
    return null
}
    
number_renewals(patrons)