Biokind Jeopardy

Question 1

Carson Palmer

Answer

This USC quarterback won the Heisman Trophy in 2002 and had a successful NFL career, particularly with the Bengals, Raiders, and Arizona Cardinals

Question 2

Dr. Allen and Charlotte Ginsburg Human-Centered Computation Hall

Answer

Which is the newest building on campus? (+20 points for full name)

Question 3

List

Answer

This Python data structure is ordered, allows duplicate elements, and can store multiple values of different data types

Question 4

Any 3: Matplotlib, Seaborn, Tableau, Power BI, Looker Studio, Spotfire, Sisense, Qlik

Answer

Name three commonly used software tools for data visualization

Question 5

Supervised learning

Answer

This type of machine learning involves labeled data and is used for tasks like classification and regression

Question 6

O.J. Simpson

Answer

Question: This former USC running back was inducted into the Pro Football Hall of Fame in 1985 and had a highly publicized legal case in the 1990s

Question 7

Pete Carrol

Answer

WHICH USC COACH TRANSFORMED THE FOOTBALL TEAM INTO NATIONAL CONTENDERS IN THE 2000s?

Question 8

Standard deviation

Answer

This statistical term refers to the measure of how spread out the values in a dataset are, often calculated as the square root of the variance

Question 9

relational database

Answer

This type of database management system (DBMS) stores data in tables and is accessed using Structured Query Language (SQL)

Question 10

Mean squared error (MSE)

Answer

This metric is used to measure the accuracy of a regression model by calculating the average of the squared differences between actual and predicted values

Question 11

George Lucas

Answer

Question: This USC alumnus is one of the highest-grossing directors of all time, known for directing films like Star Wars and Indiana Jones

Question 12

George Lucas

Answer

WHICH FAMOUS FILMMAKER DONATED TO USC IN 2006?

Question 13

Imputation

Imputation is a statistical technique used to fill in missing data points in a dataset. The goal is to replace missing values with substituted values, which can help maintain the integrity of the dataset for analysis and modeling. Common methods for imputation include replacing missing values with the mean, median, or mode of the respective column.

Example Code

Here’s a simple example using the pandas library in Python to perform imputation on a DataFrame:

import pandas as pd
import numpy as np

# Create a sample DataFrame with missing values
data = {
    'A': [1, 2, np.nan, 4],
    'B': [5, np.nan, np.nan, 8],
    'C': [10, 11, 12, 13]
}
df = pd.DataFrame(data)

# Impute missing values with the mean of each column
df_imputed = df.fillna(df.mean())

print("Original DataFrame:")
print(df)
print("\nDataFrame after imputation:")
print(df_imputed)

Explanation:

This code creates a DataFrame df with missing values (represented as np.nan).
The fillna() method is used to replace the missing values with the mean of each column.
The original DataFrame and the imputed DataFrame are printed to show the difference.

By using imputation, you can ensure that your dataset remains useful for analysis without losing valuable information due to missing values.

Answer

This technique in data preprocessing involves replacing missing values in a dataset with the mean, median, or mode of that feature

Question 14

MongoDB

Answer

This non-relational database is known for storing data in a flexible, JSON-like format and is often used for handling unstructured data

Question 15

F1 score

Answer

The ________ is a performance measure for classification models that calculates the harmonic mean of precision and recall, providing a balance between the two metrics, especially in cases of class imbalance

Question 16

Pardee Tower

Answer

This USC dorm was featured in The Office in a scene where Pam went to art school

Question 17

8

Answer

HOW MANY HEISMAN TROPHY WINNERS HAVE COME FROM USC?

Question 18

lambda function

Answer

This type of function in Python is often used for small, one-off operations and doesn't require a formal def statement. It's typically written in a single line and used in cases like sorting or filtering

Question 19

JOIN

Answer

Question: This command in SQL is used to combine rows from two or more tables based on a related column between them

Question 20

X_train, X_test, Y_train, Y_test = train_test_split(X, y, test_size=0.2, random_state=42)

Answer

Using scikit-learn, write a single line of code to split the dataset X and y into training and test sets with 80% of the data for training and a random seed of 42

Question 21

Allyson Felix

Answer

This USC alumna is the most decorated female track and field athlete in Olympic history, with a total of 11 Olympic medals, including 7 golds

Question 22

38

Answer

How many fountains do we have on campus? (±2)

Question 23

zip()

Answer

In Python, this built-in function allows you to iterate over two or more iterables (like lists or tuples) in parallel, returning tuples containing elements from each iterable at the same position

Question 24

SELECT * FROM Employees WHERE department = 'Sales';

Answer

Write an SQL query to retrieve all columns from a table named Employees where the employee's department is 'Sales'

Question 25

np.sum(3 * np.square(x) + 2 * x + 1)

Answer

Convert the following mathematical function into a NumPy expression