CS XXXXXXXXXXHOMEWORK 03: N UMPY AND P ANDAS Purpose This homework will give you practice using two very important Python modules for data manipulation: Numpy and Pandas. Numpy is a powerful library...

I need help with python data manipulation. The questions are under HW03 AND The file for data are under video_games.csv


CS2316 - HOMEWORK 03: N UMPY AND P ANDAS Purpose This homework will give you practice using two very important Python modules for data manipulation: Numpy and Pandas. Numpy is a powerful library for performing mathematical and logical operations on Arrays. It provides an abundance of useful features for operations on n-arrays and matrices in Python. Pandas builds upon Numpy adding even more features and the ability to handle tabular data from nonhomogeneous types. Both of these modules are commonly used by data scientists and analysts. Skills After learning Numpy and Pandas, you’ll be able to input, clean, and aggregate large quantities of data, and then use that data with other Python modules such as SciPy that is used for statistical analysis or Matplotlib that is used for visualizing the data. Knowledge Knowledge of these two very powerful modules will add to your overall Python and data manipulation skills. When given a new data set in your future career, you will have some powerful options on how to �ind answers to questions about the data. Important 1. Due Date: 10/30/2020 at 11:59 pm 2. This homework is graded out of 100 points. 3. This is an individual assignment. You may collaborate with other students in this class. Collaboration means talking through problems, assisting with debugging, explaining a concept, etc. Students may only collaborate with fellow students currently taking CS 2316, the TA's and the lecturer. You should not exchange code or write code for others. For individual assignments, each student must turn in a unique program. Your submission must not be substantially similar to another student' s submission. Collaboration at a reasonable level will not result in substantially similar code. 4. For Help: ○ TA Helpdesk (Schedule posted on class website) ○ Email TA's or use Piazza Forums Notes ○ [ Numpy Reference Guide PDF , Numpy User Guide PDF ] ○ [ Pandas Documentation ] ○ Handouts 5. Comment out or delete all your function calls. Only global variables, and comments are okay to be outside the scope of a function. When your code is run, all it should do is run without any errors. 8. HAVING FUNCTION CALLS OR EXTRANEOUS CODE OUTSIDE THE SCOPE OF FUNCTIONS WILL RESULT IN AN AUTOMATIC 0 . 9 . IF YOUR CODE CANNOT RUN BECAUSE OF AN ERROR, IT IS A 0% https://numpy.org/doc/1.18/numpy-ref.pdf https://numpy.org/doc/1.18/numpy-user.pdf https://pandas.pydata.org/docs/user_guide/io.html CS2316 - HOMEWORK 03: N UMPY AND P ANDAS Introduction Please read through the entire document before starting this homework. The goal of this homework is to demonstrate your understanding of Numpy and Pandas by using Numpy arrays and Pandas dataframes. You will be de�ining a few functions that create and manipulate arrays and dataframes. You should test them out �irst on your own computer, then when you have one or more of them working, upload the entire �ile (which must be named HW03.py) to GradeScope to see how well your code performs on the test cases we have created. The score shown on Gradescope may not re�lect your �inal grade on this assignment. You can submit the homework �ile as many times as you'd like before the deadline. Allowed imports: numpy, pandas, pprint One-line Formatting Correct: def function_a (param1) : return [i for i in param1] or def function_a (param1) : return type(param1) Incorrect: def function_a (param1) : val = [i for i in param1] return val or def function_a (param1) : return helper(param1) def helper (param1) : return [i for i in param1] CS2316 - HOMEWORK 03: N UMPY AND P ANDAS Functions Note: The grading rubric at the end of the document for point distribution. Function name: critic_rater Parameter(s): name