Loads_extraction.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "# -*- coding: utf-8 -*-\n",
    "import pandas as pd\n",
    "import re\n",
    "import matplotlib.pyplot as pp\n",
    "import numpy as np\n",
    "import os\n",
    "import glob"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "#loadpattern=re.compile('\\d*55\\d*(018|019|020)')\n",
    "\n",
    "load_files=glob.glob('*.pnt29b')\n",
    "\n",
    "loadpattern=re.compile('\\d{8}')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "# the function is only for one folder. To look thru the many folders one more change is required \n",
    "def loads(file):\n",
    "    d=[]\n",
    "    with open(file,'r') as l:\n",
    "        for line in l:\n",
    "            if loadpattern.search(line):\n",
    "                s=line.split()\n",
    "                pattern=re.compile('\\d{9,30}')\n",
    "                n=s.index(pattern.search(line).group())\n",
    "                if 'fs' in s or 'fy' in s:\n",
    "                    s[n+5:n+7]=[' '.join(s[n+5:n+7])]\n",
    "                s[1:n]=[' '.join(s[1:n])]\n",
    "                if len(s)!=17:\n",
    "                    k=len(s)\n",
    "                    s.extend(['non']*(17-k))\n",
    "                    s[k-1],s[-1]=s[-1],s[k-1]\n",
    "                for i,x in enumerate(s):\n",
    "                    try:\n",
    "                        s[i]=int(x)\n",
    "                    except ValueError:\n",
    "                        try:\n",
    "                            s[i]=float(x)\n",
    "                        except ValueError:  \n",
    "                            pass\n",
    "                d.append(s)\n",
    "    return d\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "data=[] \n",
    "  \n",
    "for file in load_files:\n",
    "    data.extend(loads(file))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "num=np.array(data, dtype='object')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "num=np.array(data, dtype='object')\n",
    "\n",
    "inf=['ID', 'Location', 'Element','Fmax','Cond max','Fmin','Cond min', 'Mode', 'FRF',\n",
    "     'GAG', 'DSO', 'DFRreq', 'MS', 'SEF', 'Stress Rating', 'Sc', 'DMF Set']\n",
    "\n",
    "df=pd.DataFrame(num, columns=inf)\n",
    "\n",
    "df['Fmax'] = df['Fmax'].astype(float)\n",
    "df['Fmin'] = df['Fmin'].astype(float)\n",
    "df['GAG'] = df['GAG'].astype(float)\n",
    "df['DFRreq'] = df['DFRreq'].astype(float)\n",
    "df['Element'] = df['Element'].astype(str)\n",
    "df['Stress Rating'] = df['Stress Rating'].astype(float)\n",
    "df['FRF'] = df['FRF'].astype(float)\n",
    "#df['Sc'] = df['Sc'].astype(float)\n",
    "df['DSO'] = df['DSO'].astype(int)\n",
    "df['ID'] = df['ID'].astype(int)\n",
    "\n",
    "df['R'] = df['Fmin']/df['Fmax']\n",
    "\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Element</th>\n",
       "      <th>Location</th>\n",
       "      <th>DFRreq</th>\n",
       "      <th>Fmax</th>\n",
       "      <th>Fmin</th>\n",
       "      <th>R</th>\n",
       "      <th>Mode</th>\n",
       "      <th>GAG</th>\n",
       "      <th>DSO</th>\n",
       "      <th>SEF</th>\n",
       "      <th>Stress Rating</th>\n",
       "      <th>Sc</th>\n",
       "      <th>DMF Set</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3948</th>\n",
       "      <td>15002001029001</td>\n",
       "      <td>wing lwr rib bay 25 fwd of r.s.</td>\n",
       "      <td>5.800</td>\n",
       "      <td>2.900</td>\n",
       "      <td>-0.700</td>\n",
       "      <td>-0.241</td>\n",
       "      <td>t</td>\n",
       "      <td>0.260</td>\n",
       "      <td>75000</td>\n",
       "      <td>0.730</td>\n",
       "      <td>3.900</td>\n",
       "      <td>5.200</td>\n",
       "      <td>WST726M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4452</th>\n",
       "      <td>15002001029001</td>\n",
       "      <td>wing lwr rib bay 25 fwd of r.s.</td>\n",
       "      <td>5.800</td>\n",
       "      <td>2.900</td>\n",
       "      <td>-0.700</td>\n",
       "      <td>-0.241</td>\n",
       "      <td>t</td>\n",
       "      <td>0.260</td>\n",
       "      <td>75000</td>\n",
       "      <td>0.730</td>\n",
       "      <td>3.900</td>\n",
       "      <td>5.200</td>\n",
       "      <td>WST726M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>15002001029001</td>\n",
       "      <td>wing lwr rib bay 25 fwd of r.s.</td>\n",
       "      <td>5.200</td>\n",
       "      <td>3.700</td>\n",
       "      <td>-0.700</td>\n",
       "      <td>-0.189</td>\n",
       "      <td>t</td>\n",
       "      <td>0.380</td>\n",
       "      <td>40000</td>\n",
       "      <td>0.760</td>\n",
       "      <td>4.400</td>\n",
       "      <td>5.700</td>\n",
       "      <td>WST726M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3480</th>\n",
       "      <td>15002001029001</td>\n",
       "      <td>wing lwr rib bay 25 fwd of r.s.</td>\n",
       "      <td>5.200</td>\n",
       "      <td>3.700</td>\n",
       "      <td>-0.700</td>\n",
       "      <td>-0.189</td>\n",
       "      <td>t</td>\n",
       "      <td>0.380</td>\n",
       "      <td>40000</td>\n",
       "      <td>0.760</td>\n",
       "      <td>4.400</td>\n",
       "      <td>5.700</td>\n",
       "      <td>WST726M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1484</th>\n",
       "      <td>15002001029001</td>\n",
       "      <td>wing lwr rib bay 25 fwd of r.s.</td>\n",
       "      <td>4.800</td>\n",
       "      <td>3.900</td>\n",
       "      <td>-0.700</td>\n",
       "      <td>-0.179</td>\n",
       "      <td>t</td>\n",
       "      <td>0.390</td>\n",
       "      <td>25000</td>\n",
       "      <td>0.750</td>\n",
       "      <td>4.600</td>\n",
       "      <td>6.100</td>\n",
       "      <td>WST726M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6584</th>\n",
       "      <td>15002001029001</td>\n",
       "      <td>wing lwr rib bay 25 fwd of r.s.</td>\n",
       "      <td>4.800</td>\n",
       "      <td>3.900</td>\n",
       "      <td>-0.700</td>\n",
       "      <td>-0.179</td>\n",
       "      <td>t</td>\n",
       "      <td>0.390</td>\n",
       "      <td>25000</td>\n",
       "      <td>0.750</td>\n",
       "      <td>4.600</td>\n",
       "      <td>6.100</td>\n",
       "      <td>WST726M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3949</th>\n",
       "      <td>15002002029001</td>\n",
       "      <td>wing lwr rib bay 25 fwd of r.s.</td>\n",
       "      <td>4.800</td>\n",
       "      <td>2.400</td>\n",
       "      <td>-0.700</td>\n",
       "      <td>-0.292</td>\n",
       "      <td>t</td>\n",
       "      <td>0.260</td>\n",
       "      <td>75000</td>\n",
       "      <td>0.710</td>\n",
       "      <td>3.000</td>\n",
       "      <td>4.300</td>\n",
       "      <td>WST726M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4453</th>\n",
       "      <td>15002002029001</td>\n",
       "      <td>wing lwr rib bay 25 fwd of r.s.</td>\n",
       "      <td>4.800</td>\n",
       "      <td>2.400</td>\n",
       "      <td>-0.700</td>\n",
       "      <td>-0.292</td>\n",
       "      <td>t</td>\n",
       "      <td>0.260</td>\n",
       "      <td>75000</td>\n",
       "      <td>0.670</td>\n",
       "      <td>2.900</td>\n",
       "      <td>4.300</td>\n",
       "      <td>WST726M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>15002002029001</td>\n",
       "      <td>wing lwr rib bay 25 fwd of r.s.</td>\n",
       "      <td>4.300</td>\n",
       "      <td>2.900</td>\n",
       "      <td>-0.700</td>\n",
       "      <td>-0.241</td>\n",
       "      <td>t</td>\n",
       "      <td>0.380</td>\n",
       "      <td>40000</td>\n",
       "      <td>0.720</td>\n",
       "      <td>3.300</td>\n",
       "      <td>4.600</td>\n",
       "      <td>WST726M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3481</th>\n",
       "      <td>15002002029001</td>\n",
       "      <td>wing lwr rib bay 25 fwd of r.s.</td>\n",
       "      <td>4.300</td>\n",
       "      <td>3.000</td>\n",
       "      <td>-0.700</td>\n",
       "      <td>-0.233</td>\n",
       "      <td>t</td>\n",
       "      <td>0.380</td>\n",
       "      <td>40000</td>\n",
       "      <td>0.710</td>\n",
       "      <td>3.300</td>\n",
       "      <td>4.700</td>\n",
       "      <td>WST726M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1485</th>\n",
       "      <td>15002002029001</td>\n",
       "      <td>wing lwr rib bay 25 fwd of r.s.</td>\n",
       "      <td>3.900</td>\n",
       "      <td>3.200</td>\n",
       "      <td>-0.700</td>\n",
       "      <td>-0.219</td>\n",
       "      <td>t</td>\n",
       "      <td>0.390</td>\n",
       "      <td>25000</td>\n",
       "      <td>0.740</td>\n",
       "      <td>3.700</td>\n",
       "      <td>4.900</td>\n",
       "      <td>WST726M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6585</th>\n",
       "      <td>15002002029001</td>\n",
       "      <td>wing lwr rib bay 25 fwd of r.s.</td>\n",
       "      <td>3.900</td>\n",
       "      <td>3.200</td>\n",
       "      <td>-0.700</td>\n",
       "      <td>-0.219</td>\n",
       "      <td>t</td>\n",
       "      <td>0.390</td>\n",
       "      <td>25000</td>\n",
       "      <td>0.740</td>\n",
       "      <td>3.700</td>\n",
       "      <td>4.900</td>\n",
       "      <td>WST726M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3228</th>\n",
       "      <td>15003001001001</td>\n",
       "      <td>wing xxxxx</td>\n",
       "      <td>13.500</td>\n",
       "      <td>9.400</td>\n",
       "      <td>-1.800</td>\n",
       "      <td>-0.191</td>\n",
       "      <td>t</td>\n",
       "      <td>0.570</td>\n",
       "      <td>75000</td>\n",
       "      <td>0.680</td>\n",
       "      <td>9.100</td>\n",
       "      <td>12.700</td>\n",
       "      <td>SOBF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6916</th>\n",
       "      <td>15003001001001</td>\n",
       "      <td>wing xxxxx</td>\n",
       "      <td>13.600</td>\n",
       "      <td>9.500</td>\n",
       "      <td>-1.800</td>\n",
       "      <td>-0.189</td>\n",
       "      <td>t</td>\n",
       "      <td>0.570</td>\n",
       "      <td>75000</td>\n",
       "      <td>0.680</td>\n",
       "      <td>9.100</td>\n",
       "      <td>12.800</td>\n",
       "      <td>SOBF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5396</th>\n",
       "      <td>15003001001001</td>\n",
       "      <td>wing xxxxx</td>\n",
       "      <td>12.000</td>\n",
       "      <td>9.900</td>\n",
       "      <td>-2.200</td>\n",
       "      <td>-0.222</td>\n",
       "      <td>t</td>\n",
       "      <td>0.620</td>\n",
       "      <td>40000</td>\n",
       "      <td>0.700</td>\n",
       "      <td>9.800</td>\n",
       "      <td>13.300</td>\n",
       "      <td>SOBF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6296</th>\n",
       "      <td>15003001001001</td>\n",
       "      <td>wing xxxxx</td>\n",
       "      <td>12.100</td>\n",
       "      <td>10.000</td>\n",
       "      <td>-2.300</td>\n",
       "      <td>-0.230</td>\n",
       "      <td>t</td>\n",
       "      <td>0.630</td>\n",
       "      <td>40000</td>\n",
       "      <td>0.710</td>\n",
       "      <td>9.900</td>\n",
       "      <td>13.300</td>\n",
       "      <td>SOBF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1232</th>\n",
       "      <td>15003001001001</td>\n",
       "      <td>wing xxxxx</td>\n",
       "      <td>10.900</td>\n",
       "      <td>10.000</td>\n",
       "      <td>-2.400</td>\n",
       "      <td>-0.240</td>\n",
       "      <td>t</td>\n",
       "      <td>0.610</td>\n",
       "      <td>25000</td>\n",
       "      <td>0.690</td>\n",
       "      <td>10.000</td>\n",
       "      <td>13.800</td>\n",
       "      <td>SOBF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852</th>\n",
       "      <td>15003001001001</td>\n",
       "      <td>wing xxxxx</td>\n",
       "      <td>10.300</td>\n",
       "      <td>9.900</td>\n",
       "      <td>-1.300</td>\n",
       "      <td>-0.131</td>\n",
       "      <td>t</td>\n",
       "      <td>0.560</td>\n",
       "      <td>25000</td>\n",
       "      <td>0.680</td>\n",
       "      <td>9.700</td>\n",
       "      <td>13.600</td>\n",
       "      <td>SOBF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3229</th>\n",
       "      <td>15003001002001</td>\n",
       "      <td>wing xxxxx</td>\n",
       "      <td>14.500</td>\n",
       "      <td>10.400</td>\n",
       "      <td>-1.900</td>\n",
       "      <td>-0.183</td>\n",
       "      <td>t</td>\n",
       "      <td>0.590</td>\n",
       "      <td>75000</td>\n",
       "      <td>0.700</td>\n",
       "      <td>10.100</td>\n",
       "      <td>13.600</td>\n",
       "      <td>SOBF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6917</th>\n",
       "      <td>15003001002001</td>\n",
       "      <td>wing xxxxx</td>\n",
       "      <td>14.500</td>\n",
       "      <td>10.400</td>\n",
       "      <td>-1.900</td>\n",
       "      <td>-0.183</td>\n",
       "      <td>t</td>\n",
       "      <td>0.590</td>\n",
       "      <td>75000</td>\n",
       "      <td>0.710</td>\n",
       "      <td>10.200</td>\n",
       "      <td>13.600</td>\n",
       "      <td>SOBF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5397</th>\n",
       "      <td>15003001002001</td>\n",
       "      <td>wing xxxxx</td>\n",
       "      <td>13.000</td>\n",
       "      <td>11.000</td>\n",
       "      <td>-2.300</td>\n",
       "      <td>-0.209</td>\n",
       "      <td>t</td>\n",
       "      <td>0.660</td>\n",
       "      <td>40000</td>\n",
       "      <td>0.720</td>\n",
       "      <td>10.800</td>\n",
       "      <td>14.300</td>\n",
       "      <td>SOBF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6297</th>\n",
       "      <td>15003001002001</td>\n",
       "      <td>wing xxxxx</td>\n",
       "      <td>13.100</td>\n",
       "      <td>11.100</td>\n",
       "      <td>-2.400</td>\n",
       "      <td>-0.216</td>\n",
       "      <td>t</td>\n",
       "      <td>0.660</td>\n",
       "      <td>40000</td>\n",
       "      <td>0.720</td>\n",
       "      <td>10.900</td>\n",
       "      <td>14.400</td>\n",
       "      <td>SOBF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1233</th>\n",
       "      <td>15003001002001</td>\n",
       "      <td>wing xxxxx</td>\n",
       "      <td>11.800</td>\n",
       "      <td>11.100</td>\n",
       "      <td>-2.500</td>\n",
       "      <td>-0.225</td>\n",
       "      <td>t</td>\n",
       "      <td>0.640</td>\n",
       "      <td>25000</td>\n",
       "      <td>0.720</td>\n",
       "      <td>11.300</td>\n",
       "      <td>14.800</td>\n",
       "      <td>SOBF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1853</th>\n",
       "      <td>15003001002001</td>\n",
       "      <td>wing xxxxx</td>\n",
       "      <td>11.300</td>\n",
       "      <td>11.100</td>\n",
       "      <td>-1.600</td>\n",
       "      <td>-0.144</td>\n",
       "      <td>t</td>\n",
       "      <td>0.610</td>\n",
       "      <td>25000</td>\n",
       "      <td>0.720</td>\n",
       "      <td>11.000</td>\n",
       "      <td>14.600</td>\n",
       "      <td>SOBF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3230</th>\n",
       "      <td>15003001003001</td>\n",
       "      <td>wing xxxxx</td>\n",
       "      <td>15.000</td>\n",
       "      <td>11.000</td>\n",
       "      <td>-1.900</td>\n",
       "      <td>-0.173</td>\n",
       "      <td>t</td>\n",
       "      <td>0.630</td>\n",
       "      <td>75000</td>\n",
       "      <td>0.710</td>\n",
       "      <td>10.600</td>\n",
       "      <td>14.000</td>\n",
       "      <td>SOBF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6918</th>\n",
       "      <td>15003001003001</td>\n",
       "      <td>wing xxxxx</td>\n",
       "      <td>15.000</td>\n",
       "      <td>11.000</td>\n",
       "      <td>-1.900</td>\n",
       "      <td>-0.173</td>\n",
       "      <td>t</td>\n",
       "      <td>0.630</td>\n",
       "      <td>75000</td>\n",
       "      <td>0.710</td>\n",
       "      <td>10.600</td>\n",
       "      <td>14.100</td>\n",
       "      <td>SOBF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5398</th>\n",
       "      <td>15003001003001</td>\n",
       "      <td>wing xxxxx</td>\n",
       "      <td>13.500</td>\n",
       "      <td>11.700</td>\n",
       "      <td>-2.400</td>\n",
       "      <td>-0.205</td>\n",
       "      <td>t</td>\n",
       "      <td>0.680</td>\n",
       "      <td>40000</td>\n",
       "      <td>0.730</td>\n",
       "      <td>11.400</td>\n",
       "      <td>14.800</td>\n",
       "      <td>SOBF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6298</th>\n",
       "      <td>15003001003001</td>\n",
       "      <td>wing xxxxx</td>\n",
       "      <td>13.600</td>\n",
       "      <td>11.800</td>\n",
       "      <td>-2.400</td>\n",
       "      <td>-0.203</td>\n",
       "      <td>t</td>\n",
       "      <td>0.690</td>\n",
       "      <td>40000</td>\n",
       "      <td>0.730</td>\n",
       "      <td>11.400</td>\n",
       "      <td>14.900</td>\n",
       "      <td>SOBF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1234</th>\n",
       "      <td>15003001003001</td>\n",
       "      <td>wing xxxxx</td>\n",
       "      <td>12.300</td>\n",
       "      <td>11.800</td>\n",
       "      <td>-2.500</td>\n",
       "      <td>-0.212</td>\n",
       "      <td>t</td>\n",
       "      <td>0.660</td>\n",
       "      <td>25000</td>\n",
       "      <td>0.730</td>\n",
       "      <td>11.800</td>\n",
       "      <td>15.400</td>\n",
       "      <td>SOBF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1854</th>\n",
       "      <td>15003001003001</td>\n",
       "      <td>wing xxxxx</td>\n",
       "      <td>11.800</td>\n",
       "      <td>11.700</td>\n",
       "      <td>-1.700</td>\n",
       "      <td>-0.145</td>\n",
       "      <td>t</td>\n",
       "      <td>0.640</td>\n",
       "      <td>25000</td>\n",
       "      <td>0.720</td>\n",
       "      <td>11.600</td>\n",
       "      <td>15.100</td>\n",
       "      <td>SOBF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8331</th>\n",
       "      <td>56011002026001</td>\n",
       "      <td>rib bay 22 - lwr front spar chord</td>\n",
       "      <td>9.200</td>\n",
       "      <td>5.900</td>\n",
       "      <td>-0.900</td>\n",
       "      <td>-0.153</td>\n",
       "      <td>t</td>\n",
       "      <td>0.400</td>\n",
       "      <td>75000</td>\n",
       "      <td>0.550</td>\n",
       "      <td>5.000</td>\n",
       "      <td>8.800</td>\n",
       "      <td>WST655M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9977</th>\n",
       "      <td>56011002026001</td>\n",
       "      <td>rib bay 22 - lwr front spar chord</td>\n",
       "      <td>9.300</td>\n",
       "      <td>5.900</td>\n",
       "      <td>-0.900</td>\n",
       "      <td>-0.153</td>\n",
       "      <td>t</td>\n",
       "      <td>0.400</td>\n",
       "      <td>75000</td>\n",
       "      <td>0.550</td>\n",
       "      <td>5.000</td>\n",
       "      <td>8.900</td>\n",
       "      <td>WST655M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7267</th>\n",
       "      <td>56011002026001</td>\n",
       "      <td>rib bay 22 - lwr front spar chord</td>\n",
       "      <td>8.200</td>\n",
       "      <td>6.500</td>\n",
       "      <td>-0.900</td>\n",
       "      <td>-0.138</td>\n",
       "      <td>t</td>\n",
       "      <td>0.460</td>\n",
       "      <td>40000</td>\n",
       "      <td>0.610</td>\n",
       "      <td>5.900</td>\n",
       "      <td>9.400</td>\n",
       "      <td>WST655M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10495</th>\n",
       "      <td>56011002026001</td>\n",
       "      <td>rib bay 22 - lwr front spar chord</td>\n",
       "      <td>8.300</td>\n",
       "      <td>6.600</td>\n",
       "      <td>-0.900</td>\n",
       "      <td>-0.136</td>\n",
       "      <td>t</td>\n",
       "      <td>0.460</td>\n",
       "      <td>40000</td>\n",
       "      <td>0.610</td>\n",
       "      <td>5.900</td>\n",
       "      <td>9.500</td>\n",
       "      <td>WST655M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7471</th>\n",
       "      <td>56011002026001</td>\n",
       "      <td>rib bay 22 - lwr front spar chord</td>\n",
       "      <td>7.500</td>\n",
       "      <td>6.900</td>\n",
       "      <td>-0.900</td>\n",
       "      <td>-0.130</td>\n",
       "      <td>t</td>\n",
       "      <td>0.460</td>\n",
       "      <td>25000</td>\n",
       "      <td>0.610</td>\n",
       "      <td>6.200</td>\n",
       "      <td>10.000</td>\n",
       "      <td>WST655M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9873</th>\n",
       "      <td>56011002026001</td>\n",
       "      <td>rib bay 22 - lwr front spar chord</td>\n",
       "      <td>7.500</td>\n",
       "      <td>6.800</td>\n",
       "      <td>-0.900</td>\n",
       "      <td>-0.132</td>\n",
       "      <td>t</td>\n",
       "      <td>0.460</td>\n",
       "      <td>25000</td>\n",
       "      <td>0.610</td>\n",
       "      <td>6.200</td>\n",
       "      <td>9.900</td>\n",
       "      <td>WST655M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8332</th>\n",
       "      <td>56011002027001</td>\n",
       "      <td>rib bay 23 - lwr front spar chord</td>\n",
       "      <td>8.000</td>\n",
       "      <td>4.800</td>\n",
       "      <td>-0.700</td>\n",
       "      <td>-0.146</td>\n",
       "      <td>t</td>\n",
       "      <td>0.350</td>\n",
       "      <td>75000</td>\n",
       "      <td>0.520</td>\n",
       "      <td>4.000</td>\n",
       "      <td>7.600</td>\n",
       "      <td>WST679M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9978</th>\n",
       "      <td>56011002027001</td>\n",
       "      <td>rib bay 23 - lwr front spar chord</td>\n",
       "      <td>8.000</td>\n",
       "      <td>4.900</td>\n",
       "      <td>-0.700</td>\n",
       "      <td>-0.143</td>\n",
       "      <td>t</td>\n",
       "      <td>0.350</td>\n",
       "      <td>75000</td>\n",
       "      <td>0.510</td>\n",
       "      <td>4.000</td>\n",
       "      <td>7.700</td>\n",
       "      <td>WST679M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7268</th>\n",
       "      <td>56011002027001</td>\n",
       "      <td>rib bay 23 - lwr front spar chord</td>\n",
       "      <td>7.100</td>\n",
       "      <td>5.500</td>\n",
       "      <td>-0.700</td>\n",
       "      <td>-0.127</td>\n",
       "      <td>t</td>\n",
       "      <td>0.440</td>\n",
       "      <td>40000</td>\n",
       "      <td>0.580</td>\n",
       "      <td>4.900</td>\n",
       "      <td>8.200</td>\n",
       "      <td>WST679M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10496</th>\n",
       "      <td>56011002027001</td>\n",
       "      <td>rib bay 23 - lwr front spar chord</td>\n",
       "      <td>7.100</td>\n",
       "      <td>5.500</td>\n",
       "      <td>-0.700</td>\n",
       "      <td>-0.127</td>\n",
       "      <td>t</td>\n",
       "      <td>0.430</td>\n",
       "      <td>40000</td>\n",
       "      <td>0.580</td>\n",
       "      <td>4.900</td>\n",
       "      <td>8.300</td>\n",
       "      <td>WST679M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7472</th>\n",
       "      <td>56011002027001</td>\n",
       "      <td>rib bay 23 - lwr front spar chord</td>\n",
       "      <td>6.500</td>\n",
       "      <td>5.800</td>\n",
       "      <td>-0.700</td>\n",
       "      <td>-0.121</td>\n",
       "      <td>t</td>\n",
       "      <td>0.440</td>\n",
       "      <td>25000</td>\n",
       "      <td>0.570</td>\n",
       "      <td>5.100</td>\n",
       "      <td>8.700</td>\n",
       "      <td>WST679M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9874</th>\n",
       "      <td>56011002027001</td>\n",
       "      <td>rib bay 23 - lwr front spar chord</td>\n",
       "      <td>6.500</td>\n",
       "      <td>5.800</td>\n",
       "      <td>-0.700</td>\n",
       "      <td>-0.121</td>\n",
       "      <td>t</td>\n",
       "      <td>0.440</td>\n",
       "      <td>25000</td>\n",
       "      <td>0.580</td>\n",
       "      <td>5.100</td>\n",
       "      <td>8.600</td>\n",
       "      <td>WST679M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8333</th>\n",
       "      <td>56011002028001</td>\n",
       "      <td>rib bay 24 - lwr front spar chord</td>\n",
       "      <td>6.400</td>\n",
       "      <td>3.700</td>\n",
       "      <td>-0.600</td>\n",
       "      <td>-0.162</td>\n",
       "      <td>t</td>\n",
       "      <td>0.310</td>\n",
       "      <td>75000</td>\n",
       "      <td>0.500</td>\n",
       "      <td>3.100</td>\n",
       "      <td>6.100</td>\n",
       "      <td>WST703M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9979</th>\n",
       "      <td>56011002028001</td>\n",
       "      <td>rib bay 24 - lwr front spar chord</td>\n",
       "      <td>6.400</td>\n",
       "      <td>3.700</td>\n",
       "      <td>-0.600</td>\n",
       "      <td>-0.162</td>\n",
       "      <td>t</td>\n",
       "      <td>0.310</td>\n",
       "      <td>75000</td>\n",
       "      <td>0.500</td>\n",
       "      <td>3.100</td>\n",
       "      <td>6.200</td>\n",
       "      <td>WST703M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7269</th>\n",
       "      <td>56011002028001</td>\n",
       "      <td>rib bay 24 - lwr front spar chord</td>\n",
       "      <td>5.700</td>\n",
       "      <td>4.300</td>\n",
       "      <td>-0.600</td>\n",
       "      <td>-0.140</td>\n",
       "      <td>t</td>\n",
       "      <td>0.410</td>\n",
       "      <td>40000</td>\n",
       "      <td>0.550</td>\n",
       "      <td>3.700</td>\n",
       "      <td>6.600</td>\n",
       "      <td>WST703M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10497</th>\n",
       "      <td>56011002028001</td>\n",
       "      <td>rib bay 24 - lwr front spar chord</td>\n",
       "      <td>5.700</td>\n",
       "      <td>4.300</td>\n",
       "      <td>-0.600</td>\n",
       "      <td>-0.140</td>\n",
       "      <td>t</td>\n",
       "      <td>0.410</td>\n",
       "      <td>40000</td>\n",
       "      <td>0.550</td>\n",
       "      <td>3.700</td>\n",
       "      <td>6.700</td>\n",
       "      <td>WST703M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7473</th>\n",
       "      <td>56011002028001</td>\n",
       "      <td>rib bay 24 - lwr front spar chord</td>\n",
       "      <td>5.200</td>\n",
       "      <td>4.500</td>\n",
       "      <td>-0.600</td>\n",
       "      <td>-0.133</td>\n",
       "      <td>t</td>\n",
       "      <td>0.410</td>\n",
       "      <td>25000</td>\n",
       "      <td>0.550</td>\n",
       "      <td>3.900</td>\n",
       "      <td>7.000</td>\n",
       "      <td>WST703M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9875</th>\n",
       "      <td>56011002028001</td>\n",
       "      <td>rib bay 24 - lwr front spar chord</td>\n",
       "      <td>5.200</td>\n",
       "      <td>4.500</td>\n",
       "      <td>-0.600</td>\n",
       "      <td>-0.133</td>\n",
       "      <td>t</td>\n",
       "      <td>0.420</td>\n",
       "      <td>25000</td>\n",
       "      <td>0.550</td>\n",
       "      <td>3.900</td>\n",
       "      <td>6.900</td>\n",
       "      <td>WST703M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8334</th>\n",
       "      <td>56011002029001</td>\n",
       "      <td>rib bay 25 - lwr front spar chord</td>\n",
       "      <td>5.200</td>\n",
       "      <td>2.800</td>\n",
       "      <td>-0.400</td>\n",
       "      <td>-0.143</td>\n",
       "      <td>t</td>\n",
       "      <td>0.240</td>\n",
       "      <td>75000</td>\n",
       "      <td>0.700</td>\n",
       "      <td>3.500</td>\n",
       "      <td>5.000</td>\n",
       "      <td>WST726M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9980</th>\n",
       "      <td>56011002029001</td>\n",
       "      <td>rib bay 25 - lwr front spar chord</td>\n",
       "      <td>5.200</td>\n",
       "      <td>2.900</td>\n",
       "      <td>-0.400</td>\n",
       "      <td>-0.138</td>\n",
       "      <td>t</td>\n",
       "      <td>0.250</td>\n",
       "      <td>75000</td>\n",
       "      <td>0.690</td>\n",
       "      <td>3.600</td>\n",
       "      <td>5.200</td>\n",
       "      <td>WST726M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7270</th>\n",
       "      <td>56011002029001</td>\n",
       "      <td>rib bay 25 - lwr front spar chord</td>\n",
       "      <td>4.600</td>\n",
       "      <td>3.400</td>\n",
       "      <td>-0.400</td>\n",
       "      <td>-0.118</td>\n",
       "      <td>t</td>\n",
       "      <td>0.360</td>\n",
       "      <td>40000</td>\n",
       "      <td>0.720</td>\n",
       "      <td>4.000</td>\n",
       "      <td>5.400</td>\n",
       "      <td>WST726M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10498</th>\n",
       "      <td>56011002029001</td>\n",
       "      <td>rib bay 25 - lwr front spar chord</td>\n",
       "      <td>4.700</td>\n",
       "      <td>3.500</td>\n",
       "      <td>-0.400</td>\n",
       "      <td>-0.114</td>\n",
       "      <td>t</td>\n",
       "      <td>0.360</td>\n",
       "      <td>40000</td>\n",
       "      <td>0.710</td>\n",
       "      <td>4.000</td>\n",
       "      <td>5.500</td>\n",
       "      <td>WST726M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7474</th>\n",
       "      <td>56011002029001</td>\n",
       "      <td>rib bay 25 - lwr front spar chord</td>\n",
       "      <td>4.200</td>\n",
       "      <td>3.600</td>\n",
       "      <td>-0.400</td>\n",
       "      <td>-0.111</td>\n",
       "      <td>t</td>\n",
       "      <td>0.370</td>\n",
       "      <td>25000</td>\n",
       "      <td>0.720</td>\n",
       "      <td>4.200</td>\n",
       "      <td>5.800</td>\n",
       "      <td>WST726M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9876</th>\n",
       "      <td>56011002029001</td>\n",
       "      <td>rib bay 25 - lwr front spar chord</td>\n",
       "      <td>4.200</td>\n",
       "      <td>3.600</td>\n",
       "      <td>-0.400</td>\n",
       "      <td>-0.111</td>\n",
       "      <td>t</td>\n",
       "      <td>0.380</td>\n",
       "      <td>25000</td>\n",
       "      <td>0.710</td>\n",
       "      <td>4.100</td>\n",
       "      <td>5.700</td>\n",
       "      <td>WST726M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8335</th>\n",
       "      <td>56011002030001</td>\n",
       "      <td>rib bay 26 - lwr front spar chord</td>\n",
       "      <td>4.400</td>\n",
       "      <td>2.300</td>\n",
       "      <td>-0.200</td>\n",
       "      <td>-0.087</td>\n",
       "      <td>t</td>\n",
       "      <td>0.190</td>\n",
       "      <td>75000</td>\n",
       "      <td>0.630</td>\n",
       "      <td>2.700</td>\n",
       "      <td>4.300</td>\n",
       "      <td>WST748M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9981</th>\n",
       "      <td>56011002030001</td>\n",
       "      <td>rib bay 26 - lwr front spar chord</td>\n",
       "      <td>4.400</td>\n",
       "      <td>2.500</td>\n",
       "      <td>-0.200</td>\n",
       "      <td>-0.080</td>\n",
       "      <td>t</td>\n",
       "      <td>0.240</td>\n",
       "      <td>75000</td>\n",
       "      <td>0.630</td>\n",
       "      <td>2.800</td>\n",
       "      <td>4.400</td>\n",
       "      <td>WST748M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7271</th>\n",
       "      <td>56011002030001</td>\n",
       "      <td>rib bay 26 - lwr front spar chord</td>\n",
       "      <td>3.900</td>\n",
       "      <td>2.800</td>\n",
       "      <td>-0.200</td>\n",
       "      <td>-0.071</td>\n",
       "      <td>t</td>\n",
       "      <td>0.280</td>\n",
       "      <td>40000</td>\n",
       "      <td>0.660</td>\n",
       "      <td>3.100</td>\n",
       "      <td>4.600</td>\n",
       "      <td>WST748M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10499</th>\n",
       "      <td>56011002030001</td>\n",
       "      <td>rib bay 26 - lwr front spar chord</td>\n",
       "      <td>3.900</td>\n",
       "      <td>2.800</td>\n",
       "      <td>-0.200</td>\n",
       "      <td>-0.071</td>\n",
       "      <td>t</td>\n",
       "      <td>0.270</td>\n",
       "      <td>40000</td>\n",
       "      <td>0.690</td>\n",
       "      <td>3.300</td>\n",
       "      <td>4.700</td>\n",
       "      <td>WST748M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7475</th>\n",
       "      <td>56011002030001</td>\n",
       "      <td>rib bay 26 - lwr front spar chord</td>\n",
       "      <td>3.600</td>\n",
       "      <td>2.900</td>\n",
       "      <td>-0.200</td>\n",
       "      <td>-0.069</td>\n",
       "      <td>t</td>\n",
       "      <td>0.280</td>\n",
       "      <td>25000</td>\n",
       "      <td>0.680</td>\n",
       "      <td>3.400</td>\n",
       "      <td>4.900</td>\n",
       "      <td>WST748M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9877</th>\n",
       "      <td>56011002030001</td>\n",
       "      <td>rib bay 26 - lwr front spar chord</td>\n",
       "      <td>3.500</td>\n",
       "      <td>2.900</td>\n",
       "      <td>-0.200</td>\n",
       "      <td>-0.069</td>\n",
       "      <td>t</td>\n",
       "      <td>0.290</td>\n",
       "      <td>25000</td>\n",
       "      <td>0.660</td>\n",
       "      <td>3.200</td>\n",
       "      <td>4.900</td>\n",
       "      <td>WST748M</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10500 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              Element                           Location  DFRreq   Fmax  \\\n",
       "3948   15002001029001    wing lwr rib bay 25 fwd of r.s.   5.800  2.900   \n",
       "4452   15002001029001    wing lwr rib bay 25 fwd of r.s.   5.800  2.900   \n",
       "108    15002001029001    wing lwr rib bay 25 fwd of r.s.   5.200  3.700   \n",
       "3480   15002001029001    wing lwr rib bay 25 fwd of r.s.   5.200  3.700   \n",
       "1484   15002001029001    wing lwr rib bay 25 fwd of r.s.   4.800  3.900   \n",
       "6584   15002001029001    wing lwr rib bay 25 fwd of r.s.   4.800  3.900   \n",
       "3949   15002002029001    wing lwr rib bay 25 fwd of r.s.   4.800  2.400   \n",
       "4453   15002002029001    wing lwr rib bay 25 fwd of r.s.   4.800  2.400   \n",
       "109    15002002029001    wing lwr rib bay 25 fwd of r.s.   4.300  2.900   \n",
       "3481   15002002029001    wing lwr rib bay 25 fwd of r.s.   4.300  3.000   \n",
       "1485   15002002029001    wing lwr rib bay 25 fwd of r.s.   3.900  3.200   \n",
       "6585   15002002029001    wing lwr rib bay 25 fwd of r.s.   3.900  3.200   \n",
       "3228   15003001001001                         wing xxxxx  13.500  9.400   \n",
       "6916   15003001001001                         wing xxxxx  13.600  9.500   \n",
       "5396   15003001001001                         wing xxxxx  12.000  9.900   \n",
       "6296   15003001001001                         wing xxxxx  12.100 10.000   \n",
       "1232   15003001001001                         wing xxxxx  10.900 10.000   \n",
       "1852   15003001001001                         wing xxxxx  10.300  9.900   \n",
       "3229   15003001002001                         wing xxxxx  14.500 10.400   \n",
       "6917   15003001002001                         wing xxxxx  14.500 10.400   \n",
       "5397   15003001002001                         wing xxxxx  13.000 11.000   \n",
       "6297   15003001002001                         wing xxxxx  13.100 11.100   \n",
       "1233   15003001002001                         wing xxxxx  11.800 11.100   \n",
       "1853   15003001002001                         wing xxxxx  11.300 11.100   \n",
       "3230   15003001003001                         wing xxxxx  15.000 11.000   \n",
       "6918   15003001003001                         wing xxxxx  15.000 11.000   \n",
       "5398   15003001003001                         wing xxxxx  13.500 11.700   \n",
       "6298   15003001003001                         wing xxxxx  13.600 11.800   \n",
       "1234   15003001003001                         wing xxxxx  12.300 11.800   \n",
       "1854   15003001003001                         wing xxxxx  11.800 11.700   \n",
       "...               ...                                ...     ...    ...   \n",
       "8331   56011002026001  rib bay 22 - lwr front spar chord   9.200  5.900   \n",
       "9977   56011002026001  rib bay 22 - lwr front spar chord   9.300  5.900   \n",
       "7267   56011002026001  rib bay 22 - lwr front spar chord   8.200  6.500   \n",
       "10495  56011002026001  rib bay 22 - lwr front spar chord   8.300  6.600   \n",
       "7471   56011002026001  rib bay 22 - lwr front spar chord   7.500  6.900   \n",
       "9873   56011002026001  rib bay 22 - lwr front spar chord   7.500  6.800   \n",
       "8332   56011002027001  rib bay 23 - lwr front spar chord   8.000  4.800   \n",
       "9978   56011002027001  rib bay 23 - lwr front spar chord   8.000  4.900   \n",
       "7268   56011002027001  rib bay 23 - lwr front spar chord   7.100  5.500   \n",
       "10496  56011002027001  rib bay 23 - lwr front spar chord   7.100  5.500   \n",
       "7472   56011002027001  rib bay 23 - lwr front spar chord   6.500  5.800   \n",
       "9874   56011002027001  rib bay 23 - lwr front spar chord   6.500  5.800   \n",
       "8333   56011002028001  rib bay 24 - lwr front spar chord   6.400  3.700   \n",
       "9979   56011002028001  rib bay 24 - lwr front spar chord   6.400  3.700   \n",
       "7269   56011002028001  rib bay 24 - lwr front spar chord   5.700  4.300   \n",
       "10497  56011002028001  rib bay 24 - lwr front spar chord   5.700  4.300   \n",
       "7473   56011002028001  rib bay 24 - lwr front spar chord   5.200  4.500   \n",
       "9875   56011002028001  rib bay 24 - lwr front spar chord   5.200  4.500   \n",
       "8334   56011002029001  rib bay 25 - lwr front spar chord   5.200  2.800   \n",
       "9980   56011002029001  rib bay 25 - lwr front spar chord   5.200  2.900   \n",
       "7270   56011002029001  rib bay 25 - lwr front spar chord   4.600  3.400   \n",
       "10498  56011002029001  rib bay 25 - lwr front spar chord   4.700  3.500   \n",
       "7474   56011002029001  rib bay 25 - lwr front spar chord   4.200  3.600   \n",
       "9876   56011002029001  rib bay 25 - lwr front spar chord   4.200  3.600   \n",
       "8335   56011002030001  rib bay 26 - lwr front spar chord   4.400  2.300   \n",
       "9981   56011002030001  rib bay 26 - lwr front spar chord   4.400  2.500   \n",
       "7271   56011002030001  rib bay 26 - lwr front spar chord   3.900  2.800   \n",
       "10499  56011002030001  rib bay 26 - lwr front spar chord   3.900  2.800   \n",
       "7475   56011002030001  rib bay 26 - lwr front spar chord   3.600  2.900   \n",
       "9877   56011002030001  rib bay 26 - lwr front spar chord   3.500  2.900   \n",
       "\n",
       "        Fmin      R Mode   GAG    DSO   SEF  Stress Rating     Sc  DMF Set  \n",
       "3948  -0.700 -0.241    t 0.260  75000 0.730          3.900  5.200  WST726M  \n",
       "4452  -0.700 -0.241    t 0.260  75000 0.730          3.900  5.200  WST726M  \n",
       "108   -0.700 -0.189    t 0.380  40000 0.760          4.400  5.700  WST726M  \n",
       "3480  -0.700 -0.189    t 0.380  40000 0.760          4.400  5.700  WST726M  \n",
       "1484  -0.700 -0.179    t 0.390  25000 0.750          4.600  6.100  WST726M  \n",
       "6584  -0.700 -0.179    t 0.390  25000 0.750          4.600  6.100  WST726M  \n",
       "3949  -0.700 -0.292    t 0.260  75000 0.710          3.000  4.300  WST726M  \n",
       "4453  -0.700 -0.292    t 0.260  75000 0.670          2.900  4.300  WST726M  \n",
       "109   -0.700 -0.241    t 0.380  40000 0.720          3.300  4.600  WST726M  \n",
       "3481  -0.700 -0.233    t 0.380  40000 0.710          3.300  4.700  WST726M  \n",
       "1485  -0.700 -0.219    t 0.390  25000 0.740          3.700  4.900  WST726M  \n",
       "6585  -0.700 -0.219    t 0.390  25000 0.740          3.700  4.900  WST726M  \n",
       "3228  -1.800 -0.191    t 0.570  75000 0.680          9.100 12.700     SOBF  \n",
       "6916  -1.800 -0.189    t 0.570  75000 0.680          9.100 12.800     SOBF  \n",
       "5396  -2.200 -0.222    t 0.620  40000 0.700          9.800 13.300     SOBF  \n",
       "6296  -2.300 -0.230    t 0.630  40000 0.710          9.900 13.300     SOBF  \n",
       "1232  -2.400 -0.240    t 0.610  25000 0.690         10.000 13.800     SOBF  \n",
       "1852  -1.300 -0.131    t 0.560  25000 0.680          9.700 13.600     SOBF  \n",
       "3229  -1.900 -0.183    t 0.590  75000 0.700         10.100 13.600     SOBF  \n",
       "6917  -1.900 -0.183    t 0.590  75000 0.710         10.200 13.600     SOBF  \n",
       "5397  -2.300 -0.209    t 0.660  40000 0.720         10.800 14.300     SOBF  \n",
       "6297  -2.400 -0.216    t 0.660  40000 0.720         10.900 14.400     SOBF  \n",
       "1233  -2.500 -0.225    t 0.640  25000 0.720         11.300 14.800     SOBF  \n",
       "1853  -1.600 -0.144    t 0.610  25000 0.720         11.000 14.600     SOBF  \n",
       "3230  -1.900 -0.173    t 0.630  75000 0.710         10.600 14.000     SOBF  \n",
       "6918  -1.900 -0.173    t 0.630  75000 0.710         10.600 14.100     SOBF  \n",
       "5398  -2.400 -0.205    t 0.680  40000 0.730         11.400 14.800     SOBF  \n",
       "6298  -2.400 -0.203    t 0.690  40000 0.730         11.400 14.900     SOBF  \n",
       "1234  -2.500 -0.212    t 0.660  25000 0.730         11.800 15.400     SOBF  \n",
       "1854  -1.700 -0.145    t 0.640  25000 0.720         11.600 15.100     SOBF  \n",
       "...      ...    ...  ...   ...    ...   ...            ...    ...      ...  \n",
       "8331  -0.900 -0.153    t 0.400  75000 0.550          5.000  8.800  WST655M  \n",
       "9977  -0.900 -0.153    t 0.400  75000 0.550          5.000  8.900  WST655M  \n",
       "7267  -0.900 -0.138    t 0.460  40000 0.610          5.900  9.400  WST655M  \n",
       "10495 -0.900 -0.136    t 0.460  40000 0.610          5.900  9.500  WST655M  \n",
       "7471  -0.900 -0.130    t 0.460  25000 0.610          6.200 10.000  WST655M  \n",
       "9873  -0.900 -0.132    t 0.460  25000 0.610          6.200  9.900  WST655M  \n",
       "8332  -0.700 -0.146    t 0.350  75000 0.520          4.000  7.600  WST679M  \n",
       "9978  -0.700 -0.143    t 0.350  75000 0.510          4.000  7.700  WST679M  \n",
       "7268  -0.700 -0.127    t 0.440  40000 0.580          4.900  8.200  WST679M  \n",
       "10496 -0.700 -0.127    t 0.430  40000 0.580          4.900  8.300  WST679M  \n",
       "7472  -0.700 -0.121    t 0.440  25000 0.570          5.100  8.700  WST679M  \n",
       "9874  -0.700 -0.121    t 0.440  25000 0.580          5.100  8.600  WST679M  \n",
       "8333  -0.600 -0.162    t 0.310  75000 0.500          3.100  6.100  WST703M  \n",
       "9979  -0.600 -0.162    t 0.310  75000 0.500          3.100  6.200  WST703M  \n",
       "7269  -0.600 -0.140    t 0.410  40000 0.550          3.700  6.600  WST703M  \n",
       "10497 -0.600 -0.140    t 0.410  40000 0.550          3.700  6.700  WST703M  \n",
       "7473  -0.600 -0.133    t 0.410  25000 0.550          3.900  7.000  WST703M  \n",
       "9875  -0.600 -0.133    t 0.420  25000 0.550          3.900  6.900  WST703M  \n",
       "8334  -0.400 -0.143    t 0.240  75000 0.700          3.500  5.000  WST726M  \n",
       "9980  -0.400 -0.138    t 0.250  75000 0.690          3.600  5.200  WST726M  \n",
       "7270  -0.400 -0.118    t 0.360  40000 0.720          4.000  5.400  WST726M  \n",
       "10498 -0.400 -0.114    t 0.360  40000 0.710          4.000  5.500  WST726M  \n",
       "7474  -0.400 -0.111    t 0.370  25000 0.720          4.200  5.800  WST726M  \n",
       "9876  -0.400 -0.111    t 0.380  25000 0.710          4.100  5.700  WST726M  \n",
       "8335  -0.200 -0.087    t 0.190  75000 0.630          2.700  4.300  WST748M  \n",
       "9981  -0.200 -0.080    t 0.240  75000 0.630          2.800  4.400  WST748M  \n",
       "7271  -0.200 -0.071    t 0.280  40000 0.660          3.100  4.600  WST748M  \n",
       "10499 -0.200 -0.071    t 0.270  40000 0.690          3.300  4.700  WST748M  \n",
       "7475  -0.200 -0.069    t 0.280  25000 0.680          3.400  4.900  WST748M  \n",
       "9877  -0.200 -0.069    t 0.290  25000 0.660          3.200  4.900  WST748M  \n",
       "\n",
       "[10500 rows x 13 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Display Float with 3 digits after point\n",
    "pd.options.display.float_format = '{:,.3f}'.format\n",
    "\n",
    "#Create the Data set with cpecified Columns\n",
    "ex=df[['Element','Location','DFRreq','Fmax','Fmin','R','Mode','GAG','DSO','SEF','Stress Rating','Sc','DMF Set']]\n",
    "\n",
    "#Sort the Rows by ascending/descending\n",
    "ex.sort_values(['Element','DSO'], axis=0, ascending=[True,False], inplace=False, kind='quicksort')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Create Excel file with values\n",
    "ex.to_excel(\"Loads_Summary.xlsx\",sheet_name='Sheet_name_1')\n",
    "\n",
    "#Create html if needed\n",
    "\n",
    "#ex.to_html('Loads.html')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    " "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.6.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}