{"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":"a9f33074-7bb9-5fe5-a765-489a372fd106","task_key":"default--v0~2e1~2e0~5fhf--a9f33074-7bb9-5fe5-a765-489a372fd106","task_revision_id":"1","upstream_id":"","short_description":"BigCodeBench v0.1.0_hf a9f33074-7bb9-5fe5-a765-489a372fd106","config":"default","split":"v0.1.0_hf","body":"{\"code_prompt\":\"import warnings\\nimport sqlite3\\nimport pandas as pd\\ndef task_func(db_path, query, warn_large_dataset=True):\\n\",\"complete_prompt\":\"import warnings\\nimport sqlite3\\nimport pandas as pd\\n\\n\\ndef task_func(db_path, query, warn_large_dataset=True):\\n    \\\"\\\"\\\"\\n    Fetches data from an SQLite database using the provided database path and SQL query.\\n    This function will issue a warning of \\\"The data contains more than 10000 rows.\\\" when this condition is met.\\n\\n    Parameters:\\n    - db_path (str): The file path to the SQLite database from which data needs to be fetched.\\n    - query (str): The SQL query string used to retrieve data from the specified database.\\n    - warn_large_dataset (bool, optional): A boolean flag that, when set to True, triggers a \\n      warning if the retrieved dataset has more than 10,000 rows. Default is True.\\n\\n    Returns:\\n    - pandas.DataFrame: A DataFrame containing the data fetched from the database.\\n\\n    Requirements:\\n    - sqlite3\\n    - pandas\\n    - warnings\\n\\n    Raises:\\n    - Exception: If any error occurs during database connection, SQL query execution, or data \\n      fetching. The error message provides details about the issue, starting with \\\"Error fetching data from the database: \\\".\\n\\n    Example:\\n    >>> data = task_func('/path/to/sqlite.db', 'SELECT * FROM table_name')\\n    >>> print(data)\\n        column1  column2\\n    0         1        4\\n    1         2        5\\n    2         3        6\\n    \\\"\\\"\\\"\\n\",\"entry_point\":\"task_func\",\"instruct_prompt\":\"Fetches data from an SQLite database using the provided database path and SQL query. This function will issue a warning of \\\"The data contains more than 10000 rows.\\\" when this condition is met.\\nThe function should raise the exception for: Exception: If any error occurs during database connection, SQL query execution, or data fetching. The error message provides details about the issue, starting with \\\"Error fetching data from the database: \\\".\\nThe function should output with:\\n    pandas.DataFrame: A DataFrame containing the data fetched from the database.\\nYou should write self-contained code starting with:\\n```\\nimport warnings\\nimport sqlite3\\nimport pandas as pd\\ndef task_func(db_path, query, warn_large_dataset=True):\\n```\",\"libs\":\"['sqlite3', 'pandas', 'warnings']\"}","display_format":"code","language":"","answer_status":"published","assets":[],"source_url":"https://bigcode-bench.github.io/","history":"initial import","indexing_mode":"index","subproblems":[],"grids":[]}