Data Wrangling and Exploration Real Time System - IT Assignment Help

Assignment Task

Assignment - 1 Data Wrangling and Exploration
Motivation

The purpose of this assignment is to assess your skills on reading multiple data files, merging them into a singledata frame, applying different cleaning and wrangling steps and then getting the data ready for the modelling. Data Description The observations in the attached CSV files have been taken from the Bureau of Meteorology's "real time" system. These observations provide some details about the weather in the Australian Capital territory for 33 months. Most of the data are generated automatically. Some quality checking has been performed, but it is still possible for erroneous values to appear. Sometimes, when the daily maximum and minimum temperatures, rainfall or evaporation are missing, the next value given has been accumulated over several days rather than the normal one day. There are 33 comma-separated data files provided with this assignment. These data are for the months from August 2018 to February 2021. The variables reported in each file are described in Table I. 
 

Tasks - Part A — Reading (For UG and G students) (15 marks) First, you have 33 CSV files and you need to write R code to 1- Load these files into your working directory and concatenate them into onedata frame (or tibble). You may use loop statements to achieve that. It is recommended to use the functions from the 'tidyverse' package to read and to import these files. However, using any of the other functions is also fine. (10 marks) 2- Please note that the data of the months from Feb-2018 to Jul-2020 have different data's format compared with the data of months from Jul-2020 to Aug-2021. Please ensure that all the data files have the same format for the date column before merging them. (3 marks) 3- After merging the files into a single data frame, please check for problems that may still in the data (2 marks) 
Please note that, appendix-I shows a template code for the structure and the steps of part-A. You can follow it or create your own code structure. 

Part B — Preparation (For UG and G students)

 Write code to do the following tasks -

1- Replace the cells which contain 'calm' values with NA.

 2- Remove the variables, which have no data at all (i.e. all the records in these variables are NAs)
 

The above IT Assignment has been solved by our  IT Assignment  Experts at My Uni Paper. 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.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire considered worthy of the highest distinction.