nput_1input_2input_3input_4input_5input_6input_7input_8input_9input_10output0 Private School Physics Riyadh Male $735 18,180 9.2 9.1 6.0 0.933 9.81 Public School Mathematics Madinah Male $742 2,6216.6 9.57.8 0.95 35.42 Public School Physics Madinah Female $675 17,692 6.1 7.6 7.9 0.92 35.73 Public School Physics Al-Khobar Female $841 17,738 9.99.1 9.4 0.17 41.14 Private School Chemistry Hail Female $596 10,6047.7 6.7 9.6 0.17 37.3

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

input_1input_2input_3input_4input_5input_6input_7input_8input_9input_10output0

Private School Physics Riyadh Male $735 18,180 9.2 9.1 6.0 0.933 9.81

Public School Mathematics Madinah Male $742 2,6216.6 9.57.8 0.95 35.42

Public School Physics Madinah Female $675 17,692 6.1 7.6 7.9 0.92 35.73

Public School Physics Al-Khobar Female $841 17,738 9.99.1 9.4 0.17 41.14

Private School Chemistry Hail Female $596 10,6047.7 6.7 9.6 0.17 37.3

1. [4] Identify all the inconsistencies in the data. Resolve the inconsistencies.
2. [2] Replace all missing values in column 'input_1' with the mode of that column.
[ ]:
1 #Answer for A1.1
1 #Answer for A1.2
A2.
Do the following:
1. [2] Draw a bivariate histogram for 'input_9' and 'input_10' columns using 10 bins.
2. [2] Display the total number of records for every combination of 'input_2' and 'input_3'. Which combination has the highest number of recor
1 #Answer for A2.1
1 #Answer for A2.2
АЗ.
Do the following:
1. [2] Transform column "input_3" as follows:
• 'Riyadh', 'Al-Baha', 'Hail' should be transformed as 'Central Region'
• Jeddah', 'Makkah', 'Madinah', 'Jizan', 'Taif', 'Tabuk' should be transformed as 'Western Region'
• 'Dammam', 'Al-Khobar' should be transformed as 'Eastern Region'
2. [2] Transform column "input_2" using one hot encoding method. Do not drop any of the encoded column.
Transcribed Image Text:1. [4] Identify all the inconsistencies in the data. Resolve the inconsistencies. 2. [2] Replace all missing values in column 'input_1' with the mode of that column. [ ]: 1 #Answer for A1.1 1 #Answer for A1.2 A2. Do the following: 1. [2] Draw a bivariate histogram for 'input_9' and 'input_10' columns using 10 bins. 2. [2] Display the total number of records for every combination of 'input_2' and 'input_3'. Which combination has the highest number of recor 1 #Answer for A2.1 1 #Answer for A2.2 АЗ. Do the following: 1. [2] Transform column "input_3" as follows: • 'Riyadh', 'Al-Baha', 'Hail' should be transformed as 'Central Region' • Jeddah', 'Makkah', 'Madinah', 'Jizan', 'Taif', 'Tabuk' should be transformed as 'Western Region' • 'Dammam', 'Al-Khobar' should be transformed as 'Eastern Region' 2. [2] Transform column "input_2" using one hot encoding method. Do not drop any of the encoded column.
Expert Solution
steps

Step by step

Solved in 3 steps with 1 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