MauryaHub PYQ Practice

Tools in Data Science · End Term · May 2023 · AN

Tools in Data Science · End Term · May 2023 AN

← Course papers · Start practice / exam

Questions and published explanations below are available without starting a test. Some questions may not have a published solution yet.

0 / 62 published solutions

Question 151 MCQ · 1.0 marks

The analysis metric slope can be observed through which of the following ways?
A.
Trend Line in Line Chart
B.
SLOPE function
C.
Both Trend Line in Line Chart and SLOPE function
D.
None of these

A published solution is not available for this question yet.

Report a correction for Q151

Question 152 MCQ · 1.0 marks

Quill provides the option to turn on/off, for displaying the individual comments from the narrative generation process?
A.
TRUE
B.
FALSE

A published solution is not available for this question yet.

Report a correction for Q152

Question 153 MCQ · 1.0 marks

We are analyzing how much the use of fertilizers affects the agricultural yield of the farmers. Which Excel function would you use as a starting point in this analysis?
A.
STDEV.P()
B.
STDEV.S()
C.
SLOPE()
D.
EXACT()

A published solution is not available for this question yet.

Report a correction for Q153

Question 154 MCQ · 1.0 marks

Subjectivity score in TextBlob ranges from ___________.
A.
0 to 1
B.
-1 to +1
C.
-inf to +inf
D.
0 to inf
E.
0 to 10

A published solution is not available for this question yet.

Report a correction for Q154

Question 155 MCQ · 1.0 marks

Flourish cannot be used to create animated bar charts.
A.
TRUE
B.
FALSE

A published solution is not available for this question yet.

Report a correction for Q155

Question 156 MCQ · 1.0 marks

A very large Matrix **A** has a lot of zero entries in it. Which function from the scipy library is useful in efficient storage of such a matrix **A**?
A.
csr_matrix
B.
interpolate
C.
compressed_mat
D.
zip_mat

A published solution is not available for this question yet.

Report a correction for Q156

Question 157 MCQ · 1.0 marks

Kumu is a tool that allows you to (select the most appropriate answer):
A.
Visualize complex network data
B.
create stunning dashboards for large projects
C.
merge Comicgen characters into a comic
D.
Narrate data stories

A published solution is not available for this question yet.

Report a correction for Q157

Question 158 MCQ · 1.0 marks

Which of the following Python libraries has functions and tools that are useful in the analysis of large graphs?
A.
scikit-network
B.
pandas-network
C.
numpy-network
D.
pd-network

A published solution is not available for this question yet.

Report a correction for Q158

Question 159 MCQ · 1.0 marks

Which of the following Python libraries has functions extensively written to perform numerical operations?
A.
csr_matrix
B.
numpy
C.
seaborn
D.
itertools

A published solution is not available for this question yet.

Report a correction for Q159

Question 160 MCQ · 1.0 marks

You developed a sudden interest in English Premier League. Post the TDS course, you wanted to perform an analysis on all teams which played EPL from the year 1992. You performed PDF scraping using ‘tabula’ and appended every year standings of teams one below the other and saved as a single csv file. For looking at aggregating at various levels (viz Year wise, Team wise) the following can be used in Excel:
A.
Pilot Table
B.
Pivot Table
C.
Pivol Table
D.
None of these

A published solution is not available for this question yet.

Report a correction for Q160

Question 161 MCQ · 1.0 marks

Assume you have data with a column “Direction” which takes the values “Left”, “Right”. If you had used one hot encoding, the new columns added would be:
A.
Direction_Left, Direction_Right
B.
Left_Direction, Right_Direction
C.
Left-Direction, Right-Direction
D.
Direction-Left, Right-Direction

A published solution is not available for this question yet.

Report a correction for Q161

Question 162 MCQ · 1.0 marks

One of quick ways to generate a descriptive stats file for variables along with correlation is to use
A.
pandas_profiling
B.
profiling_pandas
C.
describe_dataset
D.
Dataframe_profile

A published solution is not available for this question yet.

Report a correction for Q162

Question 163 MCQ · 1.0 marks

You decide to use keras to classify images into one of the following categories: cat, dog, bull. Which of the following loss functions from Keras would you pick for the task?
A.
binary_crossentropy
B.
categorical_crossentropy
C.
mean_squared_error
D.
mean_absolute_error

A published solution is not available for this question yet.

Report a correction for Q163

Question 164 MCQ · 1.0 marks

Logical calculations in tableau helps to determine if a certain condition is true or false. Is the following expression valid?
Source diagram or notation
A.
TRUE
B.
FALSE

A published solution is not available for this question yet.

Report a correction for Q164

Question 165 MCQ · 1.0 marks

The dataset consists of geographic, demographic information about countries and their respective GDPs. You would like to visualize this data and study the relationship between the location of countries and their GDPs. You decide to use Tableau to visualize the dataset. But you would also like to generate a summary of the data. Choose the most suitable answer among the given options.
A.
The summary can be generated using Quill and this is possible because Quill can be used as an extension in Tableau.
B.
Tableau can be used for visualization. But Quill is incompatible with Tableau.
C.
Quill does not support generation of summary. Therefore using other visualization tools such as Tableau would work.
D.
None of the options are appropriate for the generation of summary for the given question.

A published solution is not available for this question yet.

Report a correction for Q165

Question 166 MCQ · 1.0 marks

What are the two outputs provided by the Excel Azure Machine Learning plugin?
A.
Percentage, Labels
B.
Sentiment, Percentage
C.
Sentiment, Score
D.
Score, Labels

A published solution is not available for this question yet.

Report a correction for Q166

Question 167 MCQ · 1.0 marks

The final output from the BBC Weather Location Service API is in CSV format:
A.
TRUE
B.
FALSE

A published solution is not available for this question yet.

Report a correction for Q167

Question 168 MCQ · 1.0 marks

Which among the following properties are returned by the sentiment function of the TextBlob library?
A.
Score, Polarity
B.
Polarity, Negativity
C.
Median, Subjectivity
D.
Polarity, Subjectivity

A published solution is not available for this question yet.

Report a correction for Q168

Question 169 MCQ · 1.0 marks

Subjectivity score ranges between -1 to +1.
A.
TRUE
B.
FALSE

A published solution is not available for this question yet.

Report a correction for Q169

Question 170 MCQ · 1.0 marks

A subjectivity score of 0.4 means that the text statement:
A.
has a positive sentiment
B.
has a negative sentiment
C.
is more of an opinion statement
D.
is more of a factual statement

A published solution is not available for this question yet.

Report a correction for Q170

Question 171 MCQ · 1.0 marks

A polarity score of 0.1 means that the text statement:
A.
has a positive sentiment
B.
has a negative sentiment
C.
is more of an opinion statement
D.
is more of a factual statement

A published solution is not available for this question yet.

Report a correction for Q171

Question 172 MCQ · 1.0 marks

We are interested in analyzing the effect of money spent on TV advertising on the sales volume of a product. Which Excel function would you use as a starting point in this analysis?
A.
STDEV.P()
B.
STDEV.S()
C.
SLOPE()
D.
EXACT()

A published solution is not available for this question yet.

Report a correction for Q172

Question 173 MCQ · 1.0 marks

You are working on a piece of code that classifies different vehicles into its respective class (car, LCV, truck, earth movers). Which of the following loss functions from Keras would you pick for the task?
A.
binary_crossentropy
B.
categorical_crossentropy
C.
mean_squared_error
D.
Mean_absolute_error

A published solution is not available for this question yet.

Report a correction for Q173

Question 174 MCQ · 1.0 marks

Tableau automatically divides the data fields into two categories. What are they..?
A.
Measures and categories
B.
Dimensions and Measures
C.
Columns and rows
D.
Matrices and columns

A published solution is not available for this question yet.

Report a correction for Q174

Question 175 MCQ · 1.0 marks

Which Extension in Tableau transforms visualizations into narratives.?
A.
Narrator
B.
Navigator
C.
Quill
D.
Quora

A published solution is not available for this question yet.

Report a correction for Q175

Question 176 MCQ · 1.0 marks

If you want to create comical characters while building business stories, which tool would be helpful.?
A.
Cartoongen
B.
Image size
C.
Comicgen
D.
Gentoon

A published solution is not available for this question yet.

Report a correction for Q176

Question 177 MCQ · 1.0 marks

Which of the following is used to build and host web applications?
A.
Streamlit for building web applications, Heroku for hosting web applications
B.
Heroku for building web applications, Streamlit for hosting web applications
C.
Streamlit for building web applications, Streamlit for hosting web applications
D.
Heroku for building web applications, Heroku for hosting web applications

A published solution is not available for this question yet.

Report a correction for Q177

Question 178 MCQ · 1.0 marks

Which among the following excel charts is the most suitable for detecting outliers in the data?
A.
Bar chart
B.
Line chart
C.
Box and Whisker chart
D.
Histogram

A published solution is not available for this question yet.

Report a correction for Q178

Question 179 MCQ · 1.0 marks

Which of the following libraries is used to construct API urls?
A.
Urllib
B.
BeautifulSoup
C.
Requests
D.
Pandas

A published solution is not available for this question yet.

Report a correction for Q179

Question 180 MCQ · 1.0 marks

Which of the following tabs is used to identify API calls in the Inspect element in any browser?
A.
Network
B.
Elements
C.
Console
D.
Sources

A published solution is not available for this question yet.

Report a correction for Q180

Question 181 MCQ · 1.0 marks

Google Studio is a tool that allows you to
A.
merge Comicgen characters into a comic
B.
visualize complex network data
C.
create dashboards for small scale projects
D.
Edit photographs and videos

A published solution is not available for this question yet.

Report a correction for Q181

Question 182 MCQ · 1.0 marks

csr_matrix from the scipy library:
A.
always helps reduce matrix space
B.
helps reduce matrix space when there are a lot of zero entries in the matrix
C.
helps reduce matrix space when there are a lot of negative entries in the matrix
D.
makes matrix multiplication more meaningful and powerful

A published solution is not available for this question yet.

Report a correction for Q182

Question 183 MCQ · 1.0 marks

classification_report function from the sklearn.metrics module
A.
builds a decision tree classifier and prints the accuracy of the classifier
B.
reports the root mean square error of the model
C.
runs different classification models and compares the results
D.
builds a text report displaying the main classification metrics

A published solution is not available for this question yet.

Report a correction for Q183

Question 184 MCQ · 1.0 marks

pycaret is a
A.
Visualization tool
B.
Dashboard helper
C.
low-code machine learning library
D.
Data cleaning solution

A published solution is not available for this question yet.

Report a correction for Q184

Question 185 MCQ · 1.0 marks

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?
A.
ARIMA(..., trend = (4,1,0))
B.
ARIMA(..., order = (4,1,0))
C.
ARIMA(..., order = (0,4,1))
D.
ARIMA(..., trend = (0,4,1))

A published solution is not available for this question yet.

Report a correction for Q185

Question 186 MCQ · 1.0 marks

Scikit-learn has a DecisionTreeClassifier module that is useful in building decision tree classifiers. Suppose, our dataset is imbalanced in class. Which feature in the DecisionTreeClassifier() will help us tackle this problem?
A.
random_state
B.
min_sample_split
C.
class_balance
D.
class_weight

A published solution is not available for this question yet.

Report a correction for Q186

Question 187 MCQ · 1.0 marks

The data consists of prices of three shares in the stock market over a period of six months. To compute the correlation coefficients between these three shares: (Choose the most suitable option)
A.
It is sufficient if you specify these three shares as input variables in the excel ‘data analysis toolpak’ feature.
B.
You must specify both input and target variables in the excel ‘data analysis toolpak’ to obtain the correlation coefficient values.
C.
It is sufficient if you specify these three shares as target variables in the excel ‘data analysis toolpak’ feature.

A published solution is not available for this question yet.

Report a correction for Q187

Question 188 MCQ · 1.0 marks

Assume the data provided to you has a column that consists of sales dates. You would want to extract the week number from the column for further analysis. Which among the following excel function enables you to perform the above-mentioned task?
A.
WEEKGET()
B.
GETWEEKNUM()
C.
NUMWEEK()
D.
None of these

A published solution is not available for this question yet.

Report a correction for Q188

Question 189 MCQ · 1.0 marks

Which among the following features in excel enables you to scrape data from websites?
A.
Data Analysis Toolpak
B.
Connections
C.
New Query
D.
Data Validation

A published solution is not available for this question yet.

Report a correction for Q189

Question 190 MCQ · 1.0 marks

Which of the following statements about the k-means clustering algorithm is false?
A.
It is guaranteed to converge to the global optimum solution for any given dataset and initial centroids.
B.
It can be sensitive to the choice of initial centroids, and different initializations can lead to different final cluster assignments.
C.
The k-means algorithm minimizes the within-cluster sum of squares as its objective function.
D.
It can be used to cluster both continuous and categorical data.

A published solution is not available for this question yet.

Report a correction for Q190

Question 191 MCQ · 1.0 marks

Which of the following is NOT a method of the Beautiful Soup object?
A.
find()
B.
get()
C.
find_all()
D.
prettify()

A published solution is not available for this question yet.

Report a correction for Q191

Question 192 MCQ · 1.0 marks

What is ComicGen?
A.
A web development framework for comic creators.
B.
A Python library for data analysis and storytelling using comics.
C.
A tool for generating comic strips.
D.
A game development engine.

A published solution is not available for this question yet.

Report a correction for Q192

Question 193 MCQ · 1.0 marks

Network tab in Chrome Devtools (Inspect) tracks all api calls that happen in a website.
A.
TRUE
B.
FALSE

A published solution is not available for this question yet.

Report a correction for Q193

Question 194 MCQ · 1.0 marks

Flourish is a web-based:
A.
Data visualization platform
B.
Machine learning platform
C.
Business intelligence platform
D.
None of these

A published solution is not available for this question yet.

Report a correction for Q194

Question 195 MCQ · 1.0 marks

Which of the tools below are used for data storytelling?
A.
Excel
B.
Quill
C.
Comicgen
D.
Flourish
E.
Excel,Quill,Comicgen
F.
All of these

A published solution is not available for this question yet.

Report a correction for Q195

Question 196 MCQ · 1.0 marks

_______________ data consists of any value within the finite or infinite intervals.
A.Source diagram or notation
Discrete
B.
Continuous
C.
None

A published solution is not available for this question yet.

Report a correction for Q196

Question 197 MCQ · 1.0 marks

From the below options identify the statement that is False
A.
Measures contain numeric, quantitative values that you can measure.
B.
Measures can be aggregated.
C.
When you drag a measure into the view, Tableau applies an aggregation to that measure (by default).
D.
None of these

A published solution is not available for this question yet.

Report a correction for Q197

Question 198 MCQ · 1.0 marks

Which of the following statements about Heroku is true?
A.
Heroku is a cloud-based platform for deploying, managing, and scaling web applications.
B.
Heroku is a programming language used for developing front-end web applications.
C.
Heroku is a database management system used for storing and retrieving data.
D.
Heroku is a web browser used for accessing internet-based applications.

A published solution is not available for this question yet.

Report a correction for Q198

Question 199 MCQ · 1.0 marks

Which data type is not available in the ARX tool while you input data for anonymizing?
A.
String
B.
Date/Time
C.
Continuous
D.
Decimal
E.
Integer

A published solution is not available for this question yet.

Report a correction for Q199

Question 200 MCQ · 1.0 marks

Your model is performing well in your training dataset but is not performing well in test dataset. It means:
A.
Model is overfit
B.Source diagram or notation
Model is underfit
C.
Problem with test dataset
D.
None of these

A published solution is not available for this question yet.

Report a correction for Q200

Question 201 MCQ · 1.0 marks

The following function in excel helps in removing extra spaces:
A.
TRIM
B.
REDUCE
C.
REMOVESPACE
D.
None of these

A published solution is not available for this question yet.

Report a correction for Q201

Question 202 MCQ · 1.0 marks

For categorical variables, missing data can be replaced by:
A.
Mode
B.
Median
C.
Mean
D.Source diagram or notation
None of these

A published solution is not available for this question yet.

Report a correction for Q202

Question 203 MCQ · 2.0 marks

The given piece of code extract details of all Bollywood movies that were released in Jan – March 2009 and later prints out only those rows where the respective movie was categorized only as a Drama. Identify which block of code executes without any errors.
A.Source diagram or notation
B.Source diagram or notation
C.Source diagram or notation
D.Source diagram or notation

A published solution is not available for this question yet.

Report a correction for Q203

Question 204 MCQ · 2.0 marks

Identify which of the following statements is/are TRUE 1. A story contains a single view along with shelves, cards, legends, and the Data and Analytics panes in its side bar. 2. A worksheet contains a sequence of stories that work together to convey information 3. A dashboard is a collection of views from multiple worksheets
A.
1 Only
B.
3 Only
C.
2 & 3 Only
D.
1 & 2 Only

A published solution is not available for this question yet.

Report a correction for Q204

Question 205 MCQ · 2.0 marks

Source diagram or notation
A.
geopy.distance(loc1, loc2).km
B.
geopy.distance(loc1, loc2).km.km
C.
geopy.distance.distance(loc1, loc2).km
D.
geopy.distance.distance.distance(loc1_coord, loc2_coord).km

A published solution is not available for this question yet.

Report a correction for Q205

Question 206 MCQ · 2.0 marks

Source diagram or notation
A.Source diagram or notation
B.Source diagram or notation
C.Source diagram or notation
D.Source diagram or notation

A published solution is not available for this question yet.

Report a correction for Q206

Question 207 MCQ · 2.0 marks

Provided below is a snapshot of the dataset which consists of movie reviews and respective labels.
Source diagram or notation
To compute the sentiment scores the Azure Machine Learning add-in requires input and output values. In the figure provided below the input and output cells need to be populated with appropriate values to obtain sentiment scores.
Source diagram or notation
Choose the most appropriate option that enables you to predict sentiment scores using the Excel Azure Machine Learning add-in.
A.Source diagram or notation
B.Source diagram or notation

A published solution is not available for this question yet.

Report a correction for Q207

Question 208 MCQ · 2.0 marks

Source diagram or notation
A.
from sklearn.metrics import mean_absolute_error
B.Source diagram or notation
from sklearn.metrics import median_absolute_error
C.
from sklearn.metrics import median_absolute_percentage_error
D.
from sklearn.metrics import average_absolute_percentage_error

A published solution is not available for this question yet.

Report a correction for Q208

Question 209 MSQ · 2.0 marks

Comicgen is a useful tool in narrating data stories using comics. Which of the following are capabilities of comicgen?
A.
Comicgen can create comic characters
B.
Comicgen provides options to custom create different comic characters and their emotions and pose
C.
Comicgen can be easily integrated into Google sheets or Excel to narrate your data stories
D.
You can type in your data story into comicgen to get your comic in return

A published solution is not available for this question yet.

Report a correction for Q209

Question 210 MSQ · 2.0 marks

scikit-network package contains functions for (pick all correct sentences):
A.
analysis of faults in a computer network
B.
social network analysis
C.
analysis of large graphs
D.
enhancing one’s social network

A published solution is not available for this question yet.

Report a correction for Q210

Question 211 MCQ · 1.0 marks

Answer the given subquestions.
You decided to perform analysis of the IPL teams year on year. You downloaded the teams standings table which got downloaded as a PDF. You wish to convert to a csv file for further analysis in Excel. The following method in ‘tabula’ can be used for the same:
A.
convert_into
B.
convert_file
C.
convert_all
D.
convert_csv

A published solution is not available for this question yet.

Report a correction for Q211

Question 212 MCQ · 1.0 marks

Answer the given subquestions.
From the converted csv file in previous question, you realize that the team ‘Delhi Daredevil’ has changed its name to ‘Delhi Capital’. Using excel, you wish to replace the old name with a new name. It can be done in Excel using
A.
Find and Replace
B.
Finding and Replacing
C.
Replace and Find
D.
Search and Replace       **BDM** **Section Id :** 64065341311 **Section Number :** 8 **Section type :** Online **Mandatory or Optional :** Mandatory **Number of Questions :** 15 **Number of Questions to be attempted :** 15 **Section Marks :** 40 **Display Number Panel :** Yes

A published solution is not available for this question yet.

Report a correction for Q212