Multiple Choice Questions on DataFrames and Data Selection for AI Basics

📚 Quick Study Guide

• 🔍 DataFrames are 2D labeled data structures with columns of potentially different types. Think of them as spreadsheets or SQL tables.
• 🔢 Data selection can be done using `.loc[]` (label-based) and `.iloc[]` (integer-based) methods.
• 💡 Boolean indexing allows selecting data based on conditions.
• 📝 You can chain multiple selection criteria using `&` (AND) and `|` (OR) operators.
• 📈 Missing data is often represented as `NaN` and can be handled using methods like `.fillna()` or `.dropna()`.
• 📊 `.groupby()` is a powerful method for grouping data and performing aggregate functions.
• ⚙️ Be mindful of SettingWithCopyWarning in Pandas; use `.loc[]` for safe assignments.

🧪 Practice Quiz

1. Which of the following is NOT a way to select data from a Pandas DataFrame?
   1. .loc[]
   2. .iloc[]
   3. .ix[]
   4. .at[]
2. What does the `.loc[]` method primarily use for data selection?
   1. Integer-based indexing
   2. Label-based indexing
   3. Boolean indexing
   4. Random indexing
3. How do you select all rows where the 'Age' column is greater than 30?
   1. `df[df['Age'] > 30]`
   2. `df.loc['Age' > 30]`
   3. `df.iloc['Age' > 30]`
   4. `df['Age' > 30].all()`
4. Which operator is used for 'AND' condition when chaining multiple boolean conditions?
   1. `||`
   2. `&&`
   3. `&`
   4. `|`
5. What does `NaN` typically represent in a DataFrame?
   1. Zero
   2. Empty string
   3. Missing data
   4. Infinity
6. Which method is used to fill missing values in a DataFrame?
   1. `.dropna()`
   2. `.fillna()`
   3. `.replace()`
   4. `.interpolate()`
7. What is the purpose of the `.groupby()` method?
   1. To sort the DataFrame
   2. To filter the DataFrame
   3. To group data based on a column
   4. To merge two DataFrames