Coditas Technologies AWS Data Engineer Interview Questions and Answers

Q1. Reverse a string
Add your answer

Q1. How to remove duplicate values from dataset
Ans. 
Use pandas library in Python to remove duplicate values from dataset
• Import pandas library in Python

• Use drop_duplicates() method on the dataset

• Specify columns to check for duplicates if needed

• Example: df.drop_duplicates(subset=['column_name'])
Answered by AI
Add your answer
Q2. Difference between zip and enumerate
Ans. 
zip is used to combine two lists into a list of tuples, while enumerate is used to add a counter to an iterable.
• zip function takes two lists and combines them into a list of tuples

• enumerate function adds a counter to an iterable and returns it as an enumerate object

• Example for zip: zip([1, 2, 3], ['a', 'b', 'c']) will result in [(1, 'a'), (2, 'b'), (3, 'c')]

• Example for enumerate: enumerate(['apple', 'banana', 'cherry']...read more
Answered by AI
Add your answer

Q1. General questions
Add your answer
Q2. Excel Questions
Add your answer

Excel Assignment on building a dashboard

Easy 1 coding
Medium 1 coding
It was about arrays and sorting techniques and other is about your common sense

Q1. Mainly about core java
Add your answer
Q2. Mainly about SQL , My SQL and different type of joins etc
Add your answer

Q1. Pivot table in excel
Ans. 
Pivot table is a data summarization tool in Excel.
• Pivot table allows users to summarize and analyze large datasets.

• It can be used to group data by categories, calculate totals, and create custom calculations.

• Users can easily change the layout of the table to view data in different ways.

• Pivot table is a powerful tool for data analysis and reporting.

• Example: A sales manager can use pivot table to analyze sales data by re
Answered by AI
Add your answer
Q2. How to count data in excel
Ans. 
To count data in Excel, use the COUNT function or select the data and look at the status bar.
• Use the COUNT function to count the number of cells that contain numbers or dates

• Use the COUNTA function to count the number of cells that are not empty

• Select the data and look at the status bar to see the count of selected cells

• Use the COUNTIF function to count cells that meet a specific criteria
Answered by AI
Add your answer

Q1. Basic to Intermediate SQL Based questions
Add your answer
Q2. Basic to Intermediate Python Based questions
Add your answer

Q1. In depth spark fundamentals
Add your answer
Q2. Data Modelling case studies
Add your answer

Q1. It depends on the client, I got very simple SQL questions and ADF questions
Add your answer