Using the images of the dataset below, please answer the following questions  NOTE: All answers should be supported by coding and/or some written discussion. 1. Explain what this dataset about? Hint: You may need to look at columns, rows, and cells to understand the dataset. 2. Define the neighbor hood and the year where was the biggest square feet Hint: You may use .max() method 3. Is there is any relation between the income and the square feet? Hint: You may need to draw (plot) your dataset. 4. For each minimum net income in the dataset, what was the years? Hint: You may use grouped and aggregated calculations 5. Reshape the dataset based on units and value. Hint: You may apply tidy data approaches

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 the images of the dataset below, please answer the following questions 

NOTE: All answers should be supported by coding and/or some written discussion.

1. Explain what this dataset about?
Hint: You may need to look at columns, rows, and cells to understand the dataset.

2. Define the neighbor hood and the year where was the biggest square feet
Hint: You may use .max() method

3. Is there is any relation between the income and the square feet?
Hint: You may need to draw (plot) your dataset.

4. For each minimum net income in the dataset, what was the years?
Hint: You may use grouped and aggregated calculations

5. Reshape the dataset based on units and value.
Hint: You may apply tidy data approaches

 

neighborhood type
FINANCIAL
FINANCIAL
FINANCIAL
FINANCIAL
TRIBECA
TRIBECA
TRIBECA
TRIBECA
TRIBECA
TRIBECA
TRIBECA
TRIBECA
TRIBECA
TRIBECA
TRIBECA
TRIBECA
TRIBECA
TRIBECA
TRIBECA
FINANCIAL
FINANCIAL
FINANCIAL
FINANCIAL
FINANCIAL
FINANCIAL
FINANCIAL
units year_built sq_ft income income_per_sq_ft expense expense_per_sq_ft_net_income value
1920.0 36500 1332615
342005
990610 7300000
1985.0 126420 6633257
554174 17310000
1930.0 249076 11776313
1985.0 219495 10004582
1986.0 139719 5127687
1985.0 105000 4365900
1986.0 87479 3637377
1987.0 255845 11246946
1985.0 106129 4115683
1986.0 126008 5239413
1987.0 586224 24375194
1988.0 208281 8077137
1988.0 341489 13591262
2003.0 267723 12202814
2006.0 431824 18041607
1985.0 257848 11752712
2006.0 434398 19799861
1985.0 237725 10051013
1920.0 37236 1545666
1956.0 316810 14551083
1982.0 231300 9779364
2005.0 477747 19864720
1914.0 648926 27436591
1836.0 159544 7798511
1929.0 346789 13511000
36.51
52.47 1762295
31.24 3543000
47.28 2784670
45.58 2783197
36.7 1497788
41.58 1273650
41.58 1061120
43.96 2440761
38.78 1231096
41.58 1528477
41.58 7110897
38.78 2416060
39.8 4309591
45.58 3394728
41.78 5298480
45.58 3269513
45.58 5508167
42.28 2498490
41.51
439012
45.93 3760535
42.28 2430963
41.58 5795071
42.28 6820212
48.88 1973559
38.96 3172000
9.37
13.94 4870962 30690000
6.39 13767000 90970000
11.18
8991643 67556006
12.68 7221385 54320996
10.72 3629899 26737996
12.13 3092250 22210281
12.13 2576257 19449002
9.54 8806185 66316999
11.6 2884587 21821999
12.13 3710936 28015990
12.13 17264297 130154990
11.6 5661077 42824998
12.62 9281671 70161999
12.68 8808086 62110366
12.27 12743127 89682996
12.68 8483199 63811996
12.68 14291694 100582005
10.51 7552523 57048005
11.79 1106654 8355001
11.87 10790548 81144002
10.51 7348401 43229973
12.13 14069649 106168339
10.51 20616379 155560004
12.37 5824952 43678004
9.15 10339000 78272000
42 78
R9-CONDOMINIUM
R4-CONDOMINIUM
RR-CONDOMINIUM 500
R4-CONDOMINIUM 282
R4-CONDOMINIUM 239
R4-CONDOMINIUM 133
R4-CONDOMINIUM 109
R4-CONDOMINIUM 107
R4-CONDOMINIUM 247
R4-CONDOMINIUM 121
R4-CONDOMINIUM 154
R4-CONDOMINIUM 546
R4-CONDOMINIUM 182
R4-CONDOMINIUM 293
R4-CONDOMINIUM 117
R4-CONDOMINIUM 234
R4-CONDOMINIUM 304
R4-CONDOMINIUM 256
R4-CONDOMINIUM 174
R4-CONDOMINIUM 13
R4-CONDOMINIUM 452
R4-CONDOMINIUM 162
R4-CONDOMINIUM 320
R4-CONDOMINIUM 382
R4-CONDOMINIUM 107
RR-CONDOMINIUM 350
value_per_sq_ft boro
200.0 Manhattan
242.76 Manhattan
164.15 Manhattan
271.23 Manhattan
247.48 Manhattan
191.37 Manhattan
211.53 Manhattan
222.33 Manhattan
259.21 Manhattan
205.62 Manhattan
222.34 Manhattan
222.02 Manhattan
205.61 Manhattan
205.46 Manhattan
231.99 Manhattan
207.68 Manhattan
247.48 Manhattan
231.54 Manhattan
239.97 Manhattan
224.38 Manhattan
256.13 Manhattan
186.9 Manhattan
222.23 Manhattan
239.72 Manhattan
273.77 Manhattan
225.7 Manhattan
Transcribed Image Text:neighborhood type FINANCIAL FINANCIAL FINANCIAL FINANCIAL TRIBECA TRIBECA TRIBECA TRIBECA TRIBECA TRIBECA TRIBECA TRIBECA TRIBECA TRIBECA TRIBECA TRIBECA TRIBECA TRIBECA TRIBECA FINANCIAL FINANCIAL FINANCIAL FINANCIAL FINANCIAL FINANCIAL FINANCIAL units year_built sq_ft income income_per_sq_ft expense expense_per_sq_ft_net_income value 1920.0 36500 1332615 342005 990610 7300000 1985.0 126420 6633257 554174 17310000 1930.0 249076 11776313 1985.0 219495 10004582 1986.0 139719 5127687 1985.0 105000 4365900 1986.0 87479 3637377 1987.0 255845 11246946 1985.0 106129 4115683 1986.0 126008 5239413 1987.0 586224 24375194 1988.0 208281 8077137 1988.0 341489 13591262 2003.0 267723 12202814 2006.0 431824 18041607 1985.0 257848 11752712 2006.0 434398 19799861 1985.0 237725 10051013 1920.0 37236 1545666 1956.0 316810 14551083 1982.0 231300 9779364 2005.0 477747 19864720 1914.0 648926 27436591 1836.0 159544 7798511 1929.0 346789 13511000 36.51 52.47 1762295 31.24 3543000 47.28 2784670 45.58 2783197 36.7 1497788 41.58 1273650 41.58 1061120 43.96 2440761 38.78 1231096 41.58 1528477 41.58 7110897 38.78 2416060 39.8 4309591 45.58 3394728 41.78 5298480 45.58 3269513 45.58 5508167 42.28 2498490 41.51 439012 45.93 3760535 42.28 2430963 41.58 5795071 42.28 6820212 48.88 1973559 38.96 3172000 9.37 13.94 4870962 30690000 6.39 13767000 90970000 11.18 8991643 67556006 12.68 7221385 54320996 10.72 3629899 26737996 12.13 3092250 22210281 12.13 2576257 19449002 9.54 8806185 66316999 11.6 2884587 21821999 12.13 3710936 28015990 12.13 17264297 130154990 11.6 5661077 42824998 12.62 9281671 70161999 12.68 8808086 62110366 12.27 12743127 89682996 12.68 8483199 63811996 12.68 14291694 100582005 10.51 7552523 57048005 11.79 1106654 8355001 11.87 10790548 81144002 10.51 7348401 43229973 12.13 14069649 106168339 10.51 20616379 155560004 12.37 5824952 43678004 9.15 10339000 78272000 42 78 R9-CONDOMINIUM R4-CONDOMINIUM RR-CONDOMINIUM 500 R4-CONDOMINIUM 282 R4-CONDOMINIUM 239 R4-CONDOMINIUM 133 R4-CONDOMINIUM 109 R4-CONDOMINIUM 107 R4-CONDOMINIUM 247 R4-CONDOMINIUM 121 R4-CONDOMINIUM 154 R4-CONDOMINIUM 546 R4-CONDOMINIUM 182 R4-CONDOMINIUM 293 R4-CONDOMINIUM 117 R4-CONDOMINIUM 234 R4-CONDOMINIUM 304 R4-CONDOMINIUM 256 R4-CONDOMINIUM 174 R4-CONDOMINIUM 13 R4-CONDOMINIUM 452 R4-CONDOMINIUM 162 R4-CONDOMINIUM 320 R4-CONDOMINIUM 382 R4-CONDOMINIUM 107 RR-CONDOMINIUM 350 value_per_sq_ft boro 200.0 Manhattan 242.76 Manhattan 164.15 Manhattan 271.23 Manhattan 247.48 Manhattan 191.37 Manhattan 211.53 Manhattan 222.33 Manhattan 259.21 Manhattan 205.62 Manhattan 222.34 Manhattan 222.02 Manhattan 205.61 Manhattan 205.46 Manhattan 231.99 Manhattan 207.68 Manhattan 247.48 Manhattan 231.54 Manhattan 239.97 Manhattan 224.38 Manhattan 256.13 Manhattan 186.9 Manhattan 222.23 Manhattan 239.72 Manhattan 273.77 Manhattan 225.7 Manhattan
FINANCIAL
1987.0 96902 3271412
R4-CONDOMINIUM 126
40
FINANCIAL
R9-CONDOMINIUM
FINANCIAL
FINANCIAL
R4-CONDOMINIUM 31
R4-CONDOMINIUM 347
R4-CONDOMINIUM 121
R4-CONDOMINIUM 20
FINANCIAL
FINANCIAL
FINANCIAL
FINANCIAL
FINANCIAL
FINANCIAL
R4-CONDOMINIUM
FINANCIAL
FINANCIAL
FINANCIAL
FINANCIAL
FINANCIAL
FINANCIAL
1920.0 65396 1493000
1900.0 20308 854154
1987.0 422833 19420720
1956.0 109468 4199192
1902.0 39607 1644087
1893.0 73507 2563189
1928.0 548976 23210705
1900.0 21069 461000
1913.0 65992 2374392
1903.0 71985 2988097
2007.0 215467 7752503
1920.0 28550 848506
1927.0 186512 7885727
1967.0 112213 4744366
1931.0 214364 7055000
1982.0 24362 835129
2000.0 142626 4812280
2003.0 348157 14476368
1900.0 31738 1126699
1930.0 28775 850301
1930.0 17122 763299
1910.0 22613 905425
FINANCIAL R4-CONDOMINIUM 73 1909.0 89994 3333378
FINANCIAL R4-CONDOMINIUM 21 1900.0 66930 2408141
FINANCIAL R4-CONDOMINIUM 67 1906.0 66575 2395369
SOUTHBRIDGE R4-CONDOMINIUM 210 1896.0 196837 6407044
R4-CONDOMINIUM 90
R4-CONDOMINIUM 408
RR-CONDOMINIUM 13
12
R4-CONDOMINIUM 102
R4-CONDOMINIUM 160
R9-CONDOMINIUM 29
R4-CONDOMINIUM 145
R4-CONDOMINIUM 113
RR-CONDOMINIUM 221
R4-CONDOMINIUM 14
RR-CONDOMINIUM 156
R4-CONDOMINIUM 441
R9-CONDOMINIUM 11
RR-CONDOMINIUM 19
14
14
FINANCIAL
FINANCIAL
FINANCIAL
FINANCIAL
FINANCIAL
FINANCIAL
R9-CONDOMINIUM
FINANCIAL
R4-CONDOMINIUM
33.76 995184
22.83 594600
42.06 291217
45.93 5019028
38.36 1321279
41.51 466967
34.87 784320
42.28 5769738
21.88 188000
35.98 729872
41.51 848703
35.98 2383065
29.72 254952
42.28 1960241
42.28 1179359
32.91 2020000
34.28 188806
33.74 1059660
41.58 4223144
35.5 292942
29.55 314356
44.58 242276
40.04 264346
37.04 691154
35.98 740246
35.98 736320
32.55 1979777
10.27
2276228 16895998
9.09
14.34
898400 6573000
562937 3751007
11.87 14401692 83690005
12.07 2877913 21777997
11.79 1177120 8886999
10.67 1778869 13165001
10.51 17440967 118799990
8.92
273000 1875000
11.06 1644520 6787002
11.79 2139394 16151989
11.06 5369438 39629986
8.93
593554 4449000
10.51 5925486 44711007
10.51 3565007 26900017
9.42 5035000 37493000
7.75
646323 4789000
7.43 3752620 24970000
12.13 10253224 77405999
9.23 833757 6163000
10.92
535945 3751000
14.15
521023 3922000
11.69
641079 4845000
7.68 2642224 19447000
11.06 1667895 12305999
11.06 1659049 12240999
10.06 4427267 30017000
174.36 Manhattan
100.51 Manhattan
184.71 Manhattan
197.93 Manhattan
198.94 Manhattan
224.38 Manhattan
179.1 Manhattan
216.4 Manhattan
88.99 Manhattan
102.85 Manhattan
224.38 Manhattan
183.93 Manhattan
155.83 Manhattan
239.72 Manhattan
239.72 Manhattan
174.9 Manhattan
196.58 Manhattan
175.07 Manhattan
222.33 Manhattan
194.18 Manhattan
130.36 Manhattan
229.06 Manhattan
214.26 Manhattan
216.09 Manhattan
183.86 Manhattan
183.87 Manhattan
152.5 Manhattan
Transcribed Image Text:FINANCIAL 1987.0 96902 3271412 R4-CONDOMINIUM 126 40 FINANCIAL R9-CONDOMINIUM FINANCIAL FINANCIAL R4-CONDOMINIUM 31 R4-CONDOMINIUM 347 R4-CONDOMINIUM 121 R4-CONDOMINIUM 20 FINANCIAL FINANCIAL FINANCIAL FINANCIAL FINANCIAL FINANCIAL R4-CONDOMINIUM FINANCIAL FINANCIAL FINANCIAL FINANCIAL FINANCIAL FINANCIAL 1920.0 65396 1493000 1900.0 20308 854154 1987.0 422833 19420720 1956.0 109468 4199192 1902.0 39607 1644087 1893.0 73507 2563189 1928.0 548976 23210705 1900.0 21069 461000 1913.0 65992 2374392 1903.0 71985 2988097 2007.0 215467 7752503 1920.0 28550 848506 1927.0 186512 7885727 1967.0 112213 4744366 1931.0 214364 7055000 1982.0 24362 835129 2000.0 142626 4812280 2003.0 348157 14476368 1900.0 31738 1126699 1930.0 28775 850301 1930.0 17122 763299 1910.0 22613 905425 FINANCIAL R4-CONDOMINIUM 73 1909.0 89994 3333378 FINANCIAL R4-CONDOMINIUM 21 1900.0 66930 2408141 FINANCIAL R4-CONDOMINIUM 67 1906.0 66575 2395369 SOUTHBRIDGE R4-CONDOMINIUM 210 1896.0 196837 6407044 R4-CONDOMINIUM 90 R4-CONDOMINIUM 408 RR-CONDOMINIUM 13 12 R4-CONDOMINIUM 102 R4-CONDOMINIUM 160 R9-CONDOMINIUM 29 R4-CONDOMINIUM 145 R4-CONDOMINIUM 113 RR-CONDOMINIUM 221 R4-CONDOMINIUM 14 RR-CONDOMINIUM 156 R4-CONDOMINIUM 441 R9-CONDOMINIUM 11 RR-CONDOMINIUM 19 14 14 FINANCIAL FINANCIAL FINANCIAL FINANCIAL FINANCIAL FINANCIAL R9-CONDOMINIUM FINANCIAL R4-CONDOMINIUM 33.76 995184 22.83 594600 42.06 291217 45.93 5019028 38.36 1321279 41.51 466967 34.87 784320 42.28 5769738 21.88 188000 35.98 729872 41.51 848703 35.98 2383065 29.72 254952 42.28 1960241 42.28 1179359 32.91 2020000 34.28 188806 33.74 1059660 41.58 4223144 35.5 292942 29.55 314356 44.58 242276 40.04 264346 37.04 691154 35.98 740246 35.98 736320 32.55 1979777 10.27 2276228 16895998 9.09 14.34 898400 6573000 562937 3751007 11.87 14401692 83690005 12.07 2877913 21777997 11.79 1177120 8886999 10.67 1778869 13165001 10.51 17440967 118799990 8.92 273000 1875000 11.06 1644520 6787002 11.79 2139394 16151989 11.06 5369438 39629986 8.93 593554 4449000 10.51 5925486 44711007 10.51 3565007 26900017 9.42 5035000 37493000 7.75 646323 4789000 7.43 3752620 24970000 12.13 10253224 77405999 9.23 833757 6163000 10.92 535945 3751000 14.15 521023 3922000 11.69 641079 4845000 7.68 2642224 19447000 11.06 1667895 12305999 11.06 1659049 12240999 10.06 4427267 30017000 174.36 Manhattan 100.51 Manhattan 184.71 Manhattan 197.93 Manhattan 198.94 Manhattan 224.38 Manhattan 179.1 Manhattan 216.4 Manhattan 88.99 Manhattan 102.85 Manhattan 224.38 Manhattan 183.93 Manhattan 155.83 Manhattan 239.72 Manhattan 239.72 Manhattan 174.9 Manhattan 196.58 Manhattan 175.07 Manhattan 222.33 Manhattan 194.18 Manhattan 130.36 Manhattan 229.06 Manhattan 214.26 Manhattan 216.09 Manhattan 183.86 Manhattan 183.87 Manhattan 152.5 Manhattan
Expert Solution
steps

Step by step

Solved in 5 steps with 8 images

Blurred answer
Similar questions
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