Simple_API_2__v2.ipynb

{"cells":[{"cell_type":"markdown","metadata":{},"source":["\u003cp style=\"text-align:center\"\u003e\n","    \u003ca href=\"https://skills.network/?utm_medium=Exinfluencer\u0026utm_source=Exinfluencer\u0026utm_content=000026UJ\u0026utm_term=10006555\u0026utm_id=NA-SkillsNetwork-Channel-SkillsNetworkCoursesIBMDeveloperSkillsNetworkPY0101ENSkillsNetwork1005-2022-01-01\" target=\"_blank\"\u003e\n","    \u003cimg src=\"https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/assets/logos/SN_web_lightmode.png\" width=\"200\" alt=\"Skills Network Logo\"  /\u003e\n","    \u003c/a\u003e\n","\u003c/p\u003e\n","\n","# Application Programming Interface\n","\n","\n","Estimated time needed: **15** minutes\n","    \n","\n","## Objectives\n","\n","After completing this lab you will be able to:\n","\n","* Create and Use APIs in Python\n"]},{"cell_type":"markdown","metadata":{},"source":["\n","### Introduction\n","\n","An API lets two pieces of software talk to each other. Just like a function,  you don’t have to know how the API works only its inputs and outputs.  An essential type of API is a REST API that allows you to access resources via the internet. In this lab, we will review the Pandas Library  in the context of an API, we will also review a basic REST API  \n"]},{"cell_type":"markdown","metadata":{},"source":["## Table of Contents\n","\u003cdiv class=\"alert alert-block alert-info\" style=\"margin-top: 20px\"\u003e\n","\u003cli\u003e\u003ca href=\"#ref0\"\u003ePandas is an API\u003c/a\u003e\u003c/li\u003e\n","\u003cli\u003e\u003ca href=\"#ref1\"\u003eREST APIs Basics  \u003c/a\u003e\u003c/li\u003e\n","\u003cli\u003e\u003ca href=\"#ref2\"\u003eQuiz on Tuples\u003c/a\u003e\u003c/li\u003e\n","\n","\u003c/div\u003e\n","\n","\u003chr\u003e\n"]},{"cell_type":"code","execution_count":null,"metadata":{"jupyter":{"outputs_hidden":false}},"outputs":[],"source":["!pip install pycoingecko\n","!pip install plotly\n","!pip install mplfinance\n","!pip install --upgrade nbformat"]},{"cell_type":"markdown","metadata":{},"source":["\u003ch2 id=\"PandasAPI\"\u003ePandas is an API \u003c/h2\u003e\n"]},{"cell_type":"markdown","metadata":{},"source":["Pandas is actually set of software components , much of  which is not even written in Python.\n"]},{"cell_type":"code","execution_count":null,"metadata":{"jupyter":{"outputs_hidden":false}},"outputs":[],"source":["import pandas as pd\n","import numpy as np\n","import plotly.graph_objects as go\n","from plotly.offline import plot\n","import matplotlib.pyplot as plt\n","import datetime\n","from pycoingecko import CoinGeckoAPI\n","from mplfinance.original_flavor import candlestick2_ohlc"]},{"cell_type":"markdown","metadata":{},"source":["You create a dictionary, this is just data.\n"]},{"cell_type":"code","execution_count":null,"metadata":{"jupyter":{"outputs_hidden":false}},"outputs":[],"source":["dict_={'a':[11,21,31],'b':[12,22,32]}"]},{"cell_type":"markdown","metadata":{},"source":["When you create a Pandas object with the Dataframe constructor in API lingo, this is an \"instance\". The data in the dictionary is passed along to the pandas API. You then use the dataframe to communicate with the API.\n"]},{"cell_type":"code","execution_count":null,"metadata":{"jupyter":{"outputs_hidden":false}},"outputs":[],"source":["df=pd.DataFrame(dict_)\n","type(df)"]},{"cell_type":"markdown","metadata":{},"source":["\u003cimg src=\"https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-PY0101EN-SkillsNetwork/labs/Module%205/images/pandas_api.png\" width=\"800,\" align=\"center\" alt=\"logistic regression block diagram\"\u003e\n"]},{"cell_type":"markdown","metadata":{},"source":["When you call the method head the dataframe communicates with the API displaying the first few rows of the dataframe.\n","\n","\n"]},{"cell_type":"code","execution_count":null,"metadata":{"jupyter":{"outputs_hidden":false}},"outputs":[],"source":["df.head()"]},{"cell_type":"markdown","metadata":{},"source":["When you call the method mean,the API will calculate the mean and return the value.\n"]},{"cell_type":"code","execution_count":null,"metadata":{"jupyter":{"outputs_hidden":false}},"outputs":[],"source":["df.mean()"]},{"cell_type":"markdown","metadata":{},"source":["\u003ch2 id=\"ref1\"\u003eREST APIs\u003c/h2\u003e\n"]},{"cell_type":"markdown","metadata":{},"source":["Rest API’s function by sending a request,  the request is communicated via HTTP message. The HTTP message usually contains a JSON file. This contains instructions for what operation we would like the service or resource to perform. In a similar manner, API returns a response, via an HTTP message, this response is usually contained within a JSON.\n","\n","In cryptocurrency a popular method to display the movements of the price of a currency.\n","\n","![Example Candlestick Graph](https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-PY0101EN-SkillsNetwork/labs/Module%205/candlestick.png)\n","\n","Here is a description of the candle sticks.\n","\n","\u003cimg src=\"https://cf-courses-data.s3.us.cloud-object-storage.appdomain.cloud/IBMDeveloperSkillsNetwork-PY0101EN-SkillsNetwork/labs/Module%205/explanation.png\" alt=\"Candle Stick Definition\" width=\"800\" height=\"600\"\u003e\n","\n","In this lab, we will be using the \u003ca href=https://www.coingecko.com/en/api?utm_medium=Exinfluencer\u0026utm_source=Exinfluencer\u0026utm_content=000026UJ\u0026utm_term=10006555\u0026utm_id=NA-SkillsNetwork-Channel-SkillsNetworkCoursesIBMDeveloperSkillsNetworkPY0101ENSkillsNetwork1005-2022-01-01\u003eCoinGecko API\u003c/a\u003e to create one of these candlestick graphs for Bitcoin. We will use the API to get the price data for 30 days with 24 observation per day, 1 per hour. We will find the max, min, open, and close price per day meaning we will have 30 candlesticks and use that to generate the candlestick graph. Although we are using the CoinGecko API we will use a Python client/wrapper for the API called \u003ca href=https://github.com/man-c/pycoingecko\u003ePyCoinGecko\u003c/a\u003e. PyCoinGecko will make performing the requests easy and it will deal with the enpoint targeting.\n"]},{"cell_type":"markdown","metadata":{},"source":["Lets start off by getting the data we need. Using the \u003ccode\u003eget_coin_market_chart_by_id(id, vs_currency, days)\u003c/code\u003e. \u003ccode\u003eid\u003c/code\u003e is the name of the coin you want, \u003ccode\u003evs_currency\u003c/code\u003e is the currency you want the price in, and \u003ccode\u003edays\u003c/code\u003e is how many days back from today you want.\n"]},{"cell_type":"code","execution_count":null,"metadata":{},"outputs":[],"source":["cg = CoinGeckoAPI()\n","\n","bitcoin_data = cg.get_coin_market_chart_by_id(id='bitcoin', vs_currency='usd', days=30)"]},{"cell_type":"code","execution_count":null,"metadata":{},"outputs":[],"source":["type(bitcoin_data )"]},{"cell_type":"markdown","metadata":{},"source":["The response we get is in the form of a JSON which includes the price, market caps, and total volumes along with timestamps for each observation. We are focused on the prices so we will select that data.\n"]},{"cell_type":"code","execution_count":null,"metadata":{},"outputs":[],"source":["bitcoin_price_data = bitcoin_data['prices']\n","\n","bitcoin_price_data[0:5]"]},{"cell_type":"markdown","metadata":{},"source":["Finally lets turn this data into a Pandas DataFrame.\n"]},{"cell_type":"code","execution_count":null,"metadata":{},"outputs":[],"source":["data = pd.DataFrame(bitcoin_price_data, columns=['TimeStamp', 'Price'])"]},{"cell_type":"markdown","metadata":{},"source":["Now that we have the DataFrame we will convert the timestamp to datetime and save it as a column called \u003ccode\u003eDate\u003c/code\u003e. We will map our \u003ccode\u003eunix_to_datetime\u003c/code\u003e to each timestamp and convert it to a readable datetime.\n"]},{"cell_type":"code","execution_count":null,"metadata":{},"outputs":[],"source":["data['date'] = data['TimeStamp'].apply(lambda d: datetime.date.fromtimestamp(d/1000.0))\n"]},{"cell_type":"markdown","metadata":{},"source":["Using this modified dataset we can now group by the \u003ccode\u003eDate\u003c/code\u003e and find the min, max, open, and close for the candlesticks.\n"]},{"cell_type":"code","execution_count":null,"metadata":{},"outputs":[],"source":["candlestick_data = data.groupby(data.date, as_index=False).agg({\"Price\": ['min', 'max', 'first', 'last']})"]},{"cell_type":"markdown","metadata":{},"source":["Finally we are now ready to use plotly to create our Candlestick Chart.\n"]},{"cell_type":"code","execution_count":null,"metadata":{},"outputs":[],"source":["fig = go.Figure(data=[go.Candlestick(x=candlestick_data['date'],\n","                open=candlestick_data['Price']['first'], \n","                high=candlestick_data['Price']['max'],\n","                low=candlestick_data['Price']['min'], \n","                close=candlestick_data['Price']['last'])\n","                ])\n","\n","fig.update_layout(xaxis_rangeslider_visible=False)\n","\n","fig.show()"]},{"cell_type":"markdown","metadata":{},"source":["## Authors:   \n","\n","\n","## Change Log\n","\n","\n","|  Date (YYYY-MM-DD) |  Version | Changed By  |  Change Description |\n","|---|---|---|---|\n","| 2020-11-23 | 3.0 | Azim Hirjani | New API |\n","| 2020-09-09 | 2.1 | Malika Singla | Spell Check |\n","| 2020-08-26  | 2.0  | Lavanya | Moved lab to course repo in GitLab |\n","|   |   |   |   |\n","\n","\n","\n","\n","\u003chr/\u003e\n","\n","## \u003ch3 align=\"center\"\u003e © IBM Corporation 2020. All rights reserved. \u003ch3/\u003e\n"]},{"cell_type":"code","execution_count":null,"metadata":{},"outputs":[],"source":[]}],"metadata":{"kernelspec":{"display_name":"Python","language":"python","name":"conda-env-python-py"},"language_info":{"name":""}},"nbformat":4,"nbformat_minor":4}