managing_material.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "71fd0d10-86f3-467f-80fd-96ee2bb04b82",
   "metadata": {},
   "outputs": [],
   "source": [
    "import glob"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "467ae95a-ff19-48b7-8a84-665117ee2b01",
   "metadata": {},
   "outputs": [],
   "source": [
    "def update_notebook(notebook_content):\n",
    "    cells = notebook_content['cells']\n",
    "    new_cells = []\n",
    "    idx = 0\n",
    "    for cell in cells:\n",
    "        if cell.get('outputs'):\n",
    "            cell['outputs'] = []\n",
    "        if cell['cell_type'] == 'code':\n",
    "            cell['execution_count'] = None\n",
    "        if idx == len(cells):\n",
    "            break\n",
    "        if len(cell['source']) > 0 and not cell['source'][0].startswith('%%HTML'):\n",
    "            new_cells.append(cells[idx])\n",
    "        if len(cell['source']) > 0 and cell['source'][0].startswith('%%HTML') and cells[idx - 1]['cell_type'] == 'markdown' and cells[idx + 1]['cell_type'] == 'markdown':\n",
    "            cells[idx - 1]['source'] = cells[idx - 1]['source'] + cells[idx + 1]['source']\n",
    "            idx += 1\n",
    "        idx += 1\n",
    "    notebook_content['cells'] = new_cells\n",
    "    return notebook_content"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "83ce4585-b686-4fc2-bed1-513e2528697d",
   "metadata": {},
   "outputs": [],
   "source": [
    "notebooks = glob.glob('python-and-sql-material/*/*.ipynb')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "c33ed7b3-b524-4b4d-a6a6-c47f08dd69b1",
   "metadata": {},
   "outputs": [],
   "source": [
    "import json"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "7e1ecda9-6034-41ff-a0f4-e74dc38ec6b4",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "processing python-and-sql-material/19_writing_advanced_sql_queries/12_analytic_functions_windowing.ipynb\n",
      "Notebook already signed: python-and-sql-material/19_writing_advanced_sql_queries/12_analytic_functions_windowing.ipynb\n",
      "processing python-and-sql-material/19_writing_advanced_sql_queries/16_exercises_analytic_functions.ipynb\n",
      "Notebook already signed: python-and-sql-material/19_writing_advanced_sql_queries/16_exercises_analytic_functions.ipynb\n",
      "processing python-and-sql-material/19_writing_advanced_sql_queries/09_overview_of_analytic_functions.ipynb\n",
      "Notebook already signed: python-and-sql-material/19_writing_advanced_sql_queries/09_overview_of_analytic_functions.ipynb\n",
      "processing python-and-sql-material/19_writing_advanced_sql_queries/10_analytic_functions_aggregations.ipynb\n",
      "Notebook already signed: python-and-sql-material/19_writing_advanced_sql_queries/10_analytic_functions_aggregations.ipynb\n",
      "processing python-and-sql-material/19_writing_advanced_sql_queries/08_pivoting_rows_into_columns.ipynb\n",
      "Notebook already signed: python-and-sql-material/19_writing_advanced_sql_queries/08_pivoting_rows_into_columns.ipynb\n",
      "processing python-and-sql-material/19_writing_advanced_sql_queries/11_cumulative_or_moving_aggregations.ipynb\n",
      "Notebook already signed: python-and-sql-material/19_writing_advanced_sql_queries/11_cumulative_or_moving_aggregations.ipynb\n",
      "processing python-and-sql-material/19_writing_advanced_sql_queries/02_overview_of_views.ipynb\n",
      "Notebook already signed: python-and-sql-material/19_writing_advanced_sql_queries/02_overview_of_views.ipynb\n",
      "processing python-and-sql-material/19_writing_advanced_sql_queries/04_overview_of_sub_queries.ipynb\n",
      "Notebook already signed: python-and-sql-material/19_writing_advanced_sql_queries/04_overview_of_sub_queries.ipynb\n",
      "processing python-and-sql-material/19_writing_advanced_sql_queries/01_writing_advanced_sql_queries.ipynb\n",
      "Notebook already signed: python-and-sql-material/19_writing_advanced_sql_queries/01_writing_advanced_sql_queries.ipynb\n",
      "processing python-and-sql-material/19_writing_advanced_sql_queries/13_analytic_functions_ranking.ipynb\n",
      "Notebook already signed: python-and-sql-material/19_writing_advanced_sql_queries/13_analytic_functions_ranking.ipynb\n",
      "processing python-and-sql-material/19_writing_advanced_sql_queries/14_analytic_funcions_filtering.ipynb\n",
      "Notebook already signed: python-and-sql-material/19_writing_advanced_sql_queries/14_analytic_funcions_filtering.ipynb\n",
      "processing python-and-sql-material/19_writing_advanced_sql_queries/07_merging_or_upserting_data.ipynb\n",
      "Notebook already signed: python-and-sql-material/19_writing_advanced_sql_queries/07_merging_or_upserting_data.ipynb\n",
      "processing python-and-sql-material/19_writing_advanced_sql_queries/06_advanced_dml_operations.ipynb\n",
      "Notebook already signed: python-and-sql-material/19_writing_advanced_sql_queries/06_advanced_dml_operations.ipynb\n",
      "processing python-and-sql-material/19_writing_advanced_sql_queries/05_create_table_as_select.ipynb\n",
      "Notebook already signed: python-and-sql-material/19_writing_advanced_sql_queries/05_create_table_as_select.ipynb\n",
      "processing python-and-sql-material/19_writing_advanced_sql_queries/15_ranking_and_filtering_recap.ipynb\n",
      "Notebook already signed: python-and-sql-material/19_writing_advanced_sql_queries/15_ranking_and_filtering_recap.ipynb\n",
      "processing python-and-sql-material/19_writing_advanced_sql_queries/03_named_queries_using_with_clause.ipynb\n",
      "Notebook already signed: python-and-sql-material/19_writing_advanced_sql_queries/03_named_queries_using_with_clause.ipynb\n",
      "processing python-and-sql-material/15_writing_basic_sql_queries/01_writing_basic_sql_queries.ipynb\n",
      "Notebook already signed: python-and-sql-material/15_writing_basic_sql_queries/01_writing_basic_sql_queries.ipynb\n",
      "processing python-and-sql-material/15_writing_basic_sql_queries/13_exercises_basic_sql_queries.ipynb\n",
      "Notebook already signed: python-and-sql-material/15_writing_basic_sql_queries/13_exercises_basic_sql_queries.ipynb\n",
      "processing python-and-sql-material/15_writing_basic_sql_queries/02_standard_transformations.ipynb\n",
      "Notebook already signed: python-and-sql-material/15_writing_basic_sql_queries/02_standard_transformations.ipynb\n",
      "processing python-and-sql-material/15_writing_basic_sql_queries/07_filtering_data.ipynb\n",
      "Notebook already signed: python-and-sql-material/15_writing_basic_sql_queries/07_filtering_data.ipynb\n",
      "processing python-and-sql-material/15_writing_basic_sql_queries/11_sorting_data.ipynb\n",
      "Notebook already signed: python-and-sql-material/15_writing_basic_sql_queries/11_sorting_data.ipynb\n",
      "processing python-and-sql-material/15_writing_basic_sql_queries/04_define_problem_statement.ipynb\n",
      "Notebook already signed: python-and-sql-material/15_writing_basic_sql_queries/04_define_problem_statement.ipynb\n",
      "processing python-and-sql-material/15_writing_basic_sql_queries/06_selecting_or_projecting_data.ipynb\n",
      "Notebook already signed: python-and-sql-material/15_writing_basic_sql_queries/06_selecting_or_projecting_data.ipynb\n",
      "processing python-and-sql-material/15_writing_basic_sql_queries/08_joining_tables_inner.ipynb\n",
      "Notebook already signed: python-and-sql-material/15_writing_basic_sql_queries/08_joining_tables_inner.ipynb\n",
      "processing python-and-sql-material/15_writing_basic_sql_queries/09_joining_tables_outer.ipynb\n",
      "Notebook already signed: python-and-sql-material/15_writing_basic_sql_queries/09_joining_tables_outer.ipynb\n",
      "processing python-and-sql-material/15_writing_basic_sql_queries/12_solution_daily_product_revenue.ipynb\n",
      "Notebook already signed: python-and-sql-material/15_writing_basic_sql_queries/12_solution_daily_product_revenue.ipynb\n",
      "processing python-and-sql-material/15_writing_basic_sql_queries/03_overview_of_data_model.ipynb\n",
      "Notebook already signed: python-and-sql-material/15_writing_basic_sql_queries/03_overview_of_data_model.ipynb\n",
      "processing python-and-sql-material/15_writing_basic_sql_queries/10_performing_aggregations.ipynb\n",
      "Notebook already signed: python-and-sql-material/15_writing_basic_sql_queries/10_performing_aggregations.ipynb\n",
      "processing python-and-sql-material/15_writing_basic_sql_queries/05_preparing_tables.ipynb\n",
      "Notebook already signed: python-and-sql-material/15_writing_basic_sql_queries/05_preparing_tables.ipynb\n",
      "processing python-and-sql-material/09_python_collections_practice_tests/07_get_unique_programming_languages.ipynb\n",
      "Notebook already signed: python-and-sql-material/09_python_collections_practice_tests/07_get_unique_programming_languages.ipynb\n",
      "processing python-and-sql-material/09_python_collections_practice_tests/17_get_all_unique_reasons.ipynb\n",
      "Notebook already signed: python-and-sql-material/09_python_collections_practice_tests/17_get_all_unique_reasons.ipynb\n",
      "processing python-and-sql-material/09_python_collections_practice_tests/10_get_revenue_per_purchase.ipynb\n",
      "Notebook already signed: python-and-sql-material/09_python_collections_practice_tests/10_get_revenue_per_purchase.ipynb\n",
      "processing python-and-sql-material/09_python_collections_practice_tests/03_sort_data_by_scheduled_dates.ipynb\n",
      "Notebook already signed: python-and-sql-material/09_python_collections_practice_tests/03_sort_data_by_scheduled_dates.ipynb\n",
      "processing python-and-sql-material/09_python_collections_practice_tests/13_filter_companies_by_sector.ipynb\n",
      "Notebook already signed: python-and-sql-material/09_python_collections_practice_tests/13_filter_companies_by_sector.ipynb\n",
      "processing python-and-sql-material/09_python_collections_practice_tests/21_apply_schema_to_bike_details.ipynb\n",
      "Notebook already signed: python-and-sql-material/09_python_collections_practice_tests/21_apply_schema_to_bike_details.ipynb\n",
      "processing python-and-sql-material/09_python_collections_practice_tests/22_cleanup_keys_for_mobile_details.ipynb\n",
      "Notebook already signed: python-and-sql-material/09_python_collections_practice_tests/22_cleanup_keys_for_mobile_details.ipynb\n",
      "processing python-and-sql-material/09_python_collections_practice_tests/01_number_of_occurences_of_element_in_list.ipynb\n",
      "Notebook already signed: python-and-sql-material/09_python_collections_practice_tests/01_number_of_occurences_of_element_in_list.ipynb\n",
      "processing python-and-sql-material/09_python_collections_practice_tests/11_get_top_student_by_total_score.ipynb\n",
      "Notebook already signed: python-and-sql-material/09_python_collections_practice_tests/11_get_top_student_by_total_score.ipynb\n",
      "processing python-and-sql-material/09_python_collections_practice_tests/15_apply_schema_to_companies_data.ipynb\n",
      "Notebook already signed: python-and-sql-material/09_python_collections_practice_tests/15_apply_schema_to_companies_data.ipynb\n",
      "processing python-and-sql-material/09_python_collections_practice_tests/06_get_number_of_courses_for_a_level.ipynb\n",
      "Notebook already signed: python-and-sql-material/09_python_collections_practice_tests/06_get_number_of_courses_for_a_level.ipynb\n",
      "processing python-and-sql-material/09_python_collections_practice_tests/09_get_number_of_companies_per_sector.ipynb\n",
      "Notebook already signed: python-and-sql-material/09_python_collections_practice_tests/09_get_number_of_companies_per_sector.ipynb\n",
      "processing python-and-sql-material/09_python_collections_practice_tests/05_sort_courses_by_enrollments.ipynb\n",
      "Notebook already signed: python-and-sql-material/09_python_collections_practice_tests/05_sort_courses_by_enrollments.ipynb\n",
      "processing python-and-sql-material/09_python_collections_practice_tests/08_filter_mobiles_by_ram_and_storage.ipynb\n",
      "Notebook already signed: python-and-sql-material/09_python_collections_practice_tests/08_filter_mobiles_by_ram_and_storage.ipynb\n",
      "processing python-and-sql-material/09_python_collections_practice_tests/19_advanced_sort_courses_by_level_and_ratings.ipynb\n",
      "Notebook already signed: python-and-sql-material/09_python_collections_practice_tests/19_advanced_sort_courses_by_level_and_ratings.ipynb\n",
      "processing python-and-sql-material/09_python_collections_practice_tests/14_get_list_of_companies_per_sector.ipynb\n",
      "Notebook already signed: python-and-sql-material/09_python_collections_practice_tests/14_get_list_of_companies_per_sector.ipynb\n",
      "processing python-and-sql-material/09_python_collections_practice_tests/18_get_top_companies_by_stock_price.ipynb\n",
      "Notebook already signed: python-and-sql-material/09_python_collections_practice_tests/18_get_top_companies_by_stock_price.ipynb\n",
      "processing python-and-sql-material/09_python_collections_practice_tests/23_apply_schema_to_students.ipynb\n",
      "Notebook already signed: python-and-sql-material/09_python_collections_practice_tests/23_apply_schema_to_students.ipynb\n",
      "processing python-and-sql-material/09_python_collections_practice_tests/16_get_student_total_score.ipynb\n",
      "Notebook already signed: python-and-sql-material/09_python_collections_practice_tests/16_get_student_total_score.ipynb\n",
      "processing python-and-sql-material/09_python_collections_practice_tests/04_check_color_in_list_of_tuples.ipynb\n",
      "Notebook already signed: python-and-sql-material/09_python_collections_practice_tests/04_check_color_in_list_of_tuples.ipynb\n",
      "processing python-and-sql-material/09_python_collections_practice_tests/12_sort_courses_by_level_and_enrollments.ipynb\n",
      "Notebook already signed: python-and-sql-material/09_python_collections_practice_tests/12_sort_courses_by_level_and_enrollments.ipynb\n",
      "processing python-and-sql-material/09_python_collections_practice_tests/20_get_list_of_companies_by_dividend.ipynb\n",
      "Notebook already signed: python-and-sql-material/09_python_collections_practice_tests/20_get_list_of_companies_by_dividend.ipynb\n",
      "processing python-and-sql-material/09_python_collections_practice_tests/02_get_list_of_beginner_courses.ipynb\n",
      "Notebook already signed: python-and-sql-material/09_python_collections_practice_tests/02_get_list_of_beginner_courses.ipynb\n",
      "processing python-and-sql-material/05_overview_of_collections_list_and_set/05_adding_elements_to_list.ipynb\n",
      "Notebook already signed: python-and-sql-material/05_overview_of_collections_list_and_set/05_adding_elements_to_list.ipynb\n",
      "processing python-and-sql-material/05_overview_of_collections_list_and_set/01_overview_of_collections_list_and_set.ipynb\n",
      "Notebook already signed: python-and-sql-material/05_overview_of_collections_list_and_set/01_overview_of_collections_list_and_set.ipynb\n",
      "processing python-and-sql-material/05_overview_of_collections_list_and_set/07_other_list_operations.ipynb\n",
      "Notebook already signed: python-and-sql-material/05_overview_of_collections_list_and_set/07_other_list_operations.ipynb\n",
      "processing python-and-sql-material/05_overview_of_collections_list_and_set/12_exercises_list_and_set.ipynb\n",
      "Notebook already signed: python-and-sql-material/05_overview_of_collections_list_and_set/12_exercises_list_and_set.ipynb\n",
      "processing python-and-sql-material/05_overview_of_collections_list_and_set/08_adding_and_deleting_elements_set.ipynb\n",
      "Notebook already signed: python-and-sql-material/05_overview_of_collections_list_and_set/08_adding_and_deleting_elements_set.ipynb\n",
      "processing python-and-sql-material/05_overview_of_collections_list_and_set/09_typical_set_operations.ipynb\n",
      "Notebook already signed: python-and-sql-material/05_overview_of_collections_list_and_set/09_typical_set_operations.ipynb\n",
      "processing python-and-sql-material/05_overview_of_collections_list_and_set/04_accessing_elements_from_list.ipynb\n",
      "Notebook already signed: python-and-sql-material/05_overview_of_collections_list_and_set/04_accessing_elements_from_list.ipynb\n",
      "processing python-and-sql-material/05_overview_of_collections_list_and_set/02_overview_of_list_and_set.ipynb\n",
      "Notebook already signed: python-and-sql-material/05_overview_of_collections_list_and_set/02_overview_of_list_and_set.ipynb\n",
      "processing python-and-sql-material/05_overview_of_collections_list_and_set/11_list_and_set_usage.ipynb\n",
      "Notebook already signed: python-and-sql-material/05_overview_of_collections_list_and_set/11_list_and_set_usage.ipynb\n",
      "processing python-and-sql-material/05_overview_of_collections_list_and_set/13_list_of_delimited_strings.ipynb\n",
      "Notebook already signed: python-and-sql-material/05_overview_of_collections_list_and_set/13_list_of_delimited_strings.ipynb\n",
      "processing python-and-sql-material/05_overview_of_collections_list_and_set/03_common_operations.ipynb\n",
      "Notebook already signed: python-and-sql-material/05_overview_of_collections_list_and_set/03_common_operations.ipynb\n",
      "processing python-and-sql-material/05_overview_of_collections_list_and_set/14_sorting_data_in_lists_and_sets.ipynb\n",
      "Notebook already signed: python-and-sql-material/05_overview_of_collections_list_and_set/14_sorting_data_in_lists_and_sets.ipynb\n",
      "processing python-and-sql-material/05_overview_of_collections_list_and_set/15_exercises_sorting_lists_and_sets.ipynb\n",
      "Notebook already signed: python-and-sql-material/05_overview_of_collections_list_and_set/15_exercises_sorting_lists_and_sets.ipynb\n",
      "processing python-and-sql-material/05_overview_of_collections_list_and_set/06_updating_and_deleting_elements - list.ipynb\n",
      "Signing notebook: python-and-sql-material/05_overview_of_collections_list_and_set/06_updating_and_deleting_elements - list.ipynb\n",
      "processing python-and-sql-material/05_overview_of_collections_list_and_set/10_validating_set.ipynb\n",
      "Notebook already signed: python-and-sql-material/05_overview_of_collections_list_and_set/10_validating_set.ipynb\n",
      "processing python-and-sql-material/06_overview_of_collections_dict_and_tuple/10_process_dict_values.ipynb\n",
      "Notebook already signed: python-and-sql-material/06_overview_of_collections_dict_and_tuple/10_process_dict_values.ipynb\n",
      "processing python-and-sql-material/06_overview_of_collections_dict_and_tuple/01_overview_of_collections_dict_and_tuple.ipynb\n",
      "Notebook already signed: python-and-sql-material/06_overview_of_collections_dict_and_tuple/01_overview_of_collections_dict_and_tuple.ipynb\n",
      "processing python-and-sql-material/06_overview_of_collections_dict_and_tuple/09_list_of_dicts.ipynb\n",
      "Notebook already signed: python-and-sql-material/06_overview_of_collections_dict_and_tuple/09_list_of_dicts.ipynb\n",
      "processing python-and-sql-material/06_overview_of_collections_dict_and_tuple/02_overview_of_dict_and_tuple.ipynb\n",
      "Notebook already signed: python-and-sql-material/06_overview_of_collections_dict_and_tuple/02_overview_of_dict_and_tuple.ipynb\n",
      "processing python-and-sql-material/06_overview_of_collections_dict_and_tuple/08_list_of_tuples.ipynb\n",
      "Notebook already signed: python-and-sql-material/06_overview_of_collections_dict_and_tuple/08_list_of_tuples.ipynb\n",
      "processing python-and-sql-material/06_overview_of_collections_dict_and_tuple/12_sorting_dict_items.ipynb\n",
      "Notebook already signed: python-and-sql-material/06_overview_of_collections_dict_and_tuple/12_sorting_dict_items.ipynb\n",
      "processing python-and-sql-material/06_overview_of_collections_dict_and_tuple/05_accessing_elements_dict.ipynb\n",
      "Notebook already signed: python-and-sql-material/06_overview_of_collections_dict_and_tuple/05_accessing_elements_dict.ipynb\n",
      "processing python-and-sql-material/06_overview_of_collections_dict_and_tuple/03_common_operations.ipynb\n",
      "Notebook already signed: python-and-sql-material/06_overview_of_collections_dict_and_tuple/03_common_operations.ipynb\n",
      "processing python-and-sql-material/06_overview_of_collections_dict_and_tuple/15_exercises_dicts_and_tuples.ipynb\n",
      "Notebook already signed: python-and-sql-material/06_overview_of_collections_dict_and_tuple/15_exercises_dicts_and_tuples.ipynb\n",
      "processing python-and-sql-material/06_overview_of_collections_dict_and_tuple/06_manipulating_dict.ipynb\n",
      "Notebook already signed: python-and-sql-material/06_overview_of_collections_dict_and_tuple/06_manipulating_dict.ipynb\n",
      "processing python-and-sql-material/06_overview_of_collections_dict_and_tuple/07_common_examples_dict.ipynb\n",
      "Notebook already signed: python-and-sql-material/06_overview_of_collections_dict_and_tuple/07_common_examples_dict.ipynb\n",
      "processing python-and-sql-material/06_overview_of_collections_dict_and_tuple/04_accessing_elements_tuples.ipynb\n",
      "Notebook already signed: python-and-sql-material/06_overview_of_collections_dict_and_tuple/04_accessing_elements_tuples.ipynb\n",
      "processing python-and-sql-material/06_overview_of_collections_dict_and_tuple/11_process_dict_items.ipynb\n",
      "Notebook already signed: python-and-sql-material/06_overview_of_collections_dict_and_tuple/11_process_dict_items.ipynb\n",
      "processing python-and-sql-material/08_understanding_map_reduce_libraries/08_get_total_items_sold_and_revenue.ipynb\n",
      "Notebook already signed: python-and-sql-material/08_understanding_map_reduce_libraries/08_get_total_items_sold_and_revenue.ipynb\n",
      "processing python-and-sql-material/08_understanding_map_reduce_libraries/12_using_itertools_groupby.ipynb\n",
      "Notebook already signed: python-and-sql-material/08_understanding_map_reduce_libraries/12_using_itertools_groupby.ipynb\n",
      "processing python-and-sql-material/08_understanding_map_reduce_libraries/11_using_itertools_starmap.ipynb\n",
      "Notebook already signed: python-and-sql-material/08_understanding_map_reduce_libraries/11_using_itertools_starmap.ipynb\n",
      "processing python-and-sql-material/08_understanding_map_reduce_libraries/05_row_level_transformations_using_map.ipynb\n",
      "Notebook already signed: python-and-sql-material/08_understanding_map_reduce_libraries/05_row_level_transformations_using_map.ipynb\n",
      "processing python-and-sql-material/08_understanding_map_reduce_libraries/09_get_total_commission_amount.ipynb\n",
      "Notebook already signed: python-and-sql-material/08_understanding_map_reduce_libraries/09_get_total_commission_amount.ipynb\n",
      "processing python-and-sql-material/08_understanding_map_reduce_libraries/04_projecting_data_using_map.ipynb\n",
      "Notebook already signed: python-and-sql-material/08_understanding_map_reduce_libraries/04_projecting_data_using_map.ipynb\n",
      "processing python-and-sql-material/08_understanding_map_reduce_libraries/13_limitations_of_map_reduce_libraries.ipynb\n",
      "Notebook already signed: python-and-sql-material/08_understanding_map_reduce_libraries/13_limitations_of_map_reduce_libraries.ipynb\n",
      "processing python-and-sql-material/08_understanding_map_reduce_libraries/07_get_revenue_for_a_given_product_id.ipynb\n",
      "Notebook already signed: python-and-sql-material/08_understanding_map_reduce_libraries/07_get_revenue_for_a_given_product_id.ipynb\n",
      "processing python-and-sql-material/08_understanding_map_reduce_libraries/14_exercises_map_reduce_functions.ipynb\n",
      "Notebook already signed: python-and-sql-material/08_understanding_map_reduce_libraries/14_exercises_map_reduce_functions.ipynb\n",
      "processing python-and-sql-material/08_understanding_map_reduce_libraries/06_aggregations_using_reduce.ipynb\n",
      "Notebook already signed: python-and-sql-material/08_understanding_map_reduce_libraries/06_aggregations_using_reduce.ipynb\n",
      "processing python-and-sql-material/08_understanding_map_reduce_libraries/02_preparing_data_sets.ipynb\n",
      "Notebook already signed: python-and-sql-material/08_understanding_map_reduce_libraries/02_preparing_data_sets.ipynb\n",
      "processing python-and-sql-material/08_understanding_map_reduce_libraries/01_understanding_map_reduce_libraries.ipynb\n",
      "Notebook already signed: python-and-sql-material/08_understanding_map_reduce_libraries/01_understanding_map_reduce_libraries.ipynb\n",
      "processing python-and-sql-material/08_understanding_map_reduce_libraries/10_overview_of_itertools.ipynb\n",
      "Notebook already signed: python-and-sql-material/08_understanding_map_reduce_libraries/10_overview_of_itertools.ipynb\n",
      "processing python-and-sql-material/08_understanding_map_reduce_libraries/03_filtering_data_using_filter.ipynb\n",
      "Notebook already signed: python-and-sql-material/08_understanding_map_reduce_libraries/03_filtering_data_using_filter.ipynb\n",
      "processing python-and-sql-material/04_user_defined_functions/08_recap_of_user_defined_functions.ipynb\n",
      "Notebook already signed: python-and-sql-material/04_user_defined_functions/08_recap_of_user_defined_functions.ipynb\n",
      "processing python-and-sql-material/04_user_defined_functions/07_keyword_arguments.ipynb\n",
      "Notebook already signed: python-and-sql-material/04_user_defined_functions/07_keyword_arguments.ipynb\n",
      "processing python-and-sql-material/04_user_defined_functions/12_exercise_user_defined_functions.ipynb\n",
      "Notebook already signed: python-and-sql-material/04_user_defined_functions/12_exercise_user_defined_functions.ipynb\n",
      "processing python-and-sql-material/04_user_defined_functions/10_lambda_functions.ipynb\n",
      "Notebook already signed: python-and-sql-material/04_user_defined_functions/10_lambda_functions.ipynb\n",
      "processing python-and-sql-material/04_user_defined_functions/01_user_defined_functions.ipynb\n",
      "Notebook already signed: python-and-sql-material/04_user_defined_functions/01_user_defined_functions.ipynb\n",
      "processing python-and-sql-material/04_user_defined_functions/05_function_parameters_and_arguments.ipynb\n",
      "Notebook already signed: python-and-sql-material/04_user_defined_functions/05_function_parameters_and_arguments.ipynb\n",
      "processing python-and-sql-material/04_user_defined_functions/02_defining_functions.ipynb\n",
      "Notebook already signed: python-and-sql-material/04_user_defined_functions/02_defining_functions.ipynb\n",
      "processing python-and-sql-material/04_user_defined_functions/04_returning_values.ipynb\n",
      "Notebook already signed: python-and-sql-material/04_user_defined_functions/04_returning_values.ipynb\n",
      "processing python-and-sql-material/04_user_defined_functions/09_passing_functions_as_arguments.ipynb\n",
      "Notebook already signed: python-and-sql-material/04_user_defined_functions/09_passing_functions_as_arguments.ipynb\n",
      "processing python-and-sql-material/04_user_defined_functions/11_usage_of_lambda_functions.ipynb\n",
      "Notebook already signed: python-and-sql-material/04_user_defined_functions/11_usage_of_lambda_functions.ipynb\n",
      "processing python-and-sql-material/04_user_defined_functions/03_doc_strings.ipynb\n",
      "Notebook already signed: python-and-sql-material/04_user_defined_functions/03_doc_strings.ipynb\n",
      "processing python-and-sql-material/04_user_defined_functions/06_varying_arguments.ipynb\n",
      "Notebook already signed: python-and-sql-material/04_user_defined_functions/06_varying_arguments.ipynb\n",
      "processing python-and-sql-material/18_predefined_functions/02_overview_of_predefined_functions.ipynb\n",
      "Notebook already signed: python-and-sql-material/18_predefined_functions/02_overview_of_predefined_functions.ipynb\n",
      "processing python-and-sql-material/18_predefined_functions/01_predefined_functions.ipynb\n",
      "Notebook already signed: python-and-sql-material/18_predefined_functions/01_predefined_functions.ipynb\n",
      "processing python-and-sql-material/18_predefined_functions/04_date_manipulation_functions.ipynb\n",
      "Notebook already signed: python-and-sql-material/18_predefined_functions/04_date_manipulation_functions.ipynb\n",
      "processing python-and-sql-material/18_predefined_functions/06_data_type_conversion.ipynb\n",
      "Notebook already signed: python-and-sql-material/18_predefined_functions/06_data_type_conversion.ipynb\n",
      "processing python-and-sql-material/18_predefined_functions/03_string_manipulation_functions.ipynb\n",
      "Notebook already signed: python-and-sql-material/18_predefined_functions/03_string_manipulation_functions.ipynb\n",
      "processing python-and-sql-material/18_predefined_functions/07_handling_null_values.ipynb\n",
      "Notebook already signed: python-and-sql-material/18_predefined_functions/07_handling_null_values.ipynb\n",
      "processing python-and-sql-material/18_predefined_functions/08_using_case_and_when.ipynb\n",
      "Notebook already signed: python-and-sql-material/18_predefined_functions/08_using_case_and_when.ipynb\n",
      "processing python-and-sql-material/18_predefined_functions/05_overview_of_numeric_functions.ipynb\n",
      "Notebook already signed: python-and-sql-material/18_predefined_functions/05_overview_of_numeric_functions.ipynb\n",
      "processing python-and-sql-material/18_predefined_functions/09_exercises_predefined_functions.ipynb\n",
      "Notebook already signed: python-and-sql-material/18_predefined_functions/09_exercises_predefined_functions.ipynb\n",
      "processing python-and-sql-material/13_getting_started/05_setup_sql_workbench.ipynb\n",
      "Notebook already signed: python-and-sql-material/13_getting_started/05_setup_sql_workbench.ipynb\n",
      "processing python-and-sql-material/13_getting_started/04_setup_postgres_using_docker.ipynb\n",
      "Notebook already signed: python-and-sql-material/13_getting_started/04_setup_postgres_using_docker.ipynb\n",
      "processing python-and-sql-material/13_getting_started/01_getting_started.ipynb\n",
      "Notebook already signed: python-and-sql-material/13_getting_started/01_getting_started.ipynb\n",
      "processing python-and-sql-material/13_getting_started/03_using_psql.ipynb\n",
      "Notebook already signed: python-and-sql-material/13_getting_started/03_using_psql.ipynb\n",
      "processing python-and-sql-material/13_getting_started/10_exercise_loading_data.ipynb\n",
      "Notebook already signed: python-and-sql-material/13_getting_started/10_exercise_loading_data.ipynb\n",
      "processing python-and-sql-material/13_getting_started/08_data_loading_utilities.ipynb\n",
      "Notebook already signed: python-and-sql-material/13_getting_started/08_data_loading_utilities.ipynb\n",
      "processing python-and-sql-material/13_getting_started/02_connecting_to_database.ipynb\n",
      "Notebook already signed: python-and-sql-material/13_getting_started/02_connecting_to_database.ipynb\n",
      "processing python-and-sql-material/13_getting_started/06_sql_workbench_and_postgres.ipynb\n",
      "Notebook already signed: python-and-sql-material/13_getting_started/06_sql_workbench_and_postgres.ipynb\n",
      "processing python-and-sql-material/13_getting_started/09_loading_data_postgres_in_docker.ipynb\n",
      "Notebook already signed: python-and-sql-material/13_getting_started/09_loading_data_postgres_in_docker.ipynb\n",
      "processing python-and-sql-material/13_getting_started/07_sql_workbench_features.ipynb\n",
      "Notebook already signed: python-and-sql-material/13_getting_started/07_sql_workbench_features.ipynb\n",
      "processing python-and-sql-material/01_getting_started_with_python/06_using_ides_pycharm.ipynb\n",
      "Notebook already signed: python-and-sql-material/01_getting_started_with_python/06_using_ides_pycharm.ipynb\n",
      "processing python-and-sql-material/01_getting_started_with_python/08_using_itversity_labs.ipynb\n",
      "Notebook already signed: python-and-sql-material/01_getting_started_with_python/08_using_itversity_labs.ipynb\n",
      "processing python-and-sql-material/01_getting_started_with_python/03_overview_of_anaconda.ipynb\n",
      "Notebook already signed: python-and-sql-material/01_getting_started_with_python/03_overview_of_anaconda.ipynb\n",
      "processing python-and-sql-material/01_getting_started_with_python/09_leveraging_googles_colab.ipynb\n",
      "Notebook already signed: python-and-sql-material/01_getting_started_with_python/09_leveraging_googles_colab.ipynb\n",
      "processing python-and-sql-material/01_getting_started_with_python/07_overview_of_visual_studio_code.ipynb\n",
      "Notebook already signed: python-and-sql-material/01_getting_started_with_python/07_overview_of_visual_studio_code.ipynb\n",
      "processing python-and-sql-material/01_getting_started_with_python/04_python_cli_and_jupyter_notebook.ipynb\n",
      "Notebook already signed: python-and-sql-material/01_getting_started_with_python/04_python_cli_and_jupyter_notebook.ipynb\n",
      "processing python-and-sql-material/01_getting_started_with_python/01_getting_started_with_python.ipynb\n",
      "Notebook already signed: python-and-sql-material/01_getting_started_with_python/01_getting_started_with_python.ipynb\n",
      "processing python-and-sql-material/01_getting_started_with_python/02_installing_python.ipynb\n",
      "Notebook already signed: python-and-sql-material/01_getting_started_with_python/02_installing_python.ipynb\n",
      "processing python-and-sql-material/01_getting_started_with_python/05_overview_of_jupyter_lab.ipynb\n",
      "Notebook already signed: python-and-sql-material/01_getting_started_with_python/05_overview_of_jupyter_lab.ipynb\n",
      "processing python-and-sql-material/17_partitioning_tables_and_indexes/12_sub_partitioning.ipynb\n",
      "Notebook already signed: python-and-sql-material/17_partitioning_tables_and_indexes/12_sub_partitioning.ipynb\n",
      "processing python-and-sql-material/17_partitioning_tables_and_indexes/07_managing_partitions_range.ipynb\n",
      "Notebook already signed: python-and-sql-material/17_partitioning_tables_and_indexes/07_managing_partitions_range.ipynb\n",
      "processing python-and-sql-material/17_partitioning_tables_and_indexes/04_managing_partitions_list.ipynb\n",
      "Notebook already signed: python-and-sql-material/17_partitioning_tables_and_indexes/04_managing_partitions_list.ipynb\n",
      "processing python-and-sql-material/17_partitioning_tables_and_indexes/03_list_partitioning.ipynb\n",
      "Notebook already signed: python-and-sql-material/17_partitioning_tables_and_indexes/03_list_partitioning.ipynb\n",
      "processing python-and-sql-material/17_partitioning_tables_and_indexes/09_hash_partitioning.ipynb\n",
      "Notebook already signed: python-and-sql-material/17_partitioning_tables_and_indexes/09_hash_partitioning.ipynb\n",
      "processing python-and-sql-material/17_partitioning_tables_and_indexes/11_usage_scenarios.ipynb\n",
      "Notebook already signed: python-and-sql-material/17_partitioning_tables_and_indexes/11_usage_scenarios.ipynb\n",
      "processing python-and-sql-material/17_partitioning_tables_and_indexes/08_repartitioning_range.ipynb\n",
      "Notebook already signed: python-and-sql-material/17_partitioning_tables_and_indexes/08_repartitioning_range.ipynb\n",
      "processing python-and-sql-material/17_partitioning_tables_and_indexes/02_overview_of_partitioning.ipynb\n",
      "Notebook already signed: python-and-sql-material/17_partitioning_tables_and_indexes/02_overview_of_partitioning.ipynb\n",
      "processing python-and-sql-material/17_partitioning_tables_and_indexes/05_manipulating_data.ipynb\n",
      "Notebook already signed: python-and-sql-material/17_partitioning_tables_and_indexes/05_manipulating_data.ipynb\n",
      "processing python-and-sql-material/17_partitioning_tables_and_indexes/06_range_partitioning.ipynb\n",
      "Notebook already signed: python-and-sql-material/17_partitioning_tables_and_indexes/06_range_partitioning.ipynb\n",
      "processing python-and-sql-material/17_partitioning_tables_and_indexes/10_managing_partitions_hash.ipynb\n",
      "Notebook already signed: python-and-sql-material/17_partitioning_tables_and_indexes/10_managing_partitions_hash.ipynb\n",
      "processing python-and-sql-material/17_partitioning_tables_and_indexes/01_partitioning_tables_and_indexes.ipynb\n",
      "Notebook already signed: python-and-sql-material/17_partitioning_tables_and_indexes/01_partitioning_tables_and_indexes.ipynb\n",
      "processing python-and-sql-material/17_partitioning_tables_and_indexes/13_exercises_partitioning_tables.ipynb\n",
      "Notebook already signed: python-and-sql-material/17_partitioning_tables_and_indexes/13_exercises_partitioning_tables.ipynb\n",
      "processing python-and-sql-material/10_basics_of_file_io_using_python/06_read_text_file_into_string.ipynb\n",
      "Notebook already signed: python-and-sql-material/10_basics_of_file_io_using_python/06_read_text_file_into_string.ipynb\n",
      "processing python-and-sql-material/10_basics_of_file_io_using_python/12_managing_files_and_folders_using_python.ipynb\n",
      "Notebook already signed: python-and-sql-material/10_basics_of_file_io_using_python/12_managing_files_and_folders_using_python.ipynb\n",
      "processing python-and-sql-material/10_basics_of_file_io_using_python/10_read_csv_into_list_of_strings.ipynb\n",
      "Notebook already signed: python-and-sql-material/10_basics_of_file_io_using_python/10_read_csv_into_list_of_strings.ipynb\n",
      "processing python-and-sql-material/10_basics_of_file_io_using_python/03_folders_and_files.ipynb\n",
      "Notebook already signed: python-and-sql-material/10_basics_of_file_io_using_python/03_folders_and_files.ipynb\n",
      "processing python-and-sql-material/10_basics_of_file_io_using_python/02_overview_of_file_io.ipynb\n",
      "Notebook already signed: python-and-sql-material/10_basics_of_file_io_using_python/02_overview_of_file_io.ipynb\n",
      "processing python-and-sql-material/10_basics_of_file_io_using_python/11_write_strings_to_file_in_append_mode.ipynb\n",
      "Notebook already signed: python-and-sql-material/10_basics_of_file_io_using_python/11_write_strings_to_file_in_append_mode.ipynb\n",
      "processing python-and-sql-material/10_basics_of_file_io_using_python/07_write_string_to_text_file.ipynb\n",
      "Notebook already signed: python-and-sql-material/10_basics_of_file_io_using_python/07_write_string_to_text_file.ipynb\n",
      "processing python-and-sql-material/10_basics_of_file_io_using_python/08_overview_of_modes_to_write_into_files.ipynb\n",
      "Notebook already signed: python-and-sql-material/10_basics_of_file_io_using_python/08_overview_of_modes_to_write_into_files.ipynb\n",
      "processing python-and-sql-material/10_basics_of_file_io_using_python/05_overview_of_retail_data.ipynb\n",
      "Notebook already signed: python-and-sql-material/10_basics_of_file_io_using_python/05_overview_of_retail_data.ipynb\n",
      "processing python-and-sql-material/10_basics_of_file_io_using_python/04_file_paths_and_names.ipynb\n",
      "Notebook already signed: python-and-sql-material/10_basics_of_file_io_using_python/04_file_paths_and_names.ipynb\n",
      "processing python-and-sql-material/10_basics_of_file_io_using_python/09_overview_of_delimited_strings.ipynb\n",
      "Notebook already signed: python-and-sql-material/10_basics_of_file_io_using_python/09_overview_of_delimited_strings.ipynb\n",
      "processing python-and-sql-material/02_basic_programming_constructs/10_running_os_commands.ipynb\n",
      "Notebook already signed: python-and-sql-material/02_basic_programming_constructs/10_running_os_commands.ipynb\n",
      "processing python-and-sql-material/02_basic_programming_constructs/09_all_about_for_loops.ipynb\n",
      "Notebook already signed: python-and-sql-material/02_basic_programming_constructs/09_all_about_for_loops.ipynb\n",
      "processing python-and-sql-material/02_basic_programming_constructs/01_basic_programming_constructs.ipynb\n",
      "Notebook already signed: python-and-sql-material/02_basic_programming_constructs/01_basic_programming_constructs.ipynb\n",
      "processing python-and-sql-material/02_basic_programming_constructs/05_overview_of_boolean_type.ipynb\n",
      "Notebook already signed: python-and-sql-material/02_basic_programming_constructs/05_overview_of_boolean_type.ipynb\n",
      "processing python-and-sql-material/02_basic_programming_constructs/04_data_types_commonly_used.ipynb\n",
      "Notebook already signed: python-and-sql-material/02_basic_programming_constructs/04_data_types_commonly_used.ipynb\n",
      "processing python-and-sql-material/02_basic_programming_constructs/08_conditionals.ipynb\n",
      "Notebook already signed: python-and-sql-material/02_basic_programming_constructs/08_conditionals.ipynb\n",
      "processing python-and-sql-material/02_basic_programming_constructs/06_operators_in_python.ipynb\n",
      "Notebook already signed: python-and-sql-material/02_basic_programming_constructs/06_operators_in_python.ipynb\n",
      "processing python-and-sql-material/02_basic_programming_constructs/12_eval_and_exec.ipynb\n",
      "Notebook already signed: python-and-sql-material/02_basic_programming_constructs/12_eval_and_exec.ipynb\n",
      "processing python-and-sql-material/02_basic_programming_constructs/11_exercises_basic_programming_constructs.ipynb\n",
      "Notebook already signed: python-and-sql-material/02_basic_programming_constructs/11_exercises_basic_programming_constructs.ipynb\n",
      "processing python-and-sql-material/02_basic_programming_constructs/07_comments_and_doc_strings.ipynb\n",
      "Notebook already signed: python-and-sql-material/02_basic_programming_constructs/07_comments_and_doc_strings.ipynb\n",
      "processing python-and-sql-material/02_basic_programming_constructs/02_getting_help.ipynb\n",
      "Notebook already signed: python-and-sql-material/02_basic_programming_constructs/02_getting_help.ipynb\n",
      "processing python-and-sql-material/02_basic_programming_constructs/03_variables_and_objects.ipynb\n",
      "Notebook already signed: python-and-sql-material/02_basic_programming_constructs/03_variables_and_objects.ipynb\n",
      "processing python-and-sql-material/23_processing_rest_payloads/05_getting_started_with_requests.ipynb\n",
      "Notebook already signed: python-and-sql-material/23_processing_rest_payloads/05_getting_started_with_requests.ipynb\n",
      "processing python-and-sql-material/23_processing_rest_payloads/07_process_rest_payload_using_collection_operations.ipynb\n",
      "Notebook already signed: python-and-sql-material/23_processing_rest_payloads/07_process_rest_payload_using_collection_operations.ipynb\n",
      "processing python-and-sql-material/23_processing_rest_payloads/02_overview_of_rest_apis.ipynb\n",
      "Notebook already signed: python-and-sql-material/23_processing_rest_payloads/02_overview_of_rest_apis.ipynb\n",
      "processing python-and-sql-material/23_processing_rest_payloads/04_overview_of_postman.ipynb\n",
      "Notebook already signed: python-and-sql-material/23_processing_rest_payloads/04_overview_of_postman.ipynb\n",
      "processing python-and-sql-material/23_processing_rest_payloads/03_using_curl_command.ipynb\n",
      "Notebook already signed: python-and-sql-material/23_processing_rest_payloads/03_using_curl_command.ipynb\n",
      "processing python-and-sql-material/23_processing_rest_payloads/09_exercise_rest_payload_to_db_table.ipynb\n",
      "Notebook already signed: python-and-sql-material/23_processing_rest_payloads/09_exercise_rest_payload_to_db_table.ipynb\n",
      "processing python-and-sql-material/23_processing_rest_payloads/08_process_rest_payload_using_pandas.ipynb\n",
      "Notebook already signed: python-and-sql-material/23_processing_rest_payloads/08_process_rest_payload_using_pandas.ipynb\n",
      "processing python-and-sql-material/23_processing_rest_payloads/06_convert_rest_payload_to_python_objects.ipynb\n",
      "Notebook already signed: python-and-sql-material/23_processing_rest_payloads/06_convert_rest_payload_to_python_objects.ipynb\n",
      "processing python-and-sql-material/07_manipulating_collections_using_loops/10_performing_grouped_aggregations.ipynb\n",
      "Notebook already signed: python-and-sql-material/07_manipulating_collections_using_loops/10_performing_grouped_aggregations.ipynb\n",
      "processing python-and-sql-material/07_manipulating_collections_using_loops/01_manipulating_collections_using_loops.ipynb\n",
      "Notebook already signed: python-and-sql-material/07_manipulating_collections_using_loops/01_manipulating_collections_using_loops.ipynb\n",
      "processing python-and-sql-material/07_manipulating_collections_using_loops/02_reading_files_into_collections.ipynb\n",
      "Notebook already signed: python-and-sql-material/07_manipulating_collections_using_loops/02_reading_files_into_collections.ipynb\n",
      "processing python-and-sql-material/07_manipulating_collections_using_loops/06_filtering_data.ipynb\n",
      "Notebook already signed: python-and-sql-material/07_manipulating_collections_using_loops/06_filtering_data.ipynb\n",
      "processing python-and-sql-material/07_manipulating_collections_using_loops/12_manipulate_lists_using_comprehensions.ipynb\n",
      "Notebook already signed: python-and-sql-material/07_manipulating_collections_using_loops/12_manipulate_lists_using_comprehensions.ipynb\n",
      "processing python-and-sql-material/07_manipulating_collections_using_loops/05_getting_unique_elements.ipynb\n",
      "Notebook already signed: python-and-sql-material/07_manipulating_collections_using_loops/05_getting_unique_elements.ipynb\n",
      "processing python-and-sql-material/07_manipulating_collections_using_loops/13_limitations_of_using_loops.ipynb\n",
      "Notebook already signed: python-and-sql-material/07_manipulating_collections_using_loops/13_limitations_of_using_loops.ipynb\n",
      "processing python-and-sql-material/07_manipulating_collections_using_loops/07_run_other_python_notebook_demo.ipynb\n",
      "Notebook already signed: python-and-sql-material/07_manipulating_collections_using_loops/07_run_other_python_notebook_demo.ipynb\n",
      "processing python-and-sql-material/07_manipulating_collections_using_loops/07_preparing_data_sets.ipynb\n",
      "Notebook already signed: python-and-sql-material/07_manipulating_collections_using_loops/07_preparing_data_sets.ipynb\n",
      "processing python-and-sql-material/07_manipulating_collections_using_loops/11_joining_data_sets.ipynb\n",
      "Notebook already signed: python-and-sql-material/07_manipulating_collections_using_loops/11_joining_data_sets.ipynb\n",
      "processing python-and-sql-material/07_manipulating_collections_using_loops/14_exercises_manipulating_collections_using_loops.ipynb\n",
      "Notebook already signed: python-and-sql-material/07_manipulating_collections_using_loops/14_exercises_manipulating_collections_using_loops.ipynb\n",
      "processing python-and-sql-material/07_manipulating_collections_using_loops/03_overview_of_standard_transformations.ipynb\n",
      "Notebook already signed: python-and-sql-material/07_manipulating_collections_using_loops/03_overview_of_standard_transformations.ipynb\n",
      "processing python-and-sql-material/07_manipulating_collections_using_loops/08_quick_recap_of_dict_operations.ipynb\n",
      "Notebook already signed: python-and-sql-material/07_manipulating_collections_using_loops/08_quick_recap_of_dict_operations.ipynb\n",
      "processing python-and-sql-material/07_manipulating_collections_using_loops/04_row_level_transformations.ipynb\n",
      "Notebook already signed: python-and-sql-material/07_manipulating_collections_using_loops/04_row_level_transformations.ipynb\n",
      "processing python-and-sql-material/07_manipulating_collections_using_loops/09_performing_total_aggregations.ipynb\n",
      "Notebook already signed: python-and-sql-material/07_manipulating_collections_using_loops/09_performing_total_aggregations.ipynb\n",
      "processing python-and-sql-material/12_overview_of_pandas_libraries/04_creating_data_frames_from_lists.ipynb\n",
      "Notebook already signed: python-and-sql-material/12_overview_of_pandas_libraries/04_creating_data_frames_from_lists.ipynb\n",
      "processing python-and-sql-material/12_overview_of_pandas_libraries/11_joining_data_frames.ipynb\n",
      "Notebook already signed: python-and-sql-material/12_overview_of_pandas_libraries/11_joining_data_frames.ipynb\n",
      "processing python-and-sql-material/12_overview_of_pandas_libraries/14_set_up_courses_table_with_data.ipynb\n",
      "Notebook already signed: python-and-sql-material/12_overview_of_pandas_libraries/14_set_up_courses_table_with_data.ipynb\n",
      "processing python-and-sql-material/12_overview_of_pandas_libraries/10_writing_data_frames_to_files.ipynb\n",
      "Notebook already signed: python-and-sql-material/12_overview_of_pandas_libraries/10_writing_data_frames_to_files.ipynb\n",
      "processing python-and-sql-material/12_overview_of_pandas_libraries/09_performing_grouped_aggregations.ipynb\n",
      "Notebook already signed: python-and-sql-material/12_overview_of_pandas_libraries/09_performing_grouped_aggregations.ipynb\n",
      "processing python-and-sql-material/12_overview_of_pandas_libraries/08_performing_total_aggregations.ipynb\n",
      "Notebook already signed: python-and-sql-material/12_overview_of_pandas_libraries/08_performing_total_aggregations.ipynb\n",
      "processing python-and-sql-material/12_overview_of_pandas_libraries/05_data_frames_basic_operations.ipynb\n",
      "Notebook already signed: python-and-sql-material/12_overview_of_pandas_libraries/05_data_frames_basic_operations.ipynb\n",
      "processing python-and-sql-material/12_overview_of_pandas_libraries/15_running_sql_queries_using_pandas.ipynb\n",
      "Notebook already signed: python-and-sql-material/12_overview_of_pandas_libraries/15_running_sql_queries_using_pandas.ipynb\n",
      "processing python-and-sql-material/12_overview_of_pandas_libraries/02_pandas_data_structures_overview.ipynb\n",
      "Notebook already signed: python-and-sql-material/12_overview_of_pandas_libraries/02_pandas_data_structures_overview.ipynb\n",
      "processing python-and-sql-material/12_overview_of_pandas_libraries/07_projecting_and_filtering.ipynb\n",
      "Notebook already signed: python-and-sql-material/12_overview_of_pandas_libraries/07_projecting_and_filtering.ipynb\n",
      "processing python-and-sql-material/12_overview_of_pandas_libraries/03_overview_of_series.ipynb\n",
      "Notebook already signed: python-and-sql-material/12_overview_of_pandas_libraries/03_overview_of_series.ipynb\n",
      "processing python-and-sql-material/12_overview_of_pandas_libraries/06_csv_to_pandas_data_frame.ipynb\n",
      "Notebook already signed: python-and-sql-material/12_overview_of_pandas_libraries/06_csv_to_pandas_data_frame.ipynb\n",
      "processing python-and-sql-material/12_overview_of_pandas_libraries/01_overview_of_pandas_libraries.ipynb\n",
      "Notebook already signed: python-and-sql-material/12_overview_of_pandas_libraries/01_overview_of_pandas_libraries.ipynb\n",
      "processing python-and-sql-material/12_overview_of_pandas_libraries/13_set_up_variables_for_db_connectivity.ipynb\n",
      "Notebook already signed: python-and-sql-material/12_overview_of_pandas_libraries/13_set_up_variables_for_db_connectivity.ipynb\n",
      "processing python-and-sql-material/12_overview_of_pandas_libraries/12_exercises_pandas_data_frames.ipynb\n",
      "Notebook already signed: python-and-sql-material/12_overview_of_pandas_libraries/12_exercises_pandas_data_frames.ipynb\n",
      "processing python-and-sql-material/20_database_programming_crud_operations/10_querying_data_from_table.ipynb\n",
      "Notebook already signed: python-and-sql-material/20_database_programming_crud_operations/10_querying_data_from_table.ipynb\n",
      "processing python-and-sql-material/20_database_programming_crud_operations/05_function_get_database_connection.ipynb\n",
      "Notebook already signed: python-and-sql-material/20_database_programming_crud_operations/05_function_get_database_connection.ipynb\n",
      "processing python-and-sql-material/20_database_programming_crud_operations/09_deleting_data_from_table.ipynb\n",
      "Notebook already signed: python-and-sql-material/20_database_programming_crud_operations/09_deleting_data_from_table.ipynb\n",
      "processing python-and-sql-material/20_database_programming_crud_operations/03_recap_of_rdbms_concepts.ipynb\n",
      "Notebook already signed: python-and-sql-material/20_database_programming_crud_operations/03_recap_of_rdbms_concepts.ipynb\n",
      "processing python-and-sql-material/20_database_programming_crud_operations/11_recap_crud_operations.ipynb\n",
      "Notebook already signed: python-and-sql-material/20_database_programming_crud_operations/11_recap_crud_operations.ipynb\n",
      "processing python-and-sql-material/20_database_programming_crud_operations/06_creating_database_table.ipynb\n",
      "Notebook already signed: python-and-sql-material/20_database_programming_crud_operations/06_creating_database_table.ipynb\n",
      "processing python-and-sql-material/20_database_programming_crud_operations/07_inserting_data_into_table.ipynb\n",
      "Notebook already signed: python-and-sql-material/20_database_programming_crud_operations/07_inserting_data_into_table.ipynb\n",
      "processing python-and-sql-material/20_database_programming_crud_operations/08_updating_existing_table_data.ipynb\n",
      "Notebook already signed: python-and-sql-material/20_database_programming_crud_operations/08_updating_existing_table_data.ipynb\n",
      "processing python-and-sql-material/20_database_programming_crud_operations/02_overview_of_database_programming.ipynb\n",
      "Notebook already signed: python-and-sql-material/20_database_programming_crud_operations/02_overview_of_database_programming.ipynb\n",
      "processing python-and-sql-material/20_database_programming_crud_operations/04_setup_database_client_libraries.ipynb\n",
      "Notebook already signed: python-and-sql-material/20_database_programming_crud_operations/04_setup_database_client_libraries.ipynb\n",
      "processing python-and-sql-material/20_database_programming_crud_operations/01_database_programming_crud_operations.ipynb\n",
      "Notebook already signed: python-and-sql-material/20_database_programming_crud_operations/01_database_programming_crud_operations.ipynb\n",
      "processing python-and-sql-material/03_pre_defined_functions/07_print_and_input_functions.ipynb\n",
      "Notebook already signed: python-and-sql-material/03_pre_defined_functions/07_print_and_input_functions.ipynb\n",
      "processing python-and-sql-material/03_pre_defined_functions/06_formatting_strings.ipynb\n",
      "Notebook already signed: python-and-sql-material/03_pre_defined_functions/06_formatting_strings.ipynb\n",
      "processing python-and-sql-material/03_pre_defined_functions/08_date_manipulation_functions.ipynb\n",
      "Notebook already signed: python-and-sql-material/03_pre_defined_functions/08_date_manipulation_functions.ipynb\n",
      "processing python-and-sql-material/03_pre_defined_functions/05_string_manipulation_functions.ipynb\n",
      "Notebook already signed: python-and-sql-material/03_pre_defined_functions/05_string_manipulation_functions.ipynb\n",
      "processing python-and-sql-material/03_pre_defined_functions/04_overview_of_strings.ipynb\n",
      "Notebook already signed: python-and-sql-material/03_pre_defined_functions/04_overview_of_strings.ipynb\n",
      "processing python-and-sql-material/03_pre_defined_functions/01_pre_defined_functions.ipynb\n",
      "Notebook already signed: python-and-sql-material/03_pre_defined_functions/01_pre_defined_functions.ipynb\n",
      "processing python-and-sql-material/03_pre_defined_functions/03_numeric_functions.ipynb\n",
      "Notebook already signed: python-and-sql-material/03_pre_defined_functions/03_numeric_functions.ipynb\n",
      "processing python-and-sql-material/03_pre_defined_functions/02_overview_of_pre-defined_functions.ipynb\n",
      "Notebook already signed: python-and-sql-material/03_pre_defined_functions/02_overview_of_pre-defined_functions.ipynb\n",
      "processing python-and-sql-material/03_pre_defined_functions/10_exercises_pre_defined_functions.ipynb\n",
      "Notebook already signed: python-and-sql-material/03_pre_defined_functions/10_exercises_pre_defined_functions.ipynb\n",
      "processing python-and-sql-material/03_pre_defined_functions/09_special_functions.ipynb\n",
      "Notebook already signed: python-and-sql-material/03_pre_defined_functions/09_special_functions.ipynb\n",
      "processing python-and-sql-material/11_delimited_files_and_collections/05_write_delimited_strings_into_files.ipynb\n",
      "Notebook already signed: python-and-sql-material/11_delimited_files_and_collections/05_write_delimited_strings_into_files.ipynb\n",
      "processing python-and-sql-material/11_delimited_files_and_collections/02_overview_of_delimited_text_files.ipynb\n",
      "Notebook already signed: python-and-sql-material/11_delimited_files_and_collections/02_overview_of_delimited_text_files.ipynb\n",
      "processing python-and-sql-material/11_delimited_files_and_collections/03_recap_of_basic_file_io.ipynb\n",
      "Notebook already signed: python-and-sql-material/11_delimited_files_and_collections/03_recap_of_basic_file_io.ipynb\n",
      "processing python-and-sql-material/11_delimited_files_and_collections/07_read_delimited_data_using_csv.ipynb\n",
      "Notebook already signed: python-and-sql-material/11_delimited_files_and_collections/07_read_delimited_data_using_csv.ipynb\n",
      "processing python-and-sql-material/11_delimited_files_and_collections/10_apply_schema_on_lists_from_files.ipynb\n",
      "Notebook already signed: python-and-sql-material/11_delimited_files_and_collections/10_apply_schema_on_lists_from_files.ipynb\n",
      "processing python-and-sql-material/11_delimited_files_and_collections/04_read_delimited_files_into_list_of_tuples.ipynb\n",
      "Notebook already signed: python-and-sql-material/11_delimited_files_and_collections/04_read_delimited_files_into_list_of_tuples.ipynb\n",
      "processing python-and-sql-material/11_delimited_files_and_collections/09_advantages_of_using_csv.ipynb\n",
      "Notebook already signed: python-and-sql-material/11_delimited_files_and_collections/09_advantages_of_using_csv.ipynb\n",
      "processing python-and-sql-material/11_delimited_files_and_collections/06_overview_of_csv_module.ipynb\n",
      "Notebook already signed: python-and-sql-material/11_delimited_files_and_collections/06_overview_of_csv_module.ipynb\n",
      "processing python-and-sql-material/11_delimited_files_and_collections/08_write_delimited_strings_using_csv.ipynb\n",
      "Notebook already signed: python-and-sql-material/11_delimited_files_and_collections/08_write_delimited_strings_using_csv.ipynb\n",
      "processing python-and-sql-material/14_dml_or_crud_operations/03_tables_as_relations.ipynb\n",
      "Notebook already signed: python-and-sql-material/14_dml_or_crud_operations/03_tables_as_relations.ipynb\n",
      "processing python-and-sql-material/14_dml_or_crud_operations/01_dml_or_crud_operations.ipynb\n",
      "Notebook already signed: python-and-sql-material/14_dml_or_crud_operations/01_dml_or_crud_operations.ipynb\n",
      "processing python-and-sql-material/14_dml_or_crud_operations/02_normalization_principles.ipynb\n",
      "Notebook already signed: python-and-sql-material/14_dml_or_crud_operations/02_normalization_principles.ipynb\n",
      "processing python-and-sql-material/14_dml_or_crud_operations/08_updating_data.ipynb\n",
      "Notebook already signed: python-and-sql-material/14_dml_or_crud_operations/08_updating_data.ipynb\n",
      "processing python-and-sql-material/14_dml_or_crud_operations/07_inserting_data.ipynb\n",
      "Notebook already signed: python-and-sql-material/14_dml_or_crud_operations/07_inserting_data.ipynb\n",
      "processing python-and-sql-material/14_dml_or_crud_operations/05_crud_operations.ipynb\n",
      "Notebook already signed: python-and-sql-material/14_dml_or_crud_operations/05_crud_operations.ipynb\n",
      "processing python-and-sql-material/14_dml_or_crud_operations/10_overview_of_transactions.ipynb\n",
      "Notebook already signed: python-and-sql-material/14_dml_or_crud_operations/10_overview_of_transactions.ipynb\n",
      "processing python-and-sql-material/14_dml_or_crud_operations/06_creating_table.ipynb\n",
      "Notebook already signed: python-and-sql-material/14_dml_or_crud_operations/06_creating_table.ipynb\n",
      "processing python-and-sql-material/14_dml_or_crud_operations/04_overview_of_database_operations.ipynb\n",
      "Notebook already signed: python-and-sql-material/14_dml_or_crud_operations/04_overview_of_database_operations.ipynb\n",
      "processing python-and-sql-material/14_dml_or_crud_operations/09_deleting_data.ipynb\n",
      "Notebook already signed: python-and-sql-material/14_dml_or_crud_operations/09_deleting_data.ipynb\n",
      "processing python-and-sql-material/14_dml_or_crud_operations/11_exercises_database_operations.ipynb\n",
      "Notebook already signed: python-and-sql-material/14_dml_or_crud_operations/11_exercises_database_operations.ipynb\n",
      "processing python-and-sql-material/22_processing_json_data/03_json_data_types.ipynb\n",
      "Notebook already signed: python-and-sql-material/22_processing_json_data/03_json_data_types.ipynb\n",
      "processing python-and-sql-material/22_processing_json_data/06_single_json_document_in_files.ipynb\n",
      "Notebook already signed: python-and-sql-material/22_processing_json_data/06_single_json_document_in_files.ipynb\n",
      "processing python-and-sql-material/22_processing_json_data/02_overview_of_json.ipynb\n",
      "Notebook already signed: python-and-sql-material/22_processing_json_data/02_overview_of_json.ipynb\n",
      "processing python-and-sql-material/22_processing_json_data/08_process_json_using_pandas.ipynb\n",
      "Notebook already signed: python-and-sql-material/22_processing_json_data/08_process_json_using_pandas.ipynb\n",
      "processing python-and-sql-material/22_processing_json_data/12_write_to_json_files_using_pandas.ipynb\n",
      "Notebook already signed: python-and-sql-material/22_processing_json_data/12_write_to_json_files_using_pandas.ipynb\n",
      "processing python-and-sql-material/22_processing_json_data/05_process_json_string.ipynb\n",
      "Notebook already signed: python-and-sql-material/22_processing_json_data/05_process_json_string.ipynb\n",
      "processing python-and-sql-material/22_processing_json_data/11_write_to_json_files_using_json_module.ipynb\n",
      "Notebook already signed: python-and-sql-material/22_processing_json_data/11_write_to_json_files_using_json_module.ipynb\n",
      "processing python-and-sql-material/22_processing_json_data/04_create_json_string.ipynb\n",
      "Notebook already signed: python-and-sql-material/22_processing_json_data/04_create_json_string.ipynb\n",
      "processing python-and-sql-material/22_processing_json_data/07_multiple_json_documents_in_files.ipynb\n",
      "Notebook already signed: python-and-sql-material/22_processing_json_data/07_multiple_json_documents_in_files.ipynb\n",
      "processing python-and-sql-material/22_processing_json_data/10_common_use_cases_for_json.ipynb\n",
      "Notebook already signed: python-and-sql-material/22_processing_json_data/10_common_use_cases_for_json.ipynb\n",
      "processing python-and-sql-material/22_processing_json_data/09_different_json_formats_supported_by_pandas.ipynb\n",
      "Notebook already signed: python-and-sql-material/22_processing_json_data/09_different_json_formats_supported_by_pandas.ipynb\n",
      "processing python-and-sql-material/21_database_programming_batch_operations/06_reading_data_from_file.ipynb\n",
      "Notebook already signed: python-and-sql-material/21_database_programming_batch_operations/06_reading_data_from_file.ipynb\n",
      "processing python-and-sql-material/21_database_programming_batch_operations/05_preparing_database.ipynb\n",
      "Notebook already signed: python-and-sql-material/21_database_programming_batch_operations/05_preparing_database.ipynb\n",
      "processing python-and-sql-material/21_database_programming_batch_operations/04_recap_of_insert.ipynb\n",
      "Notebook already signed: python-and-sql-material/21_database_programming_batch_operations/04_recap_of_insert.ipynb\n",
      "processing python-and-sql-material/21_database_programming_batch_operations/01_database_programming_batch_operations.ipynb\n",
      "Notebook already signed: python-and-sql-material/21_database_programming_batch_operations/01_database_programming_batch_operations.ipynb\n",
      "processing python-and-sql-material/21_database_programming_batch_operations/09_execute_values_for_batch_inserts.ipynb\n",
      "Notebook already signed: python-and-sql-material/21_database_programming_batch_operations/09_execute_values_for_batch_inserts.ipynb\n",
      "processing python-and-sql-material/21_database_programming_batch_operations/08_best_practices_batch_loading.ipynb\n",
      "Notebook already signed: python-and-sql-material/21_database_programming_batch_operations/08_best_practices_batch_loading.ipynb\n",
      "processing python-and-sql-material/21_database_programming_batch_operations/02_function_get_database_connection.ipynb\n",
      "Notebook already signed: python-and-sql-material/21_database_programming_batch_operations/02_function_get_database_connection.ipynb\n",
      "processing python-and-sql-material/21_database_programming_batch_operations/07_batch_loading_of_data.ipynb\n",
      "Notebook already signed: python-and-sql-material/21_database_programming_batch_operations/07_batch_loading_of_data.ipynb\n",
      "processing python-and-sql-material/21_database_programming_batch_operations/03_creating_database_table.ipynb\n",
      "Notebook already signed: python-and-sql-material/21_database_programming_batch_operations/03_creating_database_table.ipynb\n",
      "processing python-and-sql-material/16_creating_tables_and_indexes/02_data_definition_language.ipynb\n",
      "Notebook already signed: python-and-sql-material/16_creating_tables_and_indexes/02_data_definition_language.ipynb\n",
      "processing python-and-sql-material/16_creating_tables_and_indexes/04_adding_or_modifying_columns.ipynb\n",
      "Notebook already signed: python-and-sql-material/16_creating_tables_and_indexes/04_adding_or_modifying_columns.ipynb\n",
      "processing python-and-sql-material/16_creating_tables_and_indexes/11_dropping_tables.ipynb\n",
      "Notebook already signed: python-and-sql-material/16_creating_tables_and_indexes/11_dropping_tables.ipynb\n",
      "processing python-and-sql-material/16_creating_tables_and_indexes/08_indexes_for_constraints.ipynb\n",
      "Notebook already signed: python-and-sql-material/16_creating_tables_and_indexes/08_indexes_for_constraints.ipynb\n",
      "processing python-and-sql-material/16_creating_tables_and_indexes/03_overview_of_data_types.ipynb\n",
      "Notebook already signed: python-and-sql-material/16_creating_tables_and_indexes/03_overview_of_data_types.ipynb\n",
      "processing python-and-sql-material/16_creating_tables_and_indexes/06_managing_constraints.ipynb\n",
      "Notebook already signed: python-and-sql-material/16_creating_tables_and_indexes/06_managing_constraints.ipynb\n",
      "processing python-and-sql-material/16_creating_tables_and_indexes/07_indexes_on_tables.ipynb\n",
      "Notebook already signed: python-and-sql-material/16_creating_tables_and_indexes/07_indexes_on_tables.ipynb\n",
      "processing python-and-sql-material/16_creating_tables_and_indexes/10_truncating_tables.ipynb\n",
      "Notebook already signed: python-and-sql-material/16_creating_tables_and_indexes/10_truncating_tables.ipynb\n",
      "processing python-and-sql-material/16_creating_tables_and_indexes/12_exercises_managing_db_objects.ipynb\n",
      "Notebook already signed: python-and-sql-material/16_creating_tables_and_indexes/12_exercises_managing_db_objects.ipynb\n",
      "processing python-and-sql-material/16_creating_tables_and_indexes/01_creating_tables_and_indexes.ipynb\n",
      "Notebook already signed: python-and-sql-material/16_creating_tables_and_indexes/01_creating_tables_and_indexes.ipynb\n",
      "processing python-and-sql-material/16_creating_tables_and_indexes/05_different_types_of_constraints.ipynb\n",
      "Notebook already signed: python-and-sql-material/16_creating_tables_and_indexes/05_different_types_of_constraints.ipynb\n",
      "processing python-and-sql-material/16_creating_tables_and_indexes/09_overview_of_sequences.ipynb\n",
      "Notebook already signed: python-and-sql-material/16_creating_tables_and_indexes/09_overview_of_sequences.ipynb\n"
     ]
    }
   ],
   "source": [
    "import subprocess\n",
    "for notebook in notebooks:\n",
    "    try:\n",
    "        print(f'processing {notebook}')\n",
    "        notebook_content = json.load(open(notebook))\n",
    "        notebook_content_new = update_notebook(notebook_content)\n",
    "        notebook_file = open(notebook, 'w')\n",
    "        json.dump(notebook_content_new, notebook_file, indent=2)\n",
    "        notebook_file.close()\n",
    "        subprocess.check_call(f'jupyter trust \"{notebook}\"', shell=True)\n",
    "    except:\n",
    "        print(f'failed {notebook}')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "6f301ccb-5203-427d-83ee-a2dc3aa94c2e",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}