Python
R
SQL
Stats
Random
100

What's the output of len(set([1, 2, 2, 3, 4, 4, 5]))?

5

100

What's library(tidyverse)? 

Loads a collection of R packages for data manipulation, visualization, and modeling

100

SELECT COUNT(*) FROM table_name;

Returns the number of rows in the table

100

ANOVA stands for

Analysis of variance

100

The first prime number is

2

200

What's the output of [i for i in range(10) if i % 2 == 0]?

[0, 2, 4, 6, 8]

200

summary(data)

Summary of the data contained in the data frame, including the minimum, maximum, median, and quartiles for each variable

200

ALTER TABLE T ADD C varchar(255);

Adds a new column C of type varchar to table T

200

What's the probability of getting heads when flipping a coin once?

50%

200

What's one of the tops public websites to find and publish datasets? 

Kaggle

300

What's the len of this output?  list(itertools.permutations(range(1, 4)))

Len = 6

[(1, 2, 3), (1, 3, 2), (2, 1, 3), (2, 3, 1), (3, 1, 2), (3, 2, 1)]

300

What is this code doing?

library(dplyr)

data("mtcars")

mtcars %>% group_by(cyl) %>% summarise(avg_hp = mean(hp))

Loads packages and dataset, then calculates the average horsepower (hp) for each group

300

SELECT name, last_name FROM patient_cohort WHERE name LIKE '%John%" ORDER BY last_name DESC

Select only patients like John and return name, last name in descending order of last name.

300

A t-test compares the ______ of two groups.

Means

300

What FHIR stands for?

Fast Healthcare Interoperability Resources

400

Assuming internet connectivity, what would be the output of requests.get("https://www.google.com")

200

400

summary(lm(y ~ x))

summary of the linear regression model

400

What's a VIEW?

Virtual table

400

The Pearson correlation coefficient is often represented by what letter?

r

400

What are the top two EHR vendors in the US?

Epic and Oracle Cerner

500

What's the output of this statement?

text = "I like eating pizza."

tokens = nltk.word_tokenize(text)

tags = nltk.pos_tag(tokens)

Each word tag with Part of Speech (POS)

[('I', 'PRP'), ('like', 'VBP'), ('eating', 'VBG'), ('pizza', 'NN'), ('.', '.')]

500

ggplot(mtcars, aes(x = wt, y = mpg)) + geom_point()

scatter plot of mpg versus wt using the ggplot function

500

What's the difference between UNION and UNION ALL?

UNION statement removes duplicates, while the UNION ALL statement includes duplicates

500

LCA stands for

Latent class analysis

500

In chatGPT, GPT stands for

Generative pre-trained transformer

M
e
n
u