Date: 02-01-2024
Company name: Oracle
Role: Data Analyst
Topic: outlier, dax, filter, recursive stored procedure

1. What are the ways to detect outliers?

Outliers are detected using two methods:

Box Plot Method: According to this method, the value is considered an outlier if it exceeds or falls below 1.5*IQR (interquartile range), that is, if it lies above the top quartile (Q3) or below the bottom quartile (Q1).

Standard Deviation Method: According to this method, an outlier is defined as a value that is greater or lower than the mean ± (3*standard deviation).


2. What is a Recursive Stored Procedure?

A stored procedure that calls itself until a boundary condition is reached, is called a recursive stored procedure. This recursive function helps the programmers to deploy the same set of code several times as and when required.


3. What is the shortcut to add a filter to a table in EXCEL?

The filter mechanism is used when you want to display only specific data from the entire dataset. By doing so, there is no change being made to the data. The shortcut to add a filter to a table is Ctrl+Shift+L.

4. What is DAX in Power BI?

DAX stands for Data Analysis Expressions. It's a collection of functions, operators, and constants used in formulas to calculate and return values. In other words, it helps you create new info from data you already have.

Date: 03-01-2024
Company : Accenture
Role : Data Scientist
Topic : Silhouette coeff, Trend&Seasonality, Bag of words, Self join

1. What do you understand by the term silhouette coefficient?
The silhouette coefficient is a measure of how well clustered together a data point is with respect to the other points in its cluster. It is a measure of how similar a point is to the points in its own cluster, and how dissimilar it is to the points in other clusters. The silhouette coefficient ranges from -1 to 1, with 1 being the best possible score and -1 being the worst possible score.

2. What is the difference between trend and seasonality in time series?
Trends and seasonality are two characteristics of time series metrics that break many models. Trends are continuous increases or decreases in a metric’s value. Seasonality, on the other hand, reflects periodic (cyclical) patterns that occur in a system, usually rising above a baseline and then decreasing again.

3. What is Bag of Words in NLP?
Bag of Words is a commonly used model that depends on word frequencies or occurrences to train a classifier. This model creates an occurrence matrix for documents or sentences irrespective of its grammatical structure or word order.

4. What is a Self-Join?

A self-join is a type of join that can be used to connect two tables. As a result, it is a unary relationship. Each row of the table is attached to itself and all other rows of the same table in a self-join. As a result, a self-join is mostly used to combine and compare rows from the same database table.

5.Explain the Law of Large Numbers.

The ‘Law of Large Numbers’ states that if an experiment is repeated independently a large number of times, the average of the individual results is close to the expected value. It also states that the sample variance and standard deviation also converge towards the expected value.

🚨JOB OPENING UPDATE🚨

Company – S&P Global
Role – Data Quality Analyst
Exp. – Fresher
Apply Here – https://careers.spglobal.com/jobs/295211?lang=en-us&utm_source=indeed&utm_source=indeed

Company – Shell
Role – Lead BI Analyst – Data Engineering
Exp. – Fresher
Apply Here – https://jobs.shell.com/job/bengaluru/lead-bi-analyst-data-engineering/25244/59453151280?codes=1-INDEED

Company – Ericsson
Role – Data Engineer
Exp. – Fresher
Apply Here – https://jobs.ericsson.com/careers/job/563121757378324?domain=ericsson.com&jobPipeline=Indeed

Company – FXCM
Role – Business Intelligence Analyst
Exp. – Fresher
Apply Here – https://fxcm-hr.my.salesforce-sites.com/recruit/fRecruit__ApplyJob?vacancyNo=VN982&sid=37

Company – Acies Global
Role – Data Engineer
Exp. – 2 yrs
Apply Here – https://in.indeed.com/cmp/Acies-Global/jobs?jk=0e2be75657c40262&start=0&clearPrefilter=1

Company – Cheeron Life
Role – Data Analyst Trainee
Exp. – 0-1 yrs
Apply Here – https://www.naukri.com/job-listings-data-analyst-trainee-cheeron-life-surat-gujarat-0-to-1-years-121023010939?src=jobsearchDesk&sid=17043459554449609&xp=1&px=1&nignbevent_src=jobsearchDeskGNB

Company – Zcts
Role – Data Analyst Trainee
Exp. – 0-1 yrs
Apply Here – https://www.naukri.com/job-listings-data-analyst-trainee-da-trainee-zcts-coimbatore-0-to-1-years-301223903794?src=jobsearchDesk&sid=17043459554449609&xp=2&px=1&nignbevent_src=jobsearchDeskGNB

Company – Comcast Corporation
Role – Machine Learning Intern
Exp. – 0-2 yrs
Apply Here – https://jobs.comcast.com/jobs/description/regular?external_or_internal=External&job_id=R364614&source=ind_orga_at&jobPipeline=Indeed

Company – SatSure Analytics India
Role – Data Scientist Intern
Exp. – Fresher
Apply Here – https://satsure.keka.com/careers/jobdetails/26859

Company – Add Innovations Private Limited
Role – Deep Learning Intern
Exp. – Fresher
Apply Here – https://smartapply.indeed.com/beta/indeedapply/form/contact-info

ALL THE BEST💙

🚨JOB OPENING UPDATE🚨

Company – Tree Top Staffing LLC
Role – Data Analyst
Exp. – Fresher
Apply Here – https://www.linkedin.com/jobs/view/3800053561

Company – Brainware University
Role – Data Analyst
Exp. – 1 yr
Apply Here – https://www.linkedin.com/jobs/view/3798484974

Company – MachineHack Generative AI
Role – Generative AI Engineer
Exp. – Fresher
Apply Here – https://www.linkedin.com/jobs/view/3801085938

Company – Hexaware Technologies
Role – Analytics Data science and IOT Engineer
Exp. – Fresher
Apply Here – https://www.linkedin.com/jobs/view/3800858321

Company – Altrata India Private Ltd
Role – Data Engineer
Exp. – 0-2 yr
Apply Here – https://www.naukri.com/job-listings-data-engineer-altrata-india-private-ltd-chennai-tamil-nadu-0-to-2-years-070124001912?src=sortby&sid=1704692157253739_1&xp=5&px=1&nignbevent_src=jobsearchDeskGNB

Company – SAZ India
Role – Data Analytics Intern
Exp. – Fresher
Apply Here – https://www.linkedin.com/jobs/view/3800760641

Company – Radio City
Role – Data Analytics intern
Exp. – Fresher
Apply Here – https://internshala.com/internship/detail/data-analytics-internship-in-mumbai-at-radio-city1704438545

Company – AIqwip
Role – Data Science intern
Exp. – Fresher
Apply Here – https://internshala.com/internship/detail/data-science-internship-in-bangalore-at-aiqwip1704547841

Company – Across The Globe (ATG)
Role – Deep Learning
Exp. – Fresher
Apply Here – https://internshala.com/internship/detail/deep-learning-work-from-home-job-internship-at-across-the-globe-atg1703825932

Company – Blackcoffer
Role – Data Science
Exp. – Fresher
Apply Here – https://internshala.com/internship/detail/data-science-work-from-home-job-internship-at-blackcoffer1704450041

ALL THE BEST💙

Interview QnAs
Company - Bosch
Date- 09/01/2024
Role: Data Scientist

1. What is a logistic function? What is the range of values of a logistic function?

f(z) = 1/(1+e -z )
The values of a logistic function will range from 0 to 1. The values of Z will vary from -infinity to +infinity.


2. What is the difference between R square and adjusted R square?

R square and adjusted R square values are used for model validation in case of linear regression. R square indicates the variation of all the independent variables on the dependent variable. i.e. it considers all the independent variable to explain the variation. In the case of Adjusted R squared, it considers only significant variables(P values less than 0.05) to indicate the percentage of variation in the model.

Thus Adjusted R2 is always lesser then R2.


3. What is stratify in Train_test_split?

Stratification means that the train_test_split method returns training and test subsets that have the same proportions of class labels as the input dataset. So if my input data has 60% 0's and 40% 1's as my class label, then my train and test dataset will also have the similar proportions.


4. What is Backpropagation in Artificial Neuron Network?

Backpropagation is the method of fine-tuning the weights of a neural network based on the error rate obtained in the previous epoch (i.e., iteration). Proper tuning of the weights allows you to reduce error rates and make the model reliable by increasing its generalization.

🚨JOB OPENING UPDATE🚨

Company – Ventra Health
Role – Data Engineer
Exp. – Fresher
Apply Here – https://www.simplyhired.co.in/job/V8HhCHtEsvSaVb8uRK92wo6nI__mYB2U869-zvpeO6iwUWu6-Ep6JQ


Company – Craft Worldwide
Role – Data Management Intern
Exp. – Fresher
Apply Here – https://www.linkedin.com/jobs/view/3800237121

Company – Anaxee Digital Runners
Role – Data Analyst Intern
Exp. – 0-1 yr
Apply Here – https://anaxee.com/career/?jobId=rDMbJETiWoQ-

Company – Micron
Role – Intern, Data Science
Exp. – Fresher
Apply Here – https://careers.micron.com/careers/job/19706629?domain=micron.com&utm_source=indeed

Company – LM Wind Power
Role – Data Analyst - Intern
Exp. – Fresher
Apply Here – https://www.simplyhired.co.in/job/785HSJFZYlRZeH1g7ryCsDjIA8oYO6I9mxkRjxFuMQAUM9YFTuUXjw

Company – Pfizer
Role –Data Science Intern
Exp. – Fresher
Apply Here – https://www.simplyhired.co.in/job/70yOordrKe-Q3_MOZ8s-2lCs4smIaRlW9ziag8DX1DMCZs5l0ylB7A


Company – InfoEdge
Role – Data Scientist
Exp. – 0-6 Yrs
Apply Here – https://www.hirist.com/j/infoedge-data-scientist-machine-learning-0-6-yrs-1284512.html?ref=sp_br_prm&jobpos=1&jobversion=2

Company – Dun & Bradstreet
Role – Analyst, Data Science
Exp. – 2-5 yrs
Apply Here –https://www.simplyhired.co.in/job/CvFHOc5NFOX4N8BF3L8OfY3jn41chq_YCwzP2xk3L9Ntj_FK9tGZtA

Company – Gartner
Role – Associate Data Analyst (SQL)
Exp. – 1-2 yrs
Apply Here – https://www.simplyhired.co.in/job/D0MZHfVZDbYV5Tod8hyKC8YOjQRet1IHW2PTBxZ_Yg6WZiOTmKcYNw

Company – Sasken Technologies Limited
Role – ENGINEER - DATA ANALYTICS
Exp. – 0-2 yrs
Apply Here – https://www.simplyhired.co.in/job/tt4qu-AID55ew5ju4VeD1mePh5nGJBvxiJXH5lHDj7y6gynk-2InTg

Date - 10-01-2024
Company name: LTI
Role: ML Engineer
Topic: cart, cross validation, knn, pandas data structures

1. Mention The Different Types Of Data Structures In pandas?

There are two data structures supported by pandas library, Series and DataFrames. Both of the data structures are built on top of Numpy. Series is a one-dimensional data structure in pandas and DataFrame is the two-dimensional data structure in pandas. There is one more axis label known as Panel which is a three-dimensional data structure and it includes items, major_axis, and minor_axis.

2. Why is KNN a non-parametric Algorithm?

The term “non-parametric” refers to not making any assumptions on the underlying data distribution. These methods do not have any fixed numbers of parameters in the model.
Similarly in KNN, the model parameters grow with the training data by considering each training case as a parameter of the model. So, KNN is a non-parametric algorithm.

3. Explain the CART Algorithm for Decision Trees.

CART is a variation of the decision tree algorithm. It can handle both classification and regression tasks.The CART stands for Classification and Regression Trees is a greedy algorithm that greedily searches for an optimum split at the top level, then repeats the same process at each of the subsequent levels. Moreover, it does verify whether the split will lead to the lowest impurity or not as well as the solution provided by the greedy algorithm is not guaranteed to be optimal, it often produces a solution that’s reasonably good since finding the optimal Tree is an NP-Complete problem that requires exponential time complexity.

4. Explain leave-p-out cross validation.

When using this exhaustive method, we take p number of points out from the total number of data points in the dataset(say n). While training the model we train it on these (n – p) data points and test the model on p data points. We repeat this process for all the possible combinations of p from the original dataset. Then to get the final accuracy, we average the accuracies from all these iterations.

————————————————————-

Make Your Career In Data Science Domain with our Industry-Oriented Hands-on Course @ Most Affordable Price 🤩

Visit 👉🏻 https://www.cloudyml.com/

Stay Safe & Happy Learning💙

Today's Interview QnAs
Date : 11/01/2024
Company : KPMG
Role: Data Scientist

Q1. You are given a data set. The data set has missing values that spread along 1 standard deviation from the median. What percentage of data would remain unaffected? Why?

This question has enough hints for you to start thinking! Since the data is spread across the median, let’s assume it’s a normal distribution. We know, in a normal distribution, ~68% of the data lies in 1 standard deviation from mean (or mode, median), which leaves ~32% of the data unaffected. Therefore, ~32% of the data would remain unaffected by missing values.


Q2. What do you mean by convex hull?

Convex hull is represents to outer boundaries of two-level group of data point. Once is convex hull has to been created data-set value, we get maximum data-set value level of margin hyperplane (MMH), which attempts to create data set value greatest departure between two groups data set value, as a vertical bisector between two convex hulls data set value.
A convex hull of a set S is the intersection of all convex set of which S is a subset. We denote it by [S] the convex hull of S.

Example:

S= {x: |x|=1} implies [S]= {x: |x|< or =1}
S= {x: |x| > or= 1} implies [S]=En


Q3. You’ve built a random forest model with 10000 trees. You got delighted after getting training error as 0.00. But, the validation error is 34.23. What is going on? Haven’t you trained your model perfectly?

Ans: The model has overfitted. Training error 0.00 means the classifier has mimicked the training data patterns to an extent, that they are not available in the unseen data. Hence, when this classifier was run on an unseen sample, it couldn’t find those patterns and returned predictions with higher error. In a random forest, it happens when we use a larger number of trees than necessary. Hence, to avoid this situation, we should tune the number of trees using cross-validation.


Q4. State one real life applications of convex hulls?

Ans: One applications convex hulls is to computation/construction of convex relaxations. Can say this is a way to find 'closest' convex problem to a non-convex problem one is attempting to solve.

————————————————————-

Make Your Career In Data Science Domain with our Industry-Oriented Hands-on Course @ Most Affordable Price 🤩

Visit 👉🏻 https://www.cloudyml.com/

Stay Safe & Happy Learning💙

#JobOpenings 🚨

Company – Lumbini Elite Solutions & Services
Role – Data Analyst
Exp. – 0-2 yrs
Apply Here – https://www.naukri.com/job-listings-trained-data-analyst-walk-in-drive-bengaluru-location-lumbini-elite-solutions-services-bengaluru-0-to-2-years-110124004950?src=sortby&sid=17049530362665781_1&xp=2&px=1&nignbevent_src=jobsearchDeskGNB

Company – BlackRock
Role – Data Engineer
Exp. – Fresher
Apply Here – https://careers.blackrock.com/job/19693196/data-engineer-analyst-gurgaon-in/?source=Indeed

Company – PineBridge Investments
Role – Data Scientist
Exp. – 0-7 yrs
Apply Here – https://www.linkedin.com/jobs/view/3802755552

Company – Celzene It Services
Role – Data Engineer
Exp. – 1-5 yrs
Apply Here – https://www.naukri.com/job-listings-data-engineer-celzene-it-services-pvt-ltd-hyderabad-bengaluru-delhi-ncr-0-to-5-years-100124000052?src=jobsearchDesk&sid=17049530362665781_2&xp=5&px=1&nignbevent_src=jobsearchDeskGNB

Company – Snapmint
Role – Data Analyst
Exp. – 1 yr
Apply Here – https://www.linkedin.com/jobs/view/3796100646

Company – Zupee
Role – Data Engineer Intern
Exp. – Fresher
Apply Here – https://www.naukri.com/job-listings-data-engineer-intern-zupee-gurugram-haryana-0-to-1-years-100124007387?src=jobsearchDesk&sid=17049530362665781_2&xp=2&px=1&nignbevent_src=jobsearchDeskGNB

Company – Digite Infotech Private Limited
Role – Data Analytics Intern
Exp. – Fresher
Apply Here – https://internshala.com/internship/detail/data-analytics-internship-in-bangalore-at-digite-infotech-private-limited1704869020?utm_source=cp_link&referral=web_share

Company – MentorBoxx
Role – Data Science Intern
Exp. – Fresher
Apply Here – https://internshala.com/internship/detail/data-science-work-from-home-job-internship-at-mentorboxx1704893923?utm_source=cp_link&referral=web_share

Company – Analytics Jobs
Role – Machine Learning Engineering
Exp. – Fresher
Apply Here – https://internshala.com/internship/detail/machine-learning-engineering-work-from-home-job-internship-at-analytics-jobs1704947308?utm_source=cp_link&referral=web_share

Company – AegisCovenant
Role – Data Analytics Intern
Exp. – Fresher
Apply Here – https://internshala.com/internship/detail/data-analytics-internship-in-gurgaon-at-aegiscovenant1704872042?utm_source=cp_link&referral=web_share

Date: 13-01-2024
Company name: Musigma
Role: ML Engineer
Topic: random forest, linear regression, naive bayes, gradient descent

1. How is the Error calculated in a Linear Regression model?

Measuring the distance of the observed y-values from the predicted y-values at each value of x.
Squaring each of these distances.
Calculating the mean of each of the squared distances.
MSE = (1/n) * Σ(actual – forecast)2
The smaller the Mean Squared Error, the closer you are to finding the line of best fit
How bad or good is this final value always depends on the context of the problem, but the main goal is that its value is as minimal as possible.

2. Explain the intuition behind the Gradient Descent algorithm.

Gradient descent is an optimization algorithm that’s used when training a machine learning model and is based on a convex function and tweaks its parameters iteratively to minimize a given function to its local minimum (that is, slope = 0).
For a start, we have to select a random bias and weights, and then iterate over the slope function to get a slope of 0.
The way we change update the value of the bias and weights is through a variable called the learning rate. We have to be wise on the learning rate because choosing:
A small leaning rate may lead to the model to take some time to learn
A large learning rate will make the model converge as our pointer will shoot and we’ll not be able to get to minima.

3. How is a Random Forest related to Decision Trees?

Random forest is an ensemble learning method that works by constructing a multitude of decision trees. A random forest can be constructed for both classification and regression tasks.
Random forest outperforms decision trees, and it also does not have the habit of overfitting the data as decision trees do.
A decision tree trained on a specific dataset will become very deep and cause overfitting. To create a random forest, decision trees can be trained on different subsets of the training dataset, and then the different decision trees can be averaged with the goal of decreasing the variance.

4. What are some disadvantages of using Naive Bayes Algorithm?

Some disadvantages of using Naive Bayes Algorithm are:
It relies on a very big assumption that the independent variables are not related to each other.
It is generally not suitable for datasets with large numbers of numerical attributes.
It has been observed that if a rare case is not in the training dataset but is in the testing dataset, then it will most definitely be wrong.

————————————————————-

Make Your Career In Data Science Domain with our Industry-Oriented Hands-on Course @ Most Affordable Price 🤩

Visit 👉🏻 https://www.cloudyml.com/

Stay Safe & Happy Learning💙

🚨JOB OPENING UPDATE🚨

Company – SAZ India
Role – Junior Data Analyst
Exp. – 0-1 yrs
Apply Here – https://www.linkedin.com/jobs/view/3806267870

Company – SAZ India
Role – Data Analyst Fresher
Exp. – 0-1 yr
Apply Here – https://www.linkedin.com/jobs/view/3806276028

Company – WCG
Role – AI Engineer
Exp. – Fresher
Apply Here – https://www.linkedin.com/jobs/view/3806244882

Company – Leading IT Co.
Role – Data Scientist
Exp. – 0-5 yrs
Apply Here – https://www.naukri.com/job-listings-data-scientist-leading-it-co-visakhapatnam-hindco-recruitment-consultants-vijayawada-andhra-pradesh-visakhapatnam-andhra-pradesh-guntur-andhra-pradesh-0-to-5-years-130124003990?src=sortby&sid=17053009075136849_1&xp=3&px=1&nignbevent_src=jobsearchDeskGNB

Company – CLOUDSUFI
Role – Data Engineer
Exp. – Fresher, Experienced
Apply Here – https://www.simplyhired.co.in/job/kaGgRoEupF1ERJvfnpFdjbL5e999vrLOoyHOk53MI7aft8DOMA_oxw

Company – Patenti Technology Solutions
Role – Machine Learning Intern
Exp. – Fresher
Apply Here – https://internshala.com/internship/detail/machine-learning-internship-in-bangalore-at-patenti-technology-solutions1704976556?utm_source=cp_link&referral=web_share

Company – Village Company
Role – Generative AI Intern (Remote)
Exp. – Fresher
Apply Here – https://internshala.com/internship/detail/generative-ai-work-from-home-job-internship-at-village-company1705164201?utm_source=cp_link&referral=web_share

Company – Genius AI Solutions
Role – Data Science Intern (Remote)
Exp. – Fresher
Apply Here – https://internshala.com/internship/detail/data-science-work-from-home-job-internship-at-genius-ai-solutions1705000259?utm_source=cp_link&referral=web_share

Company – Avaari
Role – Machine Learning Intern
Exp. – Fresher
Apply Here – https://internshala.com/internship/detail/machine-learning-work-from-home-job-internship-at-avaari1705138982?utm_source=cp_link&referral=web_share

Company – Aviac Technologies
Role – Data Analytics Intern
Exp. – Fresher
Apply Here – https://internshala.com/internship/detail/data-analytics-work-from-home-job-internship-at-aviac-technologies1704963415?utm_source=cp_link&referral=web_share

JOB OPENING UPDATE

Company – Outscal
Role – Data Analyst
Exp. – Fresher
Apply Here – https://www.linkedin.com/jobs/view/3808136260

Company – MobileWorld Vadodara
Role – Data Analyst
Exp. – Fresher or 2yrs
Apply Here – https://www.simplyhired.co.in/job/v2EOhk9tHARNM976W87UDNj2NssxTDuVy4UnYtenuzJ_w2NXNEdLDA

Company – Tiger Analytics
Role – Data Scientist
Exp. – 2-7 yrs
Apply Here – https://www.simplyhired.co.in/job/Bkidd4Kl-vaKSa52C2XTxCqx6co4opK5lPd3GmC9vJ5WLivrlyaGDw

Company – NGspurs Pvt. Ltd.
Role – AI/ML , Python Engineer
Exp. – 1-5 yrs
Apply Here – https://www.simplyhired.co.in/job/R8cYRDF_08bSv1xZCqVX5y_o4yJ9uXmz6LWY9pf9dIeJjnTPY7SC4w

Company – Virtusa
Role – Data Engineer
Exp. – Fresher
Apply Here – https://www.linkedin.com/jobs/view/3807584624

Company – Bureau
Role – Data Engineering Intern
Exp. – Fresher
Apply Here – https://www.linkedin.com/jobs/view/3807286769

Company – MedTourEasy
Role – Data Analysis Trainee
Exp. – Fresher
Apply Here – https://www.linkedin.com/jobs/view/3808140227

Company – Energy Alternatives India
Role – AI For Climate Research
Exp. – Fresher
Apply Here – https://internshala.com/internship/detail/ai-for-climate-research-internship-in-chennai-at-energy-alternatives-india1705387859?utm_source=cp_link&referral=web_share

Company – Faclon
Role – Data Science Intern
Exp. –Fresher
Apply Here – https://internshala.com/internship/detail/data-science-internship-in-mumbai-at-faclon1705298889?utm_source=cp_link&referral=web_share

Company – Binford Research Labs pvt ltd
Role – Artificial Intelligence
Exp. – Fresher
Apply Here – https://www.simplyhired.co.in/job/rWGTWDvTRKMxe6aIlevL06tZYOHLxlzInjBkq4DPUmZtUpE2LE1JCA

🚀 "Unveil the Future of Finance with Our Latest YouTube Video: 'Loan Approval Prediction Project'! 📊

Dive into the fascinating world of data science as we demonstrate how to predict loan approvals using cutting-edge techniques.

Watch Now👉🏻 https://youtu.be/vSBGCf5hqDE?si=qj6wx1FDOqJp_zWK

Date - 20/01/2024
Company Name - Bridgei2i Analytics
Role - Data Scientist


Q. Why does overfitting occur?

A. Overfitting happens when a model learns the detail and noise in the training data to the extent that it negatively impacts the performance of the model on new data. This means that the noise or random fluctuations in the training data is picked up and learned as concepts by the model


Q. What is ensemble learning?

A. Ensemble learning is the process by which multiple models, such as classifiers or experts, are strategically generated and combined to solve a particular computational intelligence problem. Ensemble learning is primarily used to improve the (classification, prediction, function approximation, etc.) performance of a model, or reduce the likelihood of an unfortunate selection of a poor one.


Q. What is F1 score?

A. The F1 score is defined as the harmonic mean of precision and recall. As a short reminder, the harmonic mean is an alternative metric for the more common arithmetic mean. It is often useful when computing an average rate. In the F1 score, we compute the average of precision and recall.


Q. What is pickling and unpickling?

A.“Pickling” is the process whereby a Python object hierarchy is converted into a byte stream, and “unpickling” is the inverse operation, whereby a byte stream (from a binary file or bytes-like object) is converted back into an object hierarchy.


Q. What is lambda function?

A. Python Lambda Functions are anonymous function means that the function is without a name. As we already know that the def keyword is used to define a normal function in Python. Similarly, the lambda keyword is used to define an anonymous function in Python.


Q. What is the trade of between bias and variance ?

A. Bias is the simplifying assumptions made by the model to make the target function easier to approximate. Variance is the amount that the estimate of the target function will change given different training data. Trade-off is tension between the error introduced by the bias and the variance.

🚨JOB OPENING UPDATE🚨

Company – Heelium
Role – Data Analyst
Exp. – Fresher
Apply Here – https://www.linkedin.com/jobs/view/3803663081

Company – Genpact
Role – Data Analyst Python
Exp. – Fresher
Apply Here – https://www.linkedin.com/jobs/view/3810548762

Company – GEEKRABIT PRIVATE LIMITED
Role – AI Engineer
Exp. – 1 yr
Apply Here – https://www.simplyhired.co.in/job/xFVkIPO8OYUaKn1-STY7NB2nDqIIOo0eQRstvR9FFnVud4I6-J34-Q

Company – Encardio rite Group
Role – Business Intelligence Executive
Exp. – 0-3 yrs
Apply Here – https://www.naukri.com/job-listings-business-intelligence-executive-encardio-rite-group-lucknow-uttar-pradesh-0-to-3-years-180124006254?src=jobsearchDesk&sid=17057277472926218_3&xp=14&px=1&nignbevent_src=jobsearchDeskGNB

Company – YASH Technologies
Role – Data Engineer
Exp. – 1-2 yrs
Apply Here – https://www.linkedin.com/jobs/view/3809455502

Company – Lizmotors Mobility Pvt Ltd.
Role – AI/ML Engineering Intern
Exp. – Fresher
Apply Here – https://www.simplyhired.co.in/job/Po82XP_DYPSnKqsmvWZWurpzliWKMR92p3utnMTcThs_cNUjIZx_gw

Company – Wobot Intelligence Private Limited
Role – Data Analytics Intern
Exp. – Fresher
Apply Here – https://internshala.com/internship/detail/data-analytics-work-from-home-job-internship-at-wobot-intelligence-private-limited1705722978?utm_source=cp_link&referral=web_share

Company – UM IT Services & Consulting
Role – Data Science Intern
Exp. – Fresher
Apply Here – https://www.linkedin.com/jobs/view/3810011634

Company – Avaari
Role – Machine Learning Intern
Exp. – Fresher
Apply Here – https://internshala.com/internship/detail/machine-learning-part-time-job-internship-at-multiple-locations-in-avaari1705674973?utm_source=cp_link&referral=web_share

Company – Bhashsms
Role – Data Analyst Intern
Exp. – Fresher
Apply Here – https://internshala.com/internship/detail/data-analyst-internship-in-bangalore-at-jackson-joseph1705650414?utm_source=cp_link&referral=web_share

ALL THE BEST💙

Today's Interview QnAs
Date - 25/01/2024
Company - The Math Company
Role- Data Analyst


1.How to create filters in Power BI?

Filters are an integral part of Power BI reports. They are used to slice and dice the data as per the dimensions we want. Filters are created in a couple of ways.

Using Slicers: A slicer is a visual under Visualization Pane. This can be added to the design view to filter our reports. When a slicer is added to the design view, it requires a field to be added to it. For example- Slicer can be added for Country fields. Then the data can be filtered based on countries.
Using Filter Pane: The Power BI team has added a filter pane to the reports, which is a single space where we can add different fields as filters. And these fields can be added depending on whether you want to filter only one visual(Visual level filter), or all the visuals in the report page(Page level filters), or applicable to all the pages of the report(report level filters)


2.How to sort data in Power BI?

Sorting is available in multiple formats. In the data view, a common sorting option of alphabetical order is there. Apart from that, we have the option of Sort by column, where one can sort a column based on another column. The sorting option is available in visuals as well. Sort by ascending and descending option by the fields and measure present in the visual is also available.


3.How to convert pdf to excel?

Open the PDF document you want to convert in XLSX format in Acrobat DC.
Go to the right pane and click on the “Export PDF” option.
Choose spreadsheet as the Export format.
Select “Microsoft Excel Workbook.”
Now click “Export.”
Download the converted file or share it.


4. How to enable macros in excel?

Click the file tab and then click “Options.”
A dialog box will appear. In the “Excel Options” dialog box, click on the “Trust Center” and then “Trust Center Settings.”
Go to the “Macro Settings” and select “enable all macros.”
Click OK to apply the macro settings.

Date: 27-01-2024
Company name: Infosys
Role: ML Engineer
Topic: gradient descent, random forest, kmean vs knn, svm

1. Explain how does the Gradient descent work in Linear Regression

The Gradient Descent works by starting with random values for each coefficient in the linear regression model.
After this, the sum of the squared errors is calculated for each pair of input and output values (loss function), using a learning rate as a scale factor.
For each iteration, the coefficients are updated in the direction towards minimizing the error,
then we keep repeating the iteration process until a minimum sum squared error is achieved or no further improvement is possible.


2. What does Random refer to in Random Forest?

Random forest is an extension of the bagging method as it utilizes both bagging and feature randomness to create an uncorrelated forest of decision trees. Hence, random forest is Random in the following ways:
Each tree is trained on a random subset of features, which ensures low correlation among decision trees.
Each tree in the forest is trained in 2/3-rd of the total training data and data points are drawn at random from the original dataset.

3. What is the main difference between k-Means and k-Nearest Neighbours?

k-Means is a clustering algorithm that tries to partition a set of points into k sets such that the points in each cluster tend to be near each other. It is unsupervised because the points have no external classification.

k-Nearest Neighbors is a classification (or regression) algorithm that, in order to determine the classification of a point, combines the classification of the k nearest points. It is supervised because it is trying to classify a point based on the known classification of other points.


4. What are Support Vectors in SVMs?

Support vectors are the data points nearest to the hyperplane, the points of a data set that, if removed, would alter the position of the dividing hyperplane.
Using these support vectors, we maximize the margin of the classifier.
For computing predictions, only the support vectors are used.

————————————————————-

Make Your Career In Data Science Domain with our Industry-Oriented Hands-on Course @ Most Affordable Price 🤩

Visit 👉🏻 https://www.cloudyml.com/

Stay Safe & Happy Learning💙

Company – Optum
Role – Data Analyst
Exp. – Fresher
Apply Here – https://www.linkedin.com/jobs/view/3816603941

Company – EVIFY
Role – Data Analyst
Exp. – 1-2 yrs
Apply Here – https://www.linkedin.com/jobs/view/3815712838

Company – Prodigy Recruitment Consultants
Role – Data Scientist
Exp. – 0-5 yrs
Apply Here – https://www.naukri.com/job-listings-data-scientist-chennai-prodigy-recruitment-consultants-chennai-tamil-nadu-0-to-5-years-280124000025?src=sortby&sid=17065084099779743_1&xp=5&px=1&nignbevent_src=jobsearchDeskGNB

Company – Creative Hands HR
Role – Data Analytic
Exp. – 0-4 yrs
Apply Here – https://www.naukri.com/job-listings-data-analytic-fresher-business-analytics-creative-hands-hr-kolkata-mumbai-maharashtra-hyderabad-secunderabad-ranchi-jharkhand-chennai-bangalore-bengaluru-0-to-4-years-020124003015?src=sortby&sid=17065084099779743_1&xp=4&px=1&nignbevent_src=jobsearchDeskGNB

Company – Bluo Software India LLP
Role – Data Engineer
Exp. – 0-2 yrs
Apply Here – https://www.linkedin.com/jobs/view/3815436763

Company – Victoria’s Secret & Co.
Role – Data Engineering intern
Exp. – 1 yr
Apply Here – https://www.linkedin.com/jobs/view/3815481402

Company – Zonka Technologies Pvt. Ltd.
Role – AI Intern
Exp. – Fresher
Apply Here – https://www.naukri.com/job-listings-ai-intern-zonka-technologies-pvt-ltd-gurugram-haryana-0-to-1-years-290124001017?src=sortby&sid=17065084099779743_1&xp=1&px=1&nignbevent_src=jobsearchDeskGNB

Company – PSG Institute of Technology and Applied Research
Role – Data analyst Intern
Exp. – Fresher
Apply Here – https://www.simplyhired.co.in/job/AAmy0Er4ncvWwDCSPDtbLKxUFfdSTSPRud5KnIAcHnc3DUQR8vluSQ

Company – GoMechanic
Role – Data Analytics Intern
Exp. – Fresher
Apply Here – https://internshala.com/internship/detail/data-analytics-internship-in-gurgaon-at-gomechanic1706509012?utm_source=cp_link&referral=web_share

Company – Quizzy
Role – Machine Learning Intern
Exp. – Fresher
Apply Here – https://internshala.com/internship/detail/work-from-home-applied-machine-learning-internship-at-quizzy1706501631?utm_source=cp_link&referral=web_share