Tools in Data Science (TDS) End Term: 7 August 2022, Set QPD1 (May 2022 term)

The analysis metric slope can be observed through which of the following ways?

Quill provides the option to turn on/off, for displaying the individual comments from the narrative generation process?

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?

Subjectivity score in TextBlob ranges from ___________.

Flourish cannot be used to create animated bar charts.

Which piece of code below will 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?

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?

Kumu is a tool that allows you to (select the most appropriate answer):

Which of the following Python libraries has functions and tools that are useful in the analysis of large graphs?

Which of the following Python libraries has functions extensively written to perform numerical operations?

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:

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:

One of quick ways to generate a descriptive stats file for variables along with correlation is to use

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?

Logical calculations in tableau helps to determine if a certain condition is true or false. Is the following expression valid?

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

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.

What are the two outputs provided by the Excel Azure Machine Learning plugin?

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”.

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.

The final output from the BBC Weather Location Service API is in CSV format:

Which among the following properties are returned by the sentiment function of the TextBlob library?

Subjectivity score ranges between -1 to +1.

A subjectivity score of 0.4 means that the text statement:

A polarity score of 0.1 means that the text statement:

Provided below is a snapshot of the dataset which consists of movie reviews and respective labels.

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.

Choose the most appropriate option that enables you to predict sentiment scores using the Excel Azure Machine Learning add-in.

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?

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?

Tableau automatically divides the data fields into two categories. What are they?

Which Extension in Tableau transforms visualizations into narratives?

If you want to create comical characters while building business stories, which tool would be helpful.?

Which of the following is used to build and host web applications?

Which among the following excel charts is the most suitable for detecting outliers in the data?

Which of the following libraries is used to construct API urls?

Which of the following tabs is used to identify API calls in the Inspect element in any browser?

Google Studio is a tool that allows you to

csr_matrix from the scipy library:

classification_report function from the sklearn.metrics module

pycaret is a

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?

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?

Comicgen is a useful tool in narrating data stories using comics. Which of the following are capabilities of comicgen?

scikit-network package contains functions for (pick all correct sentences):

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:

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