python for data science week 3 assignment solution

Spread the word.

Share the link on social media.

Confirm Password *

Username or email *

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Sorry, you do not have permission to ask a question, You must login to ask a question.

SIKSHAPATH Latest Articles

Python for data science assignment solutions week 3 2022.

Are you looking for help in Python for Data Science NPTEL week 3 assignment answers? So, here in this article, we have provided Python for Data Science week 3 assignment answer’s hint.

Python for Data Science NPTEL Assignment Solutions Week 3

Q1. Choose the appropriate command(s) to filter those booking details whose reservation_status are a No-show?

a. data_hotel_ns = data_hotel.loc[data_hotel.reservation_status = ‘No-Show’] b. data_hotel_ns = data_hotel [data_hotel.reservation_status ‘No-Show’] c. data_hotel_ns data_hotel.reservation_status.loc [data_hotel.isin([ ‘No-Show’])] d. data_hotel_ns = data_hotel.loc[data_hotel.reservation_status.isin([ ‘No-Show’])]

Answer : b. data_hotel_ns = data_hotel [data_hotel.reservation_status ‘No-Show’]

d. data_hotel_ns = data_hotel.loc[data_hotel.reservation_status.isin([ ‘No-Show’])]

For instant notification of any updates, Join us on telegram .

Q2. From the same data, find how many bookings were not canceled in the year 2017?

d. None of the above

Answer : a. 9064

Q3. From the total bookings that were made in 2017 and not canceled, which month had the highest number of repeated guests?

b. February

Answer: c. January

Q4. Which of the following commands can be used to create a variable Flag, and set the values as Premium when the rating is equal to or greater than 3.25, and otherwise as Regular?

a. dt_cocoa[‘Flag’] = [“Premium” if x > 3.25 else “Regular” for x in dt_cocoa[‘Rating’]]

b. dt_cocoa[‘Flag’] = [“Premium” if x >= 3.25 else “Regular” for x in dt_cocoa[ ‘Rating’]]

c. dt_cocoa[“Flag”] = np.where(dt_cocoa[“Rating”] < 3.25, “Regular”, “Premium”

Answer: b. dt_cocoa[‘Flag’] = [“Premium” if x >= 3.25 else “Regular” for x in dt_cocoa[ ‘Rating’]]

Q5. Which instruction can be used to impute the missing values in the column Review Data from the dataframe dt_cocoa by grouping the records company – wise?

a. dt_cocoa[‘Review Date’] = dt_cocoa.groupby([‘Company’])[‘Review Date’].apply(lambda x: x.fillna(x.mode().iloc[0]))

b. dt_cocoa[‘Review Date’] = dt_cocoa.groupby([‘Company’])[‘Review Date’].apply(lambda X: x.fillna(x.mean()))

c. dt_cocoa[‘Review Date’] = dt_cocoa.groupby([‘Company’])[‘Review Date’].apply(lambda x: x.fillna(x.mode()))

Answer: a. dt_cocoa[‘Review Date’] = dt_cocoa.groupby([‘Company’])[‘Review Date’].apply(lambda x: x.fillna(x.mode().iloc[0]))

Q6. After checking the data summary, which feature requires a data conversion considering the data values held?

b. Review Date

Answer: b. Review Date

Q7. What is the maximum average rating for the cocoa companies based out of Guatemala?

d.  None of the above

Answer: c. 3.42

Q8. Which pandas function is used to stack the dataframes vertically?

a. pd.merge()

b. pd.concat()

Answer: b. pd.concat()

Q9. Of the following set of statements, which of them can be used to extract the column Direction as a separate dataframe?

a. df_weather[[‘Direction’]]

b. df_weather.iloc[:,0]

c. df_weather.loc[:, [‘Direction’]]

Answer: a. df_weather[[‘Direction’]]

Q10. A file “Students.csv” contains the attendance and scores of three separate students. This dataset is loaded into a dataframe df_study and a cross table is obtained from the same dataframe which results in the following output

Which one of these students’ average score across all subjects was the lowest? Which subject has the highest average score across students?

a. Harini, Maths

b. Sathi, Maths

c. Harini, Physics

d. Rekha, Maths

Answer: b. Sathi, Maths

Disclaimer: These answers are provided only for the purpose to help students to take references. This website does not claim any surety of 100% correct answers. So, this website urges you to complete your assignment yourself.

Also Available:

Python for Data Science NPTEL Assignment Solutions Week 4

Python for Data Science NPTEL Assignment Solutions Week 2

Related Posts

NPTEL Cloud Computing Assignment 3 Answers 2023

NPTEL Problem Solving Through Programming In C Week 1 & ...

NPTEL Programming In Java Week 6 Assignment Answers 2023

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

• Review Assignment
• Announcements
• About the Course
• Explore Courses

Python for Data Science : Result Published!!

• Log in to your account and navigate to the "Download E-certificate" section.
• Next to "Download E-certificate," you'll find another tab labeled "Share your experience." Click on it.
• Answer the provided questions about your experience.
• Optionally, you can add your picture or skip this step.
• An AI-assisted post will be generated for you. You can share this post on your social media platforms.

Python for Data Science : Final Feedback Form !!!

Dear students, We are glad that you have attended the NPTEL online certification course. We hope you found the NPTEL Online course useful and have started using NPTEL extensively. In this regard, we would like to have feedback from you regarding our course and whether there are any improvements, you would like to suggest.   We are enclosing an online feedback form and would request you to spare some of your valuable time to input your observations. Your esteemed input will help us in serving you better. The link to give your feedback is: https://docs.google.com/forms/d/1WtZsDKHnfaYr8oGHL1Jqld7ydBJTnwCwRWezAXFJl50/viewform We thank you for your valuable time and feedback. Thanks & Regards, -NPTEL Team

March 2024 NPTEL Exams - Hall Tickets Released!

Exam Format - March, 2024!!

Dear Candidate, ****This is applicable only for the exam registered candidates**** Type of exam will be available in the list: Click Here You will have to appear at the allotted exam center and produce your Hall ticket and Government Photo Identification Card (Example: Driving License, Passport, PAN card, Voter ID, Aadhaar-ID with your Name, date of birth, photograph and signature) for verification and take the exam in person.  You can find the final allotted exam center details in the hall ticket. The hall ticket is yet to be released.  We will notify the same through email and SMS. Type of exam: Computer based exam (Please check in the above list corresponding to your course name) The questions will be on the computer and the answers will have to be entered on the computer; type of questions may include multiple choice questions, fill in the blanks, essay-type answers, etc. Type of exam: Paper and pen Exam  (Please check in the above list corresponding to your course name) The questions will be on the computer. You will have to write your answers on sheets of paper and submit the answer sheets. Papers will be sent to the faculty for evaluation. On-Screen Calculator Demo Link: Kindly use the below link to get an idea of how the On-screen calculator will work during the exam. https://tcsion.com/ OnlineAssessment/ ScientificCalculator/ Calculator.html NOTE: Physical calculators are not allowed inside the exam hall. Thank you! -NPTEL Team

Python for Data Science : Solution for Assignment 4 released !!

Dear Learner, The Solution for Assignment 4 have been uploaded for the course "Python for Data Science". The solution set can be accessed using the following link: Assignment 4 solution:  https://onlinecourses.nptel.ac.in/noc24_cs54/unit?unit=56&lesson=140 Please use the discussion forum if you have any queries. Thanks & Regards, NPTEL Team.

Reminder: NPTEL: Exam Registration is date is extended for Jan 2024 courses!

Dear Learner,  The exam registration for the Jan 2024 NPTEL course certification exam is extended till February 20, 2024 - 05.00 P.M . CLICK HERE to register for the exam Choose from the Cities where exam will be conducted: Exam Cities Click here to view Timeline and Guideline : Guideline For further details on registration process please refer the previous announcement in the course page. -NPTEL Team

Python for Data Science : Solution for Assignment 3 released !!

Dear Learner, The Solution for Assignment 3 have been uploaded for the course "Python for Data Science". The solution set can be accessed using the following link: Assignment 3 solution:  https://onlinecourses.nptel.ac.in/noc24_cs54/unit?unit=41&lesson=125 Please use the discussion forum if you have any queries. Thanks & Regards, NPTEL Team.

Week 4 Feedback Form: Python for Data Science!!

Dear Learners, Thank you for continuing with the course and hope you are enjoying it. We would like to know if the expectations with which you joined this course are being met and hence please do take 2 minutes to fill out our weekly feedback form. It would help us tremendously in gauging the learner experience. Here is the link to the form:    https://docs.google.com/forms/d/1y81yHE1ipGTZiTk55_JHWnV2ByKbEB3foyHcpzE7diY/viewform Thank you -NPTEL team

Python for Data Science : Week 4 Supplementary Materials!!

Dear Learners, Please go through the lectures in "Supplementary material for week 4",  as there will be questions asked in the assignment for week 4 as well as in the final exam. Have fun learning. Thanks & Regards NPTEL team

Python for Data Science : Solution for Assignment 1&2 released !!

Dear Learner, The Solution for Assignment 1&2 have been uploaded for the course "Python for Data Science". The solution set can be accessed using the following link: Assignment 1 solution:  https://onlinecourses.nptel.ac.in/noc24_cs54/unit?unit=18&lesson=123 Assignment 2 solution:  https://onlinecourses.nptel.ac.in/noc24_cs54/unit?unit=30&lesson=124 Please use the discussion forum if you have any queries. Thanks & Regards, NPTEL Team.

Python for Data Science : Assignment 4 is live now!!

Dear Learners, The lecture videos for Week 4  have been uploaded for the course "Python for Data Science" . The lectures can be accessed using the following link:   Link:  https://onlinecourses.nptel.ac.in/noc24_cs54/unit?unit=56&lesson=57 The other lectures in this week are accessible from the navigation bar to the left. Please remember to login into the website to view contents (if you aren't logged in already). Practice Assignment-4  for Week-4  is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc24_cs54/unit?unit=56&assessment=134 Assignment-4  for Week-4  is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc24_cs54/unit?unit=56&assessment=139 The assignment has to be submitted on or before Wednesday,[21/02/2024], 23:59 IST. As we have done so far, please use the discussion forums if you have any questions on this module. Note : Please check the due date of the assignments in the announcement and assignment page if you see any mismatch write to us immediately. Thanks and Regards, -NPTEL Team

Week 3 Feedback Form: Python for Data Science!!

Python for data science: reminder for assignment 1 & 2 deadline.

Dear Learners, The Deadline for Assignments 1 & 2 will close on Wednesday,[07/02/2024], 23:59 IST. Kindly submit the assignments before the deadline. Thanks and Regards, -NPTEL Team

Python for Data Science : Assignment 3 is live now!!

Dear Learners, The lecture videos for Week 3 have been uploaded for the course "Python for Data Science" . The lectures can be accessed using the following link:   Link:  https://onlinecourses.nptel.ac.in/noc24_cs54/unit?unit=41&lesson=42 The other lectures in this week are accessible from the navigation bar to the left. Please remember to login into the website to view contents (if you aren't logged in already). Practice Assignment-3  for Week-3  is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc24_cs54/unit?unit=41&assessment=133 Assignment-3  for Week-3  is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc24_cs54/unit?unit=41&assessment=137 The assignment has to be submitted on or before Wednesday,[14/02/2024], 23:59 IST. As we have done so far, please use the discussion forums if you have any questions on this module. Note : Please check the due date of the assignments in the announcement and assignment page if you see any mismatch write to us immediately. Thanks and Regards, -NPTEL Team

Week 2 Feedback Form: Python for Data Science!!

Reminder: nptel: exam registration is open now for jan 2024 courses.

Dear Learner, 

Here is the much-awaited announcement on registering for the Jan 2024 NPTEL course certification exam. 

1. The registration for the certification exam is open only to those learners who have enrolled in the course. 

2. If you want to register for the exam for this course, login here using the same email id which you had used to enroll to the course in Swayam portal. Please note that Assignments submitted through the exam registered email id ALONE will be taken into consideration towards final consolidated score & certification. 

3 . Date of exam: Mar 24, 2024 

CLICK HERE to register for the exam.

Choose from the Cities where exam will be conducted: Exam Cities

4. Exam fees: 

If you register for the exam and pay before Feb 12, 2024 - 5:00 PM, Exam fees will be Rs. 1000/- per exam .

5. 50% fee waiver for the following categories: 

Students belonging to the SC/ST category: please select Yes for the SC/ST option and upload the correct Community certificate.

Students belonging to the PwD category with more than 40% disability: please select Yes for the option and upload the relevant Disability certificate. 

6. Last date for exam registration: Feb 16, 2024 - 5:00 PM (Friday). 

7. Between Feb 12, 2024 - 5:00 PM & Feb 16, 2024 - 5:00 PM late fee will be applicable.

8. Mode of payment: Online payment - debit card/credit card/net banking/UPI. 

9. HALL TICKET: 

The hall ticket will be available for download tentatively by 2 weeks prior to the exam date. We will confirm the same through an announcement once it is published. 

10. FOR CANDIDATES WHO WOULD LIKE TO WRITE MORE THAN 1 COURSE EXAM:- you can add or delete courses and pay separately – till the date when the exam form closes. Same day of exam – you can write exams for 2 courses in the 2 sessions. Same exam center will be allocated for both the sessions. 

11. Data changes: 

Last date for data changes: Feb 16, 2024 - 5:00 PM :  

We will charge an additional fee of Rs. 200 to make any changes related to name, DOB, photo, signature, SC/ST and PWD certificates after the last date of data changes.

The following 6 fields can be changed (until the form closes) ONLY when there are NO courses in the course cart. And you will be able to edit those fields only if you: - 

REMOVE unpaid courses from the cart And/or - CANCEL paid courses 

1. Do you come under the SC/ST category? * 

2. SC/ST Proof 

3. Are you a person with disabilities? * 

4. Are you a person with disabilities above 40%? 

5. Disabilities Proof 

6. What is your role? 

Note: Once you remove or cancel a course, you will be able to edit these fields immediately. 

But, for cancelled courses, refund of fees will be initiated only after 2 weeks. 

12. LAST DATE FOR CANCELLING EXAMS and getting a refund: Feb 16, 2024 - 5:00 PM  

13. Click here to view Timeline and Guideline : Guideline

Domain Certification

Domain Certification helps learners to gain expertise in a specific Area/Domain. This can be helpful for learners who wish to work in a particular area as part of their job or research or for those appearing for some competitive exam or becoming job ready or specialising in an area of study.  

Every domain will comprise Core courses and Elective courses. Once a learner completes the requisite courses as per the mentioned criteria, you will receive a Domain Certificate showcasing your scores and the domain of expertise. Kindly refer to the following link for the list of courses available under each domain: https://nptel.ac.in/domains

Outside India Candidates

Candidates who are residing outside India may also fill the exam form and pay the fees. Mode of exam and other details will be communicated to you separately.

Thanks & Regards, 

Python for Data Science : Assignment 2 is live now!!

Dear Learners, The lecture videos for Week 2 have been uploaded for the course "Python for Data Science" . The lectures can be accessed using the following link:   Link:  https://onlinecourses.nptel.ac.in/noc24_cs54/unit?unit=30&lesson=31 The other lectures in this week are accessible from the navigation bar to the left. Please remember to login into the website to view contents (if you aren't logged in already). Practice Assignment-2 for Week-2 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc24_cs54/unit?unit=30&assessment=132 Assignment-2 for Week-2 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc24_cs54/unit?unit=30&assessment=136 The assignment has to be submitted on or before Wednesday,[07/02/2024], 23:59 IST. As we have done so far, please use the discussion forums if you have any questions on this module. Note : Please check the due date of the assignments in the announcement and assignment page if you see any mismatch write to us immediately. Thanks and Regards, -NPTEL Team

Week 1 Feedback Form: Python for Data Science!!

Python for data science : assignment 1 is live now.

Dear Learners, The lecture videos for Week 1 have been uploaded for the course "Python for Data Science" . The lectures can be accessed using the following link:   Link:  https://onlinecourses.nptel.ac.in/noc24_cs54/unit?unit=18&lesson=19 The other lectures in this week are accessible from the navigation bar to the left. Please remember to login into the website to view contents (if you aren't logged in already). Practice Assignment-1 for Week-1 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc24_cs54/unit?unit=18&assessment=131 Assignment-1 for Week-1 is also released and can be accessed from the following link Link:  https://onlinecourses.nptel.ac.in/noc24_cs54/unit?unit=18&assessment=135 The assignment has to be submitted on or before Wednesday,[07/02/2024], 23:59 IST. As we have done so far, please use the discussion forums if you have any questions on this module. Note : Please check the due date of the assignments in the announcement and assignment page if you see any mismatch write to us immediately. Thanks and Regards, -NPTEL Team

Python for Data Science : Assignment 0 is live now!!

Dear Learners, We welcome you all to this course "Python for Data Science" . The assignment 0 has been released. This assignment is based on a prerequisite of the course. You can find the assignment in the link :  https://onlinecourses.nptel.ac.in/noc24_cs54/unit?unit=16&assessment=130 Please note that this assignment is for practice and it will not be graded. Thanks & Regards   -NPTEL Team

NPTEL: Exam Registration is open now for Jan 2024 courses!

Python for data science: welcome to nptel online course - jan 2024.

• Every week, about 2.5 to 4 hours of videos containing content by the Course instructor will be released along with an assignment based on this. Please watch the lectures, follow the course regularly and submit all assessments and assignments before the due date. Your regular participation is vital for learning and doing well in the course. This will be done week on week through the duration of the course.
• Please do the assignments yourself and even if you take help, kindly try to learn from it. These assignments will help you prepare for the final exams. Plagiarism and violating the Honor Code will be taken very seriously if detected during the submission of assignments.
• The announcement group - will only have messages from course instructors and teaching assistants - regarding the lessons, assignments, exam registration, hall tickets, etc.
• The discussion forum (Ask a question tab on the portal) - is for everyone to ask questions and interact. Anyone who knows the answers can reply to anyone's post and the course instructor/TA will also respond to your queries.
• Please make maximum use of this feature as this will help you learn much better.
• If you have any questions regarding the exam, registration, hall tickets, results, queries related to the technical content in the lectures, any doubts in the assignments, etc can be posted in the forum section
• The course is free to enroll and learn from. But if you want a certificate, you have to register and write the proctored exam conducted by us in person at any of the designated exam centres.
• The exam is optional for a fee of Rs 1000/- (Rupees one thousand only).
• Date and Time of Exams: March 24, 2024 Morning session 9am to 12 noon; Afternoon Session 2 pm to 5 pm.
• Registration URL: Announcements will be made when the registration form is open for registrations.
• The online registration form has to be filled and the certification exam fee needs to be paid. More details will be made available when the exam registration form is published. If there are any changes, it will be mentioned then.
• Please check the form for more details on the cities where the exams will be held, the conditions you agree to when you fill the form etc.
• Once again, thanks for your interest in our online courses and certification. Happy learning.

A project of

In association with

[Week 3] NPTEL Python For Data Science Assignment Answer 2023

NPTEL Python For Data Science Assignment Answer

Table of Contents:-

NPTEL Python For Data Science Week 3 Assignment Answer 2023

1. Which of the following is the correct approach to fill missing values in case of categorical variable?

• None of the above

2. Of the following set of statements, which of them can be used to extract the column Type as a separate dataframe?

• df_cars[[‘Type’]]
• df_cars.iloc[[:, 1]
• df_cars.loc[:, [‘Type’]]

3. The method df_cars.describe() will give description of which of the following column?

• Price (in lakhs)
• All of the above

4. Which pandas function is used to stack the dataframes vertically?

• pd.concat()

5. Which of the following are libraries in Python?

6. Which of the following variable have null values?

• Review Date

7. Which of the following countries have maximum locations of cocoa manufacturing companies?

8. After checking the data summary, which feature requires a data conversion considering the data values held?

• Review date
• Bean origin

9. What is the maximum rating of chocolates?

• [bool, int, float, float, str]
• [str, int, float, float, str]
• [bool, int, float, int, str]
• [bool, int, int, float, str]

NPTEL Python For Data Science Week 2 Assignment Answer 2023

1. Which of the following object does not support ind e xing?

• dict i onary

2. Given a NumPy array, arr = np.array([[[1, 2, 3], [4, 5, 6], [7, 8, 9]]]), what is the output of the command, print(arr[0][1])?

• [[1 2 3] [4 5 6] [7 8 9]

3. What is the output of the following code?

• [2, 3, 4, 5]
• [1, 2, 3, 4]
• Will throw an error: Set objects are no t iterable.

5. Which of the following code gives output My friend’s house is in Chennai?

6. Let t1=(1,2, “tuple”,4) and t2=(5,6,7). Which of the follo w ing will not give any error after the execution?

• t1.append(5)
• x=t2[t1[1]]
• t3=(t1 , t2)
• t3=(list(t1), list(t2))

7. Let d={1:“Pyhton”,2:[1,2,3]}. Which among the fol l owing will not give the error after the execution?

• d[2].append(4)
• d.update({‘one’ : 22})

8. Wh i ch of the following data type is immutable?

9. student = {‘name’: ‘Jane’, ‘age’: 25 , ‘courses’: [‘Math’, ‘Statistics’]} Which among the following will return {‘name’: ‘Jane’, ‘age’: 26, ‘courses’: [‘Math’ , ‘Statistics’], ‘phone’: ‘123-456’}?

• student.update({‘age’ : 26})
• student.update({‘age’ : 26, ‘phone’: ‘123-456’}) 
• student[‘phone’] = ‘123-456’

[‘M’, ‘A’, ‘H’, ‘E’, ‘S’, ‘H’] [‘m’, ‘a’, ‘h’, ‘e’, ‘s’ , ‘h’] [‘M’, ‘a’, ‘h’, ‘e’, ‘s’, ‘h’] [‘m’, ‘A’, ‘H’, ‘E’, ‘S’, ‘H’]

NPTEL Python For Data Science Week 1 Assignment Answer 2023

• Error: Invalid operation, unsupported operator ‘*’ used between ‘int’ and ‘str’

• Code will throw an error.

4. Which of the following variable names are INVALID in Python?

• variable_ 1

5. While naming the variable, use of any special character other than unders c ore(_) ill throw which type of error?

• Syntax error
• Value er r or
• Index error

6. Let x = “Mayur”. Which of the following commands converts the ‘x’ to float datatype?

• str(float,x)
• x.flo a t()
• Cannot convert a string to float data type

7. Which Python library is commonly used for data wrangling and manipulation?

9. Given two variables, j = 6 and g = 3.3. If both normal division and floor division operators were used to divide j by g, what would be the data type of the value obtained from the operations?

• float, float

Leave a comment Cancel reply

Save my name, email, and website in this browser for the next time I comment.

NPTEL Python for Data Science Assignment 3 Answers 2023

NPTEL Python for Data Science Assignment 3 Answers 2023:-  All the Answers provided below to help the students as a reference, You must submit your assignment at your own knowledge.

NPTEL Python For Data Science Week 3 Assignment Answer 2023

1. Which of the following is the correct approach to fill missing values in case of categorical variable?

• None of the above

2. Of the following set of statements, which of them can be used to extract the column Type as a separate dataframe?

• df_cars[[‘Type’]]
• df_cars.iloc[[:, 1]
• df_cars.loc[:, [‘Type’]]

3. The method df_cars.describe() will give description of which of the following column?

• Price (in lakhs)
• All of the above

4. Which pandas function is used to stack the dataframes vertically?

• pd.concat()

5. Which of the following are libraries in Python?

6. Which of the following variable have null values?

• Review Date

7. Which of the following countries have maximum locations of cocoa manufacturing companies?

8. After checking the data summary, which feature requires a data conversion considering the data values held?

• Review date
• Bean origin

9. What is the maximum rating of chocolates?

• [bool, int, float, float, str]
• [str, int, float, float, str]
• [bool, int, float, int, str]
• [bool, int, int, float, str]

NPTEL Python for Data Science Assignment 3 Answers 2022 [July-Dec]

1. Choose the appropriate command(s) to filter those booking details whose  reservation_status  are a No-show? a. data_hotel_ns datahotel. loc[data_hotel.reservation_status=’No-Show’] b. data_hotel_ns = data_hotel[ data _hotel.reservation_status = “No-Show’] c. data hotel_ns = data_hotel.reservation_status.loc[data_hotel . isin([‘No-Show’])] d. data_hotel_ns = data_hotel.loc [data hotel.reservation_status.isin([ No-Show’])]

2. From the same data, find how many bookings were not canceled in the year 2017? a. 9064 b. 6231 c. 9046 d. None of the above

Answers will be Uploaded Shortly and it will be Notified on Telegram, So  JOIN NOW

3. From the total bookings that were made in 2017 and not canceled , which month had the highest number of repeated guests? a. July b. February c. January d. None of the above

4. Which of the following commands can be used to create a variable Flag, and set the values as Premium when the  rating  is equal to or greater than 3.25, and otherwise as Regular? a. dt_cocoa[°Flag’] = [“Premium” if x 3.25 else “Regular” for x in dt_cocoa[‘Rating’ ]] b. dt_cocoa[“Flag’] = [“Premium” if x 3.25 else “Regular” for x in dt_cocoa[ ‘ Rating ‘]] c. dt_cocoa[“Flag”] = np.where(dt_cocoa[ “Rating”] < 3.25, “Regular”, “Premium”) d. None of the above

5. Which instruction can be used to impute the missing values in the column Review Data from the dataframe  dt_cocoa  by grouping the records company–wise?

6. After checking the data summary, which feature requires a data conversion considering the data values held? a. Rating b. Review Date c. Company d. None of the above

👇 For Week 04 Assignment Answers 👇

7 . What is the maximum average rating for the cocoa companies based out of Guatemala? a. 4 b. 3.5 c. 3.42 d. None of the above

8. Which pandas function is used to stack the dataframes vertically? a. pd.merge() b. pd.concat() c. join() d. None of the above

9. Of the following set of statements, which of them can be used to extract the column Direction as a separate dataframe? a. df_weather[[ ‘ Direction ‘ ]] b. df_weather.iloc[:,0] c. df_weather.loc[: . [ ‘Direction ‘]] d. None of the above

10. Which one of these students’ average score across all subjects was the lowest? Which subject has the highest average score across students? a. Harini, Maths b. Sathi, Maths c. Harini, Physics d. Rekha, Maths

For More NPTEL Answers:-  CLICK HERE Join Our Telegram:-  CLICK HERE

About Python For Data Science

The course aims at equipping participants to be able to use python programming for solving data science problems.

CRITERIA TO GET A CERTIFICATE

Average assignment score = 25% of average of best 3 assignments out of the total 4 assignments given in the course. Exam score = 75% of the proctored certification exam score out of 100

Final score = Average assignment score + Exam score

YOU WILL BE ELIGIBLE FOR A CERTIFICATE ONLY IF AVERAGE ASSIGNMENT SCORE >=10/25 AND EXAM SCORE >= 30/75. If one of the 2 criteria is not met, you will not get the certificate even if the Final score >= 40/100.

NPTEL Python for Data Science Assignment 3 Answers [Jan 2022]

Q1. Data from the file “brand_data.csv“ has to be loaded into a pandas dataframe. A snippet of the data is shown below:

What is the right instruction to read the file into a dataframe df_brand with 4 separate columns?

Answer:- (B), (C) & (D)

👇 FOR NEXT WEEK ASSIGNMENT ANSWERS 👇

Q2. For the same file above “brand_data.csv“ , which parameter in pd.read_csv will help to load dataframe df_brand with the selected columns as shown below?

(A) index_col  (B) skiprows  (C) usecols  (D) None of the above

Answer:- (C) usecols 

Q3. Data from the file “weather.xlsx“ has to be loaded into a pandas dataframe df_weather which when printed is as shown below:

Of the following set of statements which of them can be used to move the column “Direction” into a separate dataframe

Answer:- (A), (B), (C) & (D)

Q4. Referring to the same dataframe df_weather in Question (3), which statement/statements will help to print the last row from the dataframe?

Answer:- (B) & (D)

Q5. In reference to the same dataframe df_weather, we add an additional column ‘Hot_day’ to determine whether the day is hot or not based on the values in the Temperature column. What will the print statement derive?

(A) True  (B) SyntaxError  (C) False  (D) None of the above

Answer:- (C) False 

Q6. What statement would give the number of columns in a dataframe df?

(A) len(df.columns)  (B) len(df)  (C) df.size  (D) All of the above

Answer:- (A) len(df.columns) 

Q7. A file “Students.csv” contains the attendance and total scores of three separate students. This data is loaded into a dataframe df_study and a pandas crosstab is applied on the same dataframe which results in the following output

Which student scored the maximum average score of all three subjects? Which subject has the best average score for all three students?

(A) Harini,Chemistry  (B) Rekha,Physics  (C) Harini,Physics  (D) Rekha,Maths

Answer:- (D) Rekha,Maths

Q8. The following histogram shows the number of books read in a year:

Find the mean and median in the above histogram.

(A) 7,8  (B) 8,9  (C) 8.5,7  (D) 8,8  (E) None of the above

Answer:- (D) 8,8 

Q9. For the following box plot, which among the given options are the median and the outlier?

(A) 15, 52  (B) 22, 52  (C) 13.5, 29  (D) 25, 50

Answer:- (B) 22, 52 

Q10. A dataframe df_logs has the following data.

All the NaN / Null values in the column C1 can be replaced by zero value by executing which of the following statements?

(A) df_logs[‘C1’].fillna(0,inplace = True)  (B) df_logs.fillna(0,inplace = True)  (C) df_logs.fillna(0,inplace = False)  (D) df_logs[‘C1’].fillna(df_logs[‘B1’],inplace = True)

Answer:- (A) df_logs[‘C1’].fillna(0,inplace = True) 

Disclaimer :- We do not claim 100% surety of solutions, these solutions are based on our sole expertise, and by using posting these answers we are simply looking to help students as a reference, so we urge do your assignment on your own.

For More NPTEL Answers:-  CLICK HERE

Join Our Telegram:-  CLICK HERE

NPTEL Python for Data Science Assignment 3 Answers 2022:-  All the Answers provided below to help the students as a reference, You must submit your assignment at your own knowledge.

Leave a Comment Cancel reply

You must be logged in to post a comment.

Data Analytics with Python | NPTEL | Week 3 Assignment Solutions

This set of MCQ(multiple choice questions) will help you with the answers of  Data Analytics with Python NPTEL Week 3 Assignment Solutions .

You should practice these questions to improve fundamentals of Data Analytics with Python needed for various interviews (like company interview, campus interview, walk-in interview), entrance exams, placements and other competitive exams. All the questions in this particular section are based on only “ Data Analytics with Python NPTEL Week 3 Assignment Solutions “.

Course layout

Week 1 : Basics of Python Spyder Week 2 : Introduction to probability Week 3 : Sampling and sampling distributions Week 4 : Hypothesis testing Week 5 : Two sample testing and introduction to ANOVA Week 6 : Two way ANOVA and linear regression Week 7 : Linear regression and multiple regression Week 8 : Concepts of MLE and Logistic regression Week 9 : ROC and Regression Analysis Model Building Week 10 : c 2  Test and introduction to cluster analysis Week 11 : Clustering analysis Week 12 : Classification and Regression Trees (CART)

NOTE:  You can check your answer immediately by clicking show answer button. Moreover, this set of “Data Analytics with Python NPTEL Week 3 Assignment Solution” contains 10 questions.

Now, start attempting the quiz.

Data Analytics with Python NPTEL Week 3 Assignment Solutions

Q1. Sate True or False: Statement: The specific value of a random variable is called estimator

a) True b) False

Q2. If the true proportion of customers who are below 100 kg weight is 0.4, what is the probability that a sample size 100 yields a sample proportion between 0.3 to 0.4

a) 0.961 b) 0.827 c) 0.706 d) 0.479

Q3. Stratified random sampling is a method of selecting a sample in which

a) the sample is first divided into strata, and then random samples are taken from each stratum b) various strata are selected from the sample c) the population is first divided into strata, and then random samples are drawn from each stratum d) None of these alternatives is correct.

Q4. The Poisson probability distribution is which of the following type?

a) Continuous probability distribution b) Discrete probability distribution c) Uniform probability distribution d) Normal probability distribution

Q5. Assuming a binomial experiment with p = 0.5 and a sample size of 100. The expected value of this distribution is?

a) 0.50 b) 0.30 c) 100 d) 50

Data Analytics with Python NPTEL Week 1 Assignment Solutions

Q6. A hypergeometric probability distribution is identical to

a) the Poisson probability distribution b) the binomial probability distribution c) the normal distribution d) None of these alternatives is correct

Q7. Why one should not go for sampling?

a) Less costly to administer than a census. b) The person authorizing the study is comfortable with the sample. c) Because the research process is sometimes destructive d) None of the above

Q8. A car distributor in city Y experiences on an average 2.5 car sales per day. Find the probability that on a randomly selected day, they will sell 5 car:

a) 0.0668 b) 0.544 c) 0.082 d) 0.205

Q9. In question 8, Find the probability that on a randomly selected day, they will sell no cars:

Q10. In question 8, Find the probability that on a randomly selected day, they will sell at most 2 cars

Previous Year Data Analytics with Python NPTEL Week 3 Assignment Solutions

Q1. State True or False: Statement: The specific value of a random variable is called estimator

Answer: b) False

Q2. If the true proportion of customers who are below 20 years is P=0.35, what is the probability that a sample size 100 yields a sample proportion between 0.3 to 0.4

a) 0.961 b) 0.827 c) 0.706 d) 0.53

Answer: c) 0.706

a) the sample is first divided into strata, and then random samples are taken from each stratum b) various strata are selected from the sample c) the population is first divided into strata, and then random samples are drawn from each stratum d) None of these alternatives is correct

Answer: c) the population is first divided into strata, and then random samples are drawn from each stratum

Q4. State True or False: Statement: A population is a set of all items or individual of interest

Answer: a) True

Q5. A question paper contains 90 multiple choice questions. There are 4 alternative answers (A, B, C or D) out of which only one is correct. Mr X answers these questions randomly (i.e. without preparation). What is the probability that X gets a score of at least 10 marks?

a) 0.9997 b) 0.7894 c) 0 d) 0.001

Answer: a) 0.9997

Q6. On an average 5 % items supplied by manufacturer X are defectives. If a batch of 10 items is inspected: what is the probability that 2 items are defective

a) 0.065 b) 0.075 c) 0.085 d) 0.095

Answer: b) 0.075

Q7. A car distributor in city Y experiences on an average 2.5 car sales per day. Find the probability that on a randomly selected day, they will sell  5 car:

Answer: a) 0.0668

Q8. A car distributor in city Y experiences on an average 2.5 car sales per day. Find the probability that on a randomly selected day, they will sell  no car:

Answer: c) 0.082

Q9. A random sample of 100 people shows that 25 of them are females and rest are males. Form a 95% confidence interval for the true proportion of females. The lower limit of this interval will be:

a) 0.150 b) 0.145 c) 0.165 d) 0.175

Answer: c) 0.165

Q10. A random sample of 100 people shows that 25 of them are females and rest are males. Form a 95% confidence interval for the true proportion of females. The upper limit of this interval will be:

a) 0.150 b) 0.165 c) 0.465 d) 0.335

Answer: d) 0.335

<< Prev- Data Analytics with Python Week 2 Assignment Solutions

>> Next- Data Analytics with Python Week 4 Assignment Solutions

Programming in Java NPTEL week 1 quiz answers

Nptel – Deep Learning assignment solutions

For discussion about any question, join the below comment section. And get the solution of your query. Also, try to share your thoughts about the topics covered in this particular quiz.

Related Posts

Operating system fundamentals | nptel | week 0 assignment 0 solution, nptel operating system fundamentals week 1 assignment solutions, nptel operating system fundamentals week 10 answers, nptel operating system fundamentals week 2 assignment solutions, nptel operating system fundamentals week 3 assignment solutions, nptel operating system fundamentals week 4 assignment solutions, leave a comment cancel reply.

Your email address will not be published. Required fields are marked *

Save my name, email, and website in this browser for the next time I comment.

• 1st Central Law Reviews: Expert Legal Analysis & Insights

[Week 1-4] NPTEL Python For Data Science Assignment Answers 2023

NPTEL Python For Data Science Assignment Answers

Table of Contents

NPTEL Python For Data Science Week 4 Assignment Answer 2023

1. Which of the following are regression problems? Assume that appropriate data is given.

• Predicting the house price.
• Predicting w h ether it will rain or not on a given day.
• Predicting the maximum temperature on a g iven day.
• Predicting the sales of the ice-creams.

2. Which of the followings are binary classification problems?

• Predicting whether a patient is diagnosed with cancer or not.
• Predicting whether a team will win a tournament or not.
• Predicting the price of a second-hand car.
• Classify web text into one of the follow in g categories: Sports, Entertainment, or Technology.

3. If a linear regression model achieves zero training error, can we say that all the data points lie on a hyperplane in the (d+1)-dimensional space? Here, d is the nu m ber of features.

Read the information given below and answer the questions from 4 to 6: Data Description: An automotive service chain is launching its new grand service station this weekend. They offer to service a wide variety of cars. The current capacity of the station is to check 315 cars thoroughly per day. As an inaugural offer, they claim to freely check all cars that arrive on their launch day, and report whether they need servicing or not!

Unexpectedly, they get 450 cars. The servicemen will not work longer than the working hours, but the data analysts have to!

Can you save the day for the new service station?

How can a data scientist save the day for them?

He has been given a data set, ‘ ServiceTrain.csv ’ that contains some attributes of the car that can be easily measured and a conclusion that if a service is needed or not.

Now for the cars they cannot check in detail, they measure those attributes and store them in ‘ ServiceTest.csv ’

Problem Statement:

Use machine learning techniques to identify whether the cars require service or not

Read the given datasets ‘ ServiceTrain.csv ’ and ‘ ServiceTest.csv ’ as train data and test data respectively and import all the required packages for analysis.

4. Which of the following machine learning techniques would NOT be ap p ropriate to solve the problem given in the problem statement?

• Random Forest
• Logisti c Regression
• Linear regression

5. After applying logistic regression, what is/are the correct observat ion s from the resultant confusion matrix?

• True Positive = 29, True Negative = 94
• True Positive = 94, Tr u e Negative = 29
• False Positive = 5, True Negative = 94
• None of the above

Prepare the data by following th e steps given below, and answer questions 6 and 7.

• Encode categorical variable, Service – Yes as 1 and No as 0 for both the train and test datasets.
• Split the set of independent features and the dependent feature on both the train and test datasets.
• Set random_state for the instance of the logistic regression class as 0.

6. The logistic regression model built between the input and output variables is checked for its prediction accuracy of the test data. What is the accuracy range (in %) of the predictions made over test dat a ?

• 60 – 79
• 90 – 9 5

7. How are categorical variables preprocessed before m odel building?

• Standardization
• Dummy var i ables
• Correlation

The Global Happiness Index report contains the Happiness Score data w i th multiple features (namely the Economy, Family, Health, and Freedom) that could affect the target variable value.

Prepare the data by following the steps g iven below, and answer question 8

• Split the set of independent features and the dependent feature on the given dataset
• Create training and testing data from the set of independent features and dependent feature by splitting the original data in the ratio 3:1 respectively, and set the value for random_state of the training/test split method’s instance as 1

8. A multiple linear regression model is built on the Global Happiness Index dat a set ‘GHI_Report.csv’. What is the RMSE of the baseline model?

9. A regression model with the following function y=60+5.2x was built to understand the impact of humidity (x) on rainfall (y). The humidity this week is 30 more than the previous week. Wh a t is the predicted difference in rainfall?

10. X and Y are two variables that have a strong linear relationship. Whi c h of the following statements are incorrect?

• There cannot be a negative relationship between the two variables.
• The relationship between the two variables is purely causal.
• One variable may or may not cause a change in the other variable.
• The variables can be positively or negativel y correlated with each other

NPTEL Python For Data Science Week 3 Assignment Answer 2023

1. Which of the following is the correct approach to fill missing values in case of categorical variable?

2. Of the following set of statements, which of them can be used to extract the column Type as a separate dataframe?

• df_cars[[‘Type’]]
• df_cars.iloc[[:, 1]
• df_cars.loc[:, [‘Type’]]

3. The method df_cars.describe() will give description of which of the following column?

• Price (in lakhs)
• All of the above

4. Which pandas function is used to stack the dataframes vertically?

• pd.concat()

5. Which of the following are libraries in Python?

6. Which of the following variable have null values?

• Review Date

7. Which of the following countries have maximum locations of cocoa manufacturing companies?

8. After checking the data summary, which feature requires a data conversion considering the data values held?

• Review date
• Bean origin

9. What is the maximum rating of chocolates?

• [bool, int, float, float, str]
• [str, int, float, float, str]
• [bool, int, float, int, str]
• [bool, int, int, float, str]

NPTEL Python For Data Science Week 2 Assignment Answer 2023

1. Which of the following object does not support ind e xing?

• dict i onary

2. Given a NumPy array, arr = np.array([[[1, 2, 3], [4, 5, 6], [7, 8, 9]]]), what is the output of the command, print(arr[0][1])?

• [[1 2 3] [4 5 6] [7 8 9]

3. What is the output of the following code?

• [2, 3, 4, 5]
• [1, 2, 3, 4]
• Will throw an error: Set objects are no t iterable.

5. Which of the following code gives output My friend’s house is in Chennai?

6. Let t1=(1,2, “tuple”,4) and t2=(5,6,7). Which of the follo w ing will not give any error after the execution?

• t1.append(5)
• x=t2[t1[1]]
• t3=(t1 , t2)
• t3=(list(t1), list(t2))

7. Let d={1:“Pyhton”,2:[1,2,3]}. Which among the fol l owing will not give the error after the execution?

• d[2].append(4)
• d.update({‘one’ : 22})

8. Wh i ch of the following data type is immutable?

9. student = {‘name’: ‘Jane’, ‘age’: 25 , ‘courses’: [‘Math’, ‘Statistics’]} Which among the following will return {‘name’: ‘Jane’, ‘age’: 26, ‘courses’: [‘Math’ , ‘Statistics’], ‘phone’: ‘123-456’}?

• student.update({‘age’ : 26})
• student.update({‘age’ : 26, ‘phone’: ‘123-456’}) 
• student[‘phone’] = ‘123-456’

[‘M’, ‘A’, ‘H’, ‘E’, ‘S’, ‘H’] [‘m’, ‘a’, ‘h’, ‘e’, ‘s’ , ‘h’] [‘M’, ‘a’, ‘h’, ‘e’, ‘s’, ‘h’] [‘m’, ‘A’, ‘H’, ‘E’, ‘S’, ‘H’]

NPTEL Python For Data Science Week 1 Assignment Answer 2023

• Error: Invalid operation, unsupported operator ‘*’ used between ‘int’ and ‘str’

• Code will throw an error.

4. Which of the following variable names are INVALID in Python?

• variable_ 1

5. While naming the variable, use of any special character other than unders c ore(_) ill throw which type of error?

• Syntax error
• Value er r or
• Index error

6. Let x = “Mayur”. Which of the following commands converts the ‘x’ to float datatype?

• str(float,x)
• x.flo a t()
• Cannot convert a string to float data type

7. Which Python library is commonly used for data wrangling and manipulation?

9. Given two variables, j = 6 and g = 3.3. If both normal division and floor division operators were used to divide j by g, what would be the data type of the value obtained from the operations?

• float, float

Share your love

Related posts.

[Week 1-12] NPTEL Cyber Security and Privacy Assignment Answers 2023

NPTEL Customer Relationship Management Assignment Answer (week 1-2) 2023

[Week 1 to 8] NPTEL Developing Soft Skills And Personality Assignment Answer 2023

NPTEL Plastic Waste Management Assignment Answer (week 1-2) 2023

[week 1] nptel global marketing management assignment answers 2024, [week 1] nptel plastic waste management assignment answers 2024, leave a comment cancel reply.

Your email address will not be published. Required fields are marked *

Save my name, email, and website in this browser for the next time I comment.