{"kind":"task","effective_mode":"full","benchmark":{"kind":"benchmark","effective_mode":"full","slug":"bigcodebench","formal_name":"BigCodeBench","introduction":"BigCodeBench poses 1,140 function-level tasks drawn across 139 libraries. It tests whether a model can compose several real APIs correctly rather than write one self-contained function.","introduction_ja":"","introduction_en":"","category":"Category not supplied","task_count":null,"acquisition_status":"Acquisition status not supplied","official_url":"https://bigcode-bench.github.io/","indexing_mode":"index","profile":{"resources":[],"task_format":"","scoring":"","metric":"","size":"","answer_access":"","license":"","citation":"","maintainer":"","released":"","why_hard":"","related":[],"history":"","construction":"","limitations":"","saturation":"","scores":[]}},"task_id":"f7c21bae-500e-5b59-a4ee-5a9853c45a78","task_key":"default--v0~2e1~2e0~5fhf--f7c21bae-500e-5b59-a4ee-5a9853c45a78","task_revision_id":"1","upstream_id":"","short_description":"BigCodeBench v0.1.0_hf f7c21bae-500e-5b59-a4ee-5a9853c45a78","config":"default","split":"v0.1.0_hf","body":"{\"code_prompt\":\"import sqlite3\\nimport pandas as pd\\nimport os\\ndef task_func(db_file, table_name, column_name, pattern='\\\\d+[xX]'):\\n\",\"complete_prompt\":\"import sqlite3\\nimport pandas as pd\\nimport os\\n\\n\\ndef task_func(db_file, table_name, column_name, pattern='\\\\d+[xX]'):\\n    \\\"\\\"\\\"\\n    Find all matches with a regex pattern in a list of strings in an SQL database.\\n    \\n    The function loads an sql database and selects all entries from the specified\\n    table. Matches are returned in a DataFrame.\\n\\n    Parameters:\\n    db_file (str): The SQLite database file.\\n    table_name (str): The name of the table to search.\\n    column_name (str): The name of the column to search.\\n    pattern (str, optional): The regex pattern to search for. Defaults to '\\\\d+[xX]'.\\n\\n    Returns:\\n    DataFrame: A pandas DataFrame with the matches.\\n        \\n    Raises:\\n    ValueError: If db_file does not exist.\\n\\n    Requirements:\\n    - sqlite3\\n    - pandas\\n    - os\\n        \\n    Example:\\n    >>> result = task_func('task_func_data/sample.db', 'test_table', 'test_column')\\n    >>> print(result.head(10))\\n        id              test_column\\n    0    1                  4x4 car\\n    1    2           New 3x3 puzzle\\n    3    4  Product with 5X feature\\n    55  56                   1xsafe\\n    56  57                 3xmother\\n    57  58                  5xenjoy\\n    58  59                   2xhome\\n    59  60                 3xanswer\\n    60  61                   5xgirl\\n    61  62                   5xkind\\n    \\\"\\\"\\\"\\n\",\"entry_point\":\"task_func\",\"instruct_prompt\":\"Find all matches with a regex pattern in a list of strings in an SQL database. The function loads an sql database and selects all entries from the specified table. Matches are returned in a DataFrame.\\nThe function should raise the exception for: ValueError: If db_file does not exist.\\nThe function should output with:\\n    DataFrame: A pandas DataFrame with the matches.\\nYou should write self-contained code starting with:\\n```\\nimport sqlite3\\nimport pandas as pd\\nimport os\\ndef task_func(db_file, table_name, column_name, pattern='\\\\d+[xX]'):\\n```\",\"libs\":\"['sqlite3', 'pandas', 'os']\"}","display_format":"code","language":"","answer_status":"published","assets":[],"source_url":"https://bigcode-bench.github.io/","history":"initial import","indexing_mode":"index","subproblems":[],"grids":[]}