Cut and Curve.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "36348637",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "147f62ed",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Please enter the name of the input Excel file with extension (Ex-abc.xlsx): curve and tunnel.xlsx\n",
      "Please enter the name of the worksheet containing Curve data (Ex-Sheet4): Curves\n",
      "Please enter the column containing Starting Chainage of Curve data (Ex-B): TP1  (m)\n",
      "Please enter the column containing Ending Chainage of Curve data (Ex-C): TP2  (m)\n",
      "Please enter the name of the worksheet containing Cutting data (Ex-Sheet1): Tunnels\n",
      "Please enter the column containing Starting Chainage of Cutting data (A): Start Ch (m)\n",
      "Please enter the column containing Ending Chainage of Cutting data (B): End Ch (m)\n",
      "Cuts: [[900, 7250], [7500, 7550], [8950, 12400], [12950, 17450], [18350, 22650], [25050, 28800], [28850, 34700], [35250, 35500], [35950, 36450], [36900, 46700], [48250, 57400], [57600, 58050], [58200, 66800], [68050, 68150], [68650, 70300], [70350, 78100], [79300, 90150], [90750, 94900], [95000, 97050], [97100, 99850], [101200, 101550], [101650, 110350], [111000, 111450], [111700, 123100], [124500, 126800], [126850, 126900], [127050, 132050], [132200, 132900], [133500, 140300], [140500, 140600], [141950, 150850], [151200, 157000], [158300, 158800], [159100, 164900], [165500, 165900], [167000, 167100], [167150, 167200], [167350, 167550], [167600, 167900]]\n",
      "Curves: [[631, 2331], [2531, 4853], [6684, 7900], [8200, 8487], [8987, 9487], [9687, 11687], [11787, 13787], [13887, 15163], [16268, 16768], [17118, 19118], [19218, 21500], [21641, 22527], [24027, 24527], [26527, 28427], [28827, 29327], [30527, 31527], [32637, 33037], [33476, 33710], [34260, 35210], [35610, 35810], [46010, 46310], [46510, 47079], [47579, 47879], [48079, 49079], [52479, 53129], [57529, 58029], [58229, 58729], [58929, 59529], [60029, 60814], [66814, 67014], [67114, 67314], [67514, 67814], [68014, 68514], [69514, 70014], [74187, 75138], [77231, 78328], [78528, 78828], [79328, 79828], [80028, 81278], [81778, 82528], [89528, 89828], [90028, 90328], [90528, 91028], [95028, 95228], [96728, 97228], [97428, 98718], [99718, 99918], [100918, 102018], [106518, 107438], [109638, 109918], [110418, 110668], [110868, 111868], [117868, 119568], [121531, 122236], [123579, 124027], [124527, 125327], [128827, 129427], [131427, 132427], [132677, 132977], [133277, 134277], [135777, 136927], [139127, 139727], [139927, 140578], [140628, 140924], [140974, 141174], [141224, 141524], [141624, 142124], [142324, 142824], [145824, 146824], [150284, 151284], [154184, 155184], [156784, 157084], [157284, 157584], [158084, 158584], [159084, 160084], [164084, 164584], [165134, 165764], [166764, 167044]]\n",
      "Intersections:\n",
      "[[900, 2331], [2531, 4853], [6684, 7250], [7500, 7550], [8987, 9487], [9687, 11687], [11787, 12400], [12950, 13787], [13887, 15163], [16268, 16768], [17118, 17450], [18350, 19118], [19218, 21500], [21641, 22527], [26527, 28427], [28850, 29327], [30527, 31527], [32637, 33037], [33476, 33710], [34260, 34700], [46010, 46310], [46510, 46700], [48250, 49079], [52479, 53129], [57600, 58029], [58229, 58729], [58929, 59529], [60029, 60814], [68050, 68150], [69514, 70014], [74187, 75138], [77231, 78100], [79328, 79828], [80028, 81278], [81778, 82528], [89528, 89828], [90028, 90150], [90750, 91028], [95028, 95228], [96728, 97050], [97100, 97228], [97428, 98718], [99718, 99850], [101200, 101550], [101650, 102018], [106518, 107438], [109638, 109918], [111000, 111450], [111700, 111868], [117868, 119568], [121531, 122236], [124527, 125327], [128827, 129427], [131427, 132050], [132200, 132427], [132677, 132900], [133500, 134277], [135777, 136927], [139127, 139727], [139927, 140300], [140500, 140578], [141950, 142124], [142324, 142824], [145824, 146824], [150284, 150850], [151200, 151284], [154184, 155184], [156784, 157000], [158300, 158584], [159100, 160084], [164084, 164584], [165500, 165764], [167000, 167044]]\n"
     ]
    }
   ],
   "source": [
    "#correct code\n",
    "import pandas as pd\n",
    "\n",
    "input_file = input('Please enter the name of the input Excel file with extension (Ex-abc.xlsx): ')\n",
    "\n",
    "# Accept inputs for curve data from User\n",
    "curve_sheet_name = input('Please enter the name of the worksheet containing Curve data (Ex-Sheet4): ')\n",
    "curve_start_col = input('Please enter the column containing Starting Chainage of Curve data (Ex-B): ')\n",
    "curve_end_col = input('Please enter the column containing Ending Chainage of Curve data (Ex-C): ')\n",
    "\n",
    "# Accept inputs for cutting data from User\n",
    "cutting_sheet_name = input('Please enter the name of the worksheet containing Cutting data (Ex-Sheet1): ')\n",
    "cutting_start_col = input('Please enter the column containing Starting Chainage of Cutting data (A): ')\n",
    "cutting_end_col = input('Please enter the column containing Ending Chainage of Cutting data (B): ')\n",
    "\n",
    "# Read Excel data into DataFrames\n",
    "curve_data = pd.read_excel(input_file, sheet_name=curve_sheet_name)\n",
    "cutting_data = pd.read_excel(input_file, sheet_name=cutting_sheet_name)\n",
    "\n",
    "# Create 2-D lists cuts and curves\n",
    "cuts = cutting_data[[cutting_start_col, cutting_end_col]].values.tolist()\n",
    "curves = curve_data[[curve_start_col, curve_end_col]].values.tolist()\n",
    "\n",
    "# Print the resulting lists (for verification)\n",
    "print(\"Cuts:\", cuts)\n",
    "print(\"Curves:\", curves)\n",
    "intersections = []\n",
    "i = j = 0  # Initialize pointers for both lists.\n",
    "# Continue while neither list is fully traversed.\n",
    "while i < len(cuts) and j < len(curves):\n",
    "    # Find the furthest start time and earliest end time to conveniently check \n",
    "    # if the intervals intersect.\n",
    "    maxStart = max(cuts[i][0], curves[j][0])\n",
    "    minEnd = min(cuts[i][1], curves[j][1])\n",
    "    # If the intervals intersect, add the intersection to the output.\n",
    "    if maxStart <= minEnd:\n",
    "        intersections.append([maxStart, minEnd])\n",
    "    # Move the pointer forward for the interval that ends first.\n",
    "    if cuts[i][1] < curves[j][1]:\n",
    "        i += 1\n",
    "    else:\n",
    "        j += 1\n",
    "print(\"Intersections:\")\n",
    "print(intersections)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "7b78f20d",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "73\n",
      "Please enter the name of the column containing degrees in Curve data: Deg. of Curve\n",
      "Degree for Interval 900 - 2331: 2.99\n",
      "Degree for Interval 2531 - 4853: 2.99\n",
      "Degree for Interval 6684 - 7250: 2.99\n",
      "Degree for Interval 7500 - 7550: 2.99\n",
      "Degree for Interval 8987 - 9487: 2.99\n",
      "Degree for Interval 9687 - 11687: 2.99\n",
      "Degree for Interval 11787 - 12400: 2.99\n",
      "Degree for Interval 12950 - 13787: 2.99\n",
      "Degree for Interval 13887 - 15163: 2.99\n",
      "Degree for Interval 16268 - 16768: 2.99\n",
      "Degree for Interval 17118 - 17450: 2.99\n",
      "Degree for Interval 18350 - 19118: 2.99\n",
      "Degree for Interval 19218 - 21500: 2.99\n",
      "Degree for Interval 21641 - 22527: 2.99\n",
      "Degree for Interval 26527 - 28427: 1.75\n",
      "Degree for Interval 28850 - 29327: 2.99\n",
      "Degree for Interval 30527 - 31527: 2.99\n",
      "Degree for Interval 32637 - 33037: 2.99\n",
      "Degree for Interval 33476 - 33710: 2.99\n",
      "Degree for Interval 34260 - 34700: 2.99\n",
      "Degree for Interval 46010 - 46310: 2.99\n",
      "Degree for Interval 46510 - 46700: 2.0\n",
      "Degree for Interval 48250 - 49079: 5.0\n",
      "Degree for Interval 52479 - 53129: 5.0\n",
      "Degree for Interval 57600 - 58029: 2.0\n",
      "Degree for Interval 58229 - 58729: 4.0\n",
      "Degree for Interval 58929 - 59529: 2.0\n",
      "Degree for Interval 60029 - 60814: 1.75\n",
      "Degree for Interval 68050 - 68150: 2.99\n",
      "Degree for Interval 69514 - 70014: 2.0\n",
      "Degree for Interval 74187 - 75138: 3.0\n",
      "Degree for Interval 77231 - 78100: 2.99\n",
      "Degree for Interval 79328 - 79828: 5.0\n",
      "Degree for Interval 80028 - 81278: 5.0\n",
      "Degree for Interval 81778 - 82528: 2.99\n",
      "Degree for Interval 89528 - 89828: 1.0\n",
      "Degree for Interval 90028 - 90150: 5.0\n",
      "Degree for Interval 90750 - 91028: 5.0\n",
      "Degree for Interval 95028 - 95228: 2.99\n",
      "Degree for Interval 96728 - 97050: 5.0\n",
      "Degree for Interval 97100 - 97228: 5.0\n",
      "Degree for Interval 97428 - 98718: 5.0\n",
      "Degree for Interval 99718 - 99850: 2.0\n",
      "Degree for Interval 101200 - 101550: 5.0\n",
      "Degree for Interval 101650 - 102018: 5.0\n",
      "Degree for Interval 106518 - 107438: 5.0\n",
      "Degree for Interval 109638 - 109918: 2.0\n",
      "Degree for Interval 111000 - 111450: 5.0\n",
      "Degree for Interval 111700 - 111868: 5.0\n",
      "Degree for Interval 117868 - 119568: 2.0\n",
      "Degree for Interval 121531 - 122236: 0.88\n",
      "Degree for Interval 124527 - 125327: 5.0\n",
      "Degree for Interval 128827 - 129427: 2.0\n",
      "Degree for Interval 131427 - 132050: 5.0\n",
      "Degree for Interval 132200 - 132427: 5.0\n",
      "Degree for Interval 132677 - 132900: 2.0\n",
      "Degree for Interval 133500 - 134277: 5.0\n",
      "Degree for Interval 135777 - 136927: 5.0\n",
      "Degree for Interval 139127 - 139727: 5.0\n",
      "Degree for Interval 139927 - 140300: 5.0\n",
      "Degree for Interval 140500 - 140578: 5.0\n",
      "Degree for Interval 141950 - 142124: 2.0\n",
      "Degree for Interval 142324 - 142824: 5.0\n",
      "Degree for Interval 145824 - 146824: 4.0\n",
      "Degree for Interval 150284 - 150850: 5.0\n",
      "Degree for Interval 151200 - 151284: 5.0\n",
      "Degree for Interval 154184 - 155184: 5.0\n",
      "Degree for Interval 156784 - 157000: 4.38\n",
      "Degree for Interval 158300 - 158584: 2.0\n",
      "Degree for Interval 159100 - 160084: 2.92\n",
      "Degree for Interval 164084 - 164584: 1.46\n",
      "Degree for Interval 165500 - 165764: 5.0\n",
      "Degree for Interval 167000 - 167044: 2.0\n"
     ]
    }
   ],
   "source": [
    "\n",
    "degree_col = input('Please enter the name of the column containing degrees in Curve data: ')\n",
    "\n",
    "# Fetch the degrees for each intersection\n",
    "for intersection in intersections:\n",
    "    # Identify the row in the 'curve_data' DataFrame where the intersection lies\n",
    "    intersecting_rows = curve_data[\n",
    "        (curve_data[curve_start_col] <= intersection[0]) & (curve_data[curve_end_col] >= intersection[1])\n",
    "    ]\n",
    "\n",
    "    # Check if there are any intersecting rows\n",
    "    if not intersecting_rows.empty:\n",
    "        # Print the degree value from the identified row\n",
    "        degree_value = intersecting_rows.iloc[0][degree_col]\n",
    "        print(f\"Degree for Interval {intersection[0]} - {intersection[1]}: {degree_value}\")\n",
    "    else:\n",
    "        print(f\"No matching row found for Interval {intersection[0]} - {intersection[1]}\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "dba77279",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Number of curves in each cut:\n",
      "Tunnel 1: (900, 7250) Curve 1: [900, 2331] Curve 2: [2531, 4853] Curve 3: [6684, 7250] \n",
      "Tunnel 2: (7500, 7550) Curve 1: [7500, 7550] \n",
      "Tunnel 3: (8950, 12400) Curve 1: [8987, 9487] Curve 2: [9687, 11687] Curve 3: [11787, 12400] \n",
      "Tunnel 4: (12950, 17450) Curve 1: [12950, 13787] Curve 2: [13887, 15163] Curve 3: [16268, 16768] Curve 4: [17118, 17450] \n",
      "Tunnel 5: (18350, 22650) Curve 1: [18350, 19118] Curve 2: [19218, 21500] Curve 3: [21641, 22527] \n",
      "Tunnel 6: (25050, 28800) Curve 1: [26527, 28427] \n",
      "Tunnel 7: (28850, 34700) Curve 1: [28850, 29327] Curve 2: [30527, 31527] Curve 3: [32637, 33037] Curve 4: [33476, 33710] Curve 5: [34260, 34700] \n",
      "Tunnel 8: (36900, 46700) Curve 1: [46010, 46310] Curve 2: [46510, 46700] \n",
      "Tunnel 9: (48250, 57400) Curve 1: [48250, 49079] Curve 2: [52479, 53129] \n",
      "Tunnel 10: (57600, 58050) Curve 1: [57600, 58029] \n",
      "Tunnel 11: (58200, 66800) Curve 1: [58229, 58729] Curve 2: [58929, 59529] Curve 3: [60029, 60814] \n",
      "Tunnel 12: (68050, 68150) Curve 1: [68050, 68150] \n",
      "Tunnel 13: (68650, 70300) Curve 1: [69514, 70014] \n",
      "Tunnel 14: (70350, 78100) Curve 1: [74187, 75138] Curve 2: [77231, 78100] \n",
      "Tunnel 15: (79300, 90150) Curve 1: [79328, 79828] Curve 2: [80028, 81278] Curve 3: [81778, 82528] Curve 4: [89528, 89828] Curve 5: [90028, 90150] \n",
      "Tunnel 16: (90750, 94900) Curve 1: [90750, 91028] \n",
      "Tunnel 17: (95000, 97050) Curve 1: [95028, 95228] Curve 2: [96728, 97050] \n",
      "Tunnel 18: (97100, 99850) Curve 1: [97100, 97228] Curve 2: [97428, 98718] Curve 3: [99718, 99850] \n",
      "Tunnel 19: (101200, 101550) Curve 1: [101200, 101550] \n",
      "Tunnel 20: (101650, 110350) Curve 1: [101650, 102018] Curve 2: [106518, 107438] Curve 3: [109638, 109918] \n",
      "Tunnel 21: (111000, 111450) Curve 1: [111000, 111450] \n",
      "Tunnel 22: (111700, 123100) Curve 1: [111700, 111868] Curve 2: [117868, 119568] Curve 3: [121531, 122236] \n",
      "Tunnel 23: (124500, 126800) Curve 1: [124527, 125327] \n",
      "Tunnel 24: (127050, 132050) Curve 1: [128827, 129427] Curve 2: [131427, 132050] \n",
      "Tunnel 25: (132200, 132900) Curve 1: [132200, 132427] Curve 2: [132677, 132900] \n",
      "Tunnel 26: (133500, 140300) Curve 1: [133500, 134277] Curve 2: [135777, 136927] Curve 3: [139127, 139727] Curve 4: [139927, 140300] \n",
      "Tunnel 27: (140500, 140600) Curve 1: [140500, 140578] \n",
      "Tunnel 28: (141950, 150850) Curve 1: [141950, 142124] Curve 2: [142324, 142824] Curve 3: [145824, 146824] Curve 4: [150284, 150850] \n",
      "Tunnel 29: (151200, 157000) Curve 1: [151200, 151284] Curve 2: [154184, 155184] Curve 3: [156784, 157000] \n",
      "Tunnel 30: (158300, 158800) Curve 1: [158300, 158584] \n",
      "Tunnel 31: (159100, 164900) Curve 1: [159100, 160084] Curve 2: [164084, 164584] \n",
      "Tunnel 32: (165500, 165900) Curve 1: [165500, 165764] \n",
      "Tunnel 33: (167000, 167100) Curve 1: [167000, 167044] \n"
     ]
    }
   ],
   "source": [
    "# ... (previous code remains unchanged)\n",
    "\n",
    "# Continue with the original code to calculate intersections\n",
    "# ...\n",
    "\n",
    "# Calculate the number of curves in each cut\n",
    "cuts_with_curves = {}\n",
    "i = 0  # Reset the pointer for the cuts list.\n",
    "for intersection in intersections:\n",
    "    while i < len(cuts):\n",
    "        cut_start, cut_end = cuts[i]\n",
    "        # Check if the intersection is within the current cut\n",
    "        if intersection[0] >= cut_start and intersection[1] <= cut_end:\n",
    "            # If the cut is not in the dictionary, add it with a list for curves.\n",
    "            # Otherwise, append the curve to the list for that cut.\n",
    "            cuts_with_curves.setdefault((cut_start, cut_end), [])\n",
    "            cuts_with_curves[(cut_start, cut_end)].append(intersection)\n",
    "            break\n",
    "        # Move to the next cut\n",
    "        i += 1\n",
    "\n",
    "# Display the number of curves in each cut\n",
    "print(\"Number of curves in each cut:\")\n",
    "for i, (cut, curves) in enumerate(cuts_with_curves.items(), start=1):\n",
    "    print(f\"Tunnel {i}: {cut}\", end=\" \")\n",
    "    for j, curve in enumerate(curves, start=1):\n",
    "        print(f\"Curve {j}: {curve}\", end=\" \")\n",
    "    print()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "fb3c3270",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Number of curves in each cut:\n",
      "Tunnel 1: (900, 7250) Curve 1: [900, 2331] Degree of curve: 2.99 Curve 2: [2531, 4853] Degree of curve: 2.99 Curve 3: [6684, 7250] Degree of curve: 2.99 \n",
      "Tunnel 2: (7500, 7550) Curve 1: [7500, 7550] Degree of curve: 2.99 \n",
      "Tunnel 3: (8950, 12400) Curve 1: [8987, 9487] Degree of curve: 2.99 Curve 2: [9687, 11687] Degree of curve: 2.99 Curve 3: [11787, 12400] Degree of curve: 2.99 \n",
      "Tunnel 4: (12950, 17450) Curve 1: [12950, 13787] Degree of curve: 2.99 Curve 2: [13887, 15163] Degree of curve: 2.99 Curve 3: [16268, 16768] Degree of curve: 2.99 Curve 4: [17118, 17450] Degree of curve: 2.99 \n",
      "Tunnel 5: (18350, 22650) Curve 1: [18350, 19118] Degree of curve: 2.99 Curve 2: [19218, 21500] Degree of curve: 2.99 Curve 3: [21641, 22527] Degree of curve: 2.99 \n",
      "Tunnel 6: (25050, 28800) Curve 1: [26527, 28427] Degree of curve: 1.75 \n",
      "Tunnel 7: (28850, 34700) Curve 1: [28850, 29327] Degree of curve: 2.99 Curve 2: [30527, 31527] Degree of curve: 2.99 Curve 3: [32637, 33037] Degree of curve: 2.99 Curve 4: [33476, 33710] Degree of curve: 2.99 Curve 5: [34260, 34700] Degree of curve: 2.99 \n",
      "Tunnel 8: (36900, 46700) Curve 1: [46010, 46310] Degree of curve: 2.99 Curve 2: [46510, 46700] Degree of curve: 2.0 \n",
      "Tunnel 9: (48250, 57400) Curve 1: [48250, 49079] Degree of curve: 5.0 Curve 2: [52479, 53129] Degree of curve: 5.0 \n",
      "Tunnel 10: (57600, 58050) Curve 1: [57600, 58029] Degree of curve: 2.0 \n",
      "Tunnel 11: (58200, 66800) Curve 1: [58229, 58729] Degree of curve: 4.0 Curve 2: [58929, 59529] Degree of curve: 2.0 Curve 3: [60029, 60814] Degree of curve: 1.75 \n",
      "Tunnel 12: (68050, 68150) Curve 1: [68050, 68150] Degree of curve: 2.99 \n",
      "Tunnel 13: (68650, 70300) Curve 1: [69514, 70014] Degree of curve: 2.0 \n",
      "Tunnel 14: (70350, 78100) Curve 1: [74187, 75138] Degree of curve: 3.0 Curve 2: [77231, 78100] Degree of curve: 2.99 \n",
      "Tunnel 15: (79300, 90150) Curve 1: [79328, 79828] Degree of curve: 5.0 Curve 2: [80028, 81278] Degree of curve: 5.0 Curve 3: [81778, 82528] Degree of curve: 2.99 Curve 4: [89528, 89828] Degree of curve: 1.0 Curve 5: [90028, 90150] Degree of curve: 5.0 \n",
      "Tunnel 16: (90750, 94900) Curve 1: [90750, 91028] Degree of curve: 5.0 \n",
      "Tunnel 17: (95000, 97050) Curve 1: [95028, 95228] Degree of curve: 2.99 Curve 2: [96728, 97050] Degree of curve: 5.0 \n",
      "Tunnel 18: (97100, 99850) Curve 1: [97100, 97228] Degree of curve: 5.0 Curve 2: [97428, 98718] Degree of curve: 5.0 Curve 3: [99718, 99850] Degree of curve: 2.0 \n",
      "Tunnel 19: (101200, 101550) Curve 1: [101200, 101550] Degree of curve: 5.0 \n",
      "Tunnel 20: (101650, 110350) Curve 1: [101650, 102018] Degree of curve: 5.0 Curve 2: [106518, 107438] Degree of curve: 5.0 Curve 3: [109638, 109918] Degree of curve: 2.0 \n",
      "Tunnel 21: (111000, 111450) Curve 1: [111000, 111450] Degree of curve: 5.0 \n",
      "Tunnel 22: (111700, 123100) Curve 1: [111700, 111868] Degree of curve: 5.0 Curve 2: [117868, 119568] Degree of curve: 2.0 Curve 3: [121531, 122236] Degree of curve: 0.88 \n",
      "Tunnel 23: (124500, 126800) Curve 1: [124527, 125327] Degree of curve: 5.0 \n",
      "Tunnel 24: (127050, 132050) Curve 1: [128827, 129427] Degree of curve: 2.0 Curve 2: [131427, 132050] Degree of curve: 5.0 \n",
      "Tunnel 25: (132200, 132900) Curve 1: [132200, 132427] Degree of curve: 5.0 Curve 2: [132677, 132900] Degree of curve: 2.0 \n",
      "Tunnel 26: (133500, 140300) Curve 1: [133500, 134277] Degree of curve: 5.0 Curve 2: [135777, 136927] Degree of curve: 5.0 Curve 3: [139127, 139727] Degree of curve: 5.0 Curve 4: [139927, 140300] Degree of curve: 5.0 \n",
      "Tunnel 27: (140500, 140600) Curve 1: [140500, 140578] Degree of curve: 5.0 \n",
      "Tunnel 28: (141950, 150850) Curve 1: [141950, 142124] Degree of curve: 2.0 Curve 2: [142324, 142824] Degree of curve: 5.0 Curve 3: [145824, 146824] Degree of curve: 4.0 Curve 4: [150284, 150850] Degree of curve: 5.0 \n",
      "Tunnel 29: (151200, 157000) Curve 1: [151200, 151284] Degree of curve: 5.0 Curve 2: [154184, 155184] Degree of curve: 5.0 Curve 3: [156784, 157000] Degree of curve: 4.38 \n",
      "Tunnel 30: (158300, 158800) Curve 1: [158300, 158584] Degree of curve: 2.0 \n",
      "Tunnel 31: (159100, 164900) Curve 1: [159100, 160084] Degree of curve: 2.92 Curve 2: [164084, 164584] Degree of curve: 1.46 \n",
      "Tunnel 32: (165500, 165900) Curve 1: [165500, 165764] Degree of curve: 5.0 \n",
      "Tunnel 33: (167000, 167100) Curve 1: [167000, 167044] Degree of curve: 2.0 \n"
     ]
    }
   ],
   "source": [
    "cuts_with_curves = {}\n",
    "i = 0  # Reset the pointer for the cuts list.\n",
    "for intersection in intersections:\n",
    "    while i < len(cuts):\n",
    "        cut_start, cut_end = cuts[i]\n",
    "        # Check if the intersection is within the current cut\n",
    "        if intersection[0] >= cut_start and intersection[1] <= cut_end:\n",
    "            # If the cut is not in the dictionary, add it with a list for curves.\n",
    "            # Otherwise, append the curve to the list for that cut.\n",
    "            cuts_with_curves.setdefault((cut_start, cut_end), [])\n",
    "            cuts_with_curves[(cut_start, cut_end)].append((intersection, degree_col))\n",
    "            break\n",
    "        # Move to the next cut\n",
    "        i += 1\n",
    "\n",
    "# Display the number of curves in each cut\n",
    "print(\"Number of curves in each cut:\")\n",
    "for i, (cut, curves_info) in enumerate(cuts_with_curves.items(), start=1):\n",
    "    print(f\"Tunnel {i}: {cut}\", end=\" \")\n",
    "    for j, (curve, degree_col) in enumerate(curves_info, start=1):\n",
    "        print(f\"Curve {j}: {curve} Degree of curve: {curve_data[(curve_data[curve_start_col] <= curve[0]) & (curve_data[curve_end_col] >= curve[1])][degree_col].values[0]}\", end=\" \")\n",
    "    print()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "9e5b284d",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1975481703.py:22: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "# Your existing code for reading data and calculating intersections\n",
    "# ...\n",
    "\n",
    "# Create a DataFrame for output\n",
    "output_df = pd.DataFrame(columns=['Tunnels', 'Curves within the tunnel', 'Degree of curves'])\n",
    "\n",
    "# Populate the DataFrame with data\n",
    "for i, (cut, curves_info) in enumerate(cuts_with_curves.items(), start=1):\n",
    "    tunnel_range = f'Tunnel {i}: {cut[0]} - {cut[1]}'\n",
    "    curves_within_tunnel = []\n",
    "    degrees_of_curves = []\n",
    "\n",
    "    for j, (curve, degree_col) in enumerate(curves_info, start=1):\n",
    "        curve_range = f'Curve {j}: {curve[0]} - {curve[1]}'\n",
    "        degree_value = curve_data[(curve_data[curve_start_col] <= curve[0]) & (curve_data[curve_end_col] >= curve[1])][degree_col].values[0]\n",
    "        curves_within_tunnel.append(curve_range)\n",
    "        degrees_of_curves.append(degree_value)\n",
    "\n",
    "    # Append data to the DataFrame\n",
    "    output_df = output_df.append({'Tunnels': tunnel_range, 'Curves within the tunnel': ', '.join(curves_within_tunnel), 'Degree of curves': ', '.join(map(str, degrees_of_curves))}, ignore_index=True)\n",
    "\n",
    "# Write the DataFrame to the Excel file\n",
    "with pd.ExcelWriter(input_file, engine='openpyxl', mode='a') as writer:\n",
    "    output_df.to_excel(writer, sheet_name='OutputSheet', index=False)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "16eccd2c",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
      "C:\\Users\\ratna\\AppData\\Local\\Temp\\ipykernel_14244\\1172164646.py:20: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "# Your existing code for reading data and calculating intersections\n",
    "# ...\n",
    "\n",
    "# Create a DataFrame for output\n",
    "output_df = pd.DataFrame(columns=['Tunnels', 'Details'])\n",
    "\n",
    "# Populate the DataFrame with data\n",
    "for i, (cut, curves_info) in enumerate(cuts_with_curves.items(), start=1):\n",
    "    tunnel_range = f'Tunnel {i}: {cut[0]} - {cut[1]}'\n",
    "    details_within_tunnel = []\n",
    "\n",
    "    for j, (curve, degree_col) in enumerate(curves_info, start=1):\n",
    "        curve_range = f'Curve {j}: {curve[0]} - {curve[1]}'\n",
    "        degree_value = curve_data[(curve_data[curve_start_col] <= curve[0]) & (curve_data[curve_end_col] >= curve[1])][degree_col].values[0]\n",
    "        details_within_tunnel.append(f'{curve_range} (Degree: {degree_value})')\n",
    "\n",
    "    # Append data to the DataFrame\n",
    "    output_df = output_df.append({'Tunnels': tunnel_range, 'Details': '\\n'.join(details_within_tunnel)}, ignore_index=True)\n",
    "\n",
    "# Write the DataFrame to the Excel file\n",
    "with pd.ExcelWriter(input_file, engine='openpyxl', mode='a') as writer:\n",
    "    output_df.to_excel(writer, sheet_name='Output', index=False)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "dc3ec278",
   "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.11.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}