So, let’s start with the first part – top Data Science Interview Questions for Freshers.<\/p>\n
We bring to you a variety of challenging, insightful data science interview questions curated by top data scientists, industry experts, and experienced professionals widely asked in the industry. This will surely help you to get your desired data science job. This blog consists of the following types of questions –\u00a0<\/span><\/p>\n Not only this, all the below data science interview questions cover the important concepts of data science<\/strong><\/em><\/a>, machine learning, statistics, and probability.\u00a0<\/span><\/p>\n Q.1\u00a0What do you understand by the term Normal Distribution?<\/strong><\/p>\n Normal Distribution<\/a><\/strong><\/em> is also known as Gaussian Distribution. It is a type of probability distribution that is symmetric about the mean. it shows that the data is closer to the mean and the frequency of occurrences in data are far from the mean.<\/p>\n Q.2 How will you explain linear regression to a non-tech person?<\/strong><\/p>\n Linear Regression is a statistical technique of measuring the linear relationship between the two variables. By linear relationship, we mean that an increase in a variable would lead to increase in the other variable and a decrease in one variable would lead to attenuation in the second variable as well. Based on this linear relationship, we establish a model that predicts the future outcomes based on an increase in one variable.<\/p>\n Q.3 How will you handle missing values in data?<\/strong><\/p>\n There are several ways to handle missing values in the given data-<\/p>\n Q.4 How will you verify if the items present in list A are present in series B?<\/strong><\/p>\n We will use the isin() function. For this, we create two series s1 and s2 –<\/p>\n Q.5 How to find the positions of numbers that are multiples of 4 from a series?<\/strong><\/p>\n For finding the multples of 4, we will use the argwhere() function. First, we will create a list of 10 numbers –<\/p>\n Output > [3], [7]<\/strong><\/p>\n Q.6 How are KNN and K-means clustering different?<\/strong><\/p>\n Firstly, KNN is a supervised learning algorithm. In order to train this algorithm, we require labeled data. K-means is an unsupervised learning algorithm that looks for patterns that are intrinsic to the data. The K in KNN is the number of nearest data points. On the contrary, the K in K-means specify the number of centroids.<\/p>\n Read our latest article on K-means clustering<\/a> and learn everything about it.\u00a0<\/strong><\/em><\/p>\n Q.7 Can you stack two series horizontally? If so, how?<\/strong><\/p>\n Yes, we can stack the two series horizontally using concat() function and setting axis = 1.<\/p>\n Q.8 How can you convert date-strings to timeseries in a series?<\/strong><\/p>\n Input:<\/strong><\/p>\n To solve this, we will use the to_datetime() function.<\/p>\n Q.9 Python or R \u2013 Which one would you prefer for text analytics?<\/strong><\/p>\n Both Python and R provide robust functionalities for working with text data. R provides extensive text analytics libraries but its data mining libraries are still in a nascent stage. Python is best suited for enterprise level and for increasing software productivity. For handling unstructured data, R provides a vast variety of support packages. Python is best apt at handling colossal data while R has memory constraints and is slower in response to large data. Therefore, the preference for using Python or R depends on the area of functionality and usage.<\/p>\n Revise\u00a0Python vs R<\/a> to frame the answer of this data science interview question<\/strong><\/em><\/p>\n Q.10 Explain ROC curve.<\/strong><\/p>\n Receiver Operating Characteristic is a measurement of the True Positive Rate (TPR) against False Positive Rate (FPR). We calculate True Positive (TP) as TPR = TP\/ (TP + FN). On the contrary, false positive rate is determined as FPR = FP\/FP+TN where where TP = true positive, TN = true negative, FP = false positive, FN = false negative.<\/p>\n Q.11 How is AUC different from ROC?<\/strong><\/p>\n AUC curve is a measurement of precision against the recall. Precision = TP\/(TP + FP) and TP\/(TP + FN). This is in contrast with ROC that measures and plots True Positive against False positive rate.<\/p>\n Q.12 Why is Naive Bayes referred to as Naive?<\/strong><\/p>\n Ans. In Naive Bayes<\/strong><\/em>, the assumptions and probabilities that are computed of the features are independent of each other. It is the assumption of feature independence that makes Naive Bayes, \u201cNaive\u201d.<\/p>\n Q.13 How will you create a series from a given list in Pandas?<\/strong><\/p>\n We will the list to the Series() function.<\/p>\n Q.14 Explain bias, variance tradeoff.<\/strong><\/p>\n Bias leads to a phenomenon called underfitting. This is caused by the introduction of error due to the oversimplification of the model. On the contrary, variance occurs due to complexity in the machine learning algorithm. In variance, the model also learns noise and other distortions that affect the overall performance of it. If you increase the complexity of your model, then the error will go down due to reduction in bias. However, after a certain point, the error will increase due to increasing complexity and addition of noise. This is known as bias-variance tradeoff. A good machine learning algorithm should possess low bias and low variance.<\/p>\n Q.15 What is a confusion matrix?<\/strong><\/p>\n A confusion matrix is a table that delineates the performance of a supervised learning algorithm. It provides a summary of prediction results on a classification problem. With the help of confusion matrix, you can not only find the errors made by the predictor but also the type of errors.<\/p>\n Q.16 What is SVM? Can you name some kernels used in SVM?<\/strong><\/p>\n SVM stands for support vector machine<\/strong><\/em>. They are used for classification and prediction tasks. SVM consists of a separating plane that discriminates between the two classes of variables. This separating plane is known as hyperplane. Some of the kernels used in SVM are –<\/p>\n Support Vector Machine<\/a> – Important topic for data science interview<\/strong><\/em><\/p>\n Q.17 How is Deep Learning different from Machine Learning?<\/strong><\/p>\n Deep Learning is an extension of Machine Learning. It is a special area within ML that is about developing algorithms that simulate human nervous system. Deep Learning involves neural networks which are trained over large datasets to understand the patterns and then perform classification and prediction. Check out the detailed comparison of Deep Learning vs Machine Learning<\/a> in easy steps<\/strong><\/em><\/p>\n Q.18 How can you compute significance using p-value?<\/strong><\/p>\n After a hypothesis test is conducted, we compute the significance of the results. The p-value<\/a> is present between 0 and 1. If the p-value is less than 0.05, then it means that we cannot reject the null hypothesis. However, if it is greater than 0.05, then we reject the null hypothesis.<\/p>\n Q.19 Why don\u2019t gradient descent methods always converge to the same point?<\/strong><\/p>\n This is because, in some cases, they reach to local or local optima point. The methods don\u2019t always achieve global minima. This is also dependent on the data, the descent rate and origin point of descent.<\/p>\n Q.20 Explain A\/B testing.<\/strong><\/p>\n To perform a hypothesis testing of a randomized experiment with two variables A and B, we make use of A\/B testing. A\/B testing is used to optimize web-pages based on user preferences where small changes are added to web-pages that are delivered to a sample of users. Based on their reaction to the web-page and reaction of the rest of the audience to the original page, we can carry out this statistical experiment.<\/p>\n Q.21 What is box cox transformation?<\/strong><\/p>\n In order to transform the response variable so that the data meets its required assumptions, we make use of Box Cox Transformation. With the help of this technique, we can transform non-normal dependent variables into normal shapes. We can apply a broader number of tests with the help of this transformation.<\/p>\n Q.22 What is meant by \u2018curse of dimensionality\u2019? How can we solve it?<\/strong><\/p>\n While analyzing the dataset, there are instances where the number of variables or columns are in excess. However, we are required to only extract significant variables from the group. For example, consider that there are a thousand features. However, we only need to extract handful of significant features. This problem of having numerous features where we only need a few is called \u2018curse of dimensionality\u2019.<\/p>\n There are various algorithms for dimensionality reduction like PCA (Principal Component Analysis).<\/p>\n Q.23 What is the difference between recall and precision?<\/strong><\/p>\n Recall is the fraction of instances that have been classified as true. On the contrary, precision is a measure of weighing instances that are actually true. While recall is an approximation, precision is a true value that represents factual knowledge.<\/p>\n Q.24 What is pickle module in Python?<\/strong><\/p>\n For serializing and de-serializing an object in Python, we make use of pickle module. In order to save this object on drive, we make use of pickle. It converts an object structure into character stream.<\/p>\n Learn everything about Pickle module in Python<\/a><\/strong><\/em><\/p>\n Q.25 What are the different forms of joins in a table?<\/strong><\/p>\n Some of the different joins in a table are –<\/p>\n Q.26 List differences between DELETE and TRUNCATE commands.<\/strong><\/p>\n DELETE command is used in conjunction with WHERE clause to delete some rows from the table. This action can be rolled back.<\/p>\n However, TRUNCATE is used to delete all the rows of a table and this action cannot be rolled back.<\/p>\n Q.27 Can you tell some clauses used in SQL?<\/strong><\/p>\n Some of the commonly used clauses in SQL<\/strong> <\/em><\/a>are –<\/p>\n Q.28 How will you get second highest salary of an employee emp from employee_table?<\/strong><\/p>\n In order to get the second highest salary of an employee, we will use the following query –<\/p>\n According to many data scientist, this question is considered as the most asked data science interview question.\u00a0<\/em><\/p>\n Q.29 What is a foreign key?<\/strong><\/p>\n A foreign key is a special key that belongs to one table and can be used as a primary key of another table. In order to create a relationship between the two tables, we reference the foreign key with the primary key of the other table.<\/p>\n Q.30 What do you mean by Data Integrity?<\/strong><\/p>\n With data integrity, we can define the accuracy as well as the consistency of the data. This integrity is to be ensured over the entire life-cycle.<\/p>\n Q.31 How is SQL different from NoSQL?<\/strong><\/p>\n SQL deals with Relational Database Management Systems<\/strong><\/em><\/a> or RDBMS. This type of database stores structured data that is organized in rows and columns, that is, in a table. However, NoSQL is a query language that deals with Non-Relational Database Management Systems. The data present here is unstructured. Structured data is mostly generated from services, gadgets and software systems. However, unstructured data, which is increasing day by day, is generated from users directly.<\/p>\n Q.32 Can you tell me about some NoSQL databases?<\/strong><\/p>\n Some of the popular NoSQL databases are Redis, MongoDB, Cassandra, HBase, Neo4j etc.<\/p>\n Q.33 How is Hadoop used in Data Science?<\/strong><\/p>\n Hadoop provides the data scientists the ability to deal with large scale unstructured data. Furthermore, various new extensions of Hadoop like Mahout and PIG provide various features to analyze and implement machine learning algorithms on large scale data. This makes Hadoop a comprehensive system that is capable of handling all forms of data, making it an ideal suite for data scientists.<\/p>\n Improve your Hadoop skills<\/a> and become the next data scientist<\/strong><\/em><\/p>\n Q.34 How can you select an ideal value of K for K-means clustering?<\/strong><\/p>\n There are several methods like the elbow method and kernel method to find the number of centroids in the given cluster. However, to ascertain an approximate number of centroids quickly, we can also take the square root of the number of data points divided by two. While this technique is not entirely accurate but is fast as compared to the previously mentioned techniques.<\/p>\n\n
![\"Normal](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Normal-Distribution-01.jpg\")
<\/a><\/p>\n\n
s1 = pd.Series([1, 2, 3, 4, 5])\r\ns2 = pd.Series([4, 5, 6, 7, 8])\r\ns1[s1.isin(s2)]<\/pre>\n
s1 = pd.Series([1, 2, 3, 4, 5, 6, 7, 8, 9, 10])\r\nnp.argwhere(ser % 4==0)<\/pre>\n
df = pd.concat([s1, s2], axis=1)<\/pre>\n
s = pd.Series(['02 Feb 2011', '02-02-2013', '20160104', '2011\/01\/04', '2014-12-05', '2010-06-06T12:05])<\/pre>\n
pd.to_datetime(s)<\/pre>\n
![\"R](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/R-vs-Python-for-data-science1.jpg\")
<\/a><\/p>\n![\"Data](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/07\/bayes-theorem-data-science-interview-questions.png\")
<\/a><\/p>\nser1 = pd.Series(mylist)<\/pre>\n
![\"Data](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/07\/Type-I-and-II-erorrs-interview-questions-in-data-science.jpg\")
<\/a><\/p>\n\n
![\"data](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/deep-learning-vs-machine-learning.jpg\")
<\/a><\/p>\n\n
\n
SELECT TOP 1 salary\r\nFROM(\r\nSELECT TOP 2 salary\r\nFROM employee_table\r\nORDER BY salary DESC) AS emp\r\nORDER BY salary ASC;<\/pre>\n
![\"data](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/07\/big-data-and-data-science-interview-questions.png\")
<\/a><\/p>\n