NeenOpal Intelligent Solutions Interview Questions, Process, and Tips

Q1. THey ask about your experience and projects youve worked on create table fact_product ( order_date varchar, order_id varchar, product_id varchar, quantity int, price int ); insert into fact_pr...read more
Add your answer

Q1. List vs tuple difference
Ans. 
List is mutable, tuple is immutable in Python.
• List can be modified after creation, tuple cannot be modified

• List uses square brackets [], tuple uses parentheses ()

• List is used for collections of items that may need to be changed, tuple is used for fixed collections
Answered by AI
Add your answer
Q2. How to removes duplicates in spark
Ans. 
Use dropDuplicates() function in Spark to remove duplicates from a DataFrame.
• Use dropDuplicates() function on the DataFrame to remove duplicates based on all columns

• Specify columns to check for duplicates by passing them as arguments to dropDuplicates() function

• Example: df.dropDuplicates() or df.dropDuplicates(['col1', 'col2'])
Answered by AI
Add your answer

Excel, Python, SQL and Power BI

Q1. Remove duplicates from an array without using any functions
Ans. 
Remove duplicates from an array without using any functions
• Create an empty array to store unique values

• Loop through the original array and check if the value is already in the unique array before adding it

• Use nested loops to compare each element with all other elements in the array
Answered by AI
View 1 more answer
Q2. Create a single dimensional array from a multi dimensional array
Ans. 
To create a single dimensional array from a multi dimensional array, use the flatten method in Python.
• Use the flatten method in Python to convert a multi dimensional array into a single dimensional array.

• Example: multi_array = [[1, 2], [3, 4], [5, 6]]

• single_array = [item for sublist in multi_array for item in sublist]
Answered by AI
Add your answer
Q3. You have a 7 minutes hourglass and a 4 minutes hourglass, now figure out a way to calculate 9 minutes
Add your answer

Two tasks, one python and one SQL based

Q1. Q1.) Given sample data in text, read it in python Solution: Take the text to notepad, save it as CSV and then read it in python Check the number of null values Check the number of unique values Make a new...read more
Ans. 
Read sample data in text, check for null and unique values, create new column by multiplying two features
• Save text data as CSV and read in Python using pandas

• Use isnull() to check for null values

• Use nunique() to check for unique values

• Create a new column by multiplying two existing columns

• Add the new column to the existing dataframe
Answered by AI
Add your answer
Q2. Q3.) Query the minimum & maximum marks from the student table. Will the output be in the form of columns or rows. What to do in order to get the output in rows?
Add your answer
Q3. Q2.) Difference between list and tuple? a = [1,2,3,4,5,6,7,8,9] print(a[-1:-5]) Without running this code in compiler, tell the output
Ans. 
The code will output an empty list as a result of slicing from -1 to -5 in the list 'a'.
• Slicing in Python allows you to access a subset of elements in a list or tuple.

• When slicing, the start index is inclusive and the end index is exclusive.

• In this case, a[-1:-5] will result in an empty list because the start index -1 is greater than the end index -5.
Answered by AI
View 1 more answer
Q4. Q4.) Fibonacci series in python
Ans. 
Fibonacci series is a sequence of numbers where each number is the sum of the two preceding ones.
• Use a loop or recursion to generate Fibonacci series in Python.

• Start with 0 and 1 as the first two numbers in the series.

• Add the previous two numbers to get the next number in the series.
Answered by AI
Add your answer

Q1. Sql related Questions
Add your answer
Q2. Dax related Questions
Add your answer