Using data wrangling and data visualization technique with  storytelling, analyze the data and present different (i) data frames; and (ii) visuals using the dataset given. . Create the following data frames based on the format provided: Example: Vis = [“Name”, “Gender”, “Track”, “Math<70”]; hometown is constant as Visayas Output: Name Gender Track  Math S4 Male Instrumentation 65 S11 Female Communication 48 S22 Female Communication 64 a. Filename: Instru = [“Name”, “GEAS”, “Electronics >70”]; where track is constant as Instrumentation and hometown Luzon b.Filename: Mindy = [ “Name”, “Track”, “Electronics”, “Average >=55”]; where hometown is constant as Mindanao and gender Female

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

Using data wrangling and data visualization technique with 
storytelling, analyze the data and present different (i) data frames; and (ii) visuals using the dataset given.

. Create the following data frames based on the format provided:
Example: Vis = [“Name”, “Gender”, “Track”, “Math<70”]; hometown is constant as Visayas
Output:

Name Gender Track  Math
S4 Male Instrumentation 65
S11 Female Communication 48
S22 Female Communication 64

a. Filename: Instru = [“Name”, “GEAS”, “Electronics >70”]; where track is constant as
Instrumentation and hometown Luzon

b.Filename: Mindy = [ “Name”, “Track”, “Electronics”, “Average >=55”]; where hometown is
constant as Mindanao and gender Female

1
2
3
4 S3
Name
$1
S2
5 $4
6 $5
669 69 4 8 3
7 S6
8 S7
112
9 $8
10 S9
TSS2N2222 27
$10
$11
13 $12
14 S13
15 $14
16 $15
17 S16
18 $17
19 $18
20 $19
21 $20
$21
23 S22
24 S23
25 $24
26 $25
$26
28
$27
29
$28
30 $29
31 $30
A
Gender
Male
Female
Female
Male
Male
Female
Female
Male
Male
Male
Female
Male
Female
Female
Female
Female
Female
Male
Male
Female
Female
Female
Male
Female
Male
Female
Male
Male
Male
Male
B
Track
D
Hometown
Instrumentation
Luzon
Communication
Mindanao
Instrumentation Mindanao
Instrumentation Visayas
Communication Luzon
Microelectronics Visayas
Instrumentation
Luzon
Instrumentation
Instrumentation
Microelectronics Mindanao
Communication Visayas
Communication Visayas
Microelectronics
Luzon
Microelectronics Luzon
Microelectronics Mindanao
Luzon
Communication
Microelectronics
Mindanao
Communication Visayas
Microelectronics Luzon
Communication Mindanao
Microelectronics Visayas
Communication Visayas
Instrumentation Luzon
Microelectronics Visayas
Communication Luzon
Instrumentation
Visayas
Microelectronics
Visayas
Communication
Visayas
Instrumentation Mindanao
Instrumentation Luzon
Luzon
Luzon
Math
E
58
52
228 229
83
65
59
88
66
49
50
80
48
89
88
83
69
71
81
81
79
59
83
64
84
85
74
71
70
85
73
78
F
Electronics
89
288 2 8 5 8 1 8
75
74
58
86
45
60
81
36
84
56
67
35
77
41
22385229
70
79
40
63
60
51
70
45
91
47
47
53
48
81
GEAS
G
2855 7 28 2
75
90
77
91
43
86
60
64
63
61
48
84
83
89
40
87
77
81
79
62
68
89
74
60
94
83
40
80
71
57
H
Communication
78
52
57
68
22427639
88
83
48
53
44
73
86
81
45
52
71
85
72
58
47
41
42
62
86
53
62
56
Transcribed Image Text:1 2 3 4 S3 Name $1 S2 5 $4 6 $5 669 69 4 8 3 7 S6 8 S7 112 9 $8 10 S9 TSS2N2222 27 $10 $11 13 $12 14 S13 15 $14 16 $15 17 S16 18 $17 19 $18 20 $19 21 $20 $21 23 S22 24 S23 25 $24 26 $25 $26 28 $27 29 $28 30 $29 31 $30 A Gender Male Female Female Male Male Female Female Male Male Male Female Male Female Female Female Female Female Male Male Female Female Female Male Female Male Female Male Male Male Male B Track D Hometown Instrumentation Luzon Communication Mindanao Instrumentation Mindanao Instrumentation Visayas Communication Luzon Microelectronics Visayas Instrumentation Luzon Instrumentation Instrumentation Microelectronics Mindanao Communication Visayas Communication Visayas Microelectronics Luzon Microelectronics Luzon Microelectronics Mindanao Luzon Communication Microelectronics Mindanao Communication Visayas Microelectronics Luzon Communication Mindanao Microelectronics Visayas Communication Visayas Instrumentation Luzon Microelectronics Visayas Communication Luzon Instrumentation Visayas Microelectronics Visayas Communication Visayas Instrumentation Mindanao Instrumentation Luzon Luzon Luzon Math E 58 52 228 229 83 65 59 88 66 49 50 80 48 89 88 83 69 71 81 81 79 59 83 64 84 85 74 71 70 85 73 78 F Electronics 89 288 2 8 5 8 1 8 75 74 58 86 45 60 81 36 84 56 67 35 77 41 22385229 70 79 40 63 60 51 70 45 91 47 47 53 48 81 GEAS G 2855 7 28 2 75 90 77 91 43 86 60 64 63 61 48 84 83 89 40 87 77 81 79 62 68 89 74 60 94 83 40 80 71 57 H Communication 78 52 57 68 22427639 88 83 48 53 44 73 86 81 45 52 71 85 72 58 47 41 42 62 86 53 62 56
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY