Crisil Data Analyst Intern Interview Questions and Answers

Q1. Can you elaborate on your work experience?
Add your answer
Q2. What questions were asked regarding your work experience?
Add your answer

Q1. Explain any ML model.
Add your answer
Q2. Create Dataframe from two lists.
Add your answer

Q1. Explain the RAG pipeline?
Ans. 
RAG pipeline is a data processing pipeline used in data science to categorize data into Red, Amber, and Green based on certain criteria.
• RAG stands for Red, Amber, Green which are used to categorize data based on certain criteria

• Red category typically represents data that needs immediate attention or action

• Amber category represents data that requires monitoring or further investigation

• Green category represents data that...read more
Answered by AI
Add your answer
Q2. Explain Confusion metrics
Ans. 
Confusion metrics are used to evaluate the performance of a classification model by comparing predicted values with actual values.
• Confusion matrix is a table that describes the performance of a classification model.

• It consists of four different metrics: True Positive, True Negative, False Positive, and False Negative.

• These metrics are used to calculate other evaluation metrics like accuracy, precision, recall, and F1 s...read more
Answered by AI
Add your answer

Questions based on ML,PYTHON, DATA VISUALIZATION

Q1. What is TF-IDF IN NLP
Ans. 
TF-IDF is a numerical statistic that reflects the importance of a word in a document relative to a collection of documents.
• TF-IDF stands for Term Frequency-Inverse Document Frequency

• It is used in Natural Language Processing (NLP) to determine the importance of a word in a document

• TF-IDF is calculated by multiplying the term frequency (TF) by the inverse document frequency (IDF)

• It helps in identifying the most important
Answered by AI
Add your answer
Q2. Python coding questions based on list
Add your answer

Excel data analytics case

Q1. Data analytics, data visualisation tools
Add your answer

SQL, Python coding …

The aptitude test was easy.just like usual aptitude questions like quants,verbal,reasoning etc....

Q1. Second round was all about one on one video call interview where they will ask to record a video and send it.(managerial questions). Like, why do you need to join mu sigma,why should we hire you....
Ans. Third round was online hr interview. Where there will ask questions based on your resumes.
Answered Anonymously
Add your answer

I was asked to write SQL queries for 3rd highest salary of the employee, some name filtering, group by tasks.
Python code to find the index of the maximum number without using numpy.

Q1. Explain the Project undertaken during the research and follow-up questions
Add your answer

Q1. Write pandas query to separate the names as first and last name from the full name. Drop the duplicate columns and also the missing values. Write output for the Python code. Write SQL query to retrieve t...read more
Ans. 
Answering questions related to data science concepts and techniques.
• Recall is the ratio of correctly predicted positive observations to the total actual positives. Precision is the ratio of correctly predicted positive observations to the total predicted positives.

• To reduce variance in an ensemble model, techniques like bagging, boosting, and stacking can be used. Bagging involves training multiple models on different ...read more
Answered by AI
Add your answer