10:53 18 A lab5 instructions.pdf C Lab 5 Instructions (6%) Data cleaning and preparation Data wrangling: Join, combine, and reshape Task 1 (3%): This exercise uses the provided 'Automobile_data.csv' dataset [1% ] a. Read the dataset into a pandas dataframe and prints the first and last 10 rows. b. Replace all column values which contain "?', na or empty with NaN and write to update "Automobile_data.csv'. [1%] c. Find the company name of the most expensive car. d. Print all bmw car details. e. For each company, count the total number of cars and then finds the car detail with the highest price. f. For each company, find the average mileage. [1%] g. Sort all cars by price and then by horsepower. Task 2 (1%) create two different data frames as follows and concatenate them. rank team rating rank team rating 1 England 126 1 Australia 102 India 121 2 SriLanka 100 3 NewZealand 112 3 Pakistan 93 4 SouthAfrica 111 4 WestIndies 79 Task 3 (2%) create two different data frames as follows and perform outer, right, left and inner joins between them. Clearly explain the reasons of the results in the markdown texts. rank team rating rank team rating 1 England 126 India 126 2 India 121 N England 121 3 NewZealand 1 12 SouthAfrica 112 4 SouthAfrica 111 A NewZealand 111 5 Pakistan 102 5 Australia 102 6 Australia 100 6 SriLanka 100 7 Bangladesh 93 J Pakistan 93 8 SriLanka 79 WestIndies 79 0= 1 500 0= n Dashboard Calendar To-do Notifications Inbox