hedlynogan/jobhuntlog

Python script that uses pandas to create exel spread sheet.

Python Utility for EDD Job Hunt Logging

This utility script is designed to streamline the job hunt logging process for EDD (Employment Development Department) reporting. It automatically generates an Excel spreadsheet tailored to the user's job search activities, ensuring all necessary details are meticulously recorded and formatted.

Features

• User-Specific Logging: The script prompts for the user's name, incorporating it into the spreadsheet for personalized tracking.
• Excel Spreadsheet Output: Generates a well-organized Excel spreadsheet, ideal for EDD reporting and personal record-keeping.

Getting Started

These instructions will guide you on how to set up and run the script on your local machine for development and personal use.

Prerequisites

Ensure you have the following installed:

• Python 3.x
• Pip3 (Python package installer)

Installation

Use pip3 to install the required third-party libraries:

• pip3 install pandas
• pip3 install openpyxl
• pip3 install xlsxwriter

Built With

• Pandas - Data manipulation and analysis
• OpenPyXL - Excel file reading/writing
• XlsxWriter - Advanced Excel file creation

Development Environment

• IDE: PyCharm Pro release 2023.3.2
• Platform: Developed on Apple Silicon macOS Ventura
• AI Support: Script created in PyCharm with help from the new JetBrains AI Assistant.