{"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":"9bd88d26-6330-5b79-a056-f06db96dce58","task_key":"default--v0~2e1~2e0~5fhf--9bd88d26-6330-5b79-a056-f06db96dce58","task_revision_id":"1","upstream_id":"","short_description":"BigCodeBench v0.1.0_hf 9bd88d26-6330-5b79-a056-f06db96dce58","config":"default","split":"v0.1.0_hf","body":"{\"code_prompt\":\"import sqlite3\\nimport pandas as pd\\ndef task_func(db_file: str, query: str) -> pd.DataFrame:\\n\",\"complete_prompt\":\"import sqlite3\\nimport pandas as pd\\n\\n\\ndef task_func(db_file: str, query: str) -> pd.DataFrame:\\n    \\\"\\\"\\\"Query an SQLite database and return the results.\\n\\n    This function connects to a given SQLite database, executes a given SQL query,\\n    and returns the results as a pandas DataFrame.\\n\\n    Parameters:\\n    - db_file (str): Path to the SQLite database file.\\n    - query (str): SQL query to execute.\\n\\n    Returns:\\n    - pd.DataFrame: A DataFrame containing the results of the executed query.\\n\\n    Requirements:\\n    - sqlite3\\n    - pandas\\n\\n    Example:\\n    >>> db_file = 'sample_database.db'\\n    >>> df = task_func(db_file, \\\"SELECT * FROM users WHERE name = 'John Doe'\\\")\\n    pd.DataFrame:\\n    id        name  age\\n    --  ----------  ---\\n    ..  John Doe   ..\\n    >>> df = task_func(db_file, \\\"SELECT age, COUNT(*) AS count FROM users GROUP BY age\\\")\\n    pd.DataFrame:\\n    age  count\\n    ---  -----\\n    25   3\\n    \\\"\\\"\\\"\\n\",\"entry_point\":\"task_func\",\"instruct_prompt\":\"Query an SQLite database and return the results. This function connects to a given SQLite database, executes a given SQL query, and returns the results as a pandas DataFrame.\\nThe function should output with:\\n    pd.DataFrame: A DataFrame containing the results of the executed query.\\nYou should write self-contained code starting with:\\n```\\nimport sqlite3\\nimport pandas as pd\\ndef task_func(db_file: str, query: str) -> pd.DataFrame:\\n```\",\"libs\":\"['sqlite3', 'pandas']\"}","display_format":"code","language":"","answer_status":"published","assets":[],"source_url":"https://bigcode-bench.github.io/","history":"initial import","indexing_mode":"index","subproblems":[],"grids":[]}