{"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":"f8493936-3a29-58a8-aa44-5c825b52a763","task_key":"default--v0~2e1~2e0~5fhf--f8493936-3a29-58a8-aa44-5c825b52a763","task_revision_id":"1","upstream_id":"","short_description":"BigCodeBench v0.1.0_hf f8493936-3a29-58a8-aa44-5c825b52a763","config":"default","split":"v0.1.0_hf","body":"{\"code_prompt\":\"import os\\nimport pandas as pd\\nfrom datetime import datetime\\ndef task_func(excel_directory: str, file_name: str, column_name: str, start_date: str, end_date: str) -> pd.DataFrame:\\n\",\"complete_prompt\":\"import os\\nimport pandas as pd\\nfrom datetime import datetime\\n\\ndef task_func(excel_directory: str, file_name: str, column_name: str, start_date: str, end_date: str) -> pd.DataFrame:\\n    \\\"\\\"\\\"\\n    Filters data in a specific date range from a column in an Excel file and returns a Pandas DataFrame of the filtered data.\\n\\n    Parameters:\\n    excel_directory (str): The directory of the Excel file.\\n    file_name (str): The name of the Excel file.\\n    column_name (str): The name of the date column to filter.\\n    start_date (str): The start date in 'yyyy-mm-dd' format.\\n    end_date (str): The end date in 'yyyy-mm-dd' format.\\n\\n    Returns:\\n    pd.DataFrame: A pandas DataFrame with the filtered data.\\n\\n    Raises:\\n    FileNotFoundError: If the specified Excel file does not exist.\\n    ValueError: If start_date or end_date are in an incorrect format, or if column_name does not exist in the DataFrame.\\n\\n    Example:\\n    >>> data_dir, file_name = './excel_files/', 'excel_file1.xls'\\n    >>> test_file = create_dummy_file(data_dir, file_name)\\n    >>> filtered_df = task_func(data_dir, file_name, 'Date', '2020-01-01', '2020-12-31')\\n    >>> os.remove(test_file)\\n    >>> os.rmdir(data_dir)\\n    >>> print(filtered_df.head())\\n       Unnamed: 0       Date     Value\\n    0           0 2020-01-01  0.823110\\n    1           1 2020-01-02  0.026118\\n    2           2 2020-01-03  0.210771\\n    3           3 2020-01-04  0.618422\\n    4           4 2020-01-05  0.098284\\n    \\n    Requirements:\\n    - os\\n    - pandas\\n    - datetime\\n    \\\"\\\"\\\"\\n\",\"entry_point\":\"task_func\",\"instruct_prompt\":\"Filters data in a specific date range from a column in an Excel file and returns a Pandas DataFrame of the filtered data.\\nThe function should raise the exception for: FileNotFoundError: If the specified Excel file does not exist. ValueError: If start_date or end_date are in an incorrect format, or if column_name does not exist in the DataFrame.\\nThe function should output with:\\n    pd.DataFrame: A pandas DataFrame with the filtered data.\\nYou should write self-contained code starting with:\\n```\\nimport os\\nimport pandas as pd\\nfrom datetime import datetime\\ndef task_func(excel_directory: str, file_name: str, column_name: str, start_date: str, end_date: str) -> pd.DataFrame:\\n```\",\"libs\":\"['pandas', 'datetime', 'os']\"}","display_format":"code","language":"","answer_status":"published","assets":[],"source_url":"https://bigcode-bench.github.io/","history":"initial import","indexing_mode":"index","subproblems":[],"grids":[]}