G.K. Enterprises Interview Questions and Answers

Basic content assignment

Q1. How would you identify outliers in a dataset?
Ans. 
Identifying outliers in a dataset involves using statistical methods to detect data points that significantly differ from the rest.
• Calculate the mean and standard deviation of the dataset, then identify data points that fall outside a certain number of standard deviations from the mean.

• Use box plots to visually identify outliers based on their position outside the whiskers of the plot.

• Consider using Z-scores to determi...read more
Answered by AI
Add your answer
Q2. Tell us about yourself
Add your answer

Q1. What was your previous job? what writing skills, excel skills do you have?
Ans. 
I worked as a content writer at XYZ Company.
• Proficient in writing engaging and informative articles

• Skilled in conducting research and gathering information

• Experience in proofreading and editing content

• Familiarity with SEO techniques for optimizing content

• Ability to meet deadlines and work under pressure
Answered by AI
Add your answer
Q2. What skills do you have?
Ans. 
I have a diverse range of skills including communication, problem-solving, and technical proficiency.
• Excellent communication skills, both written and verbal

• Strong problem-solving abilities

• Proficient in various technical skills such as programming languages (e.g. Python, Java), data analysis, and software development

• Ability to work well in a team and collaborate effectively

• Adaptability and willingness to learn new skill
Answered by AI
Add your answer

Q1. How are you edgy over others
Add your answer
Q2. 5 years from now?
Add your answer

Q1. About Battery Technology.
Add your answer
Q2. About Market Requirement
Add your answer

Q1. Why switching the Job
Add your answer
Q2. Salary negotiation on FIXED + Variable
Add your answer

Q1. Ledger details posting profile
Add your answer
Q2. Fixed Asset project management and accounting
Add your answer

Q1. Difference between union and union all in SQL?
Ans. 
Union combines and removes duplicates, Union All combines without removing duplicates.
• Union combines result sets and removes duplicates

• Union All combines result sets without removing duplicates

• Union is slower than Union All as it involves removing duplicates

• Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

• Example: SELECT column1 FROM table1 UNION ALL SELECT column1 FROM table2;
Answered by AI
Add your answer
Q2. How to show top 5 in pandas?
Ans. 
To show top 5 in pandas, use the nlargest() function.
• Use the nlargest() function with the 'n' parameter set to 5 to get the top 5 values in a pandas DataFrame.

• For example: df['column_name'].nlargest(5) will return the top 5 values in the specified column.
Answered by AI
Add your answer

Q1. If we have 3 numerical columns, which chart is a better representation these column?
Ans. 
A scatter plot is a better representation for 3 numerical columns.
• Use a scatter plot to show the relationship between the numerical columns.

• Scatter plots are effective for visualizing correlations and patterns in data.

• Each point on the plot represents a data point with values from all 3 columns.
Answered by AI
Add your answer