1. Create the following data frames based on the format provided: Example: Vis = ["Name", "Gender", "Track", "Math<70"]; hometown is constant as Visayas Output: Name S4 S11 S22 Gender Male Female Female Track Instrumentation Communication Communication Math 65 48 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. Create the following data frames based on the format provided: Example: Vis = ["Name", "Gender", "Track", "Math<70"]; hometown is constant as Visayas Output: Name S4 S11 S22 Gender Male Female Female Track Instrumentation Communication Communication Math 65 48 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
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
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.
Name | Gender | Track | Hometown | Math | Electronics | GEAS | Communication |
S1 | Male | Instrumentation | Luzon | 58 | 89 | 75 | 78 |
S2 | Female | Communication | Mindanao | 52 | 75 | 90 | 52 |
S3 | Female | Instrumentation | Mindanao | 83 | 74 | 77 | 57 |
S4 | Male | Instrumentation | Visayas | 65 | 58 | 91 | 68 |
S5 | Male | Communication | Luzon | 59 | 86 | 43 | 88 |
S6 | Female | Microelectronics | Visayas | 88 | 45 | 86 | 83 |
S7 | Female | Instrumentation | Luzon | 66 | 60 | 60 | 48 |
S8 | Male | Instrumentation | Luzon | 49 | 81 | 64 | 53 |
S9 | Male | Instrumentation | Luzon | 50 | 36 | 63 | 42 |
S10 | Male | Microelectronics | Mindanao | 80 | 84 | 61 | 44 |
S11 | Female | Communication | Visayas | 48 | 56 | 48 | 67 |
S12 | Male | Communication | Visayas | 89 | 67 | 84 | 64 |
S13 | Female | Microelectronics | Luzon | 88 | 35 | 83 | 43 |
S14 | Female | Microelectronics | Luzon | 83 | 77 | 89 | 73 |
S15 | Female | Microelectronics | Mindanao | 69 | 41 | 40 | 86 |
S16 | Female | Communication | Luzon | 71 | 70 | 87 | 81 |
S17 | Female | Microelectronics | Mindanao | 81 | 79 | 77 | 45 |
S18 | Male | Communication | Visayas | 81 | 40 | 81 | 52 |
S19 | Male | Microelectronics | Luzon | 79 | 63 | 79 | 71 |
S20 | Female | Communication | Mindanao | 59 | 60 | 62 | 85 |
S21 | Female | Microelectronics | Visayas | 83 | 51 | 68 | 72 |
S22 | Female | Communication | Visayas | 64 | 39 | 89 | 58 |
S23 | Male | Instrumentation | Luzon | 84 | 70 | 74 | 47 |
S24 | Female | Microelectronics | Visayas | 85 | 45 | 60 | 41 |
S25 | Male | Communication | Luzon | 74 | 91 | 94 | 42 |
S26 | Female | Instrumentation | Visayas | 71 | 47 | 83 | 62 |
S27 | Male | Microelectronics | Visayas | 70 | 47 | 40 | 86 |
S28 | Male | Communication | Visayas | 85 | 53 | 80 | 53 |
S29 | Male | Instrumentation | Mindanao | 73 | 48 | 71 | 62 |
S30 | Male | Instrumentation | Luzon | 78 | 81 | 57 | 56 |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 3 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education