Quiz Space

Tools in Data Science · End Term · 21 Dec 2025 · September 2025 term

Question 17: Scenario 1: Restaurant Review Data Analysis\ Context\ A …

Question 17

+1 markOne correct option

Scenario 1: Restaurant Review Data Analysis
Context
A food delivery platform wants to analyze restaurant reviews to identify trending cuisines and customer satisfaction patterns. They have review data in CSV format with ratings, text comments, and timestamps.
Sample Data (restaurants.csv):

Based on the above data, answer the given subquestions.

The dataset has some missing values in the review_text column (some customers left ratings but no comment). Before analyzing review text for common words, what should you do?

  1. A

    Ignore missing values and let pandas handle them automatically

  2. B

    Remove rows with missing review text using df.dropna(subset=['review_text'])

  3. C

    Replace all missing review text entries with the word "missing"

  4. D

    Delete the entire review_text column from the dataset

Show answer

Correct answer

  • B

    Remove rows with missing review text using df.dropna(subset=['review_text'])

See the whole paperTake it as a mock test

Question 17 of 36 in the IIT Madras BS Tools in Data Science (Tools in Data Science (TDS)) End Term paper sat on 21 Dec 2025, in the September 2025 term (Tools In Data Science 18 Dec 25). It carries 1 mark.

More questions from this paper

  1. Q1Which data serialization format is most efficient for storing large numeric arrays with minimal overhead?
  2. Q2In Git, which command shows the differences between your working directory and the last commit?
  3. Q3What does HTTP status code 429 indicate?
  4. Q4Which Python library is primarily designed for exploratory data analysis and statistical visualization?
  5. Q5What is the main purpose of using environment variables in production systems?
  6. Q6When validating incoming data from external APIs, which validation strategy prevents downstream pipeline failures most …
  7. Q7You are building a daily ETL pipeline that processes customer orders. Orders can arrive late or be updated. Which desig…
  8. Q8Your analytics dashboard queries a large dataset that updates hourly but is queried every few seconds by users. Which c…
  9. Q9When joining datasets from different time zones, you discover that some timestamps lack timezone information. What is t…
  10. Q10You maintain a data pipeline that transforms raw logs into analytics tables. The transformation logic changes frequentl…
  11. Q11When aggregating financial transaction data across multiple currencies, why is it important to store both the original …
  12. Q12Your team builds a recommendation system that suggests products to users. After deployment, you notice that recommendat…
  13. Q13Your data pipeline uses a third-party library that has known security vulnerabilities in older versions. The latest ver…
  14. Q14For ensuring long-term reproducibility of data analysis notebooks that depend on external data sources and multiple lib…
  15. Q15When implementing data lineage tracking for a complex pipeline with multiple data sources, transformations, and outputs…
  16. Q16Your pipeline processes personally identifiable information (PII). A privacy audit requires you to implement data minim…
  17. Q18Scenario 1: Restaurant Review Data Analysis\ Context\ A food delivery platform wants to analyze restaurant reviews to i…
  18. Q19Scenario 1: Restaurant Review Data Analysis\ Context\ A food delivery platform wants to analyze restaurant reviews to i…
  19. Q20Scenario 1: Restaurant Review Data Analysis\ Context\ A food delivery platform wants to analyze restaurant reviews to i…
  20. Q21Scenario 1: Restaurant Review Data Analysis\ Context\ A food delivery platform wants to analyze restaurant reviews to i…
  21. Q22After making changes to your code, what is the correct sequence to save your work and upload it to GitHub?
  22. Q23Two team members both modify the same line in analysis.py on different branches. When the second person tries to merge …
  23. Q24Before pushing your changes, you want to make sure your branch has the latest updates from the main branch. Which comma…
  24. Q25What is the main purpose of creating a pull request (PR) instead of directly merging your branch into main?
  25. Q26When starting work on a new feature, what is the correct Git command sequence to create and switch to a new branch call…
  26. Q27Scenario 3 : Deploying a Data Dashboard with Docker\ Context\ A team built a Python dashboard using Streamlit that visu…
  27. Q28Scenario 3 : Deploying a Data Dashboard with Docker\ Context\ A team built a Python dashboard using Streamlit that visu…
  28. Q29Scenario 3 : Deploying a Data Dashboard with Docker\ Context\ A team built a Python dashboard using Streamlit that visu…
  29. Q30Scenario 3 : Deploying a Data Dashboard with Docker\ Context\ A team built a Python dashboard using Streamlit that visu…
  30. Q31Scenario 3 : Deploying a Data Dashboard with Docker\ Context\ A team built a Python dashboard using Streamlit that visu…
  31. Q32Scenario 4 : OpenRefine for Data Cleaning\ Context\ A researcher has a dataset of company names from different sources.…
  32. Q33Scenario 4 : OpenRefine for Data Cleaning\ Context\ A researcher has a dataset of company names from different sources.…
  33. Q34Scenario 4 : OpenRefine for Data Cleaning\ Context\ A researcher has a dataset of company names from different sources.…
  34. Q35Scenario 4 : OpenRefine for Data Cleaning\ Context\ A researcher has a dataset of company names from different sources.…
  35. Q36Scenario 4 : OpenRefine for Data Cleaning\ Context\ A researcher has a dataset of company names from different sources.…