Tools in Data Science (TDS) End Term: 11 December 2022, Set ETD1-2 (September 2022 term)

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 Power BI 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.

Your project requires you to study the districts and their respective health indicators. You have a shapefile with you that provides the required details. The objective of the project is to identify and carve out districts that present high levels of health indicators. 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 “location1” and the coordinates of location 2 is stored in the variable “location2”.

The dataset consists of year, annual cotton production, annual rainfall, loan interest rates and fuel prices. You would like to compute the correlation coefficient between annual cotton production and other variables in the dataset to analyze the effects of various variables on the target variable. Choose the most suitable option among the following choices:

You would like to prepare your dataset before analysis. You choose python pandas-profiling library to perform exploratory analysis. Choose the most suitable option among the given choices:

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

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?

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

Kumu is a tool that allows you to:

Which of the following libraries has functions extensively written to extract data from Wikipedia pages?

A dataset provided to you has information about countries and respective populations. You plan to visualize the data in Tableau using the map representation. But you are unable to do so because the map representation is not activated for you to choose. What might be the issue? Provided below is a snapshot of the dataset column names and types. Choose the most appropriate option that would solve the problem.

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

___ is helpful to understand the structure of (or inspect) a website before writing a scraping script.

___ library has tools to get a webpage’s html contents into Python.

Type of location (tourist/historic/etc.) can be retrieved using Nominatim in Python

Which of the following delimiters cannot be used in text-to-column function in Excel?

What is the y-axis in autocorrelation plot?

Which of the following tools cannot be used for anonymising the data?

For a one-time anonymization, static anonymization is sufficient. Is this statement true or false?

We are analyzing how much the number of lecture hours attended by students affects their exam scores. Which Excel function would you use as a starting point in this analysis?

We are analyzing how much the number of lecture hours attended by students affects their exam scores, we plan to run a regression analysis after the preliminary analysis. Which of the following features provide you with the capability to do this?

We have a variable X, which can take values AA, BB, or CC. The first 4 values of this variable in a dataset are CC, AA, BB, AA. The format of representing this information as shown in the table below is called:

We have a variable X, which can take values AA, BB, or CC. The first 4 values of this variable in a dataset are CC, AA, BB, AA. This information is represented as shown below.

To convert a variable to this format in Python, one can use:

k-means is typically influenced by the start values. What option in sklearn.cluster.KMeans helps reduce the impact?

A Pandas dataframe DF has a column named salary_range which contains the salary details of 10000 employees of a firm binned as medium, high, and very high. You are interested in finding out the number of employees in each category of salary_range. Which of the following commands will help you to achieve this goal?

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?

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?

pycaret is a

subjectivity and polarity are two properties returned by the sentiment function of library:

A subjectivity score of 0.8 means that the text statement:

A polarity score of negative 0.5 means that the text statement:

You are working on a piece of code that classifies different fruits into its respective groups (citrus, berries, melons, apples & pears, and tropical & exotic). Which of the following loss functions from Keras would you pick for the task?

classification_report function from the sklearn.metrics module

csr_matrix from the scipy library:

Google Studio is a tool that allows you to

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

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

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

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

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 given piece of code extracts and displays details of 9 scheduled airlines in India. Identify which block of code executes without any errors.

Which among the following code blocks will get you the latitude and longitude of “IIT Madras”? Assume the Nominatim library is imported using the command given below:

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.

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