fb
$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader
Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Stuck on Your Question?

Get 24x7 live help from our Top Tutors. All subjects covered.

loader
250 words

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Students Who Viewed This Also Studied

19 Pages
NES8006 Sustainable Agriculture

Task: Background You are a scientist interested in analysing milk production performance in dairy cattle. You used 10 cows from 3 breeds (Friesian, Ayrshire and Shorthorn) and recorded: parity (numb ...

Course

NES8006

Type

Course Work

Subject

Statistics

University

Newcastle University

8 Pages
Management

These questions are for exploratory purposes; you don’t need to hand them in for marking, but they touch on important topics that might be covered on a test. 1. On the basis of these readings, w ...

Type

Assignment

Subject

Statistics

4 Pages
Business Report Proposal

Question: You and a group of investors are interested in setting up a chain of aged care homes in a number of Local Government Areas in Australia. In order to do this successfully you need to ensure t ...

Type

Assignment

Subject

Statistics

10 Pages
MKTG2010 Marketing Research

Questions: (1) To effectively communicate the findings of the marketing research project (2)  To provide interpretations of those findings in the form of sound and logical recommendations ...

Course

MKTG2010

Type

Programming

Subject

Statistics

University

The University of Newcastle

BUS5DWR-Data wrangling

Question

Answered

Part 1 

The spreadsheet titled ‘sports_and_recreation.xlsx’ details the location, types of sport played as well as the condition, age and other details about sports and recreational facilities in Victoria. 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 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, manipulate it and output the result to a single csv file having the following header row. Each row should provide the details for a single sport within a sports and recreation facility (ignore cases where the sport is unspecified). facility_ID,facility_name,street_no,street_name,street_type,suburb_town,postcode,LGA,latitude,long itude,sports_played,number_field_courts,field_surface_type,facility_age,facility_condition,facility_up grade_age

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.

a) Read the data into a dataframe (or tibble). 

b) Observe the layout of the data and describe any issues you encounter in terms of missing or duplicated data. Make the necessary modification of rows for consistency. 

c) Write a function that takes in a facility ID and outputs a dataframe with one or more rows, where each row is specific to the details of a single sport within a facility.

d) Apply the function to each facility name and then combine the rows to form a single dataframe.

e) Split the (latitude, longitude) attribute into two separate columns.

f) Split the address attribute into its components as listed above (note that not all addresses are complete so there may be more than one case to consider). 

i. Note that the street number may have two words such as “Lot 1A” but a street number is assumed to have at least one digit character.

ii. Note that the street type may have two words such as “Street North”.

iii. Assume the suburb/town attribute is the part of the address in capitals before the postcode.

g) Include the above header row for the dataframe. 

h) Do a summary of the dataframe to look for unusual values, then correct them until satisfied with the result.

i) Sort the dataframe by facility_ID, then sports_played. 

j) Write the result to a csv file. 

3. How many facilities offer softball with at least 5 fields? 

Part 2 

The online hospitality company Airbnb has made publicly available a number of datasets

Write R code to answer the following. 

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

a. Spacious, cosy

b. Vibrant, bright 

3. How many listings had last review date in the past 14 days up to and including January 6 2018?

4. How many host names (not host ids) are mentioned between 10 and 20 times (inclusive) in the listings? 

5. List the five top neighbourhoods sorted in decreasing order by average number of reviews. In a third column show the average value of availability_365 for that neighbourhood. (1 mark)

6. Write a function that has listing id as input and calculates the (direct) distance in kilometres between the location of the listing and the Melbourne CBD with latitude/longitude coordinates (-37.8136°, 144.9631°). Look up and use the haversine formula to perform this using an earth radius of 6370km (you may use an R package). Hence determine the number of listings that are between 5 and 10km from the Melbourne CBD.

7. Suppose somebody wants to choose a listing based on the following criteria. Write one or more functions that inputs a listing id and calculates a score that is the sum of points as below:

a. Points for the location: 50 × (10 minus haversine formula distance in kilometres to the nearest table tennis facility in km) but not less than zero (this uses the sports_played and location attributes in the cleaned dataset from Part 1)

b. Points for price: (300 minus price) but not less than zero

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

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

e. Points by popularity based on the number of reviews: 100 if at least in the top quartile, 0 if less than the median value, 50 otherwise Which id has the highest score according to the above system? 

Part 3 

Write a short report describing the two (processed) datasets from parts 1 and 2 through tables and plots with R including the following:

• A summary of the variables using the summarytools package. Include at least two observations you feel are worth noting. 

• A histogram showing the distribution of the distance of listings from the Melbourne CBD (using the result from Part 2). Use a bin width of 1km. 

• A single map combining a subset of the data from each of the two datasets (e.g. it could be in a single LGA). You will need to use an R package that can map geospatial data. 

• Choose one sport and do a visualisation of your choice including one or more of the following variables from the dataset of part 2. 

BUS5DWR-Data wrangling

Answer in Detail

Solved by qualified expert

Get Access to This Answer

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

27 More Pages to Come in This Document. Get access to the complete answer.

MyAssignmenthelp.com is diligent to fulfil students needs in the best possible manner by providing both thesis writing services and thesis editing services. We boast separate teams of thesis writing experts and editors who handle the students requests like can anyone do editing of my thesis online or can someone write my thesis online. Thus, we have gained the status of being the most efficient and reliable thesis help provider company in USA.

More BUS5DWR BUS5DWR-Data wrangling: Questions & Answers

Q
icon

We aren't endorsed by this University

NES8006 Sustainable Agriculture

Task: Background You are a scientist interested in analysing milk production performance in dairy cattle. You used 10 cows from 3 breeds (Friesian, Ayrshire and Shorthorn) and recorded: parity (number of times the cow calved), milk yield (kg/day) for the current lactation, milk yield (kg/day) for ...

View Answer
Q

Management

These questions are for exploratory purposes; you don’t need to hand them in for marking, but they touch on important topics that might be covered on a test. 1. On the basis of these readings, what are the “three key dimensions” used in calculating the HDI? 2. How are the three dim ...

View Answer
Q

Business Report Proposal

Question: You and a group of investors are interested in setting up a chain of aged care homes in a number of Local Government Areas in Australia. In order to do this successfully you need to ensure that the regions you choose will support your business over the next 10 years. Your minimum criteria ...

View Answer
Q
icon

We aren't endorsed by this University

MKTG2010 Marketing Research

Questions: (1) To effectively communicate the findings of the marketing research project (2)  To provide interpretations of those findings in the form of sound and logical recommendations,  (3)  To establish the credibility of the research project, and  (4)  To serve ...

View Answer

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

Choose Our Best Expert to Help You

expert
student rating student rating student rating student rating student rating
Edward Mason

PhD in Geography

1540 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Chris Watkins

Master's in Roman History

12 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Andrew Barnes

Master of Operations Management with specialization in applied science

1261 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Winston Larsen

I have got my Master’s in Economics from the National University of Singapore.

800 - Completed Orders

Hire Me

Still in Two Minds? The Proof is in Numbers!

33845 Genuine Reviews With a Rating of 4.9/5.

student rating student rating student rating student rating student rating
27 Jan 2022

Psychology

Home Work: 2 Pages, Deadline: 1 day

This is a really good service, It is rare to have them miss the assignment. I always come back with at least an 85

flag User ID: 4***21 Charlotte, United States

student rating student rating student rating student rating student rating
27 Jan 2022

Psychology

Assignment: 1 Page, Deadline: 1 day

This is a really good service, It is rare to have them miss the assignment. I always come back with at lease an 85

flag User ID: 4***21 Charlotte, United States

student rating student rating student rating student rating student rating
27 Jan 2022

Maths

Assignment: 2 Pages, Deadline: 4 days

helped me so much when I was at a time crunch, and they really pulled through for me

flag User ID: 5***12 Charlotte, United States

student rating student rating student rating student rating student rating
26 Jan 2022

Statistics

Assignment: 5 Pages, Deadline: 12 days

Great service and perfect work and fast feedbacks as well i have no doubt in the work

flag User ID: 2***25 Khobar, Saudi Arabia

student rating student rating student rating student rating student rating
26 Jan 2022

Marketing

Assignment: 1 Page, Deadline: 6 days

Got help from this expert for this assignment. I got an A and was very pleased with the help and grade. Will use again.

flag User ID: 5***56 San Francisco, United States

student rating student rating student rating student rating student rating
26 Jan 2022

Property Law

Assignment: 12 Pages, Deadline: 12 days

Just received very good marks. Very happy with his service. Answer all questions nicely and all require points are included and good eassy writing sty ...

flag User ID: 6***34 San Francisco, Singapore

student rating student rating student rating student rating student rating
26 Jan 2022

Project Management

Assignment: 6 Pages, Deadline: 1 day

I got my assignment delivered before the deadline, and it was an excellent job done.

flag User ID: 8***21 San Francisco, Nigeria

student rating student rating student rating student rating student rating
26 Jan 2022

Healthcare

Assignment: 0 Pages, Deadline: 22 hours

great work and need more concise and explanation, provide feedback as soon as possible

flag User ID: 8***48 San Francisco, Saudi Arabia

student rating student rating student rating student rating student rating
26 Jan 2022

Management

Essay: 4 Pages, Deadline: 2 days

I was impressed with the adjustment made to the report to suit the APA 7 edition style with citations for all answers.

flag User ID: 8***17 San Francisco, United States

student rating student rating student rating student rating student rating
26 Jan 2022

Marketing

Assignment: 8 Pages, Deadline: 21 days

Thank you once again excellent paper, will use service again, extremely efficient understood the requirements.

flag User ID: 7***88 Melbourne, Australia

student rating student rating student rating student rating student rating
26 Jan 2022

Economics

Course Work: 4 Pages, Deadline: 6 days

Thank you for the constant support and understanding and work towards my project

flag User ID: 8***56 Melbourne, Canada

student rating student rating student rating student rating student rating
26 Jan 2022

English

Essay: 8 Pages, Deadline: 10 days

the expert who worked on this assignment did a great job of following all the instruction I provided for this assignment and delivered it perfectly. G ...

flag User ID: 3***04 Melbourne, Bahrain

student rating student rating student rating student rating student rating
25 Jan 2022

Finance

Programming: 2 Pages, Deadline: 23 hours

Good not bad. But if the solution with more analysis and explanation will be great

flag User ID: 8***49 Melbourne, Saudi Arabia

student rating student rating student rating student rating student rating
25 Jan 2022

Management

Assignment: 6 Pages, Deadline: 5 days

Perfect work was delivered by the expert, I have been using my assignment help for quite some time now and it has been very helpful in providing excel ...

flag User ID: 8***14 Mississauga, Canada

student rating student rating student rating student rating student rating
25 Jan 2022

Chemistry

Assignment: 1 Page, Deadline: 5 days

Assignment was completed as requested! Was very organized and neat. Included all the parts!

flag User ID: 2***50 Kitchener, Canada

student rating student rating student rating student rating student rating
25 Jan 2022

Psychology

Assignment: 4 Pages, Deadline: 1 day

It was a good one thank you. I did have to correct some of the mistakes. After that, everything was good.

flag User ID: 6***66 Kitchener, United States

student rating student rating student rating student rating student rating
25 Jan 2022

Statistics

Programming: 2.6 Pages, Deadline: 7 days

Fully trust this service with perfect score. Would recommend to friends and family. Keep up the good work. Will definitely use the service.

flag User ID: 6***65 Hughesdale, Australia

student rating student rating student rating student rating student rating
25 Jan 2022

Management

Essay: 6 Pages, Deadline: 2 days

Perfect score. Great results and the marks was as expected. I trust this service fully with all my assessments.

flag User ID: 6***65 Hughesdale, Australia

student rating student rating student rating student rating student rating
25 Jan 2022

Criminal Law

Thesis: 8 Pages, Deadline: 4 days

Great results and the marks was as expected. I trust this service fully with all my assessments.

flag User ID: 6***65 Hughesdale, Australia

student rating student rating student rating student rating student rating
25 Jan 2022

Nursing

Home Work: 1 Page, Deadline: 12 hours

Satisfied with the assignment solution. All is correct, no amendment needed.Thanks

flag User ID: 6***60 Hughesdale, United States

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?