{"metadata":{"kernelspec":{"name":"ir","display_name":"R","language":"R"},"language_info":{"name":"R","codemirror_mode":"r","pygments_lexer":"r","mimetype":"text/x-r-source","file_extension":".r","version":"4.0.5"},"kaggle":{"accelerator":"none","dataSources":[{"sourceId":59575,"databundleVersionId":8060720,"sourceType":"competition"}],"dockerImageVersionId":30618,"isInternetEnabled":true,"language":"r","sourceType":"notebook","isGpuEnabled":false}},"nbformat_minor":4,"nbformat":4,"cells":[{"cell_type":"markdown","source":"# US PTO - EDA","metadata":{}},{"cell_type":"markdown","source":"## Libraries","metadata":{}},{"cell_type":"code","source":"library(tidyverse) # metapackage of all tidyverse packages\nlibrary(janitor)\nlibrary(arrow)\nlibrary(tictoc)","metadata":{"_uuid":"051d70d956493feee0c6d64651c6a088724dca2a","_execution_state":"idle","execution":{"iopub.status.busy":"2024-06-12T16:12:25.66245Z","iopub.execute_input":"2024-06-12T16:12:25.667092Z","iopub.status.idle":"2024-06-12T16:12:29.65095Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"## Datasets","metadata":{}},{"cell_type":"markdown","source":"### nearest_neighbors","metadata":{}},{"cell_type":"code","source":"nearest_neighbors <- read_csv_arrow(\"../input/uspto-explainable-ai/nearest_neighbors.csv\",\n                                    as_data_frame = FALSE) %>%\n  clean_names()","metadata":{"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"nearest_neighbors %>%\n    glimpse()","metadata":{"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"### patent_metadata","metadata":{}},{"cell_type":"code","source":"tic()\n\npatent_metadata <- arrow::read_parquet(\"../input/uspto-explainable-ai/patent_metadata.parquet\") %>%\n    clean_names()\n\ntoc()","metadata":{"execution":{"iopub.status.busy":"2024-06-12T16:17:42.059951Z","iopub.execute_input":"2024-06-12T16:17:42.061991Z","iopub.status.idle":"2024-06-12T16:21:31.351944Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"patent_metadata %>%\n    glimpse()","metadata":{"execution":{"iopub.status.busy":"2024-06-12T16:21:31.358513Z","iopub.execute_input":"2024-06-12T16:21:31.361078Z","iopub.status.idle":"2024-06-12T16:22:13.951895Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"# tic()\n# patent_metadata %>%\n#     select(cpc_codes) %>%\n#     table() %>%\n#     collect()\n# toc()","metadata":{"execution":{"iopub.status.busy":"2024-06-12T16:24:34.430279Z","iopub.execute_input":"2024-06-12T16:24:34.433309Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"### test","metadata":{}},{"cell_type":"code","source":"tic()\n\ntest <- read_csv(\"/kaggle/input/uspto-explainable-ai/test.csv\") %>%\n    clean_names()\n\ntoc()","metadata":{"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"test %>%\n    glimpse()","metadata":{"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"### patent_data","metadata":{}},{"cell_type":"code","source":"patent_data <- open_dataset(\"/kaggle/input/uspto-explainable-ai/patent_data\")","metadata":{"execution":{"iopub.status.busy":"2024-06-12T16:12:39.109651Z","iopub.execute_input":"2024-06-12T16:12:39.148573Z","iopub.status.idle":"2024-06-12T16:12:42.21383Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"patent_data %>%\n    glimpse()","metadata":{"execution":{"iopub.status.busy":"2024-06-12T16:12:48.309559Z","iopub.execute_input":"2024-06-12T16:12:48.311848Z","iopub.status.idle":"2024-06-12T16:13:00.745995Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"#### Cooperative Patent Classification\n[Wikipedia: Cooperative Patent Classification](https://en.wikipedia.org/wiki/Cooperative_Patent_Classification)\n\n    A: Human Necessities\n    B: Operations and Transport\n    C: Chemistry and Metallurgy\n    D: Textiles\n    E: Fixed Constructions\n    F: Mechanical Engineering\n    G: Physics\n    H: Electricity\n    Y: Emerging Cross-Sectional Technologies","metadata":{}},{"cell_type":"code","source":"patent_data %>% \n    # select(title) %>%\n    head() %>%\n    collect()","metadata":{"execution":{"iopub.status.busy":"2024-06-12T16:16:41.522119Z","iopub.execute_input":"2024-06-12T16:16:41.52417Z","iopub.status.idle":"2024-06-12T16:16:41.6707Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"patent_data %>% \n    select(title) %>%\n    head() %>%\n    collect()","metadata":{"execution":{"iopub.status.busy":"2024-06-12T16:16:18.334429Z","iopub.execute_input":"2024-06-12T16:16:18.336508Z","iopub.status.idle":"2024-06-12T16:16:18.449213Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"patent_data %>% \n    select(description) %>%\n    head() %>%\n    collect()","metadata":{"execution":{"iopub.status.busy":"2024-06-12T16:15:23.807454Z","iopub.execute_input":"2024-06-12T16:15:23.809611Z","iopub.status.idle":"2024-06-12T16:15:24.003427Z"},"trusted":true},"execution_count":null,"outputs":[]}]}