You receive a tab-delimited file where some numeric fields are interpreted as dates (e.g., "3/10" becomes "March 10" in Excel). What is the most effective way to handle this in Text to-Columns?
Change the delimiter to commas before opening the file
Format the column as Text before applying Text-to-Columns
Use the General data format option in Text-to-Columns
Manually change the affected cells back to numbers after splitting
In Python, which statement correctly handles exceptions and ensures that cleanup code is executed?
A research team has a pandas dataframe of medical trial participants. To quickly identify how many different treatment groups exist, which Pandas method would be most efficient?
`len(set(column))`
`column.count()`
`column.nunique()`
`column.value_counts()`
Sign in with Google — it is free — to see every question with its answer and explanation, practise it in learning mode, or take it as a timed mock test.
The IIT Madras BS Tools in Data Science (Tools in Data Science (TDS)) End Term paper sat on 13 Apr 2025, in the January 2025 term, set QDD1: 35 questions for 40 marks in 180 minutes. The first 3 questions are below. Sign in with Google — it is free — to see the whole paper with its answers and explanations, in learning mode or as a timed mock test.
| Feature | Tools in Data Science (TDS) End Term 13 Apr 2025 Set QDD1 at a glance |
|---|---|
| Term | January 2025 term |
| Subject | Tools in Data Science |
| Course code | BSSE2002 |
| Questions | 35 |
| Marks | 40 |
| Duration | 180 min |
| MCQ | 33 |
| MSQ | 2 |
| Official paper | IIT M DIPLOMA AN EXAM QDD3 13 Apr 2025 |
| Negative marking | No negative marking. |
| Updated |
