🧠 Quick Study Guide: Analyzing Student Data with Pandas DataFrames
- 📚 What is a DataFrame? A Pandas DataFrame is a 2-dimensional labeled data structure with columns of potentially different types. Think of it like a spreadsheet or SQL table, but in Python.
- 💡 Importing Data: Student data often comes in CSV, Excel, or database formats. Pandas allows easy import using functions like `pd.read_csv()`, `pd.read_excel()`, etc.
- 🔍 Basic Inspection: Use `.head()`, `.info()`, `.describe()`, and `.shape` to quickly understand your data's structure, types, and summary statistics.
- 🔢 Selecting Columns: Access specific student attributes (e.g., 'Grades', 'Attendance') using bracket notation: `df['Grades']` or `df[['Name', 'Grades']]`.
- 📈 Filtering Data: Identify specific groups of students (e.g., 'students with grade > 90') using boolean indexing: `df[df['Grade'] > 90]`.
- 📊 Group By Operations: Aggregate data by categories (e.g., 'average grade per class') using `.groupby()`: `df.groupby('Class')['Grade'].mean()`.
- 🧹 Handling Missing Data: Student records might have missing entries. Use `.isnull().sum()` to check and `.dropna()` or `.fillna()` to manage them.
- ➕ Creating New Columns: Derive new insights (e.g., 'Pass/Fail status') by creating new columns based on existing ones: `df['Status'] = np.where(df['Grade'] >= 60, 'Pass', 'Fail')`.
- ⚙️ Sorting Data: Order student records based on specific criteria (e.g., 'highest grade first') using `.sort_values()`: `df.sort_values(by='Grade', ascending=False)`.
📝 Practice Quiz
1. Which Pandas function is best suited for loading student data from a CSV file into a DataFrame?
A) pd.load_csv()
B) pd.read_csv()
C) pd.get_csv()
D) pd.import_csv()
2. You want to see the first 5 rows of your students_df DataFrame to quickly inspect its structure. Which method would you use?
A) students_df.tail(5)
B) students_df.info()
C) students_df.head()
D) students_df.describe()
3. To calculate the average 'Score' for each 'Course' in a DataFrame named grades_df, which combination of methods is most appropriate?
A) grades_df.sort_values('Course')['Score'].mean()
B) grades_df.filter('Course')['Score'].average()
C) grades_df.groupby('Course')['Score'].mean()
D) grades_df.aggregate(by='Course', func='mean')
4. If you have a DataFrame student_data and want to select only the 'Name' and 'Email' columns, what is the correct syntax?
A) student_data['Name', 'Email']
B) student_data.columns('Name', 'Email')
C) student_data[['Name', 'Email']]
D) student_data.select_columns('Name', 'Email')
5. You need to find all students in student_df who have a 'Grade' greater than or equal to 90. Which of the following correctly filters the DataFrame?
A) student_df.filter(grade >= 90)
B) student_df[student_df['Grade'] >= 90]
C) student_df.query('Grade' >= 90)
D) student_df.where(student_df['Grade'] >= 90)
6. Which method would you use to check for the total number of missing values in each column of your DataFrame df_students?
A) df_students.isna().count()
B) df_students.dropna().sum()
C) df_students.isnull().sum()
D) df_students.missing_values()
7. You want to add a new column 'Performance' to your student_df based on 'Score', where 'Excellent' for scores > 90, 'Good' for scores between 70-90, and 'Average' otherwise. Which Pandas concept is primarily used here?
A) Data Merging
B) Data Pivoting
C) Conditional Column Creation
D) Data Reshaping
Click to see Answers
1. B) pd.read_csv()
2. C) students_df.head()
3. C) grades_df.groupby('Course')['Score'].mean()
4. C) student_data[['Name', 'Email']]
5. B) student_df[student_df['Grade'] >= 90]
6. C) df_students.isnull().sum()
7. C) Conditional Column Creation
