{"cells":[{"metadata":{},"cell_type":"markdown","source":"### Might be helpful to some people."},{"metadata":{},"cell_type":"markdown","source":"<font size=4 color='red'> If you find this kernel useful, please don't forget to upvote. Thank you. </font>"},{"metadata":{"trusted":true},"cell_type":"code","source":"import pandas as pd\n\nlong_answers = pd.DataFrame(columns = ['example_id' , 'PredictionString'])\nshort_answers = pd.DataFrame(columns = ['example_id' , 'PredictionString'])","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"import json\n\nwith open('/kaggle/input/tensorflow2-question-answering/simplified-nq-test.jsonl', 'rt') as f:\n    for i, l in enumerate(f):\n        example = json.loads(l)\n        \n        example_id = example['example_id']\n        \n        long_answers.loc[i] = [example_id, '']\n        short_answers.loc[i] = [example_id, '']","execution_count":null,"outputs":[]},{"metadata":{"_uuid":"d629ff2d2480ee46fbb7e2d37f6b5fab8052498a","_cell_guid":"79c7e3d0-c299-4dcb-8224-4455121ee9b0","trusted":true},"cell_type":"code","source":"long_answers['example_id'] = long_answers['example_id'].apply(lambda example_id: str(example_id) + '_long')\nshort_answers['example_id'] = short_answers['example_id'].apply(lambda example_id: str(example_id) + '_short')\n\nsubmission = pd.concat([long_answers, short_answers], axis=0)\n\nsubmission.sort_values(by='example_id').to_csv('submission.csv', index=False)","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":1}