scripting
304
excel-vba-double-click-task-duplicator
Generates VBA code for a worksheet double-click event to duplicate task rows, shift data down, clear specific rows, and prevent edit mode based on user confirmation.
ECNU-ICALK
development
sorting
stars
current ordering strategy
query
all entries
refine the visible subset
scripting
304
extract-positive-numbers-from-strings-using-python-regex
Create a Python script using regular expressions to extract all positive integers and floating-point numbers from a list of strings, ensuring hyphens are treated as separators and handling optional currency symbols.
ECNU-ICALK
development
scripting
304
automated-screenshot-translation-script
Create a Python script to automate the workflow of capturing a screenshot using the Snipping Tool, uploading it to the Google Translate website (image mode) without using an API, extracting the translated text, saving it to a text file, and cleaning up temporary files.
ECNU-ICALK
development
scripting
304
csv-header-and-prefix-cleaning-script
Generates a Python script to clean CSV files by conditionally removing the header row and stripping the first two characters from the first column based on whether they are letters or numbers.
ECNU-ICALK
development
scripting
304
dynamic-c-compilation-script-generator
Generates shell scripts (Batch, PowerShell, or Bash) that accept source and output filenames as arguments to compile C programs using GCC dynamically.
ECNU-ICALK
development
scripting
304
generate-c-random-integer-csv
Generates a C# script to create two columns of random integers with specific ranges (1-20 and 1-100) and outputs the results in CSV format.
ECNU-ICALK
development
scripting
304
generate-vmware-powercli-mass-migration-script
Generates a PowerShell script for mass VMotion and Storage VMotion using an input file to map servers to specific destination hosts and datastores.
ECNU-ICALK
development
scripting
304
python-cli-arithmetic-operations-script
Generates a Python 3 script that processes three command-line arguments (int, int, float) through a specific sequence of arithmetic and bitwise operations, outputting results in a strict 3-line format.
ECNU-ICALK
development
scripting
304
python-cli-beer-song-script-generator
Create a Python script for the 'N bottles of beverage' song with specific CLI arguments, pluralization logic, and standard-library-only number-to-word conversion.
ECNU-ICALK
development
scripting
304
python-cli-script-generator-with-strict-constraints
Generate or simplify Python command-line scripts using sys.argv and if __name__ == '__main__'. Ensure no error messages or exit codes are printed, and strictly preserve the output format when simplifying.
ECNU-ICALK
development
scripting
304
python-code-generation-for-restricted-open-environment
Generate Python code for CSV file operations in environments where the open() function does not support keyword arguments. Output only the code block without explanations.
ECNU-ICALK
development
scripting
304
python-csv-batch-processing-and-date-transformation
Generates Python code using pandas to batch process CSV files, including deleting columns, converting date formats to Year.Month, enforcing UTF-8 encoding, and adding process completion markers.
ECNU-ICALK
development
scripting
304
python-excel-consolidation-with-multi-row-headers-and-splitting
Develop a Python script using pandas to load multiple Excel files from a directory, flatten multi-row headers, remove specific columns, merge the data, and split the output into smaller files to handle size constraints.
ECNU-ICALK
development
scripting
304
python-factorial-string-generator
Creates a Python program with a `factorial` function that calculates the factorial of an integer and returns a string showing the calculation steps (e.g., '4x3x2x1 = 24'). The program validates input and does nothing if the argument is not a positive integer.
ECNU-ICALK
development
scripting
304
python-logfile-context-manager-with-specific-format
Generates a Python class `LogFile` inheriting from `ContextDecorator` to log execution start time, duration, and errors to a file using a strict pipe-delimited format.
ECNU-ICALK
development
scripting
304
python-script-to-split-csv-first-column-using-pandas
Generates a Python script using pandas to iterate through CSV files in a directory, split the first column into multiple columns based on a comma delimiter, and save the result.
ECNU-ICALK
development
scripting
304
qliksense-join-filter-date-calc
Generates Qlik Sense scripts to join tables with status filters, handle specific date formats, and perform logic such as max record selection or time difference calculation in hours.
ECNU-ICALK
development
scripting
304
resumable-csv-cell-iterator-with-auto-interruption
Generates a Python 3 script to iterate through a CSV file cell-by-cell, tracking progress via a text file to resume after interruption. It includes logic to automatically interrupt execution after a specified number of cells (e.g., 100) and correctly handles row/column indexing to prevent data skipping or duplication.
ECNU-ICALK
development
scripting
304
serialize-numpy-complex-matrix-to-hex-file
Generates Python scripts to write numpy complex matrices to text files using float16 hex format, concatenating real/imaginary parts without separators, and traversing 4x4 blocks in a specific 2x2 sub-block order.
ECNU-ICALK
development
scripting
304
text-based-excel-spreadsheet-simulator
Simulates an Excel spreadsheet using text-based tables, executing formulas and formatting cells without providing explanations.
ECNU-ICALK
development
scripting
304
windows-wifi-onboarding-script-generator
Generates a Windows Batch (.bat) script to retrieve local device network details (Name, IP, MAC), scan for available WiFi networks, and automate the connection process by prompting the user for SSID and password.
ECNU-ICALK
development
scripting
304
bat-python
Генерирует bat-скрипт для Windows, который динамически устанавливает последнюю версию Python (пропуская, если она уже есть), устанавливает пакеты из packages.txt, добавляет Python в PATH и запускает main.py в тихом режиме.
ECNU-ICALK
development
scripting
304
lfsr-encryption-and-decryption-script
Generates a Python script to encrypt and decrypt messages using a Linear Feedback Shift Register (LFSR) with user-defined parameters, including a state table and error handling for sequence length.
ECNU-ICALK
development
scripting
304
postgresql-c-dao-update-last-row-by-date
Generates SQL update scripts using Common Table Expressions (CTE) and corresponding C# DAO code using IDbConnection to update the runId of the most recent record for a specific user, including logic for filtering by Unix timestamp dates.
ECNU-ICALK
development