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:

Let’s scrape product details from a sample e-commerce page (e.g., Amazon, eBay, or a local retailer). Start by identifying the HTML structure of the page using your browser's Developer Tools.

Here’s an example for scraping product details:

# Add a new sheet for the summary
summary = workbook.create_sheet('Summary')

# Calculate total sales for all products
total_sales = sum(sheet.cell(row=row, column=5).value for row in range(2, sheet.max_row + 1))

# Find the highest-selling product
highest_sales = max(sheet.cell(row=row, column=5).value for row in range(2, sheet.max_row + 1))
highest_product = None
for row in range(2, sheet.max_row + 1):
    if sheet.cell(row=row, column=5).value == highest_sales:
        highest_product = sheet.cell(row=row, column=1).value
        break

# Write summary data
summary.cell(row=1, column=1, value="Total Sales")
summary.cell(row=1, column=2, value=total_sales)
summary.cell(row=2, column=1, value="Highest-Selling Product")
summary.cell(row=2, column=2, value=highest_product)

# Save the updated workbook
workbook.save('sales_report_with_summary.xlsx')

After completing the above steps, you will have a fully automated Excel report with:

// app.js

const sqlite3 = require('sqlite3').verbose();

// Connect to the SQLite database (creates the file if it doesn't exist)
const db = new sqlite3.Database('your_database_name.db', (err) => {
  if (err) {
    console.error('Error opening database:', err.message);
  } else {
    console.log('Connected to the SQLite database.');
  }
});

// Serialize ensures that the queries are executed sequentially
db.serialize(() => {
  // Create the "accounts" table
  db.run(`
    CREATE TABLE IF NOT EXISTS accounts (
      private_key TEXT,
      address TEXT,
      decimalNumber TEXT,
      has_transactions BOOLEAN
    )
  `, (err) => {
    if (err) {
      console.error('Error creating table:', err.message);
    } else {
      console.log('Table "accounts" created or already exists.');
    }
  });

  // Insert data into the "accounts" table
  const stmt = db.prepare('INSERT INTO accounts (private_key, address, decimalNumber, has_transactions) VALUES (?, ?, ?, ?)');

  stmt.run('private_key_value', 'address_value', 'decimalNumber_value', 1, function(err) {
    if (err) {
      console.error('Error inserting data:', err.message);
    } else {
      console.log(`A row has been inserted with rowid ${this.lastID}`);
    }
  });

  stmt.finalize();

  // Retrieve data from the "accounts" table
  db.each('SELECT * FROM accounts', (err, row) => {
    if (err) {
      console.error('Error retrieving data:', err.message);
    } else {
      console.log(`Private Key: ${row.private_key}`);
      console.log(`Address: ${row.address}`);
      console.log(`Decimal Number: ${row.decimalNumber}`);
      console.log(`Has Transactions: ${row.has_transactions}`);
      console.log('---------------------------');
    }
  });
});

// Close the database connection
db.close((err) => {
  if (err) {
    console.error('Error closing the database connection:', err.message);
  } else {
    console.log('Database connection closed.');
  }
});

When working with databases, especially those storing sensitive information like private keys, adhering to security best practices is essential.

• Basic understanding of Laravel, React, and JavaScript.
• Familiarity with npm or Yarn.
• A Laravel project set up on your local machine.

Laravel provides a built-in ORM (Object-Relational Mapping) called Eloquent, which simplifies database interactions. Let's start by configuring the database and creating the necessary models and migrations.

Run the application:

python app.py