In this assignment, you will learn how to import a dataset and create various graphs. To do this assignment, you will need to use Google Colab. Please watch this video to set up Googel Colab.

Task

Follow this tutorial along to complete the following tasks,

• DATA1501 Colab Setup
• DATA1501 - Upload Dataset
• DATA1501 Bar Chart
• DATA1501 Pie Chart and Line Chart

You can also refer to the demo code. Bear in mind that the object of this assignment is not to just copy the demo code and run it.The object is for you to adapt the demo code to a different dataset and the instructions outlined below.The assignment will be graded usingUnit 2 Assignment Rubric (LO3, LO6).

1. Download this .csv file, headcounts then complete the following task. Create a Google Colab file. Load it to a DataFrame and print it out.- 20 points
2. Use a bar chart to compare the head counts between the departments in 2012. -20 points
3. Use a line chart to show the change of the head count of all the departments across the years. -20 points
4. Use a pie chart to show the distribution of the head counts in 2012. -20 points
5. Add title and labels or legends for your charts.Add in-line comments before each task -20 points