Challenge Intellus Group - Challenge Quiz Name Email Company Telephone 1. What type of analytics focuses on understanding past performance to guide decision-making and planning for the future? Descriptive analytics Predictive analytics Prescriptive analytics Diagnostic analytics 2. What is the process of organizing and preparing data to make it suitable for analysis? Data governance Data warehousing Data wrangling Data visualization 3. What is the name of the branch of statistics that deals with the collection, analysis, interpretation, presentation, and organization of data? Data science Business intelligence Information management Descriptive statistics 4. How can you calculate the correlation between two variables in python? df[var1].corr(df[var2]) df[var1].correlation(df[var2]) df[var1].corrwith(df[var2]) df.corr(var1, var2) 5. How can you calculate the median of a column in a pandas dataframe? df['column'].median() df['column'].mean() df['column'].mode() df.median('column') 6. Given the following Python code, what is the value of the variable "result" after the code is executed?import pandas as pd import numpy as np df = pd.DataFrame({'A': [1, 2, 3], 'B': [4, 5, 6], 'C': [7, 8, 9]}) df['D'] = df.apply(lambda row: row['A'] + row['B'] + row['C'], axis=1) result = df['D'].sum() 21 27 36 45 7. How to get following result in SQL (left circle A, right circle B) select * from A INNER JOIN B on A.Key = B.Key select * from A LEFT OUTER JOIN B on A.Key = B.Key select * from A FULL OUTER JOIN B on A.Key = B.Key where A.Key IS NULL or B.Key IS NULL select * from A FULL OUTER JOIN B on A.Key = B.Key 8. How to get following result in SQL (left circle A, right circle B) select * from A INNER JOIN B on A.Key = B.Key select * from A LEFT OUTER JOIN B on A.Key = B.Key where B.Key is NULL select * from A RIGHT OUTER JOIN B on A.Key = B.Key where A.Key IS NULL or B.Key IS NULL select * from A FULL OUTER JOIN B on A.Key = B.Key Time is Up! Time's up Post Navigation
