Amex Gbt Data Analyst Interview Questions and Answers

Q1. Explain Moving Average
Ans. 
Moving Average is a statistical technique used to analyze data points by creating a series of averages of different subsets of the full data set.
• Moving Average helps in smoothing out fluctuations in data to identify trends over time.

• It is calculated by taking the average of a specific number of data points within a defined window.

• For example, a 3-day moving average for stock prices would be the average of the stock pri...read more
Answered by AI
Add your answer
Q2. Explain Decorators
Ans. 
Decorators in Python are functions that modify the behavior of other functions.
• Decorators are denoted by the @ symbol followed by the decorator function name.

• They allow you to add functionality to an existing function without modifying its code.

• Common use cases include logging, timing, and authentication.

• Example: @decorator_function def function_to_decorate(): pass
Answered by AI
Add your answer
Q3. Explain Object Oriented Programming
Ans. 
Object Oriented Programming is a programming paradigm based on the concept of objects, which can contain data and code.
• OOP focuses on creating objects that interact with each other to solve complex problems.

• Objects have attributes (data) and methods (functions) that can manipulate the data.

• Encapsulation, inheritance, and polymorphism are key principles of OOP.

• Example: In a car simulation program, a 'Car' object can hav...read more
Answered by AI
Add your answer
Q4. Explain classes objects
Ans. 
Classes are blueprints for creating objects in object-oriented programming.
• Classes define the properties and behaviors of objects

• Objects are instances of classes

• Classes can inherit properties and behaviors from other classes

• Classes can have constructors to initialize objects

• Classes can have methods to perform actions
Answered by AI
Add your answer
Q5. Explain Functions
Ans. 
Functions are blocks of code that perform a specific task and can be reused multiple times in a program.
• Functions help in organizing code and making it more modular.

• They can take input parameters and return output values.

• Functions can be called multiple times from different parts of the program.

• Examples: summing two numbers, finding the maximum value in a list.
Answered by AI
Add your answer
Q6. Pandas and Numpy
Add your answer
Q7. Swap L1 and L5 in a list
Ans. 
Swap L1 and L5 in a list
• Create a temporary variable to store the value of L1

• Assign the value of L5 to L1

• Assign the value of the temporary variable to L5
Answered by AI
Add your answer

Business problems were asked and analyzed the approach to solve the problem. Reading case studies would help you here

Q1. Few Statistics questions were asked. Some coding. And all about our resume in depth. Prepare your resume and Stats well.
Add your answer

Q1. What is the number of tourist per day in jaipur
Ans. 
The number of tourists per day in Jaipur varies depending on the season and events happening in the city.
• Tourist numbers fluctuate based on time of year (peak season vs off-peak season)

• Events like festivals or cultural events can attract more tourists

• Historical sites like Amer Fort and Hawa Mahal are popular attractions

• Tourist numbers can be estimated based on hotel occupancy rates and ticket sales for attractions
Answered by AI
Add your answer

Q1. Calculate no of rows after join
Ans. 
Calculate the number of rows after joining two datasets.
• Count the number of rows in each dataset

• Perform the join operation

• Count the number of rows in the resulting dataset
Answered by AI
Add your answer
Q2. Split person name in excel
Ans. 
Use Excel's text to columns feature to split person names into separate columns.
• Select the column containing the full names

• Go to the Data tab and click on Text to Columns

• Choose 'Delimited' and select the delimiter that separates the names (e.g. space)

• Click Finish to split the names into separate columns
Answered by AI
Add your answer