[solved]-Need Done R Language Please Assist Problem Data Csv Could Found Given Page 1 Using Data H Q38991972
This need to be done in R language, please assist with problem. The data for the csv could be found on given page below. 1. using the data on http://www1.nyc.gov/site/finance/taxes/property-rolling- sales-data.page. The property sales data for Borough of Manhattan for the period June 2018 to May 2019(or the latest available period). Read the data description on this page to understand the various fields in the data file – most column names are self-explanatory. Upload the data into R. You may have to cut out a few top rows first. 2. We need to examine the data, and try to understand what each field might be about. Make a list of each column header and its class. Cast the variables to appropriate types – for example Sale prices may be loaded as a factor, which you need to cast into numeric type. 3. Understand what a sale price of O means by reading the documentation. Then eliminate all rows from the data with sale price of 0 or blank. How many rows are left? 4. Split the data into Commercial and Non-Commercial properties. You could look at Tax Class to determine if a property is commercial or residential, or find some other reasonable way to do it. Explain what criterion was used. 5. Aggregate total sales by Neighborhood for Commercial and Non- Commercial property sales. 6. Graph (using the best choice of graph type), the total sales of Commercial and Non-commercial properties in each Neighborhood of Manhattan. 7. This is an open-ended question. Create some visualizations that give insights into the property values in Manhattan. You need to tell a story through your visualizations; for example describing neighborhoods, property type distributions and desirable locations to live. Any story is good, but it must be clear, and understandable without straining your eyes too much. Read and refresh the notes on what constitutes good visuals and what are easy for humans to visualize. Use your imagination and creativity. Show transcribed image text This need to be done in R language, please assist with problem. The data for the csv could be found on given page below. 1. using the data on http://www1.nyc.gov/site/finance/taxes/property-rolling- sales-data.page. The property sales data for Borough of Manhattan for the period June 2018 to May 2019(or the latest available period). Read the data description on this page to understand the various fields in the data file – most column names are self-explanatory. Upload the data into R. You may have to cut out a few top rows first. 2. We need to examine the data, and try to understand what each field might be about. Make a list of each column header and its class. Cast the variables to appropriate types – for example Sale prices may be loaded as a factor, which you need to cast into numeric type. 3. Understand what a sale price of O means by reading the documentation. Then eliminate all rows from the data with sale price of 0 or blank. How many rows are left? 4. Split the data into Commercial and Non-Commercial properties. You could look at Tax Class to determine if a property is commercial or residential, or find some other reasonable way to do it. Explain what criterion was used. 5. Aggregate total sales by Neighborhood for Commercial and Non- Commercial property sales. 6. Graph (using the best choice of graph type), the total sales of Commercial and Non-commercial properties in each Neighborhood of Manhattan. 7. This is an open-ended question. Create some visualizations that give insights into the property values in Manhattan. You need to tell a story through your visualizations; for example describing neighborhoods, property type distributions and desirable locations to live. Any story is good, but it must be clear, and understandable without straining your eyes too much. Read and refresh the notes on what constitutes good visuals and what are easy for humans to visualize. Use your imagination and creativity.
Expert Answer
Answer to This need to be done in R language, please assist with problem. The data for the csv could be found on given page below…. . . .
OR
