{"metadata":{"kernelspec":{"language":"python","display_name":"Python 3","name":"python3"},"language_info":{"name":"python","version":"3.10.13","mimetype":"text/x-python","codemirror_mode":{"name":"ipython","version":3},"pygments_lexer":"ipython3","nbconvert_exporter":"python","file_extension":".py"},"kaggle":{"accelerator":"none","dataSources":[{"sourceId":59575,"databundleVersionId":8060720,"sourceType":"competition"}],"dockerImageVersionId":30732,"isInternetEnabled":true,"language":"python","sourceType":"notebook","isGpuEnabled":false}},"nbformat_minor":4,"nbformat":4,"cells":[{"cell_type":"code","source":"one_publication_number = 'US-6439223-B1' # found in nearest_neighbors.csv","metadata":{"execution":{"iopub.status.busy":"2024-07-07T03:42:09.975902Z","iopub.execute_input":"2024-07-07T03:42:09.976574Z","iopub.status.idle":"2024-07-07T03:42:09.982511Z","shell.execute_reply.started":"2024-07-07T03:42:09.976530Z","shell.execute_reply":"2024-07-07T03:42:09.981200Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"import pandas as pd\n\nfile_path = '/kaggle/input/uspto-explainable-ai/nearest_neighbors.csv'\nsearch_value = 'US-6439223-B1'\n\nchunk_size = 10000\n\nfound = False\nfor chunk in pd.read_csv(file_path, chunksize=chunk_size):\n    if search_value in chunk['publication_number'].values:\n        found = True\n        break\n\nif found:\n    print(f\"Value '{search_value}' found in 'publication_number'.\")\nelse:\n    print(f\"Value '{search_value}' not found in 'publication_number'.\")\n","metadata":{"execution":{"iopub.status.busy":"2024-07-07T03:47:09.959458Z","iopub.execute_input":"2024-07-07T03:47:09.961735Z","iopub.status.idle":"2024-07-07T03:53:35.019312Z","shell.execute_reply.started":"2024-07-07T03:47:09.961682Z","shell.execute_reply":"2024-07-07T03:53:35.017892Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"patent_metadata = pd.read_parquet(\"/kaggle/input/uspto-explainable-ai/patent_metadata.parquet\")\npatent_metadata.set_index('publication_number', inplace=True)","metadata":{"execution":{"iopub.status.busy":"2024-07-07T03:53:35.021859Z","iopub.execute_input":"2024-07-07T03:53:35.022364Z","iopub.status.idle":"2024-07-07T03:54:06.627835Z","shell.execute_reply.started":"2024-07-07T03:53:35.022319Z","shell.execute_reply":"2024-07-07T03:54:06.626234Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"search_value_metadata = patent_metadata.loc[search_value]\nprint(search_value_metadata)\nsearch_value_pub_date = search_value_metadata.publication_date\nsearch_value_year, search_value_month = search_value_pub_date.year, search_value_pub_date.month ","metadata":{"execution":{"iopub.status.busy":"2024-07-07T03:54:52.780016Z","iopub.execute_input":"2024-07-07T03:54:52.780465Z","iopub.status.idle":"2024-07-07T03:54:52.788855Z","shell.execute_reply.started":"2024-07-07T03:54:52.780433Z","shell.execute_reply":"2024-07-07T03:54:52.787567Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"# Try to find info by publication_date\npath = f'/kaggle/input/uspto-explainable-ai/patent_data/{search_value_year}_{search_value_month}.parquet'\nparquet_pub_date = pd.read_parquet(path)\nparquet_pub_date.set_index('publication_number', inplace=True)","metadata":{"execution":{"iopub.status.busy":"2024-07-07T03:56:47.710431Z","iopub.execute_input":"2024-07-07T03:56:47.711015Z","iopub.status.idle":"2024-07-07T03:57:02.569173Z","shell.execute_reply.started":"2024-07-07T03:56:47.710973Z","shell.execute_reply":"2024-07-07T03:57:02.567702Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"parquet_pub_date.index","metadata":{"execution":{"iopub.status.busy":"2024-07-07T03:58:09.263775Z","iopub.execute_input":"2024-07-07T03:58:09.264513Z","iopub.status.idle":"2024-07-07T03:58:09.273430Z","shell.execute_reply.started":"2024-07-07T03:58:09.264451Z","shell.execute_reply":"2024-07-07T03:58:09.271871Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"if search_value in parquet_pub_date.index:\n    print(f'{search_value} found in parquet')","metadata":{"execution":{"iopub.status.busy":"2024-07-07T03:59:05.137972Z","iopub.execute_input":"2024-07-07T03:59:05.139553Z","iopub.status.idle":"2024-07-07T03:59:05.146739Z","shell.execute_reply.started":"2024-07-07T03:59:05.139488Z","shell.execute_reply":"2024-07-07T03:59:05.145138Z"},"trusted":true},"execution_count":null,"outputs":[]}]}