NEW
Font size
WorksheetsSQL & PANDAS Quiz
Total questions: 12
Worksheet time: 6mins
SQL: which keyword is used to read /query value from a table in a database?
SELECT
UPDATE
DELETE
JOIN
Which of the following statements is true about the SELECT statement in Google BigQuery?
It specifies the tables to be included in the query
It specifies the columns to be included in the query result
It specifies the conditions for filtering the query result
In Google BigQuery, which keyword is used to specify the table or tables from which you want to retrieve data?
WHERE
GROUP
FROM
Setting
Which of the following statements is true about the WHERE clause in Google BigQuery?
It specifies the columns to be included in the query result
It specifies the tables to be included in the query
It specifies the conditions for filtering the query result
Which of the following methods is used to create an empty DataFrame in Pandas?
pd.empty()
pd.DataFrame()
pd.zeros()
pd.ones()
What is the Pandas method used to merge two DataFrames based on a common column?
df.merge()
df.plus()
df + df
Which method is used to remove columns from a Pandas DataFrame?
df - column name
df.remove()
df.erase()
df.drop()
What is the Pandas method used to group a DataFrame by a specific column or set of columns?
df.group_by()
df.groupby()
df.segment()
df.split()
Which method is used to select a single column from a Pandas DataFrame and return a Series object?
df.select()
df.get()
df[] or df['column_name']
Which method is used to fill the missing values in a Pandas DataFrame with a specified value?
df.fill_missing()
df.fillna()
df.replace_missing()
df.replace_na()
Which method is used to apply a function to each element of a Pandas DataFrame?
df.apply()
df.map()
df.filter()
Which method is used to pivot a Pandas DataFrame based on the values in one or more columns?
df.pivot()
df.stack()
df.unstack()
df.melt()
