C2fo Business Data Analyst Interview Questions and Answers

Assignment containing the python coding and the pandas data analysis and statistics questions

Q1. Given the tabular data and asked to find the issues in the data and how to solve them.
Add your answer
Q2. Check if the sentence is palindrome or not.
Ans. 
Check if a sentence is a palindrome or not.
• Remove all non-alphanumeric characters and convert to lowercase.

• Compare the original sentence with its reverse to check for palindrome.

• Example: 'A man, a plan, a canal, Panama' is a palindrome sentence.
Answered by AI
Add your answer

Q1. Classical data science questions
Add your answer
Q2. Given the large dataset and asked to find the answers using pandas
Add your answer

Q1. What is difference between delete,drop and truncate. ?
Ans. 
Delete removes specific rows from a table, drop removes entire table structure, and truncate removes all rows from a table.
• Delete is a DML command, drop is a DDL command, and truncate is a DDL command.

• Delete can be rolled back, drop cannot be rolled back, and truncate cannot be rolled back.

• Delete triggers delete triggers, drop triggers drop triggers, and truncate does not trigger any triggers.

• Example: DELETE FROM table...read more
Answered by AI
Add your answer

Q1. What are iterrators .?
Ans. 
Iterators are objects that allow sequential access to elements in a collection.
• Iterators are used to loop through elements in a collection one at a time.

• They provide a way to access elements without exposing the underlying data structure.

• Iterators have methods like next() to retrieve the next element in the collection.

• Examples of iterators include Python's iter() and Java's Iterator interface.
Answered by AI
Add your answer

Q1. Given a dataset, pandas task and commands
Add your answer
Q2. DSA round for lists,string, tuples, dictionary
Add your answer

A simple Python coding assesment - had fibonacci series and just general python questions

Q1. Probablity Question - Coin toss one
Add your answer
Q2. Statistical Significance - what it is? and how to use hypothesis testing
Ans. 
Statistical significance refers to the likelihood that a result or relationship is not due to chance.
• Statistical significance is a measure of the probability that a relationship between variables is not due to random chance.

• Hypothesis testing is a common method to determine statistical significance by comparing observed data to what would be expected by chance.

• A p-value is used to determine statistical significance, wi...read more
Answered by AI
Add your answer

Python coding round. The question will be regarding list, class and objects

Q1. Why do you want to join our company?
Ans. 
I am impressed by your company's innovative projects and collaborative work culture.
• I admire the cutting-edge technologies and projects your company is involved in.

• I value the collaborative work culture and team spirit that your company promotes.

• I believe my skills and expertise align well with the goals and values of your company.
Answered by AI
Add your answer
Q2. What is your strength?
Ans. 
My strength lies in my ability to analyze complex data sets and derive actionable insights.
• Strong analytical skills

• Ability to work with large data sets

• Experience with data visualization tools like Tableau

• Strong problem-solving skills

• Effective communication of findings to non-technical stakeholders
Answered by AI
Add your answer

MCQ based Python test, SQL, Data Analysis, Machine learning test. Each test should be cleared for further round

Client will give you Assignment question Sample and answer. Similarly you have to give answer. For me Python code , in which my role is to give machine solution with different algorithm approach and test cases with that. It is kind of prompt engineer which will trained the machine for coding

Python and SQL coding assessment with 2 python question

Q1. Given a string s and integer k , return the maximum number of vowel letters in any substring of s with length k. vowel letters in English are 'a','e','i','o','u' .
Ans. 
Find the maximum number of vowels in any substring of length k in a given string.
• Iterate through the string with a sliding window of size k, counting vowels in each substring.

• Keep track of the maximum vowel count encountered.

• Return the maximum vowel count found.
Answered by AI
Add your answer
Q2. Find all the numbers that appear at least three times consecutively return the result table in any order
Ans. 
Find numbers that appear at least three times consecutively in any order.
• Use a window function to track consecutive numbers

• Filter the result to only include numbers that appear at least three times consecutively

• Return the result table in any order
Answered by AI
Add your answer
Q3. What is the neihbourhood in which superhosts have the biggest median pries difference with respect to non superhosts ?
Ans. 
The neighbourhood with the biggest median price difference between superhosts and non superhosts is X.
• Calculate the median price for superhosts and non superhosts in each neighbourhood

• Find the neighbourhood with the largest difference in median prices between superhosts and non superhosts

• Example: Neighbourhood X has a median price of $200 for superhosts and $150 for non superhosts, resulting in a $50 difference
Answered by AI
Add your answer

The first round was a coding test (the language was Python). There were two questions, each 1.5 hrs. The coding test was monitored. You have to turn on your microphone and camera and share the screen.

While doing this coding test, you also have to write the steps of the code you want to implement.