{"cells":[{"metadata":{"_uuid":"d629ff2d2480ee46fbb7e2d37f6b5fab8052498a","_cell_guid":"79c7e3d0-c299-4dcb-8224-4455121ee9b0","trusted":true},"cell_type":"code","source":"import pandas as pd\nfrom uuid import uuid4","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"!mkdir 'birdcall-check'\n!mkdir 'birdcall-check/test_audio'","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"df_train = pd.read_csv('../input/birdsong-recognition/train.csv')","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"def copy_audio(ebird_code, filename, audio_id):\n    !cp '../input/birdsong-recognition/train_audio/{ebird_code}/{filename}' 'birdcall-check/test_audio/{audio_id}.mp3'\n\ndata_check = []\nfor _, row in df_train[:5].iterrows():\n    site = 'site_1'\n    audio_id = str(uuid4()).replace('-', '')\n    copy_audio(row['ebird_code'], row['filename'], audio_id)\n    for i in range(row['duration']//5):\n        seconds = int((i + 1)*5)\n        row_id = f'{site}_{audio_id}_{seconds}'\n        data_check.append({\n            'site': site,\n            'row_id': row_id,\n            'seconds': seconds,\n            'audio_id': audio_id\n        })\n        \nfor _, row in df_train[5:10].iterrows():\n    site = 'site_2'\n    audio_id = str(uuid4()).replace('-', '')\n    copy_audio(row['ebird_code'], row['filename'], audio_id)\n    for i in range(row['duration']//5):\n        seconds = int((i + 1)*5)\n        row_id = f'{site}_{audio_id}_{seconds}'\n        data_check.append({\n            'site': site,\n            'row_id': row_id,\n            'seconds': seconds,\n            'audio_id': audio_id\n        })\n        \nfor _, row in df_train[10:15].iterrows():\n    site = 'site_3'\n    audio_id = str(uuid4()).replace('-', '')\n    copy_audio(row['ebird_code'], row['filename'], audio_id)\n    seconds = None\n    row_id = f'{site}_{audio_id}'\n    data_check.append({\n        'site': site,\n        'row_id': row_id,\n        'seconds': seconds,\n        'audio_id': audio_id\n    })\n\n\ndata_check = pd.DataFrame(data_check)\ndata_check.to_csv('birdcall-check/test.csv', index=False)\ndata_check.head()","execution_count":null,"outputs":[]}],"metadata":{"kernelspec":{"language":"python","display_name":"Python 3","name":"python3"},"language_info":{"pygments_lexer":"ipython3","nbconvert_exporter":"python","version":"3.6.4","file_extension":".py","codemirror_mode":{"name":"ipython","version":3},"name":"python","mimetype":"text/x-python"}},"nbformat":4,"nbformat_minor":4}