Programming Question

Attached below are the questions in pdf format for my final project. Please go through test data and help with accurate output. attached expected output for reference. contact me in case of any queries. Test data is zip file which has 3 excel sheets. Thanks!

Programming Languages – Project
WJ Inc., is a company with o ces around the world. The HR team wants to build reports on
the number of employees around the world, in di erent departments. But they do not want to
use the raw data for the reporting purpose. They want some consolidation and aggregation to
be done prior to being loaded into their reporting system. The data is provided to the software
engineer in CSV les. There are 3 CSV les, each holding the department, location and
employee headcount data.
The department and location information is provided as a attened hierarchy. Given below is a
snapshot of the department le content:
The department hierarchy has 7 levels. The le has columns level1 – level7 and an additional
column to indicate the the bottom level. The department hierarchy is a jagged hierarchy
meaning not all hierarchies have 7 levels.
Similarly the location data is also provided. The screen shot is given below:
The head count data includes the department, location. Each row in the le gives the number
of employees for a particular department at a particular location. The headcount data is only
fi
fl
ff
fi
fi
ffi
fi
fi
available at bottom levels. Given below is a screenshot of the data:
The headcount data needs to be aggregated to level5 (district) for locations, and departments.
The output should also be in CSV format for being easily uploaded to the reporting system.
Should look something like:
Instructions:
1. You are free to implement the application in any of the languages studied in the course, and
also in addition Java and Python are also acceptable.
2. Code should be well commented to explain the logic being used.
3. Functional programming paradigm needs to be used (use recursive functions, pattern
matching, higher order functions, etc. No imperative programming – no loops)
4. Clear instructions should be included in submission on how to run the application. (.txt le)
Rubric:
Criteria
Weightage
Application runs and produces expected output
45%
Functional programming paradigm is used
consistently
20%
Code is well commented and understandable
15%
Code is well formatted and readable
10%
Meaningful names used for variables, functions,
classes, etc
10%
100%
* Clear instructions should be included in submission on how to run the application. If not
included, I might consider this as “application does not run.”
* If the application does not run, I will give credit based on comments given and my
fi
understanding of the comments and code.
Paste
D13
A
BIU
1
level1
2 World
3 World
4 World
5 World
6 World
7 World
8
9
10
B
C
==== =
Possible Data Loss Some features might be lost if you save this workbook in the comma-delimited (.csv) format. To preserve these features, save it in an Excel file format.
fx
level2
level3
North Americ USA
North Americ USA
North Americ USA
Asia
Asia
Asia
Malaysia
India
UAE
Merge & Center ✓
D
% 9
E
.00
←0
.00 →.0
F
Conditional Format
Formatting as Table
level4
California
California
California
Sarawak
Karnataka
Emirate of Sh Sharjah Distri Sharjah
level5
level6
Northern Cali San Jose
Northern Cali San Jose
Southern Cal Los Angeles
Kuching Distr Kuching
Bangalore Di: Bangalore
Cell
Styles
G
H
level7
level8
Main Campu: SJC 1
Main Campu: SJC 2
LA Techspace LA 1
South Kuchin KCH 1
STP
STP 1
Emirate Park SHJ 1
NO
Delete v
Format v
sle
V
Sort &
Filter
I
bottom_level
SJC 1
SJC 2
LA 1
KCH 1
STP 1
SHJ 1
Find &
Select
J
Analyze
Data
SPaste
A1
Possible Data Loss Some features might be lost if you save thi
fx location
A
1 location
2 SJC 1
3
SJC 1
4
SJC 1
5 SJC 1
6
SJC 1
7 SJC 1
8
SJC 1
9 SJC 2
10 SJC 2
11 SJC 2
12 SJC 2
13 SJC 2
14 LA 1
15 LA 1
16 LA 1
17 LA 1
18 KCH 1
19 KCH 1
20 | KCH 1
21 KCH 1
BIU
22 KCH 1
23 KCH 1
24 KCH 1
25 STP 1
26 STP 1
27 STP 1
28 STP 1
29 STP 1
30 SHJ 1
31 SHJ 1
32 SHJ 1
33 SHJ 1
34 SHJ 1
35 HJ 1
36 SHJ 1
B
Idepartment
DEPT_11111
DEPT_12
DEPT_133
DEPT_2222
DEPT_2244
DEPT_22455
DEPT_22456
DEPT_11111
DEPT_12
DEPT_2222
DEPT_22455
DEPT_22456
DEPT_11111
DEPT_12
DEPT_2222
DEPT_22455
DEPT_11111
DEPT_12
DEPT_133
DEPT_2222
DEPT_2244
DEPT_22455
DEPT_22456
DEPT_11111
DEPT_133
DEPT_2222
DEPT_22455
DEPT_22456
DEPT_11111
DEPT_12
DEPT_133
DEPT_2222
DEPT_2244
EPT_22455
DEPT_22456
C
head_count
12
42
122
3
12
5
234
36
124
126
67
39
94
63
20
109
25
78
93
82
74
79
47
67
29
39
48
9
58
3
8
9
23
34
38
D
E
FPaste
F17
BIU
==== =
Merge & Center ✓
A
% 9
.00
←0
.00 →.0
F
Possible Data Loss Some features might be lost if you save this workbook in the comma-delimited (.csv) format. To preserve these features, save it in an Excel file format.
fx
B
C
D
E
1
level1
level2 level3 level4 level5
level6
level7
WJ Group
WJ Inc. DEPT_1 DEPT _11 DEPT_111 DEPT_1111 DEPT_11111
2
3 WJ Group
WJ Inc.
DEPT_1 DEPT_12
4 WJ Group WJ Inc.
DEPT_1 DEPT_13 DEPT_133
5
WJ Group WJ Inc.
DEPT_2 DEPT 22 DEPT_222 DEPT_2222
WJ Group WJ Inc.
DEPT_2
DEPT 22 DEPT_224 DEPT_2244
Conditional Format
Formatting as Table
G
Cell
Styles
NO
H
bottom_level
DEPT_11111
DEPT_12
DEPT_133
DEPT_2222
DEPT_2244
6
7
WJ Group WJ Inc.
DEPT_2 DEPT 22 DEPT_224 DEPT_2245 DEPT_22455
DEPT_22455
8 WJ Group WJ Inc. DEPT_2 DEPT 22 DEPT_224 DEPT_2245 DEPT_22456 DEPT_22456
9
10
11
12
13
14
Delete v
Format v
|
sle
V
Sort &
Filter
Fir
SePaste
F11
สี
BIU
A
Possible Data Loss Some features might be lost if you save this workbo
fx
1 location
2 Bangalore District
3 Bangalore District
4 Bangalore District
5 Bangalore District
6 Kuching District
7 Kuching District
8 Kuching District
9 Kuching District
10 Northern California
11 Northern California
12 Northern California
13 Northe California
14 Sharjah District
15 Sharjah District
16 Sharjah District
17 Sharjah District
18 Southern California
19 Southern California
20 Southern California
21 Southern California
22
B
C
department head_count
DEPT_111
DEPT_133
DEPT_222
DEPT 224
DEPT_111
DEPT 133
DEPT 222
DEPT 224
DEPT_111
DEPT_133
DEPT_222
DEPT_224
DEPT_111
DEPT_133
DEPT_222
DEPT_224
DEPT_111
DEPT_133
DEPT_222
DEPT_224
67
29
39
57
25
93
82
200
48
122
129
35
==
58
8
9
95
94
0
20
109
D