Python with Data Science

Assignment 3

Due date: 2019-09-23, 23:59 IST.

Your last recorded submission was on 2019-09-17, 17:21 IST

Get description about the data files by clicking on the following links :

mtcars_DataDescription

Diamond_DataDescription

Churn_DataDescription

1 point

The command used for reading a text file in python is: -

 read_ csv 

 read_table 

 read_ excel

 both a and b

1 point

The command used for line plot from the package Matplotlib?

 plot( )

 line( )

 join( )

 plt( ) 

1 point

From the given dataset ‘mtcars.csv’, plot a histogram to check the frequency distribution of the variable ‘mpg’ (Miles per gallon). The interval having the
   highest frequency is: -

 10 to 15

 15 to 20

 25 to 30

 30 to 35

1 point

Which of the following can be inferred from scatter plot of ‘mpg’ (Miles per gallon) vs ‘wt’ (Weight of car) from the dataset mtcars.csv?

 As weight of the car increases, the mpg decreases

 As weight of the car increases, the mpg increases

 There is no relation between weight of the car and mpg

 When weight increases, mpg increases exponentially

1 point

The command from seaborn library that is used to plot the relationship between two numerical variables 

 plotreg( )

 plot( )

 pair( )

 regplot( )

1 point

The function from seaborn library that combines regplot() and FacetGrid is

 regplot( )

 boxplot( )

 lmplot( )

 pairplot( )

1 point

The visual representation of the statistical five number summary of variable (s) is given by

 Pair-plot

 Box-and-Whisker plot

 Scatter plot

 Histogram

1 point

Plot a boxplot for “price” vs “cut” from the dataset “diamond.csv”. Which of the categories under “cut” have the highest median price?

 Good

 Ver Good

 Premium

 Fair

1 point

Create a frequency table (one-way table) for the variable “cut” from the dataset “diamond.csv”. What is the frequency for the cut type “Ideal”?

 13791

 12082

 21552

 21551

1 point

The probability of two different events occurring at the same time is known as

 Marginal probability

 Conditional probability

 Joint probability

 Marginal and Joint probability

1 point

The command to detect NaN (null) values in pandas dataframes is

 isna( ) 

 isnull( )

 isnan( )

 Both a and b

1 point

The command to identify the data type of a column in the dataframe is

 DataFrame.column_name.dtypes

 DataFrame.column_name.ftypes

 DataFrame.column.dtype

 All the above

Read the given data “churn.csv” and save it as a dataframe called churn, and answer the questions from 13 to 18

1 point

The no. of duplicate records in the churn dataframe based on the cutomerID column are

 7

 8

 22

 No duplicates

1 point

In the churn dataframe, what are the total no. of missing values for the variable TotalCharges?

 10

 23

 15

 5

1 point

From the churn dataframe, what is the average monthly charge paid by a customer for the services he/she has signed up for?

 72.56

 62.47

 68.86

 78.58

1 point

In the churn dataframe, under the variable Dependents how many records have “1@#" ?

 9

 6

 2

 8

1 point

The data type of the variable tenure from the churn dataframe is

 int64

 float64

 long

 object

1 point

The command to replace ‘Four’ by 4 and ‘One’ by 1 under the variable “tenure” of the churn dataframe: -

 pandas.Dataframe.where()

 pandas.Dataframe.replace()

 numpy.where()

 all the above

1 point

The Pearson correlation coefficient value ranges from

 0 to 1

 -1 to 1

 -1 to 0

 None of the above

1 point

In control structures, to mark the beginning of sequence of operations, ----- is used

 Curly braces – { }

 Semi colon - ;

 Indentation – (blank space)

 Square bracket - [ ]

You may submit any number of times before the due date. The final submission will be considered for grading.

Share This:

Facebook

Twitter

Google Plus

Pinterest

Linkedin