
Python
Quiz by Support - BusinessPromoted .com
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Measure skills
from any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
With a free account, teachers can
- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
20 questions
Show answers
- Q11. How can you embed a Python script in Power BI to perform data transformation?Use DAX Script in Power Query EditorUse R Script in Power Query EditorUse Python Script in Power Query EditorUse SQL Script in Power Query Editor40s
- Q22. Which Python library is most commonly used for data manipulation and analysis in Power BI?seabornnumpypandasmatplotlib40s
- Q33. How can you handle missing values in a dataset using Python in Power BI?df.replace()df.interpolate()df.fillna()df.dropna()40s
- Q44. What is the purpose of using 'df.groupby()' in a Python script within Power BI?To merge dataframesTo filter dataTo group data based on one or more columnsTo sort data40s
- Q55. How can you visualize data using Python in Power BI?Use SQLUse pandasUse matplotlib or seaborn within a Python visualUse numpy40s
- Q66. How do you ensure your Python environment is set up correctly for Power BI integration?Install Java and required librariesInstall Python and required libraries, and set the correct Python home directory in Power BIInstall R and required librariesInstall SQL Server and required libraries40s
- Q77. How do you read a CSV file into a pandas DataFrame in Power BI?pd.load_csv('file_path')pd.read_csv('file_path')pd.open_csv('file_path')pd.get_csv('file_path')40s
- Q88. How can you merge two DataFrames in Python for use in Power BI?pd.join(df1, df2, on='key')pd.append(df1, df2)pd.merge(df1, df2, on='key')pd.concat(df1, df2)40s
- Q99. What method would you use to remove duplicates from a DataFrame in Python within Power BI?df.drop_duplicates()df.clear_duplicates()df.delete_duplicates()df.remove_duplicates()40s
- Q1010. How can you create a new column in a DataFrame in Python to calculate the total sales from quantity and price columns?df['Total Sales'] = df['Quantity'] / df['Price']df['Total Sales'] = df['Quantity'] * df['Price']df['Total Sales'] = df['Quantity'] + df['Price']df['Total Sales'] = df['Quantity'] - df['Price']40s
- Q1111. How do you handle large datasets in Python within Power BI to ensure performance?Load the entire dataset at onceUse Excel for pre-processingUse chunking with pd.read_csv()Use SQL queries40s
- Q1212. How can you apply a custom function to each element of a column in a DataFrame in Power BI using Python?df['column'].sort(custom_function)df['column'].map(custom_function)df['column'].filter(custom_function)df['column'].apply(custom_function)40s
- Q1313. How can you perform a left join between two DataFrames in Python within Power BI?pd.join(df1, df2, how='left')pd.append(df1, df2, how='left')pd.concat(df1, df2, how='left')pd.merge(df1, df2, how='left')40s
- Q1414. Which method would you use to pivot a DataFrame in Python within Power BI?df.pivot()df.melt()df.stack()df.unstack()40s
- Q1515. How do you filter rows in a DataFrame based on a condition in Python for Power BI?df.select('column' > value)df.filter('column' > value)df[df['column'] > value]df.where('column' > value)40s