Data Processing

Data Processing:

Following is the data set provided by the Wales Government official site. The data set contains the year 2009 2018:

Data Analysis:

Which industry employed highest and lowest workers over the period?

The industry which provided the lowest number of employees in the period, is ICT: in the year of 2009 (27,800), it is the lowest in year and over the period (2009 2018). The industry which provided the highest among the rest is the Public Administration which provided most employees over the period (434,900), and through every year. Public administration is the high scorer in every year, providing maximum number of employments as compared to rest.

Which industry has highest and lowest overall growth over the period?

The industry of Construction has the highest overall growth over the period with growth of 92,000 over 9 years. The worst growth of the timeline was of the industry of Finance with growth of 1,700.

Which years are the best and worst performing year in relation to number of employment. (Highest and lowest employment)?

When it comes to the least performing year of the rest, the year 2009 is the one to go with; having least number of employments in given timeline. In year 2009 1,248,400 employments were available. Let’s talk about the best performer in the given time period. The year 2018 was the year with most opportunities, providing 1,452,200 employment opportunities.

PCA/Correlation:

The correlation table of the dataset given above is below:

The individual cluster correlation diagram of the years with respect to the industry is given below. The Excel sheet with all the calculation performed on it is also attached.

Clustering:

Cluster analysis or clustering is the task of grouping a set of objects in such a way that objects in the same group are more similar to each other than to those in other groups.

Discussion:

The dataset provided to us to perform different type of tasks was of Wales, as the record of the employment based on every year, having classified the data on basis of the industries. The conclusion based on the dataset provided is stated below. Let’s talk briefly with the industry wise comparison and its performance per hear. The conclusion is totally based on the data provided and the Machine Learning tasks perform served.

 Let’s talk about the Agriculture first, the agricultural industry in the wales is not the one the biggest, however it improved around ~9% in the 9 years of data, having created over 10000 more opportunities as compared to 2008. Talking about the Production it is medium based industry which also improved, not too much did improve worth noticing, next on the list is Construction which was not a big industry until 2208, but in the end of 2018 it has improved 1000% over 9 years. Retail, ICT, Finance performed almost the same and showed up the positive performance on the timeline from year 2008 2018. Real Estate, Professional service, Public Administration and other services also performed better. Public Administration being the best employer industry providing half a million opportunities every year. Public Administration undoubtedly outnumbers the performing industries on the list.