27823, 1:11 PM (swayamn De NPTEL (https://swayam.go Course outline How does an NPTEL online course work? 0 Week 0 () Week 1 Week 2 () Week 3 () Reading data (unit? unite41&lesson=42) @ Pandas Datatrames | (unit? Unit=41&lesson=43) Pandas Dataframes I hitpsortinecourses.np 1 innoe23_cs2 lunt?unit=41assessment=104 Python for Data Science -- Unit 5- Week 3 ) (https://swayam.gov.in) @ (etpatowayan govbie, diaNeTEL) patnaik.sathyabama@gmail.com » jexplorer?ncCode=NPTEL) » Python for Data Science (course) Week 3: Assignment 3 Your last recorded submission was on 2023-02-08, 11:43 IST Due date: 2023-02-15, 23:59 IST. 1) Which of the following is the correct approach to fill missing values in case of 1 point categorical variable? OMean @ Median O Mode ONone of the above ‘Assume a pandas dataframe df_cars which when printed is as shown below. Based on this information, answer questions 2 and 3. Car name Type Brand Price (in Lakhs) ° A2 Sedan ASP 15 a c3 suv TRE 20 2 D2 Hatchback ASP 14 3 A3 Sedan TOY 13 4 ce Muy TOY 18 2) Of the following set of statements, which of them can be used to extract the column 1 point ‘Type as a separate dataframe?27823, 1:11 PM Blesson=44) Pandas Dataframes Ill (unit? Unit=41&lesson=45) Controt structures & Functions (unit? Unit=41&lesson=46) Exploratory data analysis, (unit? Unit=418lesson=47) Data Visualization- Part | (unit? unit=418lesson=48) Data Visualization- Part (unit? unit=41alesson=49) Dealing with missing data (unit? unit=418lesson=50) Datasets (unit? Uunit=418lesson=51) Week 3: Lecture slides (unit? Unit=41&lesson=52) Week 3-FAQs (unit? unit=418lesson=53) Practice: Week 3: Practice Assignment 3 (assessment? name=96) © Quiz: Week 3: Assignment 3 (assossmont? name=104) hitpsontinecoureesin cvnoe23_c82 unt?unt=4 assessmer Python for Data Science -- Unit 5- Week 3 df cars{(Type'}} df carsiiloc{: 1] Odfcars.locl:, [Type']] (ONone of the above 8) The method df_cars.describe() will give description of which of the following column? 1 point Ocername Ocrana O Price (in aks) @allof the above 4) Which pandas function is used to stack the dataframes vertically? 1 point Opa merge © paconcati Ofeine) ONone of the above 5) Which of the following are liabraries in Python? 1 point OPandas O matpioti Onumey A of the above Read the comma-separated values file hotel bookings.csv {hitps:tirive.google.comifile/al imimTyULec38KJGKYACQMhuPDOc-vldXkview?usp=sharing) as a ddataframe data hotel and answer questions 6 - 8. Please refer to Hotel Bookings Data Description pat (hitps:lirive.google.comfile/d/tkiJmX6mSqatqaNu4SQRCwBWXWhVTUCculview?usp=sharing) for data and variable description. 6) Choose the appropriate command{s) to fiter those booking details whose 1 point reservation-status are 2 No-show? a data_hotel_ns = data_hotel.loc[data_hotel.reservation_status = No-Show’) data_hotel_ns = data_hotel{data_hotel.reservation_status == ‘No-Show’ ] 6 data hotel_ns = data_hotel.reservation_status.loc{data hotel isin(('No-Show'])] 2627823, 1:11 PM Week 3 Feedback Form Python for Data Science (unit? unit=418lesson=100) Download Videos () Books () Text Transcripts () hitpsontinecourees.np Python for Data Science -- Unit 5- Week 3 data_hotel_ns = data_hotel. loc[data_hotel .reservation_status.isin({'No-Show' ])] 7) From the same data, find how many bookings were not canceled in the year 2017? 1 point @ 9064 Oca O 9046 None of the above 8) From the total bookings that were made in 2017 and not canceled, which month had 1 point the highest number of repeated guests? Ouuy O February © January ONone of the above 9), What will be the output of the following code? 1 point import numpy as np B = [True, 2, 3.0, np.nan, “False"] [type(i) for i in B] © [boo int, float, float, st] Ofer, int, oa, float, st] O foot, at, int, st] © foot, int, int, float, st] 1 innoe23_cs2 /unt?unit=41assessmont=104 34218/28, 1:14 PM Python for Data Science -- Unit Week 3 110) Which command is used to generate the plot shown below? 1 point 0 9 2q- oo 05 10 15 20 25 30 35 40 Opttplotx, inesiyle @ pt plotx,inestylo =~") Opttplotx,tnestyle ==") Oplt.plot(x, tinestyle = *") You may submit any number of times before the due date, The final submission will be considered for grading ‘Submit Answers Intps:foninecourses.nptol.ac.invnoc23_es2"/unit?unit=418assessment=104 4a