Espire Infolabs Interview Questions and Answers

I use tools like Python, SQL, Tableau for data analysis and visualization.

• Python for data cleaning and analysis

• SQL for querying databases

• Tableau for creating interactive visualizations

A numeric value can be treated as a text value in Microsoft Excel if it precedes with an apostrophe.

• Precede the numeric value with an apostrophe (') to treat it as text.

• For example, entering '123 in a cell will display as text '123 instead of the numeric value 123.

• This is useful when you want to display leading zeros in a number without Excel automatically removing them.

To remove duplicates in MySQL, you can use the DISTINCT keyword or the GROUP BY clause.

• Use the DISTINCT keyword to select unique values from a single column.

• Use the GROUP BY clause to select unique combinations of values from multiple columns.

• You can also use the DELETE statement with a subquery to remove duplicate rows from a table.

To find the last 3 records, sort the data in descending order and select the first 3 records.

• Sort the data in descending order based on the relevant field

• Select the first 3 records from the sorted data

I am proficient in Python, SQL, and R for data analysis.

• Proficient in Python for data cleaning and analysis

• Strong in SQL for querying databases

• Experienced in R for statistical analysis and visualization

Finding the longest common subsequence in a string is a standard dynamic programming problem.

• Use dynamic programming to build a 2D array to store the length of the longest common subsequence at each pair of indices.

• Traverse the array to reconstruct the longest common subsequence.

• Example: For strings 'ABCD' and 'ACD', the longest common subsequence is 'ACD'.