CIS7031: Programming for Data Analysis - Data processing - IT/Computer Science Assignment Help

Assignment Task:
 

Learning Outcomes
This assessment is designed to demonstrate a student’s completion of the following Learning Outcomes: 

• Critically analyse and evaluate various statistical and computational techniques for analysing datasets and determine the most appropriate technique for a business problem;
• Critically evaluate, develop and implement solutions for processing datasets and solving complex problems in various environments using relevant programming paradigms;
• Evaluate and apply key steps and issues involved in data preparation, cleaning, exploring, creating, optimizing and evaluating models;
• Evaluate and apply aspects of data science applications and their use.

EDGE 
The Cardiff Met EDGE supports students in graduating with the knowledge, skills, and attributes that allow them to contribute positively and effectively to the communities in which they live and work.
Assessment Requirements / Tasks (include all guidance notes)
This assignment will use employment data of Wales from the StatsWales data source.  This dataset provides workplace employment estimates, or estimates of total jobs, for Wales and its NUTS2 areas, along with comparable UK data disaggregated by industry section.

For this assignment students will undertake a data analysis and machine learning approach to reveal the workplace employment landscape of Wales.  

Data processing 
Download the dataset for the period 2009 – 2018 and create a dataframe that concatenates Wales (total) employment value only.
Check for any null value or outlier. If found replace that with mean value.

Data analysis

• For each question provide graph/chart along with your own interpretation (~ 50 words)
• Which industry employed highest and lowest workers over the period?
• Which industry has the highest and lowest overall growth over the period? 
• Which years are the best and worst performing year in relation to number of employment. (highest and lowest employment) 

Visual analysis
Create a dynamic scatter/bubble plot showing the change of workforce number over the period using Plotly express. 

Correlation 
Taking average employment number for each industry over the period, show and identify the highest and lowest correlated industries.

Make a year wise correlation for each industry.  Does the aforementioned industries are also correlated over the each year? Explain your answer. 

Clustering (k means & hierarchical)

Using the best and worst performing year column’s employment data (2.3) undertake a K means clustering analysis (K=2 & 3) and identify industries cluster together.  Write your own interpretation (~100 words).

Using the same dataset (best & worst performing) create a hierarchical cluster.  Compare the cluster with k means clusters. 

Discussion

Provide a brief discussion (~ 300 words) on employment landscape of Wales based on the employment data analysis results. 

This IT/Computer Science Assignment has been solved by our IT/Computer Science 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 an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.