C2fo Data Analyst Interview Questions and Answers

30 minutes Aptitude test

1 Hour 30 minutes on SQL screening test

Q1. Questions based on MS Excel only and provide 1 assignment for data analysis.
Add your answer

Q1. Again easy questions on MS Excel like; Vlookup, pivot, summarize, sumif, etc
Add your answer

Q1. Mostly revolves around SQL, A bit of python and in that also specially pandas and might be a bit of excel
Add your answer

Q1. SQL a bit advanced, Pandas and Python, and around your projects some time and if you mentioned ML then some questions around it mostly logistic regression,random foresr
Add your answer

Q1. Filtering methods in pandas?
Ans. 
Pandas filtering methods allow for selecting data based on conditions, enhancing data analysis and manipulation.
• Boolean indexing: Use boolean conditions to filter rows. Example: df[df['age'] > 30]

• Query method: Use the query() function for filtering. Example: df.query('age > 30')

• loc method: Access a group of rows and columns by labels. Example: df.loc[df['age'] > 30, ['name', 'age']]

• isin method: Filter rows bas...read more
Answered by AI
Add your answer
Q2. Make simple function to create new columns by using existing multiple other fields.
Add your answer
Q3. Write a simple SQL query for department wise budget?
Add your answer

How to improve credit model in order to increase sales growth of the organization?

Q1. Related to relocation?
Add your answer
Q2. Why you want to chnage current organization?
Ans. 
I seek new challenges and opportunities for growth that align with my career goals and passion for data science.
• Desire for professional growth: I want to work on more complex projects that push my analytical skills.

• Interest in innovative technologies: My current organization is not utilizing the latest tools in data science, like machine learning frameworks.

• Cultural fit: I am looking for a company that values collabora...read more
Answered by AI
Add your answer

Q1. Tell me about yourself.
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Can you relocate to Gurgaon
Add your answer

Q1. What is Vector? How it is different from arrays?
Ans. 
Vector is a dynamic array that can resize itself. It differs from arrays in its ability to change size during runtime.
• Vectors are implemented as dynamic arrays, whereas arrays are static.

• Vectors can resize themselves during runtime, whereas arrays have a fixed size.

• Vectors can be used to store objects of any type, whereas arrays can only store objects of a specific type.

• Vectors have built-in functions for easy manipula
Answered by AI
Add your answer
Q2. What is an abstract class?
Ans. 
An abstract class is a class that cannot be instantiated and is used as a base class for other classes.
• An abstract class can have abstract and non-abstract methods.

• Abstract methods are declared but not implemented in the abstract class.

• A non-abstract class that inherits from an abstract class must implement all abstract methods.

• An abstract class can have constructors and fields like a regular class.

• An abstract class ca...read more
Answered by AI
Add your answer

Q1. How event loop works?
Add your answer