How to extract numbers from string in excel? This article will help you with the approach and give you a clarity of logic that you can use in excel function to extract numbers. Let us understand different types of data that we can have. Predominantly, there are three different scenarios. numbers at the end (right […]
Python Interview Codes
Python Interview Codes Palindrome: A palindrome is a word, sentence, verse, or number that reads the same backward or forward. For example: madam, level, noon, etc Palindrome Code 1: Python program to check if a string is palindrome or not # Python program to check if a string is palindrome or notx = input(‘Enter a […]
Python codes
Python program to find the max of 2 numbers (using if) a=int(input(“Enter first number: “))b=int(input(“Enter second number: “))if a>b: print(a,’is the greater number’)elif b>a: print(b,’is the greater number’)else: print(‘Both the numbers are same’) Python program to find the max of 2 numbers (using function) a=int(input(“Enter first number: “))b=int(input(“Enter second number: “))if a==b: print(‘Both the numbers […]
Data Science Interview Questions
Q1:What is Data Science? Data science is the study of data using statistical techniques and computer programming to predict what will happen, recommend what is good, find association, understand pattern, etc. t is a multidisciplinary approach that combines principles and practices from the fields of mathematics, statistics, and computer engineering to analyze large amounts of […]
Excel Interview Questions for Analytics and MIS
Q1: What is a hyperlink? Q2: If you need to link a picture to one of the sheets then what option would you use and how would you do that? Q3: What is text-to-columns? Q4: Can you split the data stored in a column into multiple columns? If yes, how? Q5: I have Order Id […]
SQL Interview Questions and Answers
SQL interview questions with answers for Analytics and Data Science interview preparation Q1: What is the difference between a permanent table and a temporary table? A temporary table is a database table that is used to store the temporary result set. The result set can be reused several times in a single session. But the temporary table is […]
Tableau Interview Question and Answers in 2022
Tableau Interview Question and Answers in 2022 Q1: What is Tableau? Tableau is a Business Intelligence and Analytics software that is used to create visualizations and dashboards to provide actionable insights. Q2: What is data visualization? Data visualization means representing the information using visuals like charts, maps, colors (to highlight performance), heatmap, etc. This helps […]
Python Interview Questions
1) What is Python? Ans: Python is a high-level, interpreted, general-purpose programming language. It is an object oriented programming language and is used across industry for several purpose like Application Development, Data Science, Analytics, Machine Learning, Web Development, Games Development, etc. 2) What are the different data types Python? Data types in python are: – Numbers […]