1from datetime import datetime, date, timedelta
2 
3today = date(2026, 10, 8)
4students = {"Aman": "20-09-2026", "Priya": "01-10-2026", "Rahul": "27-09-2026", "Sneha": "05-10-2026"}
5 
6for name, joined in students.items():
7    due = datetime.strptime(joined, "%d-%m-%Y").date() + timedelta(days=10)
8    diff = (due - today).days
9    if diff > 0:
10        msg = f"due in {diff} day(s) on {due:%d %b}"
11    elif diff == 0:
12        msg = "due TODAY"
13    else:
14        msg = f"LATE by {-diff} days, late fee Rs {-diff * 50}"
15    print(f"{name:<6} {msg}")

1from pathlib import Path
2from collections import Counter
3import shutil
4 
5TYPES = {".pdf": "Documents", ".txt": "Documents", ".jpg": "Images", ".png": "Images",
6         ".xlsx": "Spreadsheets", ".mp3": "Music", ".zip": "Archives"}
7folder = Path("Downloads")
8moved = Counter()
9for f in list(folder.iterdir()):
10    if f.is_file():
11        target = folder / TYPES.get(f.suffix.lower(), "Others")
12        target.mkdir(exist_ok=True)
13        shutil.move(str(f), str(target / f.name))
14        moved[target.name] += 1
15 
16for sub in sorted(p for p in folder.iterdir() if p.is_dir()):
17    print(f"{sub.name:<13}", sorted(x.name for x in sub.iterdir()))
18print("Moved:", dict(moved))

1from collections import Counter, defaultdict
2 
3ballots = {
4    "9A": ["Anjali", "Rohit", "Anjali", "Imran", "Anjali", "Rohit"],
5    "9B": ["Rohit", "Rohit", "Imran", "Anjali", "Rohit"],
6    "10A": ["Imran", "Anjali", "Imran", "Imran", "Rohit", "Imran", "Anjali"],
7}
8total = Counter()
9breakdown = defaultdict(dict)
10for cls, votes in ballots.items():
11    c = Counter(votes)
12    total += c
13    for cand, n in c.items():
14        breakdown[cand][cls] = n
15 
16for rank, (cand, n) in enumerate(total.most_common(), 1):
17    print(f"{rank}. {cand:<7}{'#' * n:<10}{n:>3}  {breakdown[cand]}")
18print("Winner:", total.most_common(1)[0][0])

1import re
2 
3RULES = {
4    "name": (r"[A-Za-z ]{3,40}", "letters only, 3-40 chars"),
5    "mobile": (r"[6-9]\d{9}", "10 digits starting 6-9"),
6    "email": (r"[\w.+-]+@[\w-]+\.[\w.]+", "like name@site.com"),
7    "pin": (r"8[0-5]\d{4}", "Bihar/Jharkhand PIN, 6 digits"),
8    "id_number": (r"\d{4} ?\d{4} ?\d{4}", "12 digits"),
9}
10 
11def validate(form):
12    errors = [f"{f}: {msg}" for f, (pat, msg) in RULES.items() if not re.fullmatch(pat, form.get(f, "").strip())]
13    return errors
14 
15forms = [
16    {"name": "Riya Kumari", "mobile": "9835011111", "email": "riya@gmail.com", "pin": "834001", "id_number": "1234 5678 9012"},
17    {"name": "R2", "mobile": "5835011111", "email": "riya.gmail.com", "pin": "110001", "id_number": "12345"},
18]
19for i, f in enumerate(forms, 1):
20    errs = validate(f)
21    print(f"Form {i}:", "OK" if not errs else "")
22    for e in errs:
23        print("   x", e)

1import re
2from collections import Counter, defaultdict
3 
4levels = Counter()
5failed = defaultdict(list)
6slow = []
7with open("server.log") as f:
8    for line in f:
9        levels[line.split()[2]] += 1
10        if m := re.search(r"order=(\d+) code=(\w+)", line):
11            failed[m.group(2)].append(m.group(1))
12        if m := re.search(r"page=(\S+) time=([\d.]+)s", line):
13            slow.append((float(m.group(2)), m.group(1)))
14 
15print("Levels:", dict(levels))
16for code, orders in failed.items():
17    print(f"Payment error {code}: orders {orders}")
18print("Slowest page:", max(slow))

1import sqlite3
2con = sqlite3.connect("students.db")
3con.row_factory = sqlite3.Row
4 
5def init_db():
6    con.execute("DROP TABLE IF EXISTS students")
7    con.execute("CREATE TABLE students (roll INTEGER PRIMARY KEY, name TEXT, cls TEXT, marks INTEGER)")
8 
9def add_student(name, cls, marks):
10    with con:                       # auto-commit
11        con.execute("INSERT INTO students (name, cls, marks) VALUES (?, ?, ?)", (name, cls, marks))
12 
13def find(name):
14    return con.execute("SELECT * FROM students WHERE name = ?", (name,)).fetchone()
15 
16def top(n=3):
17    return con.execute("SELECT name, marks FROM students ORDER BY marks DESC LIMIT ?", (n,)).fetchall()
18 
19init_db()
20for s in [("Aman", "9A", 78), ("Priya", "9A", 92), ("Rahul", "9B", 65), ("Sneha", "9B", 88)]:
21    add_student(*s)
22r = find("Sneha")
23print("Found:", dict(r) if r else None)
24print("Missing:", find("Zara"))
25print("Top 2:", [tuple(x) for x in top(2)])

1import sqlite3
2con = sqlite3.connect(":memory:")
3con.executescript("""
4CREATE TABLE books (id INTEGER PRIMARY KEY, title TEXT);
5CREATE TABLE issues (id INTEGER PRIMARY KEY, book_id INTEGER, member TEXT, returned INTEGER DEFAULT 0);
6INSERT INTO books (title) VALUES ('Wings of Fire'), ('Godan'), ('Malgudi Days');
7""")
8 
9def is_out(book_id):
10    return con.execute("SELECT 1 FROM issues WHERE book_id = ? AND returned = 0", (book_id,)).fetchone() is not None
11 
12def issue(book_id, member):
13    if is_out(book_id):
14        return print(f"Book {book_id} is already issued")
15    con.execute("INSERT INTO issues (book_id, member) VALUES (?, ?)", (book_id, member))
16    print(f"Book {book_id} issued to {member}")
17 
18def return_book(book_id):
19    con.execute("UPDATE issues SET returned = 1 WHERE book_id = ? AND returned = 0", (book_id,))
20    print(f"Book {book_id} returned")
21 
22issue(1, "Asha"); issue(1, "Vikas"); issue(2, "Vikas"); return_book(1); issue(1, "Vikas")
23print("Currently issued:")
24for title, member in con.execute("SELECT b.title, i.member FROM issues i JOIN books b ON b.id = i.book_id WHERE i.returned = 0"):
25    print(f"  {title:<15} -> {member}")

1import sqlite3
2con = sqlite3.connect(":memory:")
3con.execute("CREATE TABLE items (name TEXT PRIMARY KEY, qty INTEGER, min_qty INTEGER, price REAL)")
4con.executemany("INSERT INTO items VALUES (?, ?, ?, ?)", [("Rice 5kg", 20, 5, 320), ("Dal 1kg", 8, 6, 128), ("Oil 1L", 12, 4, 175), ("Sugar 1kg", 15, 5, 46)])
5 
6def sell(name, n):
7    cur = con.execute("UPDATE items SET qty = qty - ? WHERE name = ? AND qty >= ?", (n, name, n))
8    print(f"{'Sold' if cur.rowcount else 'NOT enough'}: {n} x {name}")
9 
10for name, n in [("Dal 1kg", 3), ("Oil 1L", 9), ("Rice 5kg", 30), ("Sugar 1kg", 11)]:
11    sell(name, n)
12 
13print("Reorder list:")
14for name, qty, mn in con.execute("SELECT name, qty, min_qty FROM items WHERE qty < min_qty"):
15    print(f"  {name:<10} only {qty} left (min {mn})")
16value = con.execute("SELECT SUM(qty * price) FROM items").fetchone()[0]
17print(f"Stock value: Rs {value:,.2f}")

1import sqlite3
2con = sqlite3.connect(":memory:")
3con.execute("CREATE TABLE parents (name TEXT, area TEXT, phone TEXT)")
4con.executemany("INSERT INTO parents VALUES (?, ?, ?)", [
5    ("Sunil Mahto", "Kanke", "98350 10001"), ("Rekha Devi", "Hinoo", "98350 10002"), ("Mohan Lal", "Doranda", "98350 10003"),
6    ("Sunita Kujur", "Bariatu", "98350 10004"), ("Irfan Ansari", "Hinoo", "98350 10005"), ("Sunny Singh", "Lalpur", "98350 10006"),
7    ("Anita Tirkey", "Kanke", "98350 10007"), ("Rakesh Oraon", "Ratu", "98350 10008")])
8 
9for word in [input("Search name or area: "), input("Search again: ")]:
10    rows = con.execute("SELECT name, area, phone FROM parents WHERE name LIKE ? OR area LIKE ? ORDER BY name",
11                       (f"%{word}%", f"%{word}%")).fetchall()
12    print(f"Results for '{word}':" if rows else f"No match for '{word}'")
13    for r in rows:
14        print(f"  {r[0]:<14} {r[1]:<8} {r[2]}")

1import sqlite3
2con = sqlite3.connect(":memory:")
3con.executescript("""
4CREATE TABLE products (id INTEGER PRIMARY KEY, name TEXT, price INTEGER);
5CREATE TABLE orders (product_id INTEGER, qty INTEGER, month TEXT);
6INSERT INTO products VALUES (1,'Earphones',799),(2,'Charger',549),(3,'Phone cover',299),(4,'Power bank',1299);
7INSERT INTO orders VALUES (1,12,'Jul'),(2,20,'Jul'),(3,35,'Jul'),(4,6,'Jul'),(1,18,'Aug'),(2,15,'Aug'),
8 (3,40,'Aug'),(4,11,'Aug'),(1,25,'Sep'),(2,22,'Sep'),(3,28,'Sep'),(4,14,'Sep');
9""")
10JOIN = "FROM orders o JOIN products p ON p.id = o.product_id"
11print("Month  Revenue")
12for m, rev in con.execute(f"SELECT month, SUM(o.qty * p.price) {JOIN} GROUP BY month ORDER BY MIN(o.rowid)"):
13    print(f"{m:<6} Rs {rev:>8,} {'#' * (rev // 5000)}")
14name, units, rev = con.execute(f"SELECT p.name, SUM(o.qty), SUM(o.qty * p.price) AS r {JOIN} GROUP BY p.id ORDER BY r DESC LIMIT 1").fetchone()
15print(f"Best seller: {name} ({units} units, Rs {rev:,})")

1import pandas as pd
2df = pd.read_csv("results.csv")
3subs = ["maths", "science", "english", "hindi"]
4df["percent"] = df[subs].mean(axis=1)
5df["rank"] = df["percent"].rank(ascending=False).astype(int)
6print(df.sort_values("rank")[["rank", "name", "section", "percent"]].to_string(index=False))
7print("Best subject:", df[subs].mean().idxmax(), round(df[subs].mean().max(), 1))
8bands = pd.cut(df["percent"], bins=[0, 50, 75, 90, 100], labels=["Retest", "Good", "Very good", "Excellent"])
9print(bands.value_counts().sort_index().to_dict())

1import pandas as pd
2import matplotlib.pyplot as plt
3 
4months = ["Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
5rain = [18, 22, 25, 30, 65, 220, 330, 305, 240, 85, 12, 8]       # sample values (mm)
6df = pd.DataFrame({"month": months, "rain": rain})
7df["monsoon"] = df["month"].isin(["Jun", "Jul", "Aug", "Sep"])
8 
9colors = ["#1971c2" if m else "#adb5bd" for m in df["monsoon"]]
10plt.figure(figsize=(7, 3))
11plt.bar(df["month"], df["rain"], color=colors)
12plt.title("Ranchi monthly rainfall (sample data)")
13plt.ylabel("mm")
14plt.tight_layout()
15plt.savefig("rainfall.png", dpi=80)
16 
17share = df[df["monsoon"]]["rain"].sum() / df["rain"].sum() * 100
18print(f"Yearly total: {df['rain'].sum()} mm, monsoon share: {share:.0f}%")
19print("Wettest month:", df.loc[df["rain"].idxmax(), "month"])

1import pandas as pd
2import matplotlib.pyplot as plt
3 
4df = pd.read_csv("sales.csv", parse_dates=["date"])
5df["revenue"] = df["qty"] * df["price"]
6df["month"] = df["date"].dt.strftime("%b")
7monthly = df.groupby("month", sort=False)["revenue"].sum()
8branch = df.groupby("branch")["revenue"].sum().sort_values(ascending=False)
9product = df.groupby("product")["revenue"].sum().sort_values()
10 
11print("Monthly:", monthly.to_dict())
12print("Best branch:", branch.index[0], f"Rs {branch.iloc[0]:,}")
13print("Best product:", product.index[-1], f"Rs {product.iloc[-1]:,}")
14 
15fig, (a, b) = plt.subplots(1, 2, figsize=(9, 3))
16monthly.plot(ax=a, marker="o", title="Revenue by month")
17product.plot(ax=b, kind="barh", color="#2f9e44", title="Revenue by product")
18plt.tight_layout()
19plt.savefig("dashboard.png", dpi=80)