MauryaHub PYQ Practice

Tools in Data Science · End Term · Sep 2022 · AN

Tools in Data Science · End Term · Sep 2022 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 / 46 published solutions

Question 90 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 Q90

Question 91 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 Q91

Question 92 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 Q92

Question 93 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 Q93

Question 94 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 Q94

Question 95 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 Q95

Question 96 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 Q96

Question 97 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 Q97

Question 98 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 Q98

Question 99 MCQ · 1.0 marks

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 Q99

Question 100 MCQ · 1.0 marks

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, 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

A published solution is not available for this question yet.

Report a correction for Q100

Question 101 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 Q101

Question 102 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 Q102

Question 103 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 Q103

Question 104 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 Q104

Question 105 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 Q105

Question 106 MCQ · 1.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 Q106

Question 107 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 Q107

Question 108 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 Q108

Question 109 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 Q109

Question 110 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 Q110

Question 111 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 Q111

Question 112 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 Q112

Question 113 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 Q113

Question 114 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 Q114

Question 115 MCQ · 1.0 marks

Source diagram or notation
A.
from sklearn.metrics import mean_absolute_error
B.
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 Q115

Question 116 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 Q116

Question 117 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 Q117

Question 118 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 Q118

Question 119 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 Q119

Question 120 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 Q120

Question 121 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 Q121

Question 122 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 Q122

Question 123 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 Q123

Question 124 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 Q124

Question 125 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 Q125

Question 126 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 Q126

Question 127 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 Q127

Question 128 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 Q128

Question 129 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 Q129

Question 130 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 Q130

Question 131 MCQ · 2.0 marks

Provided below is an incomplete code snippet that enables you to compute distance between two locations. Choose the most appropriate option that can be used in place of **< missing line >** to compute the distance. Assume the coordinates of location one is stored in the variable “loc1” and the coordinates of location 2 is stored in the variable “loc2”.
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 Q131

Question 132 MCQ · 2.0 marks

Provided below is a snippet of the code block of HTML tags from a website providing weather forecast. Your goal is to scrape the high and low values for the 10-day temperature forecast.
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 Q132

Question 133 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 Q133

Question 134 MSQ · 1.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 Q134

Question 135 MSQ · 1.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       **BDM** **Section Id :** 64065329421 **Section Number :** 5 **Section type :** Online **Mandatory or Optional :** Mandatory **Number of Questions :** 21 **Number of Questions to be attempted :** 21 **Section Marks :** 40

A published solution is not available for this question yet.

Report a correction for Q135