Build a Facial Recognition Attendance System

So I built a simple Python script that could scrape data from websites and save it in a CSV file. No fancy interface, no complex setup—just a straightforward tool that did the job.

I kept it simple and used:

Here’s an example for scraping product details:

import requests
from bs4 import BeautifulSoup

# Target URL of the product
URL = "https://www.example.com/product-page"

# Headers to mimic a real browser
HEADERS = {
    "User-Agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36"
}

def get_product_price():
    response = requests.get(URL, headers=HEADERS)
    soup = BeautifulSoup(response.content, "html.parser")

    # Extract product name and price using CSS selectors
    product_name = soup.find("h1", {"class": "product-title"}).text.strip()
    price = soup.find("span", {"class": "price"}).text.strip()

    return product_name, float(price.replace("$", ""))

product, price = get_product_price()
print(f"{product}: ${price}")

Create a sample Excel file named sales_data.xlsx with the following structure:

Here’s how to load and read data from an Excel file:

Explanation:

• require('sqlite3').verbose(): Imports the sqlite3 module with verbose error logging enabled.
• new sqlite3.Database('your_database_name.db'): Creates a new SQLite database file named your_database_name.db. If the file doesn't exist, SQLite will create it.

Replace the placeholders with your actual database details.

Migrations in Laravel allow you to define and modify your database schema. Let's create a migration for a posts table:

Create a file named app.py and add:

from flask import Flask

app = Flask(__name__)

@app.route('/')
def home():
    return "Welcome to the Flask REST API!"

if __name__ == '__main__':
    app.run(debug=True)