Give the five neighbourhoods with the most listings

Assignment Help Other Subject
Reference no: EM132324870

DATA WRANGLING AND R Assignment -

The purpose of this assignment is to develop and assess your skills in R programming including wrangling, summarising and plotting data. Using the tidyverse package is recommended but not compulsory. Please read through the entire assignment and understand the submission format and marking rubrics before starting.

Part 1 - The spreadsheet titled 'censusdata.xlsx' contains information about the number of bedrooms in occupied private dwellings for local government areas in Melbourne for the years 2011 and 2016. You will see that it is far from being ready for analysis and needs to be 'wrangled'. Additionally a few errors have been deliberately introduced into the first two columns so these will need to be corrected by initial analysis.

1. Explain why the data in its current form is not considered to be in 'tidy' format.

2. Write R code to read in the data (readxl package), manipulate it and output it to a single csv file having the following header row.

region,year,br_count_0,br_count_1,br_count_2,br_count_3,br_count_4_or_more,br_count_unstate d,av_per_dwelling,av_per_household

Your code will have the following sections (not necessarily in the order given and the process may be iterative as you find more things to do). Please include comments in the code to separate each segment and explain your steps.

Read in the data sets into two data frames df2011 and df2016.

Compare the layout of each of the two data frames, then remove appropriate rows of one data frame to match the format of the other.

Write a function that takes in a table of the original form and outputs a table in the desired form with columns specified above.

  • Remove unwanted rows or columns.
  • Split values into multiple columns to make them atomic.
  • Appropriately transform the data into the desired form.
  • Rename columns.

Apply the function to each table to create two tables in the desired format.

Do a summary of each table to look for unusual values.

Correct those values until the two tables have the same dimensions and format.

Merge the two tables into a single table so that we see data in the form

Banyule,2011,78,1287,8457,21865,11366,645,3.1,2.6

Banyule,2016,...

Bayside,2011,...

Bayside,2016,...

...

Victoria,2011,...

Victoria,2016,...

Australia,2011,...

Australia,2016,...

(listed alphabetically by region, then by year, with Victoria and Australia at the end) (2 marks)

Write the result to a csv file (it should have 65 rows including the header).

3. Which region(s) (ignoring Victoria and Australia) had the largest increase in the number of occupied dwellings with 3 or more bedrooms between 2011 and 2016? (Ignore the unstated counts.)

Part 2 - The online hospitality company Airbnb has made publicly available a number of datasets. This part of the assignment makes use of the listings.csv dataset.

It consists of a number of parameters related to properties available for lodging in the Melbourne metropolitan area and can be visualized.

Write R code to answer the following.

1. Give the five neighbourhoods with the most listings (list them along with the counts in descending order).

2. How many listings contain the following words (upper or lower case or mixed) in the name column?

a. Beautiful

b. Quiet

c. Amazing

d. <another adjective of your choice with at least 200 instances>

3. How many listings are there with last review in 2016? Give month by month counts for the year 2016.

4. Create a new column of the table which calculates the number of ids that correspond to the given host_id . Your answer will match the calculated_host_listings_count column (only use this column to check your answer).

5. Write a function that inputs a listing id and outputs a score that is the sum of points according to the following criteria:

a. Points for the neighbourhood: (average number of bedrooms per dwelling in 2016) × 50 (this comes from the data set in Part 1)

b. Points for the room type: 200 for Entire home/apt, 100 for Private room, 0 for Shared room

c. Points for minimum nights: 50 for 1 night, 25 for 2 nights, 0 for 3 or more nights

d. Points for availability: (availability_365) divided by 5

e. Points for review frequency: 50 × (reviews per month), but no more than 100

f. Points for price: (300 minus price)

Which id (ids if more than one) has the highest score according to the above system?

Part 3 - Write a short report summarising the variables in the two (processed) datasets from parts 1 and 2 through tables [2 marks] and plots with R including the following:

  • A histogram showing the distribution of a variable of interest.
  • A plot of one or more variables with time on the x axis (e.g. month, year or date).
  • A word cloud of the words in the name column of the listings table. You may follow the instructions and use the packages referred.
  • A map showing the price of listings by colour (e.g. a dot plot or heat map - you will need to use an R package that can map geospatial data).

Point out any interesting patterns (e.g. trends) you see from your plots and summaries.

Attachment:- Assignment Files.rar

Verified Expert

In this assignment data wrangling was done by R code with various packages. ‘readxl’ package was used to read ‘.xlsx'. data in R. Summary statistic and dimension of the data was checked. Unwanted rows and column were removed from data set. Text analysis also performed in this assignment using ‘wordcloud’. Some functions were written for score calculation.

Reference no: EM132324870

Questions Cloud

What is indra nooyi of pepsi leadership style : What is Indra Nooyi of Pepsi's leadership style? Can Indra be considered as a transformational leader? Why, Explain
Environmental or marketing impacts : So why should companies be concerned with environmental or marketing impacts? Are there more ethical ways to get the same or different results
What is the process used to separate the change in gdp : What is the process used to separate the change in GDP due to an increased output of goods and services
Describe technology dimensions of information systems : BZ380 - Management Information Systems - List and describe the organizational, management, and technology dimensions of information systems.
Give the five neighbourhoods with the most listings : BUS5DWR DATA WRANGLING AND R Assignment, La Trobe University, Australia. Give the five neighbourhoods with the most listings
Describe the major types of knowledge work systems : Describe the major types of knowledge work systems and assess how they provide value for firms. The response must be typed, single spaced.
How enterprise applications are used in platforms : Describe how enterprise applications are used in platforms for new cross-functional services. The response must be typed, single spaced.
Discuss ethical issues raised by information systems : Discuss some of the ethical, social, and political issues that are raised by information systems. The response must be typed, single spaced.
Find a sample proportion : With which sample size are you more likely to find a sample proportion that is close to the population proportion?

Reviews

inf2324870

7/31/2019 4:14:54 AM

Im attaching the original assignment questions and also with my word file with Please assist me on this.. I have even ran the Rmarkdown for the solution and I have clearly mentioned in the word document below that some of the questions nd the below solution along with I have attached my assignment file and the changes which needs to be made. Can you please check the word file. I have mentioned all the changes which needs to be made. Please find the attached changes for the solutions in the word document. Please provide us with necessary changes and coding as soon as possible n the second question it is clearly asked to manipulate the data and convert it to the .csv file, s the reason the error keeps popping for the rest of the code. Can you please fix it ASAP. We need to submit it in 2 to 3 Hours. Can you just fix that thing. Regarding this tutor connect till now how session is over

len2324870

6/19/2019 3:21:10 AM

Submission - Your submission to this assignment will consist of two files. A single .R file with all the code used for this assignment (all parts), including comments that contain the answers for parts 1 and 2. A document (pdf or docx) for part 3 (including code here is optional, only code in the R file will be assessed). Do not include the answers for parts 1 or 2 here. Note: please keep the data files in the same directory as your scripts so that you do not specify directories in your code. This will make your R code easier to assess.

len2324870

6/19/2019 3:21:04 AM

Marking Rubrics - Please note the following as it shows how marks may be deducted. For question 1 of part 1 up to 1 mark will be deducted for any incomplete explanation. Marks will be deducted if the R code does not work easily on the marker’s R studio installation and if you need to be offered an opportunity to show the marker that it does work on your installation. This means all references to directories have to be removed and packages being used are to be specified clearly. It will be assumed that the tidyverse, readxl and packages used for the word cloud as per the link above have been installed.

len2324870

6/19/2019 3:20:56 AM

For each coding question, 0.5 marks will be deducted for each minor mistake in the code, 1 mark deducted for each major mistake up to the full number allocated for that question. In part 3, 2 marks will be deducted if there is little or no explanation of what is being plotted, or if no patterns in the data are noted. In part 3, 1 or more marks will be deducted for each plot that lacks colour or is displayed inappropriately (e.g. missing axis labels, messy view). Overall 2 marks will be deducted if the R code is poorly commented with lack of explanation.

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd