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

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
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

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

Accepted Answer

Introduction:
The questions ask about dataset, defining the neighborhood and the year where was the…