The IIT Madras BS Tools in Data Science (Tools in Data Science (TDS)) End Term paper sat on 24 Dec 2023, in the September 2023 term, set ADD3: 20 questions for 20 marks in 180 minutes. Every question is below with its answer. Take it as a timed mock test to be marked, or read it through first.
How do we find (using Python) all the possible values of categories inside a Pandas data-frame column named ‘book’? The name of the Pandas data-frame is data_df.
data_df.book.unique()
data_df.book.category_name()
data_df['book'].distinct()
data_df['book'].unique()
Correct answers
data_df.book.unique()
data_df['book'].unique()
Which of these are Python libraries specifically useful for Geospatial analysis:
Geopandas
QGIS
Folium
OpenStreetMap
Correct answers
Geopandas
Folium
Using cross-validation we find that the ideal K in a K -Nearest Neighbour procedure is 6. Your friend does not use cross-validation but instead guesses a K of 2. His predictor would:
have higher bias
have higher variance
have lower bias
have lower variance
overfit the data compared to your solution
underfit the data compared to your solution
Correct answers
have higher variance
overfit the data compared to your solution
The analysis metric slope can be observed through which of the following ways?
Trend Line in Line Chart
SLOPE function
None of these
Correct answers
Trend Line in Line Chart
SLOPE function
Under which of the following parts of inspect elements can you find cookie information?
Elements
network
Source
Application
Correct answers
network
Application
By default, for making connections in a Kumu network, which of the following column names are necessary for the data frame that is passed?.
name , attribute
to , from
from , to
first , second
Correct answer
from , to
If the p-value in a regression analysis is less than the significance level (e.g., 0.05), what does it generally indicate?
There is no relationship between variables
The analysis is inconclusive
The relationship between variables is statistically significant
The model is overfitting
Correct answer
The relationship between variables is statistically significant
What is OpenRefine used for?
Data cleaning and transformation
Data compression and storage
Real-time data analysis
Open source refined data
Correct answer
Data cleaning and transformation
In the WEEKNUM function, how can you change the starting day of the week to Sunday?
By using the optional argument: =WEEKNUM(A1, 1)
It is not possible to change the starting day
By using the optional argument: =WEEKNUM(A1, 7)
By adjusting the Excel settings in the options menu
Correct answer
By using the optional argument: =WEEKNUM(A1, 7)
We are interested in fitting an ARIMA model to our time series data. Specifically, we are interested in a moving average model of 0, setting a lag value of 4 for autoregression, and a difference order of 1. Which of the following gives you such a model?
ARIMA(..., trend = (4,1,0))
ARIMA(..., order = (4,1,0))
ARIMA(..., order = (0,4,1))
ARIMA(..., trend = (0,4,1))
Correct answer
ARIMA(..., order = (4,1,0))
Subjectivity score ranges between -1 to +1.
TRUE
FALSE
Correct answer
FALSE
Which of the following tab in chrome devtools will show API calls on the website?
Elements
Console
Sources
Network
APILogs
Correct answer
Network
Chrome devtools can be accessed by which of the following steps?
Right click, choose View page-source
Right click, choose Inspect
Settings, more tools and choose Developer Tools
Settings, extensions and search for devtools
Correct answer
Right click, choose Inspect
Nominatim can output the type of place for every latitutde longitude.
TRUE
FALSE
Correct answer
TRUE
What Streamlit command is used to add text to the app interface?
st.add_text()
st.text()
st.insert_text()
st.display_text()
Correct answer
st.text()
What is a "Tableau Workbook" in Tableau terminology?
A workbook created in Microsoft Excel
A Tableau file containing sheets, dashboards, and stories
A spreadsheet in Tableau
A summary of visualizations
Correct answer
A Tableau file containing sheets, dashboards, and stories
K-Means clustering algorithm is sensitive to the initial choice of centroids. Which parameter in kmeans() function helps the user mitigate this problem?
algorithm
max_iter
n_clusters
n_init
Correct answer
n_init
What is the purpose of the "st.button()" command in a Streamlit app?
Adds a button to trigger an action
Displays the current status of the app
Resets all input fields
Turns the app into full-screen mode
Correct answer
Adds a button to trigger an action
What happens if you choose the "Delimited" option in "Text to Columns" and don't select any delimiter?
The text will be split based on spaces
The text will not be split, and the original content remains unchanged
An error message will be displayed
The text will be split into individual characters
Correct answer
The text will not be split, and the original content remains unchanged
How can you change the calculation performed in the "Values" area of a Pivot Table?
By selecting a function from the “Summarize Values by” in the “Value Field settings”
By right-clicking the cell and choosing "Change Calculation"
By dragging a new field into the "Values" area
By adjusting the cell formatting in the "Values" area
Correct answer
By selecting a function from the “Summarize Values by” in the “Value Field settings”
