BUS5DWR – Data Wrangling and R Assignment 

Assignment Task

Overview

This assignment allows you to demonstrate your knowledge and skills of data wrangling with Text editors and R. Please carefully read the entire assignment to make sure you understand the requirements, the submission format and marking rubrics before starting.

Specific Requirements

The data received from Vivino wine rating IT department comprises three data files: Wine.xlsx, WineRating.txt and Region.csv. The Wine.xlsx file records the information of wine list across the world which detailed information about their ratings is recorded in WineRating.txt and Region.csv records the country of each wine region. You are asked to:

1. Import all the data from different files into three dataframes. Write R codes to fill the last three empty columns in the Wine dataframe with appropriate information provided from the other datasets. (Hint: using merge function….)

2. Assess the data and correct it if necessary. a) Assess data in Wine data frame. (We can describe the expected output here. For example: in each column,students write R code to show: datatype, min-max value (if it is numeric). Write some sentences to describe issues in column (if necessary)Correct data: write R code to fix issues in columns (if necessary)

3. Investigate the data distribution of wine price by drawing its histogram and boxplot and providing your insight.

This BUS5DWR – IT Assignment Help has been solved by our IT Experts at My Uni Papers. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.