Skip to content

Instantly share code, notes, and snippets.

@aeron7

aeron7/getting-nse-holidays-data-using-python.ipynb

Created April 21, 2021 19:26
Show Gist options
  • Save aeron7/59d247a7df28222a44c2e2813714be6c to your computer and use it in GitHub Desktop.
Save aeron7/59d247a7df28222a44c2e2813714be6c to your computer and use it in GitHub Desktop.
Download ZIP
Getting NSE Holidays Data Using Python
Display the source blob
Display the rendered blob
Raw
getting-nse-holidays-data-using-python.ipynb
{
"nbformat": 4,
"nbformat_minor": 0,
"metadata": {
"colab": {
"name": "Getting NSE Holidays Data Using Python",
"provenance": [],
"authorship_tag": "ABX9TyM4moKWQWd0wZNVseuz0bQZ",
"include_colab_link": true
},
"kernelspec": {
"name": "python3",
"display_name": "Python 3"
},
"language_info": {
"name": "python"
}
},
"cells": [
{
"cell_type": "markdown",
"metadata": {
"id": "view-in-github",
"colab_type": "text"
},
"source": [
"<a href=\"https://colab.research.google.com/gist/aeron7/59d247a7df28222a44c2e2813714be6c/getting-nse-holidays-data-using-python.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
]
},
{
"cell_type": "code",
"metadata": {
"id": "j2A_YrFO35nP"
},
"source": [
"#This data is from nse_holidays() command of nsepython as seen here - https://forum.unofficed.com/t/nsepython-documentation/376/19?u=dexter\n",
"json_data = '''{\n",
" \"CBM\":[\n",
" {\n",
" \"tradingDate\":\"26-Jan-2021\",\n",
" \"weekDay\":\"Tuesday\",\n",
" \"description\":\"Republic Day\",\n",
" \"Sr_no\":1\n",
" },\n",
" {\n",
" \"tradingDate\":\"19-Feb-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Chatrapati Shivaji Jayanti\",\n",
" \"Sr_no\":2\n",
" },\n",
" {\n",
" \"tradingDate\":\"11-Mar-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Mahashivratri\",\n",
" \"Sr_no\":3\n",
" },\n",
" {\n",
" \"tradingDate\":\"29-Mar-2021\",\n",
" \"weekDay\":\"Monday\",\n",
" \"description\":\"Holi\",\n",
" \"Sr_no\":4\n",
" },\n",
" {\n",
" \"tradingDate\":\"01-Apr-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Annual Bank Closing\",\n",
" \"Sr_no\":5\n",
" },\n",
" {\n",
" \"tradingDate\":\"02-Apr-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Good Friday\",\n",
" \"Sr_no\":6\n",
" },\n",
" {\n",
" \"tradingDate\":\"13-Apr-2021\",\n",
" \"weekDay\":\"Tuesday\",\n",
" \"description\":\"Gudi Padwa\",\n",
" \"Sr_no\":7\n",
" },\n",
" {\n",
" \"tradingDate\":\"14-Apr-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Dr.Baba Saheb Ambedkar Jayanti\",\n",
" \"Sr_no\":8\n",
" },\n",
" {\n",
" \"tradingDate\":\"21-Apr-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Ram Navami\",\n",
" \"Sr_no\":9\n",
" },\n",
" {\n",
" \"tradingDate\":\"25-Apr-2021\",\n",
" \"weekDay\":\"Sunday\",\n",
" \"description\":\"Mahavir Jayanti\",\n",
" \"Sr_no\":10\n",
" },\n",
" {\n",
" \"tradingDate\":\"01-May-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Maharashtra Day\",\n",
" \"Sr_no\":11\n",
" },\n",
" {\n",
" \"tradingDate\":\"13-May-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Id-Ul-Fitr (Ramzan ID)\",\n",
" \"Sr_no\":12\n",
" },\n",
" {\n",
" \"tradingDate\":\"26-May-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Buddha Pournima\",\n",
" \"Sr_no\":13\n",
" },\n",
" {\n",
" \"tradingDate\":\"21-Jul-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Bakri Id\",\n",
" \"Sr_no\":14\n",
" },\n",
" {\n",
" \"tradingDate\":\"15-Aug-2021\",\n",
" \"weekDay\":\"Sunday\",\n",
" \"description\":\"Independence Day\",\n",
" \"Sr_no\":15\n",
" },\n",
" {\n",
" \"tradingDate\":\"16-Aug-2021\",\n",
" \"weekDay\":\"Monday\",\n",
" \"description\":\"Parsi New Year\",\n",
" \"Sr_no\":16\n",
" },\n",
" {\n",
" \"tradingDate\":\"19-Aug-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Moharram\",\n",
" \"Sr_no\":17\n",
" },\n",
" {\n",
" \"tradingDate\":\"10-Sep-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Ganesh Chaturthi\",\n",
" \"Sr_no\":18\n",
" },\n",
" {\n",
" \"tradingDate\":\"02-Oct-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Mahatma Gandhi Jayanti\",\n",
" \"Sr_no\":19\n",
" },\n",
" {\n",
" \"tradingDate\":\"15-Oct-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Dussehra\",\n",
" \"Sr_no\":20\n",
" },\n",
" {\n",
" \"tradingDate\":\"19-Oct-2021\",\n",
" \"weekDay\":\"Tuesday\",\n",
" \"description\":\"Id-E-Milad\",\n",
" \"Sr_no\":21\n",
" },\n",
" {\n",
" \"tradingDate\":\"04-Nov-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Diwali-Laxmi Pujan\",\n",
" \"Sr_no\":22\n",
" },\n",
" {\n",
" \"tradingDate\":\"05-Nov-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Diwali-Balipratipada\",\n",
" \"Sr_no\":23\n",
" },\n",
" {\n",
" \"tradingDate\":\"19-Nov-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Gurunanak Jayanti\",\n",
" \"Sr_no\":24\n",
" },\n",
" {\n",
" \"tradingDate\":\"25-Dec-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Christmas\",\n",
" \"Sr_no\":25\n",
" }\n",
" ],\n",
" \"CD\":[\n",
" {\n",
" \"tradingDate\":\"26-Jan-2021\",\n",
" \"weekDay\":\"Tuesday\",\n",
" \"description\":\"Republic Day\",\n",
" \"Sr_no\":1\n",
" },\n",
" {\n",
" \"tradingDate\":\"19-Feb-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Chatrapati Shivaji Jayanti\",\n",
" \"Sr_no\":2\n",
" },\n",
" {\n",
" \"tradingDate\":\"11-Mar-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Mahashivratri\",\n",
" \"Sr_no\":3\n",
" },\n",
" {\n",
" \"tradingDate\":\"29-Mar-2021\",\n",
" \"weekDay\":\"Monday\",\n",
" \"description\":\"Holi\",\n",
" \"Sr_no\":4\n",
" },\n",
" {\n",
" \"tradingDate\":\"01-Apr-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Annual Bank Closing\",\n",
" \"Sr_no\":5\n",
" },\n",
" {\n",
" \"tradingDate\":\"02-Apr-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Good Friday\",\n",
" \"Sr_no\":6\n",
" },\n",
" {\n",
" \"tradingDate\":\"13-Apr-2021\",\n",
" \"weekDay\":\"Tuesday\",\n",
" \"description\":\"Gudi Padwa\",\n",
" \"Sr_no\":7\n",
" },\n",
" {\n",
" \"tradingDate\":\"14-Apr-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Dr.Baba Saheb Ambedkar Jayanti\",\n",
" \"Sr_no\":8\n",
" },\n",
" {\n",
" \"tradingDate\":\"21-Apr-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Ram Navami\",\n",
" \"Sr_no\":9\n",
" },\n",
" {\n",
" \"tradingDate\":\"25-Apr-2021\",\n",
" \"weekDay\":\"Sunday\",\n",
" \"description\":\"Mahavir Jayanti\",\n",
" \"Sr_no\":10\n",
" },\n",
" {\n",
" \"tradingDate\":\"01-May-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Maharashtra Day\",\n",
" \"Sr_no\":11\n",
" },\n",
" {\n",
" \"tradingDate\":\"13-May-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Id-Ul-Fitr (Ramzan ID)\",\n",
" \"Sr_no\":12\n",
" },\n",
" {\n",
" \"tradingDate\":\"26-May-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Buddha Pournima\",\n",
" \"Sr_no\":13\n",
" },\n",
" {\n",
" \"tradingDate\":\"21-Jul-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Bakri Id\",\n",
" \"Sr_no\":14\n",
" },\n",
" {\n",
" \"tradingDate\":\"15-Aug-2021\",\n",
" \"weekDay\":\"Sunday\",\n",
" \"description\":\"Independence Day\",\n",
" \"Sr_no\":15\n",
" },\n",
" {\n",
" \"tradingDate\":\"16-Aug-2021\",\n",
" \"weekDay\":\"Monday\",\n",
" \"description\":\"Parsi New Year\",\n",
" \"Sr_no\":16\n",
" },\n",
" {\n",
" \"tradingDate\":\"19-Aug-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Moharram\",\n",
" \"Sr_no\":17\n",
" },\n",
" {\n",
" \"tradingDate\":\"10-Sep-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Ganesh Chaturthi\",\n",
" \"Sr_no\":18\n",
" },\n",
" {\n",
" \"tradingDate\":\"02-Oct-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Mahatma Gandhi Jayanti\",\n",
" \"Sr_no\":19\n",
" },\n",
" {\n",
" \"tradingDate\":\"15-Oct-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Dussehra\",\n",
" \"Sr_no\":20\n",
" },\n",
" {\n",
" \"tradingDate\":\"19-Oct-2021\",\n",
" \"weekDay\":\"Tuesday\",\n",
" \"description\":\"Id-E-Milad\",\n",
" \"Sr_no\":21\n",
" },\n",
" {\n",
" \"tradingDate\":\"05-Nov-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Diwali-Balipratipada\",\n",
" \"Sr_no\":22\n",
" },\n",
" {\n",
" \"tradingDate\":\"19-Nov-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Gurunanak Jayanti\",\n",
" \"Sr_no\":23\n",
" },\n",
" {\n",
" \"tradingDate\":\"25-Dec-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Christmas\",\n",
" \"Sr_no\":24\n",
" }\n",
" ],\n",
" \"CM\":[\n",
" {\n",
" \"tradingDate\":\"26-Jan-2021\",\n",
" \"weekDay\":\"Tuesday\",\n",
" \"description\":\"Republic Day\",\n",
" \"Sr_no\":1\n",
" },\n",
" {\n",
" \"tradingDate\":\"11-Mar-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Mahashivratri\",\n",
" \"Sr_no\":2\n",
" },\n",
" {\n",
" \"tradingDate\":\"29-Mar-2021\",\n",
" \"weekDay\":\"Monday\",\n",
" \"description\":\"Holi\",\n",
" \"Sr_no\":3\n",
" },\n",
" {\n",
" \"tradingDate\":\"02-Apr-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Good Friday\",\n",
" \"Sr_no\":4\n",
" },\n",
" {\n",
" \"tradingDate\":\"14-Apr-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Dr.Baba Saheb Ambedkar Jayanti\",\n",
" \"Sr_no\":5\n",
" },\n",
" {\n",
" \"tradingDate\":\"21-Apr-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Ram Navami\",\n",
" \"Sr_no\":6\n",
" },\n",
" {\n",
" \"tradingDate\":\"25-Apr-2021\",\n",
" \"weekDay\":\"Sunday\",\n",
" \"description\":\"Mahavir Jayanti\",\n",
" \"Sr_no\":7\n",
" },\n",
" {\n",
" \"tradingDate\":\"01-May-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Maharashtra Day\",\n",
" \"Sr_no\":8\n",
" },\n",
" {\n",
" \"tradingDate\":\"13-May-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Id-Ul-Fitr (Ramzan ID)\",\n",
" \"Sr_no\":9\n",
" },\n",
" {\n",
" \"tradingDate\":\"21-Jul-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Bakri Id\",\n",
" \"Sr_no\":10\n",
" },\n",
" {\n",
" \"tradingDate\":\"15-Aug-2021\",\n",
" \"weekDay\":\"Sunday\",\n",
" \"description\":\"Independence Day\",\n",
" \"Sr_no\":11\n",
" },\n",
" {\n",
" \"tradingDate\":\"19-Aug-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Moharram\",\n",
" \"Sr_no\":12\n",
" },\n",
" {\n",
" \"tradingDate\":\"10-Sep-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Ganesh Chaturthi\",\n",
" \"Sr_no\":13\n",
" },\n",
" {\n",
" \"tradingDate\":\"02-Oct-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Mahatma Gandhi Jayanti\",\n",
" \"Sr_no\":14\n",
" },\n",
" {\n",
" \"tradingDate\":\"15-Oct-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Dussehra\",\n",
" \"Sr_no\":15\n",
" },\n",
" {\n",
" \"tradingDate\":\"05-Nov-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Diwali-Balipratipada\",\n",
" \"Sr_no\":16\n",
" },\n",
" {\n",
" \"tradingDate\":\"19-Nov-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Gurunanak Jayanti\",\n",
" \"Sr_no\":17\n",
" },\n",
" {\n",
" \"tradingDate\":\"25-Dec-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Christmas\",\n",
" \"Sr_no\":18\n",
" }\n",
" ],\n",
" \"CMOT\":[\n",
" {\n",
" \"tradingDate\":\"26-Jan-2021\",\n",
" \"weekDay\":\"Tuesday\",\n",
" \"description\":\"Republic Day\",\n",
" \"Sr_no\":1\n",
" },\n",
" {\n",
" \"tradingDate\":\"11-Mar-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Mahashivratri\",\n",
" \"Sr_no\":2\n",
" },\n",
" {\n",
" \"tradingDate\":\"29-Mar-2021\",\n",
" \"weekDay\":\"Monday\",\n",
" \"description\":\"Holi\",\n",
" \"Sr_no\":3\n",
" },\n",
" {\n",
" \"tradingDate\":\"02-Apr-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Good Friday\",\n",
" \"Sr_no\":4\n",
" },\n",
" {\n",
" \"tradingDate\":\"14-Apr-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Dr.Baba Saheb Ambedkar Jayanti\",\n",
" \"Sr_no\":5\n",
" },\n",
" {\n",
" \"tradingDate\":\"21-Apr-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Ram Navami\",\n",
" \"Sr_no\":6\n",
" },\n",
" {\n",
" \"tradingDate\":\"25-Apr-2021\",\n",
" \"weekDay\":\"Sunday\",\n",
" \"description\":\"Mahavir Jayanti\",\n",
" \"Sr_no\":7\n",
" },\n",
" {\n",
" \"tradingDate\":\"01-May-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Maharashtra Day\",\n",
" \"Sr_no\":8\n",
" },\n",
" {\n",
" \"tradingDate\":\"13-May-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Id-Ul-Fitr (Ramzan ID)\",\n",
" \"Sr_no\":9\n",
" },\n",
" {\n",
" \"tradingDate\":\"21-Jul-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Bakri Id\",\n",
" \"Sr_no\":10\n",
" },\n",
" {\n",
" \"tradingDate\":\"15-Aug-2021\",\n",
" \"weekDay\":\"Sunday\",\n",
" \"description\":\"Independence Day\",\n",
" \"Sr_no\":11\n",
" },\n",
" {\n",
" \"tradingDate\":\"19-Aug-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Moharram\",\n",
" \"Sr_no\":12\n",
" },\n",
" {\n",
" \"tradingDate\":\"10-Sep-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Ganesh Chaturthi\",\n",
" \"Sr_no\":13\n",
" },\n",
" {\n",
" \"tradingDate\":\"02-Oct-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Mahatma Gandhi Jayanti\",\n",
" \"Sr_no\":14\n",
" },\n",
" {\n",
" \"tradingDate\":\"15-Oct-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Dussehra\",\n",
" \"Sr_no\":15\n",
" },\n",
" {\n",
" \"tradingDate\":\"05-Nov-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Diwali-Balipratipada\",\n",
" \"Sr_no\":16\n",
" },\n",
" {\n",
" \"tradingDate\":\"19-Nov-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Gurunanak Jayanti\",\n",
" \"Sr_no\":17\n",
" },\n",
" {\n",
" \"tradingDate\":\"25-Dec-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Christmas\",\n",
" \"Sr_no\":18\n",
" }\n",
" ],\n",
" \"COM\":[\n",
" {\n",
" \"tradingDate\":\"26-Jan-2021\",\n",
" \"weekDay\":\"Tuesday\",\n",
" \"description\":\"Republic Day\",\n",
" \"Sr_no\":1\n",
" },\n",
" {\n",
" \"tradingDate\":\"02-Apr-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Good Friday\",\n",
" \"Sr_no\":2\n",
" },\n",
" {\n",
" \"tradingDate\":\"25-Apr-2021\",\n",
" \"weekDay\":\"Sunday\",\n",
" \"description\":\"Mahavir Jayanti\",\n",
" \"Sr_no\":3\n",
" },\n",
" {\n",
" \"tradingDate\":\"01-May-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Maharashtra Day\",\n",
" \"Sr_no\":4\n",
" },\n",
" {\n",
" \"tradingDate\":\"15-Aug-2021\",\n",
" \"weekDay\":\"Sunday\",\n",
" \"description\":\"Independence Day\",\n",
" \"Sr_no\":5\n",
" },\n",
" {\n",
" \"tradingDate\":\"02-Oct-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Mahatma Gandhi Jayanti\",\n",
" \"Sr_no\":6\n",
" },\n",
" {\n",
" \"tradingDate\":\"25-Dec-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Christmas\",\n",
" \"Sr_no\":7\n",
" }\n",
" ],\n",
" \"FO\":[\n",
" {\n",
" \"tradingDate\":\"26-Jan-2021\",\n",
" \"weekDay\":\"Tuesday\",\n",
" \"description\":\"Republic Day\",\n",
" \"Sr_no\":1\n",
" },\n",
" {\n",
" \"tradingDate\":\"11-Mar-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Mahashivratri\",\n",
" \"Sr_no\":2\n",
" },\n",
" {\n",
" \"tradingDate\":\"29-Mar-2021\",\n",
" \"weekDay\":\"Monday\",\n",
" \"description\":\"Holi\",\n",
" \"Sr_no\":3\n",
" },\n",
" {\n",
" \"tradingDate\":\"02-Apr-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Good Friday\",\n",
" \"Sr_no\":4\n",
" },\n",
" {\n",
" \"tradingDate\":\"14-Apr-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Dr.Baba Saheb Ambedkar Jayanti\",\n",
" \"Sr_no\":5\n",
" },\n",
" {\n",
" \"tradingDate\":\"21-Apr-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Ram Navami\",\n",
" \"Sr_no\":6\n",
" },\n",
" {\n",
" \"tradingDate\":\"25-Apr-2021\",\n",
" \"weekDay\":\"Sunday\",\n",
" \"description\":\"Mahavir Jayanti\",\n",
" \"Sr_no\":7\n",
" },\n",
" {\n",
" \"tradingDate\":\"01-May-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Maharashtra Day\",\n",
" \"Sr_no\":8\n",
" },\n",
" {\n",
" \"tradingDate\":\"13-May-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Id-Ul-Fitr (Ramzan ID)\",\n",
" \"Sr_no\":9\n",
" },\n",
" {\n",
" \"tradingDate\":\"21-Jul-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Bakri Id\",\n",
" \"Sr_no\":10\n",
" },\n",
" {\n",
" \"tradingDate\":\"15-Aug-2021\",\n",
" \"weekDay\":\"Sunday\",\n",
" \"description\":\"Independence Day\",\n",
" \"Sr_no\":11\n",
" },\n",
" {\n",
" \"tradingDate\":\"19-Aug-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Moharram\",\n",
" \"Sr_no\":12\n",
" },\n",
" {\n",
" \"tradingDate\":\"10-Sep-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Ganesh Chaturthi\",\n",
" \"Sr_no\":13\n",
" },\n",
" {\n",
" \"tradingDate\":\"02-Oct-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Mahatma Gandhi Jayanti\",\n",
" \"Sr_no\":14\n",
" },\n",
" {\n",
" \"tradingDate\":\"15-Oct-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Dussehra\",\n",
" \"Sr_no\":15\n",
" },\n",
" {\n",
" \"tradingDate\":\"05-Nov-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Diwali-Balipratipada\",\n",
" \"Sr_no\":16\n",
" },\n",
" {\n",
" \"tradingDate\":\"19-Nov-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Gurunanak Jayanti\",\n",
" \"Sr_no\":17\n",
" },\n",
" {\n",
" \"tradingDate\":\"25-Dec-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Christmas\",\n",
" \"Sr_no\":18\n",
" }\n",
" ],\n",
" \"IRD\":[\n",
" {\n",
" \"tradingDate\":\"26-Jan-2021\",\n",
" \"weekDay\":\"Tuesday\",\n",
" \"description\":\"Republic Day\",\n",
" \"Sr_no\":1\n",
" },\n",
" {\n",
" \"tradingDate\":\"19-Feb-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Chatrapati Shivaji Jayanti\",\n",
" \"Sr_no\":2\n",
" },\n",
" {\n",
" \"tradingDate\":\"11-Mar-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Mahashivratri\",\n",
" \"Sr_no\":3\n",
" },\n",
" {\n",
" \"tradingDate\":\"29-Mar-2021\",\n",
" \"weekDay\":\"Monday\",\n",
" \"description\":\"Holi\",\n",
" \"Sr_no\":4\n",
" },\n",
" {\n",
" \"tradingDate\":\"01-Apr-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Annual Bank Closing\",\n",
" \"Sr_no\":5\n",
" },\n",
" {\n",
" \"tradingDate\":\"02-Apr-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Good Friday\",\n",
" \"Sr_no\":6\n",
" },\n",
" {\n",
" \"tradingDate\":\"13-Apr-2021\",\n",
" \"weekDay\":\"Tuesday\",\n",
" \"description\":\"Gudi Padwa\",\n",
" \"Sr_no\":7\n",
" },\n",
" {\n",
" \"tradingDate\":\"14-Apr-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Dr.Baba Saheb Ambedkar Jayanti\",\n",
" \"Sr_no\":8\n",
" },\n",
" {\n",
" \"tradingDate\":\"21-Apr-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Ram Navami\",\n",
" \"Sr_no\":9\n",
" },\n",
" {\n",
" \"tradingDate\":\"25-Apr-2021\",\n",
" \"weekDay\":\"Sunday\",\n",
" \"description\":\"Mahavir Jayanti\",\n",
" \"Sr_no\":10\n",
" },\n",
" {\n",
" \"tradingDate\":\"01-May-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Maharashtra Day\",\n",
" \"Sr_no\":11\n",
" },\n",
" {\n",
" \"tradingDate\":\"13-May-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Id-Ul-Fitr (Ramzan ID)\",\n",
" \"Sr_no\":12\n",
" },\n",
" {\n",
" \"tradingDate\":\"26-May-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Buddha Pournima\",\n",
" \"Sr_no\":13\n",
" },\n",
" {\n",
" \"tradingDate\":\"21-Jul-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Bakri Id\",\n",
" \"Sr_no\":14\n",
" },\n",
" {\n",
" \"tradingDate\":\"15-Aug-2021\",\n",
" \"weekDay\":\"Sunday\",\n",
" \"description\":\"Independence Day\",\n",
" \"Sr_no\":15\n",
" },\n",
" {\n",
" \"tradingDate\":\"16-Aug-2021\",\n",
" \"weekDay\":\"Monday\",\n",
" \"description\":\"Parsi New Year\",\n",
" \"Sr_no\":16\n",
" },\n",
" {\n",
" \"tradingDate\":\"19-Aug-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Moharram\",\n",
" \"Sr_no\":17\n",
" },\n",
" {\n",
" \"tradingDate\":\"10-Sep-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Ganesh Chaturthi\",\n",
" \"Sr_no\":18\n",
" },\n",
" {\n",
" \"tradingDate\":\"02-Oct-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Mahatma Gandhi Jayanti\",\n",
" \"Sr_no\":19\n",
" },\n",
" {\n",
" \"tradingDate\":\"15-Oct-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Dussehra\",\n",
" \"Sr_no\":20\n",
" },\n",
" {\n",
" \"tradingDate\":\"19-Oct-2021\",\n",
" \"weekDay\":\"Tuesday\",\n",
" \"description\":\"Id-E-Milad\",\n",
" \"Sr_no\":21\n",
" },\n",
" {\n",
" \"tradingDate\":\"05-Nov-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Diwali-Balipratipada\",\n",
" \"Sr_no\":22\n",
" },\n",
" {\n",
" \"tradingDate\":\"19-Nov-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Gurunanak Jayanti\",\n",
" \"Sr_no\":23\n",
" },\n",
" {\n",
" \"tradingDate\":\"25-Dec-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Christmas\",\n",
" \"Sr_no\":24\n",
" }\n",
" ],\n",
" \"MF\":[\n",
" {\n",
" \"tradingDate\":\"26-Jan-2021\",\n",
" \"weekDay\":\"Tuesday\",\n",
" \"description\":\"Republic Day\",\n",
" \"Sr_no\":1\n",
" },\n",
" {\n",
" \"tradingDate\":\"11-Mar-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Mahashivratri\",\n",
" \"Sr_no\":2\n",
" },\n",
" {\n",
" \"tradingDate\":\"29-Mar-2021\",\n",
" \"weekDay\":\"Monday\",\n",
" \"description\":\"Holi\",\n",
" \"Sr_no\":3\n",
" },\n",
" {\n",
" \"tradingDate\":\"02-Apr-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Good Friday\",\n",
" \"Sr_no\":4\n",
" },\n",
" {\n",
" \"tradingDate\":\"14-Apr-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Dr.Baba Saheb Ambedkar Jayanti\",\n",
" \"Sr_no\":5\n",
" },\n",
" {\n",
" \"tradingDate\":\"21-Apr-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Ram Navami\",\n",
" \"Sr_no\":6\n",
" },\n",
" {\n",
" \"tradingDate\":\"25-Apr-2021\",\n",
" \"weekDay\":\"Sunday\",\n",
" \"description\":\"Mahavir Jayanti\",\n",
" \"Sr_no\":7\n",
" },\n",
" {\n",
" \"tradingDate\":\"01-May-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Maharashtra Day\",\n",
" \"Sr_no\":8\n",
" },\n",
" {\n",
" \"tradingDate\":\"13-May-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Id-Ul-Fitr (Ramzan ID)\",\n",
" \"Sr_no\":9\n",
" },\n",
" {\n",
" \"tradingDate\":\"21-Jul-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Bakri Id\",\n",
" \"Sr_no\":10\n",
" },\n",
" {\n",
" \"tradingDate\":\"15-Aug-2021\",\n",
" \"weekDay\":\"Sunday\",\n",
" \"description\":\"Independence Day\",\n",
" \"Sr_no\":11\n",
" },\n",
" {\n",
" \"tradingDate\":\"19-Aug-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Moharram\",\n",
" \"Sr_no\":12\n",
" },\n",
" {\n",
" \"tradingDate\":\"10-Sep-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Ganesh Chaturthi\",\n",
" \"Sr_no\":13\n",
" },\n",
" {\n",
" \"tradingDate\":\"02-Oct-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Mahatma Gandhi Jayanti\",\n",
" \"Sr_no\":14\n",
" },\n",
" {\n",
" \"tradingDate\":\"15-Oct-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Dussehra\",\n",
" \"Sr_no\":15\n",
" },\n",
" {\n",
" \"tradingDate\":\"04-Nov-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Diwali-Laxmi Pujan\",\n",
" \"Sr_no\":16\n",
" },\n",
" {\n",
" \"tradingDate\":\"05-Nov-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Diwali-Balipratipada\",\n",
" \"Sr_no\":17\n",
" },\n",
" {\n",
" \"tradingDate\":\"19-Nov-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Gurunanak Jayanti\",\n",
" \"Sr_no\":18\n",
" },\n",
" {\n",
" \"tradingDate\":\"25-Dec-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Christmas\",\n",
" \"Sr_no\":19\n",
" }\n",
" ],\n",
" \"NDM\":[\n",
" {\n",
" \"tradingDate\":\"26-Jan-2021\",\n",
" \"weekDay\":\"Tuesday\",\n",
" \"description\":\"Republic Day\",\n",
" \"Sr_no\":1\n",
" },\n",
" {\n",
" \"tradingDate\":\"19-Feb-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Chatrapati Shivaji Jayanti\",\n",
" \"Sr_no\":2\n",
" },\n",
" {\n",
" \"tradingDate\":\"11-Mar-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Mahashivratri\",\n",
" \"Sr_no\":3\n",
" },\n",
" {\n",
" \"tradingDate\":\"29-Mar-2021\",\n",
" \"weekDay\":\"Monday\",\n",
" \"description\":\"Holi\",\n",
" \"Sr_no\":4\n",
" },\n",
" {\n",
" \"tradingDate\":\"01-Apr-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Annual Bank Closing\",\n",
" \"Sr_no\":5\n",
" },\n",
" {\n",
" \"tradingDate\":\"02-Apr-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Good Friday\",\n",
" \"Sr_no\":6\n",
" },\n",
" {\n",
" \"tradingDate\":\"13-Apr-2021\",\n",
" \"weekDay\":\"Tuesday\",\n",
" \"description\":\"Gudi Padwa\",\n",
" \"Sr_no\":7\n",
" },\n",
" {\n",
" \"tradingDate\":\"14-Apr-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Dr.Baba Saheb Ambedkar Jayanti\",\n",
" \"Sr_no\":8\n",
" },\n",
" {\n",
" \"tradingDate\":\"21-Apr-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Ram Navami\",\n",
" \"Sr_no\":9\n",
" },\n",
" {\n",
" \"tradingDate\":\"25-Apr-2021\",\n",
" \"weekDay\":\"Sunday\",\n",
" \"description\":\"Mahavir Jayanti\",\n",
" \"Sr_no\":10\n",
" },\n",
" {\n",
" \"tradingDate\":\"01-May-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Maharashtra Day\",\n",
" \"Sr_no\":11\n",
" },\n",
" {\n",
" \"tradingDate\":\"13-May-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Id-Ul-Fitr (Ramzan ID)\",\n",
" \"Sr_no\":12\n",
" },\n",
" {\n",
" \"tradingDate\":\"26-May-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Buddha Pournima\",\n",
" \"Sr_no\":13\n",
" },\n",
" {\n",
" \"tradingDate\":\"21-Jul-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Bakri Id\",\n",
" \"Sr_no\":14\n",
" },\n",
" {\n",
" \"tradingDate\":\"15-Aug-2021\",\n",
" \"weekDay\":\"Sunday\",\n",
" \"description\":\"Independence Day\",\n",
" \"Sr_no\":15\n",
" },\n",
" {\n",
" \"tradingDate\":\"16-Aug-2021\",\n",
" \"weekDay\":\"Monday\",\n",
" \"description\":\"Parsi New Year\",\n",
" \"Sr_no\":16\n",
" },\n",
" {\n",
" \"tradingDate\":\"19-Aug-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Moharram\",\n",
" \"Sr_no\":17\n",
" },\n",
" {\n",
" \"tradingDate\":\"10-Sep-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Ganesh Chaturthi\",\n",
" \"Sr_no\":18\n",
" },\n",
" {\n",
" \"tradingDate\":\"02-Oct-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Mahatma Gandhi Jayanti\",\n",
" \"Sr_no\":19\n",
" },\n",
" {\n",
" \"tradingDate\":\"15-Oct-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Dussehra\",\n",
" \"Sr_no\":20\n",
" },\n",
" {\n",
" \"tradingDate\":\"19-Oct-2021\",\n",
" \"weekDay\":\"Tuesday\",\n",
" \"description\":\"Id-E-Milad\",\n",
" \"Sr_no\":21\n",
" },\n",
" {\n",
" \"tradingDate\":\"04-Nov-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Diwali-Laxmi Pujan\",\n",
" \"Sr_no\":22\n",
" },\n",
" {\n",
" \"tradingDate\":\"05-Nov-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Diwali-Balipratipada\",\n",
" \"Sr_no\":23\n",
" },\n",
" {\n",
" \"tradingDate\":\"19-Nov-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Gurunanak Jayanti\",\n",
" \"Sr_no\":24\n",
" },\n",
" {\n",
" \"tradingDate\":\"25-Dec-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Christmas\",\n",
" \"Sr_no\":25\n",
" }\n",
" ],\n",
" \"NTRP\":[\n",
" {\n",
" \"tradingDate\":\"26-Jan-2021\",\n",
" \"weekDay\":\"Tuesday\",\n",
" \"description\":\"Republic Day\",\n",
" \"Sr_no\":1\n",
" },\n",
" {\n",
" \"tradingDate\":\"19-Feb-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Chatrapati Shivaji Jayanti\",\n",
" \"Sr_no\":2\n",
" },\n",
" {\n",
" \"tradingDate\":\"11-Mar-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Mahashivratri\",\n",
" \"Sr_no\":3\n",
" },\n",
" {\n",
" \"tradingDate\":\"29-Mar-2021\",\n",
" \"weekDay\":\"Monday\",\n",
" \"description\":\"Holi\",\n",
" \"Sr_no\":4\n",
" },\n",
" {\n",
" \"tradingDate\":\"01-Apr-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Annual Bank Closing\",\n",
" \"Sr_no\":5\n",
" },\n",
" {\n",
" \"tradingDate\":\"02-Apr-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Good Friday\",\n",
" \"Sr_no\":6\n",
" },\n",
" {\n",
" \"tradingDate\":\"13-Apr-2021\",\n",
" \"weekDay\":\"Tuesday\",\n",
" \"description\":\"Gudi Padwa\",\n",
" \"Sr_no\":7\n",
" },\n",
" {\n",
" \"tradingDate\":\"14-Apr-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Dr.Baba Saheb Ambedkar Jayanti\",\n",
" \"Sr_no\":8\n",
" },\n",
" {\n",
" \"tradingDate\":\"21-Apr-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Ram Navami\",\n",
" \"Sr_no\":9\n",
" },\n",
" {\n",
" \"tradingDate\":\"25-Apr-2021\",\n",
" \"weekDay\":\"Sunday\",\n",
" \"description\":\"Mahavir Jayanti\",\n",
" \"Sr_no\":10\n",
" },\n",
" {\n",
" \"tradingDate\":\"01-May-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Maharashtra Day\",\n",
" \"Sr_no\":11\n",
" },\n",
" {\n",
" \"tradingDate\":\"13-May-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Id-Ul-Fitr (Ramzan ID)\",\n",
" \"Sr_no\":12\n",
" },\n",
" {\n",
" \"tradingDate\":\"26-May-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Buddha Pournima\",\n",
" \"Sr_no\":13\n",
" },\n",
" {\n",
" \"tradingDate\":\"21-Jul-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Bakri Id\",\n",
" \"Sr_no\":14\n",
" },\n",
" {\n",
" \"tradingDate\":\"15-Aug-2021\",\n",
" \"weekDay\":\"Sunday\",\n",
" \"description\":\"Independence Day\",\n",
" \"Sr_no\":15\n",
" },\n",
" {\n",
" \"tradingDate\":\"16-Aug-2021\",\n",
" \"weekDay\":\"Monday\",\n",
" \"description\":\"Parsi New Year\",\n",
" \"Sr_no\":16\n",
" },\n",
" {\n",
" \"tradingDate\":\"19-Aug-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Moharram\",\n",
" \"Sr_no\":17\n",
" },\n",
" {\n",
" \"tradingDate\":\"10-Sep-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Ganesh Chaturthi\",\n",
" \"Sr_no\":18\n",
" },\n",
" {\n",
" \"tradingDate\":\"02-Oct-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Mahatma Gandhi Jayanti\",\n",
" \"Sr_no\":19\n",
" },\n",
" {\n",
" \"tradingDate\":\"15-Oct-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Dussehra\",\n",
" \"Sr_no\":20\n",
" },\n",
" {\n",
" \"tradingDate\":\"19-Oct-2021\",\n",
" \"weekDay\":\"Tuesday\",\n",
" \"description\":\"Id-E-Milad\",\n",
" \"Sr_no\":21\n",
" },\n",
" {\n",
" \"tradingDate\":\"04-Nov-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Diwali-Laxmi Pujan\",\n",
" \"Sr_no\":22\n",
" },\n",
" {\n",
" \"tradingDate\":\"05-Nov-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Diwali-Balipratipada\",\n",
" \"Sr_no\":23\n",
" },\n",
" {\n",
" \"tradingDate\":\"19-Nov-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Gurunanak Jayanti\",\n",
" \"Sr_no\":24\n",
" },\n",
" {\n",
" \"tradingDate\":\"25-Dec-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Christmas\",\n",
" \"Sr_no\":25\n",
" }\n",
" ],\n",
" \"SLBS\":[\n",
" {\n",
" \"tradingDate\":\"26-Jan-2021\",\n",
" \"weekDay\":\"Tuesday\",\n",
" \"description\":\"Republic Day\",\n",
" \"Sr_no\":1\n",
" },\n",
" {\n",
" \"tradingDate\":\"11-Mar-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Mahashivratri\",\n",
" \"Sr_no\":2\n",
" },\n",
" {\n",
" \"tradingDate\":\"29-Mar-2021\",\n",
" \"weekDay\":\"Monday\",\n",
" \"description\":\"Holi\",\n",
" \"Sr_no\":3\n",
" },\n",
" {\n",
" \"tradingDate\":\"02-Apr-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Good Friday\",\n",
" \"Sr_no\":4\n",
" },\n",
" {\n",
" \"tradingDate\":\"14-Apr-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Dr.Baba Saheb Ambedkar Jayanti\",\n",
" \"Sr_no\":5\n",
" },\n",
" {\n",
" \"tradingDate\":\"21-Apr-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Ram Navami\",\n",
" \"Sr_no\":6\n",
" },\n",
" {\n",
" \"tradingDate\":\"25-Apr-2021\",\n",
" \"weekDay\":\"Sunday\",\n",
" \"description\":\"Mahavir Jayanti\",\n",
" \"Sr_no\":7\n",
" },\n",
" {\n",
" \"tradingDate\":\"01-May-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Maharashtra Day\",\n",
" \"Sr_no\":8\n",
" },\n",
" {\n",
" \"tradingDate\":\"13-May-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Id-Ul-Fitr (Ramzan ID)\",\n",
" \"Sr_no\":9\n",
" },\n",
" {\n",
" \"tradingDate\":\"21-Jul-2021\",\n",
" \"weekDay\":\"Wednesday\",\n",
" \"description\":\"Bakri Id\",\n",
" \"Sr_no\":10\n",
" },\n",
" {\n",
" \"tradingDate\":\"15-Aug-2021\",\n",
" \"weekDay\":\"Sunday\",\n",
" \"description\":\"Independence Day\",\n",
" \"Sr_no\":11\n",
" },\n",
" {\n",
" \"tradingDate\":\"19-Aug-2021\",\n",
" \"weekDay\":\"Thursday\",\n",
" \"description\":\"Moharram\",\n",
" \"Sr_no\":12\n",
" },\n",
" {\n",
" \"tradingDate\":\"10-Sep-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Ganesh Chaturthi\",\n",
" \"Sr_no\":13\n",
" },\n",
" {\n",
" \"tradingDate\":\"02-Oct-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Mahatma Gandhi Jayanti\",\n",
" \"Sr_no\":14\n",
" },\n",
" {\n",
" \"tradingDate\":\"15-Oct-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Dussehra\",\n",
" \"Sr_no\":15\n",
" },\n",
" {\n",
" \"tradingDate\":\"05-Nov-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Diwali-Balipratipada\",\n",
" \"Sr_no\":16\n",
" },\n",
" {\n",
" \"tradingDate\":\"19-Nov-2021\",\n",
" \"weekDay\":\"Friday\",\n",
" \"description\":\"Gurunanak Jayanti\",\n",
" \"Sr_no\":17\n",
" },\n",
" {\n",
" \"tradingDate\":\"25-Dec-2021\",\n",
" \"weekDay\":\"Saturday\",\n",
" \"description\":\"Christmas\",\n",
" \"Sr_no\":18\n",
" }\n",
" ]\n",
"}'''"
],
"execution_count": 6,
"outputs": []
},
{
"cell_type": "code",
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/"
},
"id": "kt1kxYNQ39aE",
"outputId": "3f53dbb8-7ffc-4421-d977-749d94aeaddc"
},
"source": [
"import json\n",
"stuff = json.loads(json_data)\n",
"stuff['CBM']"
],
"execution_count": 8,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"[{'Sr_no': 1,\n",
" 'description': 'Republic Day',\n",
" 'tradingDate': '26-Jan-2021',\n",
" 'weekDay': 'Tuesday'},\n",
" {'Sr_no': 2,\n",
" 'description': 'Chatrapati Shivaji Jayanti',\n",
" 'tradingDate': '19-Feb-2021',\n",
" 'weekDay': 'Friday'},\n",
" {'Sr_no': 3,\n",
" 'description': 'Mahashivratri',\n",
" 'tradingDate': '11-Mar-2021',\n",
" 'weekDay': 'Thursday'},\n",
" {'Sr_no': 4,\n",
" 'description': 'Holi',\n",
" 'tradingDate': '29-Mar-2021',\n",
" 'weekDay': 'Monday'},\n",
" {'Sr_no': 5,\n",
" 'description': 'Annual Bank Closing',\n",
" 'tradingDate': '01-Apr-2021',\n",
" 'weekDay': 'Thursday'},\n",
" {'Sr_no': 6,\n",
" 'description': 'Good Friday',\n",
" 'tradingDate': '02-Apr-2021',\n",
" 'weekDay': 'Friday'},\n",
" {'Sr_no': 7,\n",
" 'description': 'Gudi Padwa',\n",
" 'tradingDate': '13-Apr-2021',\n",
" 'weekDay': 'Tuesday'},\n",
" {'Sr_no': 8,\n",
" 'description': 'Dr.Baba Saheb Ambedkar Jayanti',\n",
" 'tradingDate': '14-Apr-2021',\n",
" 'weekDay': 'Wednesday'},\n",
" {'Sr_no': 9,\n",
" 'description': 'Ram Navami',\n",
" 'tradingDate': '21-Apr-2021',\n",
" 'weekDay': 'Wednesday'},\n",
" {'Sr_no': 10,\n",
" 'description': 'Mahavir Jayanti',\n",
" 'tradingDate': '25-Apr-2021',\n",
" 'weekDay': 'Sunday'},\n",
" {'Sr_no': 11,\n",
" 'description': 'Maharashtra Day',\n",
" 'tradingDate': '01-May-2021',\n",
" 'weekDay': 'Saturday'},\n",
" {'Sr_no': 12,\n",
" 'description': 'Id-Ul-Fitr (Ramzan ID)',\n",
" 'tradingDate': '13-May-2021',\n",
" 'weekDay': 'Thursday'},\n",
" {'Sr_no': 13,\n",
" 'description': 'Buddha Pournima',\n",
" 'tradingDate': '26-May-2021',\n",
" 'weekDay': 'Wednesday'},\n",
" {'Sr_no': 14,\n",
" 'description': 'Bakri Id',\n",
" 'tradingDate': '21-Jul-2021',\n",
" 'weekDay': 'Wednesday'},\n",
" {'Sr_no': 15,\n",
" 'description': 'Independence Day',\n",
" 'tradingDate': '15-Aug-2021',\n",
" 'weekDay': 'Sunday'},\n",
" {'Sr_no': 16,\n",
" 'description': 'Parsi New Year',\n",
" 'tradingDate': '16-Aug-2021',\n",
" 'weekDay': 'Monday'},\n",
" {'Sr_no': 17,\n",
" 'description': 'Moharram',\n",
" 'tradingDate': '19-Aug-2021',\n",
" 'weekDay': 'Thursday'},\n",
" {'Sr_no': 18,\n",
" 'description': 'Ganesh Chaturthi',\n",
" 'tradingDate': '10-Sep-2021',\n",
" 'weekDay': 'Friday'},\n",
" {'Sr_no': 19,\n",
" 'description': 'Mahatma Gandhi Jayanti',\n",
" 'tradingDate': '02-Oct-2021',\n",
" 'weekDay': 'Saturday'},\n",
" {'Sr_no': 20,\n",
" 'description': 'Dussehra',\n",
" 'tradingDate': '15-Oct-2021',\n",
" 'weekDay': 'Friday'},\n",
" {'Sr_no': 21,\n",
" 'description': 'Id-E-Milad',\n",
" 'tradingDate': '19-Oct-2021',\n",
" 'weekDay': 'Tuesday'},\n",
" {'Sr_no': 22,\n",
" 'description': 'Diwali-Laxmi Pujan',\n",
" 'tradingDate': '04-Nov-2021',\n",
" 'weekDay': 'Thursday'},\n",
" {'Sr_no': 23,\n",
" 'description': 'Diwali-Balipratipada',\n",
" 'tradingDate': '05-Nov-2021',\n",
" 'weekDay': 'Friday'},\n",
" {'Sr_no': 24,\n",
" 'description': 'Gurunanak Jayanti',\n",
" 'tradingDate': '19-Nov-2021',\n",
" 'weekDay': 'Friday'},\n",
" {'Sr_no': 25,\n",
" 'description': 'Christmas',\n",
" 'tradingDate': '25-Dec-2021',\n",
" 'weekDay': 'Saturday'}]"
]
},
"metadata": {
"tags": []
},
"execution_count": 8
}
]
},
{
"cell_type": "code",
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 787
},
"id": "ByvWi4qH4ruO",
"outputId": "a2c7e683-195e-49b9-ab9e-3d3a23d474f8"
},
"source": [
"import pandas as pd \n",
"data = pd.DataFrame.from_records(stuff['CBM'])\n",
"data"
],
"execution_count": 11,
"outputs": [
{
"output_type": "execute_result",
"data": {
"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>tradingDate</th>\n",
" <th>weekDay</th>\n",
" <th>description</th>\n",
" <th>Sr_no</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>26-Jan-2021</td>\n",
" <td>Tuesday</td>\n",
" <td>Republic Day</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>19-Feb-2021</td>\n",
" <td>Friday</td>\n",
" <td>Chatrapati Shivaji Jayanti</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>11-Mar-2021</td>\n",
" <td>Thursday</td>\n",
" <td>Mahashivratri</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>29-Mar-2021</td>\n",
" <td>Monday</td>\n",
" <td>Holi</td>\n",
" <td>4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>01-Apr-2021</td>\n",
" <td>Thursday</td>\n",
" <td>Annual Bank Closing</td>\n",
" <td>5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>02-Apr-2021</td>\n",
" <td>Friday</td>\n",
" <td>Good Friday</td>\n",
" <td>6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>13-Apr-2021</td>\n",
" <td>Tuesday</td>\n",
" <td>Gudi Padwa</td>\n",
" <td>7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>14-Apr-2021</td>\n",
" <td>Wednesday</td>\n",
" <td>Dr.Baba Saheb Ambedkar Jayanti</td>\n",
" <td>8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>21-Apr-2021</td>\n",
" <td>Wednesday</td>\n",
" <td>Ram Navami</td>\n",
" <td>9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>25-Apr-2021</td>\n",
" <td>Sunday</td>\n",
" <td>Mahavir Jayanti</td>\n",
" <td>10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>01-May-2021</td>\n",
" <td>Saturday</td>\n",
" <td>Maharashtra Day</td>\n",
" <td>11</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>13-May-2021</td>\n",
" <td>Thursday</td>\n",
" <td>Id-Ul-Fitr (Ramzan ID)</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>26-May-2021</td>\n",
" <td>Wednesday</td>\n",
" <td>Buddha Pournima</td>\n",
" <td>13</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>21-Jul-2021</td>\n",
" <td>Wednesday</td>\n",
" <td>Bakri Id</td>\n",
" <td>14</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>15-Aug-2021</td>\n",
" <td>Sunday</td>\n",
" <td>Independence Day</td>\n",
" <td>15</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>16-Aug-2021</td>\n",
" <td>Monday</td>\n",
" <td>Parsi New Year</td>\n",
" <td>16</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>19-Aug-2021</td>\n",
" <td>Thursday</td>\n",
" <td>Moharram</td>\n",
" <td>17</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>10-Sep-2021</td>\n",
" <td>Friday</td>\n",
" <td>Ganesh Chaturthi</td>\n",
" <td>18</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>02-Oct-2021</td>\n",
" <td>Saturday</td>\n",
" <td>Mahatma Gandhi Jayanti</td>\n",
" <td>19</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>15-Oct-2021</td>\n",
" <td>Friday</td>\n",
" <td>Dussehra</td>\n",
" <td>20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>19-Oct-2021</td>\n",
" <td>Tuesday</td>\n",
" <td>Id-E-Milad</td>\n",
" <td>21</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>04-Nov-2021</td>\n",
" <td>Thursday</td>\n",
" <td>Diwali-Laxmi Pujan</td>\n",
" <td>22</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>05-Nov-2021</td>\n",
" <td>Friday</td>\n",
" <td>Diwali-Balipratipada</td>\n",
" <td>23</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>19-Nov-2021</td>\n",
" <td>Friday</td>\n",
" <td>Gurunanak Jayanti</td>\n",
" <td>24</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>25-Dec-2021</td>\n",
" <td>Saturday</td>\n",
" <td>Christmas</td>\n",
" <td>25</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" tradingDate weekDay description Sr_no\n",
"0 26-Jan-2021 Tuesday Republic Day 1\n",
"1 19-Feb-2021 Friday Chatrapati Shivaji Jayanti 2\n",
"2 11-Mar-2021 Thursday Mahashivratri 3\n",
"3 29-Mar-2021 Monday Holi 4\n",
"4 01-Apr-2021 Thursday Annual Bank Closing 5\n",
"5 02-Apr-2021 Friday Good Friday 6\n",
"6 13-Apr-2021 Tuesday Gudi Padwa 7\n",
"7 14-Apr-2021 Wednesday Dr.Baba Saheb Ambedkar Jayanti 8\n",
"8 21-Apr-2021 Wednesday Ram Navami 9\n",
"9 25-Apr-2021 Sunday Mahavir Jayanti 10\n",
"10 01-May-2021 Saturday Maharashtra Day 11\n",
"11 13-May-2021 Thursday Id-Ul-Fitr (Ramzan ID) 12\n",
"12 26-May-2021 Wednesday Buddha Pournima 13\n",
"13 21-Jul-2021 Wednesday Bakri Id 14\n",
"14 15-Aug-2021 Sunday Independence Day 15\n",
"15 16-Aug-2021 Monday Parsi New Year 16\n",
"16 19-Aug-2021 Thursday Moharram 17\n",
"17 10-Sep-2021 Friday Ganesh Chaturthi 18\n",
"18 02-Oct-2021 Saturday Mahatma Gandhi Jayanti 19\n",
"19 15-Oct-2021 Friday Dussehra 20\n",
"20 19-Oct-2021 Tuesday Id-E-Milad 21\n",
"21 04-Nov-2021 Thursday Diwali-Laxmi Pujan 22\n",
"22 05-Nov-2021 Friday Diwali-Balipratipada 23\n",
"23 19-Nov-2021 Friday Gurunanak Jayanti 24\n",
"24 25-Dec-2021 Saturday Christmas 25"
]
},
"metadata": {
"tags": []
},
"execution_count": 11
}
]
},
{
"cell_type": "code",
"metadata": {
"id": "zysq7lml4Fly"
},
"source": [
""
],
"execution_count": null,
"outputs": []
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment