-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathApi_python_intro
1 lines (1 loc) · 31.1 KB
/
Api_python_intro
1
{"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":[],"dockerImageVersionId":30732,"isInternetEnabled":true,"language":"python","sourceType":"notebook","isGpuEnabled":false}},"nbformat_minor":4,"nbformat":4,"cells":[{"cell_type":"code","source":"# This Python 3 environment comes with many helpful analytics libraries installed\n# It is defined by the kaggle/python Docker image: https://github.com/kaggle/docker-python\n# For example, here's several helpful packages to load\n\nimport numpy as np # linear algebra\nimport pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)\n\n# Input data files are available in the read-only \"../input/\" directory\n# For example, running this (by clicking run or pressing Shift+Enter) will list all files under the input directory\n\nimport os\nfor dirname, _, filenames in os.walk('/kaggle/input'):\n for filename in filenames:\n print(os.path.join(dirname, filename))\n\n# You can write up to 20GB to the current directory (/kaggle/working/) that gets preserved as output when you create a version using \"Save & Run All\" \n# You can also write temporary files to /kaggle/temp/, but they won't be saved outside of the current session","metadata":{"_uuid":"8f2839f25d086af736a60e9eeb907d3b93b6e0e5","_cell_guid":"b1076dfc-b9ad-4769-8c92-a6c4dae69d19","execution":{"iopub.status.busy":"2024-06-18T09:17:23.325181Z","iopub.execute_input":"2024-06-18T09:17:23.326143Z","iopub.status.idle":"2024-06-18T09:17:24.686619Z","shell.execute_reply.started":"2024-06-18T09:17:23.326105Z","shell.execute_reply":"2024-06-18T09:17:24.685395Z"},"trusted":true},"execution_count":1,"outputs":[]},{"cell_type":"code","source":"# Making request in python\nimport requests\n","metadata":{"execution":{"iopub.status.busy":"2024-06-18T09:21:25.501462Z","iopub.execute_input":"2024-06-18T09:21:25.501901Z","iopub.status.idle":"2024-06-18T09:21:25.599612Z","shell.execute_reply.started":"2024-06-18T09:21:25.501838Z","shell.execute_reply":"2024-06-18T09:21:25.598521Z"},"trusted":true},"execution_count":2,"outputs":[]},{"cell_type":"code","source":"# base url\nbase_url = 'https://rickandmortyapi.com/api/'\n\nendpoint = 'character'\nr = requests.get(base_url + endpoint)\nprint(r)\n# 200 -Everything is fine\n# 500 -Acess denied\n# 400 or else no good\ndata = r.json()\ndata['info']","metadata":{"execution":{"iopub.status.busy":"2024-06-18T09:27:08.366949Z","iopub.execute_input":"2024-06-18T09:27:08.367351Z","iopub.status.idle":"2024-06-18T09:27:08.430401Z","shell.execute_reply.started":"2024-06-18T09:27:08.367321Z","shell.execute_reply":"2024-06-18T09:27:08.429296Z"},"trusted":true},"execution_count":5,"outputs":[{"name":"stdout","text":"<Response [200]>\n","output_type":"stream"},{"execution_count":5,"output_type":"execute_result","data":{"text/plain":"{'count': 826,\n 'pages': 42,\n 'next': 'https://rickandmortyapi.com/api/character?page=2',\n 'prev': None}"},"metadata":{}}]},{"cell_type":"code","source":"data['results'][0]['name']","metadata":{"execution":{"iopub.status.busy":"2024-06-18T09:30:53.174136Z","iopub.execute_input":"2024-06-18T09:30:53.174564Z","iopub.status.idle":"2024-06-18T09:30:53.182888Z","shell.execute_reply.started":"2024-06-18T09:30:53.174531Z","shell.execute_reply":"2024-06-18T09:30:53.181797Z"},"trusted":true},"execution_count":8,"outputs":[{"execution_count":8,"output_type":"execute_result","data":{"text/plain":"'Rick Sanchez'"},"metadata":{}}]},{"cell_type":"code","source":"episodes= data['results'][0]['episode']\nlen(episodes)","metadata":{"execution":{"iopub.status.busy":"2024-06-18T09:33:02.717395Z","iopub.execute_input":"2024-06-18T09:33:02.717797Z","iopub.status.idle":"2024-06-18T09:33:02.726454Z","shell.execute_reply.started":"2024-06-18T09:33:02.717768Z","shell.execute_reply":"2024-06-18T09:33:02.725254Z"},"trusted":true},"execution_count":11,"outputs":[{"execution_count":11,"output_type":"execute_result","data":{"text/plain":"51"},"metadata":{}}]},{"cell_type":"code","source":"# Declaring the fuctions\ndef main_request(base_url,endpoint,x):\n r = requests.get(base_url+endpoint+f'?page = {x}')\n return r.json()","metadata":{"execution":{"iopub.status.busy":"2024-06-18T10:05:53.976457Z","iopub.execute_input":"2024-06-18T10:05:53.976893Z","iopub.status.idle":"2024-06-18T10:05:53.982840Z","shell.execute_reply.started":"2024-06-18T10:05:53.976860Z","shell.execute_reply":"2024-06-18T10:05:53.981704Z"},"trusted":true},"execution_count":48,"outputs":[]},{"cell_type":"code","source":"def get_pages(response):\n pages = response['info']['pages']\n return pages","metadata":{"execution":{"iopub.status.busy":"2024-06-18T09:44:27.063021Z","iopub.execute_input":"2024-06-18T09:44:27.063545Z","iopub.status.idle":"2024-06-18T09:44:27.070200Z","shell.execute_reply.started":"2024-06-18T09:44:27.063508Z","shell.execute_reply":"2024-06-18T09:44:27.068674Z"},"trusted":true},"execution_count":22,"outputs":[]},{"cell_type":"code","source":"# Calling our main function\ndata = main_request(base_url,endpoint,1)\nmainList = []\nfor x in range(1,get_pages(data)+1):\n print(x)\n mainList.append((parse_json(main_request(base_url,endpoint,x))))\ndf = pd.DataFrame(mainList)\ndf","metadata":{"execution":{"iopub.status.busy":"2024-06-18T10:22:48.721335Z","iopub.execute_input":"2024-06-18T10:22:48.721810Z","iopub.status.idle":"2024-06-18T10:22:50.964650Z","shell.execute_reply.started":"2024-06-18T10:22:48.721772Z","shell.execute_reply":"2024-06-18T10:22:50.963297Z"},"trusted":true},"execution_count":70,"outputs":[{"name":"stdout","text":"1\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n2\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n3\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n4\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n5\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n6\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n7\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n8\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n9\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n10\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n11\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n12\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n13\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n14\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n15\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n16\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n17\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n18\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n19\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n20\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n21\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n22\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n23\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n24\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n25\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n26\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n27\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n28\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n29\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n30\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n31\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n32\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n33\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n34\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n35\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n36\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n37\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n38\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n39\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n40\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n41\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n42\nRick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n","output_type":"stream"},{"execution_count":70,"output_type":"execute_result","data":{"text/plain":" 0\n0 None\n1 None\n2 None\n3 None\n4 None\n5 None\n6 None\n7 None\n8 None\n9 None\n10 None\n11 None\n12 None\n13 None\n14 None\n15 None\n16 None\n17 None\n18 None\n19 None\n20 None\n21 None\n22 None\n23 None\n24 None\n25 None\n26 None\n27 None\n28 None\n29 None\n30 None\n31 None\n32 None\n33 None\n34 None\n35 None\n36 None\n37 None\n38 None\n39 None\n40 None\n41 None","text/html":"<div>\n<style scoped>\n .dataframe tbody tr th:only-of-type {\n vertical-align: middle;\n }\n\n .dataframe tbody tr th {\n vertical-align: top;\n }\n\n .dataframe thead th {\n text-align: right;\n }\n</style>\n<table border=\"1\" class=\"dataframe\">\n <thead>\n <tr style=\"text-align: right;\">\n <th></th>\n <th>0</th>\n </tr>\n </thead>\n <tbody>\n <tr>\n <th>0</th>\n <td>None</td>\n </tr>\n <tr>\n <th>1</th>\n <td>None</td>\n </tr>\n <tr>\n <th>2</th>\n <td>None</td>\n </tr>\n <tr>\n <th>3</th>\n <td>None</td>\n </tr>\n <tr>\n <th>4</th>\n <td>None</td>\n </tr>\n <tr>\n <th>5</th>\n <td>None</td>\n </tr>\n <tr>\n <th>6</th>\n <td>None</td>\n </tr>\n <tr>\n <th>7</th>\n <td>None</td>\n </tr>\n <tr>\n <th>8</th>\n <td>None</td>\n </tr>\n <tr>\n <th>9</th>\n <td>None</td>\n </tr>\n <tr>\n <th>10</th>\n <td>None</td>\n </tr>\n <tr>\n <th>11</th>\n <td>None</td>\n </tr>\n <tr>\n <th>12</th>\n <td>None</td>\n </tr>\n <tr>\n <th>13</th>\n <td>None</td>\n </tr>\n <tr>\n <th>14</th>\n <td>None</td>\n </tr>\n <tr>\n <th>15</th>\n <td>None</td>\n </tr>\n <tr>\n <th>16</th>\n <td>None</td>\n </tr>\n <tr>\n <th>17</th>\n <td>None</td>\n </tr>\n <tr>\n <th>18</th>\n <td>None</td>\n </tr>\n <tr>\n <th>19</th>\n <td>None</td>\n </tr>\n <tr>\n <th>20</th>\n <td>None</td>\n </tr>\n <tr>\n <th>21</th>\n <td>None</td>\n </tr>\n <tr>\n <th>22</th>\n <td>None</td>\n </tr>\n <tr>\n <th>23</th>\n <td>None</td>\n </tr>\n <tr>\n <th>24</th>\n <td>None</td>\n </tr>\n <tr>\n <th>25</th>\n <td>None</td>\n </tr>\n <tr>\n <th>26</th>\n <td>None</td>\n </tr>\n <tr>\n <th>27</th>\n <td>None</td>\n </tr>\n <tr>\n <th>28</th>\n <td>None</td>\n </tr>\n <tr>\n <th>29</th>\n <td>None</td>\n </tr>\n <tr>\n <th>30</th>\n <td>None</td>\n </tr>\n <tr>\n <th>31</th>\n <td>None</td>\n </tr>\n <tr>\n <th>32</th>\n <td>None</td>\n </tr>\n <tr>\n <th>33</th>\n <td>None</td>\n </tr>\n <tr>\n <th>34</th>\n <td>None</td>\n </tr>\n <tr>\n <th>35</th>\n <td>None</td>\n </tr>\n <tr>\n <th>36</th>\n <td>None</td>\n </tr>\n <tr>\n <th>37</th>\n <td>None</td>\n </tr>\n <tr>\n <th>38</th>\n <td>None</td>\n </tr>\n <tr>\n <th>39</th>\n <td>None</td>\n </tr>\n <tr>\n <th>40</th>\n <td>None</td>\n </tr>\n <tr>\n <th>41</th>\n <td>None</td>\n </tr>\n </tbody>\n</table>\n</div>"},"metadata":{}}]},{"cell_type":"code","source":"# Parsing the json\ndef parse_json(response):\n for item in response['results']:\n print(item['name'],len(item['episode']))\n return\n# name = data['results'][0]['name']\n# episodes = data['results'][0]['episode'] \n\n\n","metadata":{"execution":{"iopub.status.busy":"2024-06-18T10:06:08.699197Z","iopub.execute_input":"2024-06-18T10:06:08.699653Z","iopub.status.idle":"2024-06-18T10:06:08.707978Z","shell.execute_reply.started":"2024-06-18T10:06:08.699617Z","shell.execute_reply":"2024-06-18T10:06:08.706114Z"},"trusted":true},"execution_count":50,"outputs":[]},{"cell_type":"code","source":"parse_json(data) # This is from the main request","metadata":{"execution":{"iopub.status.busy":"2024-06-18T10:06:57.798446Z","iopub.execute_input":"2024-06-18T10:06:57.799029Z","iopub.status.idle":"2024-06-18T10:06:57.806703Z","shell.execute_reply.started":"2024-06-18T10:06:57.798986Z","shell.execute_reply":"2024-06-18T10:06:57.805072Z"},"trusted":true},"execution_count":56,"outputs":[{"name":"stdout","text":"Rick Sanchez 51\nMorty Smith 51\nSummer Smith 42\nBeth Smith 42\nJerry Smith 39\nAbadango Cluster Princess 1\nAbradolf Lincler 2\nAdjudicator Rick 1\nAgency Director 1\nAlan Rails 1\nAlbert Einstein 1\nAlexander 1\nAlien Googah 1\nAlien Morty 1\nAlien Rick 1\nAmish Cyborg 1\nAnnie 1\nAntenna Morty 2\nAntenna Rick 1\nAnts in my Eyes Johnson 1\n","output_type":"stream"}]},{"cell_type":"code","source":"df","metadata":{"execution":{"iopub.status.busy":"2024-06-18T10:23:11.094915Z","iopub.execute_input":"2024-06-18T10:23:11.095321Z","iopub.status.idle":"2024-06-18T10:23:11.109201Z","shell.execute_reply.started":"2024-06-18T10:23:11.095289Z","shell.execute_reply":"2024-06-18T10:23:11.107918Z"},"trusted":true},"execution_count":71,"outputs":[{"execution_count":71,"output_type":"execute_result","data":{"text/plain":" 0\n0 None\n1 None\n2 None\n3 None\n4 None\n5 None\n6 None\n7 None\n8 None\n9 None\n10 None\n11 None\n12 None\n13 None\n14 None\n15 None\n16 None\n17 None\n18 None\n19 None\n20 None\n21 None\n22 None\n23 None\n24 None\n25 None\n26 None\n27 None\n28 None\n29 None\n30 None\n31 None\n32 None\n33 None\n34 None\n35 None\n36 None\n37 None\n38 None\n39 None\n40 None\n41 None","text/html":"<div>\n<style scoped>\n .dataframe tbody tr th:only-of-type {\n vertical-align: middle;\n }\n\n .dataframe tbody tr th {\n vertical-align: top;\n }\n\n .dataframe thead th {\n text-align: right;\n }\n</style>\n<table border=\"1\" class=\"dataframe\">\n <thead>\n <tr style=\"text-align: right;\">\n <th></th>\n <th>0</th>\n </tr>\n </thead>\n <tbody>\n <tr>\n <th>0</th>\n <td>None</td>\n </tr>\n <tr>\n <th>1</th>\n <td>None</td>\n </tr>\n <tr>\n <th>2</th>\n <td>None</td>\n </tr>\n <tr>\n <th>3</th>\n <td>None</td>\n </tr>\n <tr>\n <th>4</th>\n <td>None</td>\n </tr>\n <tr>\n <th>5</th>\n <td>None</td>\n </tr>\n <tr>\n <th>6</th>\n <td>None</td>\n </tr>\n <tr>\n <th>7</th>\n <td>None</td>\n </tr>\n <tr>\n <th>8</th>\n <td>None</td>\n </tr>\n <tr>\n <th>9</th>\n <td>None</td>\n </tr>\n <tr>\n <th>10</th>\n <td>None</td>\n </tr>\n <tr>\n <th>11</th>\n <td>None</td>\n </tr>\n <tr>\n <th>12</th>\n <td>None</td>\n </tr>\n <tr>\n <th>13</th>\n <td>None</td>\n </tr>\n <tr>\n <th>14</th>\n <td>None</td>\n </tr>\n <tr>\n <th>15</th>\n <td>None</td>\n </tr>\n <tr>\n <th>16</th>\n <td>None</td>\n </tr>\n <tr>\n <th>17</th>\n <td>None</td>\n </tr>\n <tr>\n <th>18</th>\n <td>None</td>\n </tr>\n <tr>\n <th>19</th>\n <td>None</td>\n </tr>\n <tr>\n <th>20</th>\n <td>None</td>\n </tr>\n <tr>\n <th>21</th>\n <td>None</td>\n </tr>\n <tr>\n <th>22</th>\n <td>None</td>\n </tr>\n <tr>\n <th>23</th>\n <td>None</td>\n </tr>\n <tr>\n <th>24</th>\n <td>None</td>\n </tr>\n <tr>\n <th>25</th>\n <td>None</td>\n </tr>\n <tr>\n <th>26</th>\n <td>None</td>\n </tr>\n <tr>\n <th>27</th>\n <td>None</td>\n </tr>\n <tr>\n <th>28</th>\n <td>None</td>\n </tr>\n <tr>\n <th>29</th>\n <td>None</td>\n </tr>\n <tr>\n <th>30</th>\n <td>None</td>\n </tr>\n <tr>\n <th>31</th>\n <td>None</td>\n </tr>\n <tr>\n <th>32</th>\n <td>None</td>\n </tr>\n <tr>\n <th>33</th>\n <td>None</td>\n </tr>\n <tr>\n <th>34</th>\n <td>None</td>\n </tr>\n <tr>\n <th>35</th>\n <td>None</td>\n </tr>\n <tr>\n <th>36</th>\n <td>None</td>\n </tr>\n <tr>\n <th>37</th>\n <td>None</td>\n </tr>\n <tr>\n <th>38</th>\n <td>None</td>\n </tr>\n <tr>\n <th>39</th>\n <td>None</td>\n </tr>\n <tr>\n <th>40</th>\n <td>None</td>\n </tr>\n <tr>\n <th>41</th>\n <td>None</td>\n </tr>\n </tbody>\n</table>\n</div>"},"metadata":{}}]},{"cell_type":"code","source":"# Creating a dictionary\ndef parse_json2(response):\n charlist = []\n for item in response['results']:\n char ={'name':item['name'],\n 'episode_no':len(item['episode']),}\n charlist.append(char)\n return charlist","metadata":{"execution":{"iopub.status.busy":"2024-06-18T10:06:13.105392Z","iopub.execute_input":"2024-06-18T10:06:13.106144Z","iopub.status.idle":"2024-06-18T10:06:13.113886Z","shell.execute_reply.started":"2024-06-18T10:06:13.106104Z","shell.execute_reply":"2024-06-18T10:06:13.112116Z"},"trusted":true},"execution_count":52,"outputs":[]},{"cell_type":"code","source":"json_ = parse_json2(data)","metadata":{"execution":{"iopub.status.busy":"2024-06-18T10:07:06.076230Z","iopub.execute_input":"2024-06-18T10:07:06.076685Z","iopub.status.idle":"2024-06-18T10:07:06.083163Z","shell.execute_reply.started":"2024-06-18T10:07:06.076651Z","shell.execute_reply":"2024-06-18T10:07:06.081482Z"},"trusted":true},"execution_count":58,"outputs":[]},{"cell_type":"code","source":"json_","metadata":{"execution":{"iopub.status.busy":"2024-06-18T10:07:07.385547Z","iopub.execute_input":"2024-06-18T10:07:07.385981Z","iopub.status.idle":"2024-06-18T10:07:07.396209Z","shell.execute_reply.started":"2024-06-18T10:07:07.385949Z","shell.execute_reply":"2024-06-18T10:07:07.394867Z"},"trusted":true},"execution_count":59,"outputs":[{"execution_count":59,"output_type":"execute_result","data":{"text/plain":"[{'name': 'Rick Sanchez', 'episode_no': 51},\n {'name': 'Morty Smith', 'episode_no': 51},\n {'name': 'Summer Smith', 'episode_no': 42},\n {'name': 'Beth Smith', 'episode_no': 42},\n {'name': 'Jerry Smith', 'episode_no': 39},\n {'name': 'Abadango Cluster Princess', 'episode_no': 1},\n {'name': 'Abradolf Lincler', 'episode_no': 2},\n {'name': 'Adjudicator Rick', 'episode_no': 1},\n {'name': 'Agency Director', 'episode_no': 1},\n {'name': 'Alan Rails', 'episode_no': 1},\n {'name': 'Albert Einstein', 'episode_no': 1},\n {'name': 'Alexander', 'episode_no': 1},\n {'name': 'Alien Googah', 'episode_no': 1},\n {'name': 'Alien Morty', 'episode_no': 1},\n {'name': 'Alien Rick', 'episode_no': 1},\n {'name': 'Amish Cyborg', 'episode_no': 1},\n {'name': 'Annie', 'episode_no': 1},\n {'name': 'Antenna Morty', 'episode_no': 2},\n {'name': 'Antenna Rick', 'episode_no': 1},\n {'name': 'Ants in my Eyes Johnson', 'episode_no': 1}]"},"metadata":{}}]},{"cell_type":"code","source":"","metadata":{},"execution_count":null,"outputs":[]}]}