# 1. Create a new file called "school_search.py" # 2. Open it in any text editor # 3. Start with this basic setup: import pandas as pd def main(): # Main function - everything starts here print("=== School Search System ===") # Load our Excel file file_path = "school_data.xlsx" try: # Read the Excel file excel_file = pd.ExcelFile(file_path) print(f"Success! Found {len(excel_file.sheet_names)} sheets") return excel_file except Exception as e: print(f"Error: {e}") return None if __name__ == "__main__": main()

# Add this function to your file (under the imports) def simple_search(excel_file, search_term): """Search for any term across all sheets""" results = [] for sheet_name in excel_file.sheet_names: # Read each sheet df = pd.read_excel(excel_file, sheet_name=sheet_name) # Search in all cells for row_idx, row in df.iterrows(): for col_name, cell_value in row.items(): if pd.notna(cell_value): if search_term.lower() in str(cell_value).lower(): results.append({ 'sheet': sheet_name, 'row': row_idx + 2, # Excel row number 'column': col_name, 'value': str(cell_value) }) return results

def main(): print("=== School Search System ===") # Load data data = pd.ExcelFile("school_data.xlsx") # Test search print("\nSearching for 'Math'...") math_results = simple_search(data, "Math") for result in math_results[:5]: # Show first 5 results print(f"Found in {result['sheet']}, row {result['row']}: {result['value']}") print(f"\nTotal found: {len(math_results)} results")

# Function to find homeroom teacher def find_teacher(excel_file, student_name): """Find homeroom teacher for a student""" for sheet_name in excel_file.sheet_names: df = pd.read_excel(excel_file, sheet_name=sheet_name) # Look for student name for idx, row in df.iterrows(): for cell_value in row.values: if pd.notna(cell_value) and student_name in str(cell_value): # Check if teacher info is in same row for col in df.columns: if "teacher" in str(col).lower() or "преподаватель" in str(col).lower(): if pd.notna(row[col]): return row[col] return "Teacher not found"

# Function to find students by class def find_students_in_class(excel_file, class_name): """Find all students in a specific class (like 4A)""" students = [] for sheet_name in excel_file.sheet_names: df = pd.read_excel(excel_file, sheet_name=sheet_name) for idx, row in df.iterrows(): for cell_value in row.values: if pd.notna(cell_value) and class_name in str(cell_value): # Look for student names in this row for col in df.columns: if "name" in str(col).lower() or "фио" in str(col).lower(): if pd.notna(row[col]): students.append(row[col]) return list(set(students)) # Remove duplicates

# school_search.py - COMPLETE PROGRAM import pandas as pd # [PASTE ALL FUNCTIONS FROM PREVIOUS SLIDES HERE] # 1. simple_search() function # 2. find_teacher() function # 3. find_students_in_class() function def main(): # 1. Load the data print("=== Student Database Search ===") try: # Change this to your actual file name data = pd.ExcelFile("Распределение по группам Технолицей 2025_2026 - 4.xlsx") print(f"✓ Loaded: {len(data.sheet_names)} sheets") except: print("✗ Error: Make sure the Excel file is in the same folder!") return # 2. Example searches print("\n--- Example 1: Find Teacher ---") teacher = find_teacher(data, "Арефьев") print(f"Homeroom teacher: {teacher}") print("\n--- Example 2: Find Students ---") students = find_students_in_class(data, "4A") print(f"Students in 4A: {len(students)} found") for student in students[:3]: # Show first 3 print(f" • {student}") print("\n--- Example 3: General Search ---") results = simple_search(data, "Math") print(f"Found 'Math' {len(results)} times") print("\n=== Search Complete ===") if __name__ == "__main__": main()

# Simple SQLite database setup (future enhancement) import sqlite3 def create_database(): # Connect to database (creates if doesn't exist) conn = sqlite3.connect('school.db') cursor = conn.cursor() # Create tables (like in the video!) cursor.execute('''CREATE TABLE IF NOT EXISTS students ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, grade TEXT, class TEXT, homeroom_teacher_id INTEGER )''') cursor.execute('''CREATE TABLE IF NOT EXISTS teachers ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, subject TEXT )''') conn.commit() conn.close() print("Database created successfully!")