Requirements are in attached PDF. Check PDF and make sure to follow all instructions

MapReduce City-Temperature
Assignment
Due Date: Monday 8/28 Midnight
Find (a) Hottest Temp of the month for each City (b) Corresponding Hottest
Day(s) of the month for each city.
15 Days of Records
Input Data File:
Excel File (city-temp.xlsx) available
on Blackboard
Method:
Apply a manual 5 Cluster MapReduce
Method to Solve this Computation
Problem
Deliverable
Excel File (city-temp-output.xlsx).
Upload to the Assignment on
Blackboard
Note:
Separate Tab/Sheet for Each Phase of
the Process with all Clusters in the
same sheet.
Phases:

  1. Splitting, 2. Map-1: Key-Value
    Pairing, 3. Map-2: Node Compute, 4.
    Reduce 1, 5. Reduce 2 (Output).
    MapReduce Example: Solution Hints
    Split
    Key
    Value
    Pairing
    Key
    Value
    Pairing
    Key
    Value
    Pairing
    Key
    Value
    Pairing
    Key
    Value
    Pairing
    Node
    Compute
    Node
    Compute
    Node
    Compute
    Node
    Compute
    Node
    Compute
    Shuffle
    Sort
    Merge
    OUTPUT
    Reduce
    Use 5 Clusters Map
    1
    Reduce
    1
    Map
    2
    Reduce
    2
    How to Solve
    • Partition the data into 5 clusters. The provided Data File
    indicates five clusters.
    • Make a separate sheet for each stages:
    – Map 1
    – Map 2
    – Reduce 1
    – Reduce 2
    • In each sheet show what is happening to each clusters. This
    means you will keep all five clusters in every sheet and show
    the changes in the clusters as you move through different
    stages of MapReduce
    Final Output
    {Key} { Value 1, Value 2 [ …. ] }