CIEL HR Interview Questions and Answers

Effective data cleaning involves identifying and correcting errors in a dataset to ensure accuracy and reliability.

• Identify and remove duplicate entries

• Correct inaccuracies and inconsistencies in data

• Handle missing values appropriately

• Standardize data formats and values

• Validate data against predefined rules or constraints

• Automate the process using scripts or tools like Python pandas or SQL queries

Exploratory Data Analysis (EDA) involves steps like data cleaning, visualization, and statistical analysis.

• Data cleaning to handle missing values and outliers

• Visualization of data using plots like histograms, scatter plots, and box plots

• Statistical analysis to understand relationships between variables

• Identifying patterns and trends in the data

• Creating summary statistics to describe the data

The median is the middle value in a list of numbers when they are ordered from smallest to largest.

• The median can be found by arranging the numbers in order and selecting the middle value. If there is an even number of values, the median is the average of the two middle values.

• For example, in the list 2, 4, 6, 8, 10, the median is 6. In the list 1, 3, 5, 7, the median is 4.

• The median is a measure of central tendency that is less affected by extreme values compared to the mean...read more

Lists, tuples, and dictionaries are data structures in Python used to store collections of items.

• Lists are mutable and ordered collections of items, accessed by index. Example: my_list = [1, 2, 3]

• Tuples are immutable and ordered collections of items, accessed by index. Example: my_tuple = (1, 2, 3)

• Dictionaries are unordered collections of key-value pairs, accessed by key. Example: my_dict = {'key': 'value'}

Linear regression is a statistical method to model the relationship between a dependent variable and one or more independent variables.

• Linear regression is used to predict the value of a dependent variable based on the value of one or more independent variables.

• It assumes a linear relationship between the independent and dependent variables.

• The goal of linear regression is to find the best-fitting line that represents the relationship between the variables.

• An example of linea...read more

Named Entity Recognition (NER) is a natural language processing task that identifies and classifies named entities in text.

• NER is used to extract entities such as names of people, organizations, locations, dates, and more from unstructured text.

• It helps in information retrieval, question answering, and text summarization.

• Example: In the sentence 'Apple is headquartered in Cupertino', NER would identify 'Apple' as an organization and 'Cupertino' as a location.

OOPs stands for Object-Oriented Programming. It is a programming paradigm based on the concept of objects.

• OOPs focuses on creating objects that contain data and methods to manipulate that data.

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

• Examples of OOP languages include Java, C++, and Python.