1. Create a dataset like the example below with the given data. D * Example x Y z PU ID 7.0 1.0 3.12 3.2760 NaN 4.0 1.0 4.16 4.3680 NaN 2.0 0.0 5.20 5.4600 NaN 3 3 3.0 1.0 1.35 1.4175 NaN 4 4 NaN 0.0 1.77 1.8585 6.0 5.0 1.0 2.80 2.9400 4.0 6. 7.0 0.0 5.75 6.0375 NaN 7 3.0 0.0 6.02 6.3210 2.0 8 1.0 1.0 7.21 7.5705 7.0 9 0.0 1.0 8.44 8.8620 NaN 10 10 5.0 NaN 9.43 9.9015 NaN 2. Treat the missing value in column X using replacement with the median value. 3. Draw a box plot of column X after completing Question-2. 2.

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
icon
Related questions
Question
1. Create a dataset like the example below with the given data.
# Example
X
Y Z P U
ID
7.0
1.0 3.12 3.2760 NaN
1
1
4.0
1.0 4.16 4.3680 NaN
2
2.0
0.0 5.20 5.4600 NaN
3
3
3.0
1.0 1.35 1.4175 NaN
4
4 NaN
0.0 1.77 1.8585
6.0
5.0
1.0 2.80 2.9400
4.0
6
6
7.0
0.0 5.75 6.0375 NaN
7
7
3.0
0.0 6.02 6.3210
2.0
8
8
1.0
1.0 7.21 7.5705
7.0
9
0.0
1.0 8.44 8.8620 NaN
10
10
5.0 NaN 9.43 9.9015 NaN
2. Treat the missing value in column X using replacement with the median value.
3. Draw a box plot of column X after completing Question-2.
4. Treat the missing value in column Y.
5. Draw a bar plot of column Y after completing Question-4.
6. Visualize the distribution of column Z.
7. Delete the columns ID, P and U
Transcribed Image Text:1. Create a dataset like the example below with the given data. # Example X Y Z P U ID 7.0 1.0 3.12 3.2760 NaN 1 1 4.0 1.0 4.16 4.3680 NaN 2 2.0 0.0 5.20 5.4600 NaN 3 3 3.0 1.0 1.35 1.4175 NaN 4 4 NaN 0.0 1.77 1.8585 6.0 5.0 1.0 2.80 2.9400 4.0 6 6 7.0 0.0 5.75 6.0375 NaN 7 7 3.0 0.0 6.02 6.3210 2.0 8 8 1.0 1.0 7.21 7.5705 7.0 9 0.0 1.0 8.44 8.8620 NaN 10 10 5.0 NaN 9.43 9.9015 NaN 2. Treat the missing value in column X using replacement with the median value. 3. Draw a box plot of column X after completing Question-2. 4. Treat the missing value in column Y. 5. Draw a bar plot of column Y after completing Question-4. 6. Visualize the distribution of column Z. 7. Delete the columns ID, P and U
Expert Solution
steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Knowledge Booster
Processes of 3D Graphics
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
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)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education