{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Learning how to understand a project management dataset and build models in Python for further analysis\n", "Today we will be exploring a synthetically generated dataset based on the PERIL database. Learn more about the PERIL dataset and it's creator Tom Kendrick [here](http://www.failureproofprojects.com/peril.php). " ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "To accomplish our task of understanding the data, we will need to use some Python libraries. Python libraries can be summarized as code other people have written and shared that we can use to save us time. We can import and use that code with a small import statement. Some of the packages we will use today include [Pandas](https://towardsdatascience.com/a-quick-introduction-to-the-pandas-python-library-f1b678f34673), [Scipy](https://www.scipy.org/getting-started.html), [Numpy](https://docs.scipy.org/doc/numpy-1.15.0/user/whatisnumpy.html), and [MatPlotLib](https://matplotlib.org/). If you want to learn more about how these different packages work with examples, click [here](http://cs231n.github.io/python-numpy-tutorial/). If you would like to see the code that imports these packages - click the show code button below. " ] }, { "cell_type": "code", "execution_count": 34, "metadata": {}, "outputs": [], "source": [ "#Importing python libraries which help us speed our coding up.\n", "#The packages we're importing are below.\n", "import pandas as pd\n", "import random\n", "from pandas.plotting import scatter_matrix\n", "import scipy as sc\n", "import numpy as np\n", "import matplotlib\n", "import matplotlib.pyplot as plt #Can abbreviate specific parts of the packages so it's easier to type\n", "import sklearn as sk\n", "import seaborn as sns\n", "from sklearn.linear_model import LogisticRegression\n", "from sklearn import metrics\n", "from sklearn.neighbors import KNeighborsClassifier\n", "from sklearn.model_selection import train_test_split\n", "from sklearn import datasets, linear_model" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [], "source": [ "#We will now read the data in and store it in a dataframe called dataset\n", "dataset = pd.read_excel('Peril_Dataset.xlsx', header = 0)\n", "dataset.insert(loc = 0, column = 'Project Number', value = np.arange(len(dataset)))" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### Understanding our data\n", "Let's run some code and see how many rows and columns we have. Below - you will see the result as (Number of Rows, Number of Columns)" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "(5000, 13)" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "dataset.shape" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### What do the first 10 rows of our data look like? " ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | Project Number | \n", "Parameter | \n", "Category | \n", "Sub cat | \n", "Impact | \n", "TRL | \n", "Description | \n", "Region Numeric | \n", "Region | \n", "Project | \n", "Year | \n", "Month | \n", "Cost | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "0 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "18 | \n", "5 | \n", "Did not have sufficient resources and the cont... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2010 | \n", "October | \n", "700560 | \n", "
1 | \n", "1 | \n", "Resource | \n", "Outsourcing | \n", "Delayed start | \n", "17 | \n", "4 | \n", "Contractor setup delayed by a week | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2002 | \n", "May | \n", "347922 | \n", "
2 | \n", "2 | \n", "Resource | \n", "Outsourcing | \n", "Late or poor output | \n", "13 | \n", "5 | \n", "Contractor did not spend time on the project b... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2002 | \n", "August | \n", "919828 | \n", "
3 | \n", "3 | \n", "Resource | \n", "Outsourcing | \n", "Late or poor output | \n", "13 | \n", "7 | \n", "Contractors failed to show up as committed | \n", "1 | \n", "Asia | \n", "IT/Solution | \n", "2014 | \n", "July | \n", "521495 | \n", "
4 | \n", "4 | \n", "Resource | \n", "Outsourcing | \n", "Late or poor output | \n", "13 | \n", "3 | \n", "Third-party vendor inadvertently introduced a ... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2010 | \n", "November | \n", "322010 | \n", "
5 | \n", "5 | \n", "Resource | \n", "Outsourcing | \n", "Late or poor output | \n", "16 | \n", "7 | \n", "Outsouced staff lacked the necessary skillset | \n", "3 | \n", "Africa | \n", "IT/Solution | \n", "2014 | \n", "June | \n", "498896 | \n", "
6 | \n", "6 | \n", "Resource | \n", "People | \n", "Late start | \n", "15 | \n", "5 | \n", "Planning delayed due to staff being still tied... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2015 | \n", "April | \n", "592785 | \n", "
7 | \n", "7 | \n", "Resource | \n", "People | \n", "Loss | \n", "16 | \n", "4 | \n", "Chef quit two days before the café was schedul... | \n", "3 | \n", "Africa | \n", "IT/Solution | \n", "2017 | \n", "October | \n", "578928 | \n", "
8 | \n", "8 | \n", "Resource | \n", "People | \n", "Motivation | \n", "11 | \n", "5 | \n", "Work at customer site had to be done by union ... | \n", "3 | \n", "Africa | \n", "IT/Solution | \n", "2003 | \n", "July | \n", "318846 | \n", "
9 | \n", "9 | \n", "Resource | \n", "People | \n", "Queuing | \n", "16 | \n", "6 | \n", "Critical task assigned to a heavily booked expert | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2010 | \n", "June | \n", "1109120 | \n", "
\n", " | Project Number | \n", "Parameter | \n", "Category | \n", "Sub cat | \n", "Impact | \n", "TRL | \n", "Description | \n", "Region Numeric | \n", "Region | \n", "Project | \n", "Year | \n", "Month | \n", "Cost | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3842 | \n", "3842 | \n", "Resource | \n", "People | \n", "Late start | \n", "26 | \n", "3 | \n", "Change Management Lead took unexpected medical... | \n", "1 | \n", "Asia | \n", "IT/Solution | \n", "2003 | \n", "November | \n", "2562560 | \n", "
4940 | \n", "4940 | \n", "Scope | \n", "Change | \n", "Gap | \n", "26 | \n", "8 | \n", "Chip failed and had to be refabricated with ch... | \n", "2 | \n", "Eur/ME | \n", "IT/Solution | \n", "2018 | \n", "January | \n", "2548442 | \n", "
3705 | \n", "3705 | \n", "Resource | \n", "Outsourcing | \n", "Delayed start | \n", "26 | \n", "2 | \n", "Project had to wait until all data collection ... | \n", "2 | \n", "Eur/ME | \n", "Prod. Dev. | \n", "2001 | \n", "October | \n", "2543034 | \n", "
4956 | \n", "4956 | \n", "Scope | \n", "Change | \n", "Gap | \n", "26 | \n", "6 | \n", "The scope of the project was poorly defined | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2010 | \n", "September | \n", "2535416 | \n", "
4938 | \n", "4938 | \n", "Scope | \n", "Change | \n", "Gap | \n", "26 | \n", "3 | \n", "Ship sinks with critical part; forced to repla... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2010 | \n", "February | \n", "2533232 | \n", "
4077 | \n", "4077 | \n", "Schedule | \n", "Dependency | \n", "Project | \n", "26 | \n", "5 | \n", "Client's insisted on the use of \"the latest te... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2010 | \n", "May | \n", "2526342 | \n", "
4991 | \n", "4991 | \n", "Resource | \n", "People | \n", "Loss | \n", "26 | \n", "2 | \n", "To expand business, unrealistic commitments we... | \n", "3 | \n", "Africa | \n", "Prod. Dev. | \n", "2004 | \n", "May | \n", "2504268 | \n", "
4788 | \n", "4788 | \n", "Resource | \n", "People | \n", "Loss | \n", "25 | \n", "2 | \n", "Contract lab failed to inform us that they had... | \n", "3 | \n", "Africa | \n", "Prod. Dev. | \n", "2002 | \n", "December | \n", "2469325 | \n", "
4549 | \n", "4549 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "26 | \n", "4 | \n", "\"Minor\" changes added and accepted late in pr... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2002 | \n", "January | \n", "2437292 | \n", "
4552 | \n", "4552 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "26 | \n", "7 | \n", "Server technology chage was necessitated to su... | \n", "2 | \n", "Eur/ME | \n", "Prod. Dev. | \n", "2015 | \n", "December | \n", "2425748 | \n", "
4133 | \n", "4133 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "24 | \n", "6 | \n", "Shipping documents not filled in correctly | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2006 | \n", "March | \n", "2383512 | \n", "
4116 | \n", "4116 | \n", "Scope | \n", "Change | \n", "Gap | \n", "25 | \n", "6 | \n", "Key contributor out ill at critical time. | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2019 | \n", "December | \n", "2371375 | \n", "
3580 | \n", "3580 | \n", "Schedule | \n", "Delay | \n", "Parts | \n", "24 | \n", "2 | \n", "Team leader reassigned to another project and ... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2014 | \n", "November | \n", "2366784 | \n", "
4925 | \n", "4925 | \n", "Scope | \n", "Change | \n", "Creep | \n", "25 | \n", "2 | \n", "Outsourcing partner in Switzerland did unneede... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2010 | \n", "November | \n", "2360300 | \n", "
3394 | \n", "3394 | \n", "Schedule | \n", "Dependency | \n", "Infrastructure | \n", "26 | \n", "6 | \n", "Need to upgrade detected only at project end | \n", "2 | \n", "Eur/ME | \n", "Prod. Dev. | \n", "2003 | \n", "March | \n", "2357602 | \n", "
4251 | \n", "4251 | \n", "Resource | \n", "Outsourcing | \n", "Late or poor output | \n", "26 | \n", "2 | \n", "Late in project, the budget and staff are cut ... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2017 | \n", "March | \n", "2350920 | \n", "
4843 | \n", "4843 | \n", "Resource | \n", "Outsourcing | \n", "Late start | \n", "25 | \n", "4 | \n", "Internal supplier problem; needed components d... | \n", "3 | \n", "Africa | \n", "Prod. Dev. | \n", "2013 | \n", "June | \n", "2326750 | \n", "
3730 | \n", "3730 | \n", "Resource | \n", "People | \n", "Queuing | \n", "24 | \n", "6 | \n", "Planning delayed due to staff being still tied... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2015 | \n", "August | \n", "2324688 | \n", "
4598 | \n", "4598 | \n", "Resource | \n", "Outsourcing | \n", "Late or poor output | \n", "25 | \n", "6 | \n", "Product owner having unique knowledge left the... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2010 | \n", "February | \n", "2316300 | \n", "
4797 | \n", "4797 | \n", "Scope | \n", "Change | \n", "Creep | \n", "24 | \n", "7 | \n", "Late test results came back negative | \n", "3 | \n", "Africa | \n", "IT/Solution | \n", "2011 | \n", "January | \n", "2309472 | \n", "
3523 | \n", "3523 | \n", "Scope | \n", "Change | \n", "Gap | \n", "24 | \n", "8 | \n", "Several employees had to take a leave of absen... | \n", "1 | \n", "Asia | \n", "Prod. Dev. | \n", "2011 | \n", "August | \n", "2301120 | \n", "
4933 | \n", "4933 | \n", "Scope | \n", "Change | \n", "Gap | \n", "25 | \n", "1 | \n", "Negotiation and training on a new tool took mo... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2015 | \n", "September | \n", "2292350 | \n", "
3740 | \n", "3740 | \n", "Resource | \n", "People | \n", "Temp loss | \n", "23 | \n", "5 | \n", "Development plans failed to include all of the... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2016 | \n", "January | \n", "2286108 | \n", "
4641 | \n", "4641 | \n", "Resource | \n", "People | \n", "Temp loss | \n", "24 | \n", "5 | \n", "Delay in hiring more engineers due to cost cut... | \n", "3 | \n", "Africa | \n", "IT/Solution | \n", "2010 | \n", "June | \n", "2286048 | \n", "
4753 | \n", "4753 | \n", "Scope | \n", "Change | \n", "Gap | \n", "25 | \n", "3 | \n", "Components do not work as documented. Replace... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2015 | \n", "September | \n", "2285325 | \n", "
4393 | \n", "4393 | \n", "Resource | \n", "People | \n", "Loss | \n", "25 | \n", "3 | \n", "Software modules in system do not work togethe... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2008 | \n", "April | \n", "2276500 | \n", "
4545 | \n", "4545 | \n", "Scope | \n", "Change | \n", "Gap | \n", "23 | \n", "1 | \n", "Escalated late changes from Sponsor | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2008 | \n", "January | \n", "2276126 | \n", "
4595 | \n", "4595 | \n", "Resource | \n", "Outsourcing | \n", "Delayed start | \n", "25 | \n", "5 | \n", "Market change due to Improvements in technolog... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2015 | \n", "May | \n", "2265925 | \n", "
4725 | \n", "4725 | \n", "Scope | \n", "Change | \n", "Creep | \n", "23 | \n", "9 | \n", "User specifications not defined until late in ... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2010 | \n", "July | \n", "2259957 | \n", "
4875 | \n", "4875 | \n", "Schedule | \n", "Delay | \n", "Hardware | \n", "25 | \n", "9 | \n", "Issues discovered late in testing | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2015 | \n", "May | \n", "2257500 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
4905 | \n", "4905 | \n", "Schedule | \n", "Estimates | \n", "Judgment | \n", "25 | \n", "6 | \n", "Lack of testing of older WWW browser versions ... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2015 | \n", "November | \n", "2161575 | \n", "
4864 | \n", "4864 | \n", "Resource | \n", "People | \n", "Queuing | \n", "23 | \n", "1 | \n", "Lack of understanding by the manager of the sy... | \n", "2 | \n", "Eur/ME | \n", "Prod. Dev. | \n", "2007 | \n", "April | \n", "2157676 | \n", "
4083 | \n", "4083 | \n", "Schedule | \n", "Estimates | \n", "Learning | \n", "22 | \n", "5 | \n", "Project delayed due to recent/last minute chan... | \n", "1 | \n", "Asia | \n", "Prod. Dev. | \n", "2014 | \n", "March | \n", "2150148 | \n", "
4599 | \n", "4599 | \n", "Resource | \n", "Outsourcing | \n", "Late or poor output | \n", "25 | \n", "1 | \n", "Poor communications resulted in never truly un... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2010 | \n", "March | \n", "2149800 | \n", "
4747 | \n", "4747 | \n", "Scope | \n", "Change | \n", "Gap | \n", "26 | \n", "3 | \n", "Product developed for multiple platforms, but ... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2010 | \n", "July | \n", "2127450 | \n", "
4883 | \n", "4883 | \n", "Schedule | \n", "Delay | \n", "Parts | \n", "24 | \n", "4 | \n", "Apartments were sold before construction begin... | \n", "2 | \n", "Eur/ME | \n", "IT/Solution | \n", "2007 | \n", "December | \n", "2124000 | \n", "
4160 | \n", "4160 | \n", "Schedule | \n", "Delay | \n", "Parts | \n", "24 | \n", "7 | \n", "Cable required had been left off the implement... | \n", "2 | \n", "Eur/ME | \n", "IT/Solution | \n", "2006 | \n", "April | \n", "2106312 | \n", "
4000 | \n", "4000 | \n", "Resource | \n", "People | \n", "Loss | \n", "26 | \n", "9 | \n", "Client requested \"15 minute\" change accepted a... | \n", "1 | \n", "Asia | \n", "Prod. Dev. | \n", "2003 | \n", "November | \n", "2098902 | \n", "
4779 | \n", "4779 | \n", "Scope | \n", "Defect | \n", "Software | \n", "23 | \n", "3 | \n", "Too few disc drives, and insufficient \"owned\" ... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2015 | \n", "August | \n", "2095208 | \n", "
3518 | \n", "3518 | \n", "Schedule | \n", "Delay | \n", "Decision | \n", "24 | \n", "2 | \n", "Poor Fit/Gap analysis | \n", "1 | \n", "Asia | \n", "Prod. Dev. | \n", "2006 | \n", "November | \n", "2094336 | \n", "
4437 | \n", "4437 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "26 | \n", "5 | \n", "None of the developers had experience with the... | \n", "2 | \n", "Eur/ME | \n", "Prod. Dev. | \n", "2009 | \n", "July | \n", "2093078 | \n", "
4316 | \n", "4316 | \n", "Scope | \n", "Change | \n", "Gap | \n", "23 | \n", "9 | \n", "Lack of spare parts and expertise | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2011 | \n", "August | \n", "2092333 | \n", "
3726 | \n", "3726 | \n", "Resource | \n", "People | \n", "Loss | \n", "24 | \n", "9 | \n", "Project start delayed; staffing and buy-in lat... | \n", "1 | \n", "Asia | \n", "IT/Solution | \n", "2011 | \n", "June | \n", "2090328 | \n", "
4947 | \n", "4947 | \n", "Scope | \n", "Change | \n", "Gap | \n", "23 | \n", "4 | \n", "Inexperienced staff | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2015 | \n", "April | \n", "2088676 | \n", "
4986 | \n", "4986 | \n", "Scope | \n", "Defect | \n", "Software | \n", "25 | \n", "6 | \n", "Initial code release was a major failure | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2010 | \n", "July | \n", "2085275 | \n", "
3831 | \n", "3831 | \n", "Schedule | \n", "Delay | \n", "Hardware | \n", "22 | \n", "4 | \n", "After more than 2/3 of the original budget had... | \n", "2 | \n", "Eur/ME | \n", "Prod. Dev. | \n", "2003 | \n", "March | \n", "2085204 | \n", "
4835 | \n", "4835 | \n", "Resource | \n", "Outsourcing | \n", "Late or poor output | \n", "24 | \n", "7 | \n", "Parallel tasks require resources beyond what i... | \n", "2 | \n", "Eur/ME | \n", "IT/Solution | \n", "2001 | \n", "July | \n", "2082432 | \n", "
4682 | \n", "4682 | \n", "Schedule | \n", "Delay | \n", "Parts | \n", "26 | \n", "3 | \n", "Supplier was unable to make a sample correctly | \n", "2 | \n", "Eur/ME | \n", "IT/Solution | \n", "2004 | \n", "January | \n", "2081560 | \n", "
4183 | \n", "4183 | \n", "Scope | \n", "Change | \n", "Gap | \n", "25 | \n", "9 | \n", "Scope not defined well; huge software delays | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2003 | \n", "July | \n", "2075050 | \n", "
3345 | \n", "3345 | \n", "Resource | \n", "People | \n", "Temp loss | \n", "24 | \n", "8 | \n", "Scope expanded during the course of the project | \n", "1 | \n", "Asia | \n", "IT/Solution | \n", "2017 | \n", "December | \n", "2055624 | \n", "
4318 | \n", "4318 | \n", "Resource | \n", "People | \n", "Temp loss | \n", "22 | \n", "2 | \n", "Move out of old location required, but new spa... | \n", "2 | \n", "Eur/ME | \n", "IT/Solution | \n", "2017 | \n", "November | \n", "2052248 | \n", "
3557 | \n", "3557 | \n", "Resource | \n", "People | \n", "Queuing | \n", "24 | \n", "3 | \n", "Inadequate procedures for acceptance, quality,... | \n", "1 | \n", "Asia | \n", "Prod. Dev. | \n", "2015 | \n", "May | \n", "2052144 | \n", "
3857 | \n", "3857 | \n", "Resource | \n", "People | \n", "Loss | \n", "25 | \n", "7 | \n", "Team was staffed by 3 successive new hires in ... | \n", "2 | \n", "Eur/ME | \n", "IT/Solution | \n", "2010 | \n", "March | \n", "2050425 | \n", "
3556 | \n", "3556 | \n", "Resource | \n", "People | \n", "Queuing | \n", "25 | \n", "1 | \n", "A pool of unqualified, poorly performing, marg... | \n", "1 | \n", "Asia | \n", "Prod. Dev. | \n", "2013 | \n", "September | \n", "2041850 | \n", "
3898 | \n", "3898 | \n", "Resource | \n", "Outsourcing | \n", "Late or poor output | \n", "21 | \n", "5 | \n", "Errors found in data and critrical reports | \n", "1 | \n", "Asia | \n", "IT/Solution | \n", "2011 | \n", "March | \n", "2040171 | \n", "
3878 | \n", "3878 | \n", "Resource | \n", "Outsourcing | \n", "Late or poor output | \n", "22 | \n", "8 | \n", "Late stakeholders redefine requiremnts | \n", "2 | \n", "Eur/ME | \n", "IT/Solution | \n", "2017 | \n", "April | \n", "2035968 | \n", "
3235 | \n", "3235 | \n", "Scope | \n", "Defect | \n", "Hardware | \n", "21 | \n", "9 | \n", "Conversion from legacy system to SAP has multi... | \n", "2 | \n", "Eur/ME | \n", "IT/Solution | \n", "2017 | \n", "April | \n", "2033829 | \n", "
3577 | \n", "3577 | \n", "Schedule | \n", "Delay | \n", "Information | \n", "22 | \n", "3 | \n", "Project team was not aware that the new releas... | \n", "2 | \n", "Eur/ME | \n", "IT/Solution | \n", "2016 | \n", "January | \n", "2023054 | \n", "
4453 | \n", "4453 | \n", "Scope | \n", "Change | \n", "Creep | \n", "24 | \n", "4 | \n", "Unexpectedly high demand requires outlisde help | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2010 | \n", "April | \n", "2018520 | \n", "
3329 | \n", "3329 | \n", "Resource | \n", "People | \n", "Motivation | \n", "24 | \n", "8 | \n", "Lack of head count from a 10% company-wide lay... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2003 | \n", "March | \n", "2002488 | \n", "
72 rows × 13 columns
\n", "\n", " | Project Number | \n", "Parameter | \n", "Category | \n", "Sub cat | \n", "Impact | \n", "TRL | \n", "Description | \n", "Region Numeric | \n", "Region | \n", "Project | \n", "Year | \n", "Month | \n", "Cost | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4956 | \n", "4956 | \n", "Scope | \n", "Change | \n", "Gap | \n", "26 | \n", "6 | \n", "The scope of the project was poorly defined | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2010 | \n", "September | \n", "2535416 | \n", "
4938 | \n", "4938 | \n", "Scope | \n", "Change | \n", "Gap | \n", "26 | \n", "3 | \n", "Ship sinks with critical part; forced to repla... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2010 | \n", "February | \n", "2533232 | \n", "
4077 | \n", "4077 | \n", "Schedule | \n", "Dependency | \n", "Project | \n", "26 | \n", "5 | \n", "Client's insisted on the use of \"the latest te... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2010 | \n", "May | \n", "2526342 | \n", "
4549 | \n", "4549 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "26 | \n", "4 | \n", "\"Minor\" changes added and accepted late in pr... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2002 | \n", "January | \n", "2437292 | \n", "
4133 | \n", "4133 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "24 | \n", "6 | \n", "Shipping documents not filled in correctly | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2006 | \n", "March | \n", "2383512 | \n", "
4116 | \n", "4116 | \n", "Scope | \n", "Change | \n", "Gap | \n", "25 | \n", "6 | \n", "Key contributor out ill at critical time. | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2019 | \n", "December | \n", "2371375 | \n", "
3580 | \n", "3580 | \n", "Schedule | \n", "Delay | \n", "Parts | \n", "24 | \n", "2 | \n", "Team leader reassigned to another project and ... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2014 | \n", "November | \n", "2366784 | \n", "
4925 | \n", "4925 | \n", "Scope | \n", "Change | \n", "Creep | \n", "25 | \n", "2 | \n", "Outsourcing partner in Switzerland did unneede... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2010 | \n", "November | \n", "2360300 | \n", "
4251 | \n", "4251 | \n", "Resource | \n", "Outsourcing | \n", "Late or poor output | \n", "26 | \n", "2 | \n", "Late in project, the budget and staff are cut ... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2017 | \n", "March | \n", "2350920 | \n", "
3730 | \n", "3730 | \n", "Resource | \n", "People | \n", "Queuing | \n", "24 | \n", "6 | \n", "Planning delayed due to staff being still tied... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2015 | \n", "August | \n", "2324688 | \n", "
4598 | \n", "4598 | \n", "Resource | \n", "Outsourcing | \n", "Late or poor output | \n", "25 | \n", "6 | \n", "Product owner having unique knowledge left the... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2010 | \n", "February | \n", "2316300 | \n", "
4933 | \n", "4933 | \n", "Scope | \n", "Change | \n", "Gap | \n", "25 | \n", "1 | \n", "Negotiation and training on a new tool took mo... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2015 | \n", "September | \n", "2292350 | \n", "
3740 | \n", "3740 | \n", "Resource | \n", "People | \n", "Temp loss | \n", "23 | \n", "5 | \n", "Development plans failed to include all of the... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2016 | \n", "January | \n", "2286108 | \n", "
4753 | \n", "4753 | \n", "Scope | \n", "Change | \n", "Gap | \n", "25 | \n", "3 | \n", "Components do not work as documented. Replace... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2015 | \n", "September | \n", "2285325 | \n", "
4393 | \n", "4393 | \n", "Resource | \n", "People | \n", "Loss | \n", "25 | \n", "3 | \n", "Software modules in system do not work togethe... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2008 | \n", "April | \n", "2276500 | \n", "
4545 | \n", "4545 | \n", "Scope | \n", "Change | \n", "Gap | \n", "23 | \n", "1 | \n", "Escalated late changes from Sponsor | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2008 | \n", "January | \n", "2276126 | \n", "
4595 | \n", "4595 | \n", "Resource | \n", "Outsourcing | \n", "Delayed start | \n", "25 | \n", "5 | \n", "Market change due to Improvements in technolog... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2015 | \n", "May | \n", "2265925 | \n", "
4725 | \n", "4725 | \n", "Scope | \n", "Change | \n", "Creep | \n", "23 | \n", "9 | \n", "User specifications not defined until late in ... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2010 | \n", "July | \n", "2259957 | \n", "
4875 | \n", "4875 | \n", "Schedule | \n", "Delay | \n", "Hardware | \n", "25 | \n", "9 | \n", "Issues discovered late in testing | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2015 | \n", "May | \n", "2257500 | \n", "
3337 | \n", "3337 | \n", "Resource | \n", "People | \n", "Queuing | \n", "25 | \n", "6 | \n", "Building permit was issued late due to roof da... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2002 | \n", "June | \n", "2227875 | \n", "
4970 | \n", "4970 | \n", "Scope | \n", "Change | \n", "Gap | \n", "23 | \n", "2 | \n", "Defects discovered in late testing | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2010 | \n", "February | \n", "2227527 | \n", "
3469 | \n", "3469 | \n", "Scope | \n", "Defect | \n", "Integration | \n", "26 | \n", "3 | \n", "Program Manager squeezes in additional functio... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2014 | \n", "January | \n", "2226432 | \n", "
3882 | \n", "3882 | \n", "Schedule | \n", "Delay | \n", "Information | \n", "25 | \n", "5 | \n", "Foundation was inadaquate and needed upgrading | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2003 | \n", "February | \n", "2200725 | \n", "
4423 | \n", "4423 | \n", "Scope | \n", "Change | \n", "Gap | \n", "22 | \n", "7 | \n", "Partner software is incompatible with current ... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2015 | \n", "November | \n", "2180992 | \n", "
4842 | \n", "4842 | \n", "Resource | \n", "Outsourcing | \n", "Late or poor output | \n", "26 | \n", "8 | \n", "The Project Lead did not hold the customer/bus... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2015 | \n", "June | \n", "2164214 | \n", "
4905 | \n", "4905 | \n", "Schedule | \n", "Estimates | \n", "Judgment | \n", "25 | \n", "6 | \n", "Lack of testing of older WWW browser versions ... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2015 | \n", "November | \n", "2161575 | \n", "
4599 | \n", "4599 | \n", "Resource | \n", "Outsourcing | \n", "Late or poor output | \n", "25 | \n", "1 | \n", "Poor communications resulted in never truly un... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2010 | \n", "March | \n", "2149800 | \n", "
4747 | \n", "4747 | \n", "Scope | \n", "Change | \n", "Gap | \n", "26 | \n", "3 | \n", "Product developed for multiple platforms, but ... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2010 | \n", "July | \n", "2127450 | \n", "
4779 | \n", "4779 | \n", "Scope | \n", "Defect | \n", "Software | \n", "23 | \n", "3 | \n", "Too few disc drives, and insufficient \"owned\" ... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2015 | \n", "August | \n", "2095208 | \n", "
4316 | \n", "4316 | \n", "Scope | \n", "Change | \n", "Gap | \n", "23 | \n", "9 | \n", "Lack of spare parts and expertise | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2011 | \n", "August | \n", "2092333 | \n", "
4947 | \n", "4947 | \n", "Scope | \n", "Change | \n", "Gap | \n", "23 | \n", "4 | \n", "Inexperienced staff | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2015 | \n", "April | \n", "2088676 | \n", "
4986 | \n", "4986 | \n", "Scope | \n", "Defect | \n", "Software | \n", "25 | \n", "6 | \n", "Initial code release was a major failure | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2010 | \n", "July | \n", "2085275 | \n", "
4183 | \n", "4183 | \n", "Scope | \n", "Change | \n", "Gap | \n", "25 | \n", "9 | \n", "Scope not defined well; huge software delays | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2003 | \n", "July | \n", "2075050 | \n", "
4453 | \n", "4453 | \n", "Scope | \n", "Change | \n", "Creep | \n", "24 | \n", "4 | \n", "Unexpectedly high demand requires outlisde help | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2010 | \n", "April | \n", "2018520 | \n", "
3329 | \n", "3329 | \n", "Resource | \n", "People | \n", "Motivation | \n", "24 | \n", "8 | \n", "Lack of head count from a 10% company-wide lay... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2003 | \n", "March | \n", "2002488 | \n", "
4716 | \n", "4716 | \n", "Schedule | \n", "Estimates | \n", "Judgment | \n", "21 | \n", "4 | \n", "Changing product definition and poor estimatio... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2015 | \n", "October | \n", "1999221 | \n", "
4256 | \n", "4256 | \n", "Resource | \n", "Outsourcing | \n", "Late or poor output | \n", "23 | \n", "9 | \n", "Resources thin and tasks queued in backlogs. | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2002 | \n", "July | \n", "1994169 | \n", "
4035 | \n", "4035 | \n", "Scope | \n", "Change | \n", "Gap | \n", "22 | \n", "6 | \n", "The project team agreed to new requirements; u... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2015 | \n", "September | \n", "1987920 | \n", "
4400 | \n", "4400 | \n", "Schedule | \n", "Dependency | \n", "Project | \n", "24 | \n", "2 | \n", "Controlled Document rejected by Approvers | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2010 | \n", "September | \n", "1985688 | \n", "
3734 | \n", "3734 | \n", "Resource | \n", "People | \n", "Temp loss | \n", "22 | \n", "4 | \n", "Programmers were volunteers, and ultimately al... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2015 | \n", "July | \n", "1975996 | \n", "
3615 | \n", "3615 | \n", "Scope | \n", "Change | \n", "Creep | \n", "26 | \n", "9 | \n", "Developer added a new routine that was not ful... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2008 | \n", "October | \n", "1974674 | \n", "
4660 | \n", "4660 | \n", "Schedule | \n", "Delay | \n", "Decision | \n", "20 | \n", "1 | \n", "Key resource tied to a previous project for tw... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2015 | \n", "March | \n", "1973680 | \n", "
4505 | \n", "4505 | \n", "Schedule | \n", "Delay | \n", "Parts | \n", "25 | \n", "3 | \n", "Had only 1/3 of the units needed on time | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2015 | \n", "October | \n", "1972475 | \n", "
3838 | \n", "3838 | \n", "Scope | \n", "Change | \n", "Creep | \n", "26 | \n", "7 | \n", "New application works, but data collected is n... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2005 | \n", "December | \n", "1961206 | \n", "
4650 | \n", "4650 | \n", "Resource | \n", "People | \n", "Temp loss | \n", "21 | \n", "9 | \n", "Project team members reassigned. Not replaced... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2010 | \n", "May | \n", "1955856 | \n", "
4994 | \n", "4994 | \n", "Schedule | \n", "Delay | \n", "Parts | \n", "24 | \n", "7 | \n", "Freelancer hired was a nutjob, and lacked t... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2015 | \n", "September | \n", "1952040 | \n", "
4009 | \n", "4009 | \n", "Resource | \n", "Outsourcing | \n", "Delayed start | \n", "25 | \n", "1 | \n", "Upgrade to software required. Planning and tr... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2016 | \n", "April | \n", "1933950 | \n", "
3560 | \n", "3560 | \n", "Resource | \n", "People | \n", "Queuing | \n", "26 | \n", "2 | \n", "Six weeks in, a redesign to the most fundament... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2011 | \n", "July | \n", "1928602 | \n", "
4418 | \n", "4418 | \n", "Scope | \n", "Change | \n", "Gap | \n", "23 | \n", "1 | \n", "Contributor couldn't work due to injury and ba... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2010 | \n", "May | \n", "1926181 | \n", "
4500 | \n", "4500 | \n", "Schedule | \n", "Delay | \n", "Hardware | \n", "25 | \n", "6 | \n", "Needed system delivered to wrong building; los... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2015 | \n", "September | \n", "1923300 | \n", "
\n", " | Project Number | \n", "Parameter | \n", "Category | \n", "Sub cat | \n", "Impact | \n", "TRL | \n", "Description | \n", "Region Numeric | \n", "Region | \n", "Project | \n", "Year | \n", "Month | \n", "Cost | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4549 | \n", "4549 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "26 | \n", "4 | \n", "\"Minor\" changes added and accepted late in pr... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2002 | \n", "January | \n", "2437292 | \n", "
4133 | \n", "4133 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "24 | \n", "6 | \n", "Shipping documents not filled in correctly | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2006 | \n", "March | \n", "2383512 | \n", "
4082 | \n", "4082 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "24 | \n", "1 | \n", "Components that could have been purchased were... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2017 | \n", "December | \n", "1864824 | \n", "
4434 | \n", "4434 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "26 | \n", "6 | \n", "Key analyst is scheduled to work on another pr... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2015 | \n", "November | \n", "1809678 | \n", "
4546 | \n", "4546 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "22 | \n", "5 | \n", "Project schedule was revised user interface re... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2010 | \n", "July | \n", "1724844 | \n", "
4435 | \n", "4435 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "19 | \n", "6 | \n", "Architect who knew how to integrate all compon... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2010 | \n", "February | \n", "1678745 | \n", "
1077 | \n", "1077 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "21 | \n", "6 | \n", "Sponsor fails to provide money | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2007 | \n", "November | \n", "1646505 | \n", "
1132 | \n", "1132 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "22 | \n", "3 | \n", "IT department was underfunded and had insuffie... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2019 | \n", "January | \n", "1594516 | \n", "
4072 | \n", "4072 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "26 | \n", "9 | \n", "Delay in getting material when a fermentation ... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2014 | \n", "February | \n", "1552278 | \n", "
1480 | \n", "1480 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "21 | \n", "6 | \n", "Internal resources were not available on a ful... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2007 | \n", "December | \n", "1486023 | \n", "
1138 | \n", "1138 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "21 | \n", "5 | \n", "Staffing was not sufficient to complete all as... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2019 | \n", "July | \n", "1464645 | \n", "
4369 | \n", "4369 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "24 | \n", "5 | \n", "Online badge printing requirement completely m... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2001 | \n", "June | \n", "1388904 | \n", "
4473 | \n", "4473 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "16 | \n", "8 | \n", "The key person responsible for major marketing... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2015 | \n", "December | \n", "1346976 | \n", "
1100 | \n", "1100 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "20 | \n", "6 | \n", "Development team had insufficient resources as... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2017 | \n", "August | \n", "1342380 | \n", "
1709 | \n", "1709 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "17 | \n", "6 | \n", "Chronically understaffed business environment | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2016 | \n", "September | \n", "1339753 | \n", "
4292 | \n", "4292 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "16 | \n", "7 | \n", "New equipment critical to the success of the p... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2010 | \n", "December | \n", "1262176 | \n", "
2049 | \n", "2049 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "20 | \n", "4 | \n", "Contractor setup delayed by a week | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2019 | \n", "August | \n", "1229220 | \n", "
4553 | \n", "4553 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "23 | \n", "6 | \n", "Corporate merger delayed project | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2006 | \n", "February | \n", "1213710 | \n", "
531 | \n", "531 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "15 | \n", "6 | \n", "Lack of funds for travel at launch | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2014 | \n", "September | \n", "1160100 | \n", "
4387 | \n", "4387 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "14 | \n", "8 | \n", "fittings and assemblies were not up to project... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2008 | \n", "July | \n", "1135526 | \n", "
4300 | \n", "4300 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "15 | \n", "2 | \n", "Errors in input data had to be fixed and repor... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2007 | \n", "August | \n", "1133325 | \n", "
937 | \n", "937 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "15 | \n", "5 | \n", "Without funding, all work ceased, contracts we... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2001 | \n", "March | \n", "1124565 | \n", "
1078 | \n", "1078 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "22 | \n", "4 | \n", "Project needs $150K per month in supplies but ... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2007 | \n", "August | \n", "1105742 | \n", "
4134 | \n", "4134 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "17 | \n", "7 | \n", "Dependency on other project not discovered unt... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2013 | \n", "August | \n", "1035181 | \n", "
1521 | \n", "1521 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "15 | \n", "4 | \n", "Due to a layoff no writer was immediately avai... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2009 | \n", "January | \n", "1028115 | \n", "
1963 | \n", "1963 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "22 | \n", "5 | \n", "Did not have sufficient resources and the co... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2019 | \n", "January | \n", "1005026 | \n", "
2169 | \n", "2169 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "22 | \n", "4 | \n", "Lack of money for sufficient equipment | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2019 | \n", "November | \n", "981112 | \n", "
3293 | \n", "3293 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "15 | \n", "4 | \n", "Project has funding, but limited staff delays ... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2005 | \n", "April | \n", "957585 | \n", "
1328 | \n", "1328 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "20 | \n", "6 | \n", "Insufficient resources assigned to the project | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2007 | \n", "September | \n", "930900 | \n", "
813 | \n", "813 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "18 | \n", "6 | \n", "lack of staff availability due to company down... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2007 | \n", "February | \n", "917766 | \n", "
4445 | \n", "4445 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "17 | \n", "2 | \n", "Patch to software required for project work; e... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2002 | \n", "May | \n", "885836 | \n", "
2014 | \n", "2014 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "13 | \n", "6 | \n", "Major infrastructure project cut back; delayed... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2007 | \n", "July | \n", "883350 | \n", "
1400 | \n", "1400 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "16 | \n", "3 | \n", "The travel budget for the project was cut and ... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2003 | \n", "March | \n", "849680 | \n", "
76 | \n", "76 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "15 | \n", "6 | \n", "Project budget was dramatically cut | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2009 | \n", "May | \n", "832665 | \n", "
2769 | \n", "2769 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "20 | \n", "4 | \n", "Delays due to bidding issues and protests | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2010 | \n", "August | \n", "822300 | \n", "
4361 | \n", "4361 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "15 | \n", "2 | \n", "Details of requirements were submitted incorre... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2002 | \n", "June | \n", "820110 | \n", "
2405 | \n", "2405 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "16 | \n", "5 | \n", "Unexpectedly high demand requires outlisde help | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2013 | \n", "December | \n", "809664 | \n", "
2048 | \n", "2048 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "22 | \n", "7 | \n", "Did not have sufficient resources and the cont... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2019 | \n", "April | \n", "804584 | \n", "
1329 | \n", "1329 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "11 | \n", "7 | \n", "Project Budget was restricted to the bare mini... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2009 | \n", "June | \n", "785147 | \n", "
356 | \n", "356 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "13 | \n", "5 | \n", "Development team had insufficient resources as... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2005 | \n", "September | \n", "779298 | \n", "
355 | \n", "355 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "13 | \n", "5 | \n", "Part of the project team ran of money three mo... | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2009 | \n", "July | \n", "777777 | \n", "
4004 | \n", "4004 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "10 | \n", "8 | \n", "Contract had no penalties for missing deadline... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2005 | \n", "August | \n", "759950 | \n", "
1876 | \n", "1876 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "15 | \n", "6 | \n", "Layoffs in mid-project | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2013 | \n", "March | \n", "758550 | \n", "
102 | \n", "102 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "11 | \n", "6 | \n", "Project had limited funding and limited staffing | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2012 | \n", "April | \n", "717541 | \n", "
73 | \n", "73 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "10 | \n", "5 | \n", "Failed to allocate enough resources and missed... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2002 | \n", "May | \n", "708760 | \n", "
1453 | \n", "1453 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "12 | \n", "4 | \n", "Lack of money for sufficient equipment | \n", "0 | \n", "Americas | \n", "Prod. Dev. | \n", "2007 | \n", "August | \n", "701112 | \n", "
0 | \n", "0 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "18 | \n", "5 | \n", "Did not have sufficient resources and the cont... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2010 | \n", "October | \n", "700560 | \n", "
2854 | \n", "2854 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "20 | \n", "4 | \n", "Unexpectedly high demand requires outlisde help | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2005 | \n", "July | \n", "692300 | \n", "
719 | \n", "719 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "11 | \n", "4 | \n", "Client slashed the original budget | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2014 | \n", "December | \n", "673464 | \n", "
1405 | \n", "1405 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "15 | \n", "4 | \n", "Key consultant was let go at a critical time f... | \n", "0 | \n", "Americas | \n", "IT/Solution | \n", "2014 | \n", "February | \n", "664230 | \n", "
\n", " | TRL | \n", "Impact | \n", "
---|---|---|
0 | \n", "1 | \n", "14.75 | \n", "
1 | \n", "2 | \n", "13.50 | \n", "
2 | \n", "3 | \n", "12.45 | \n", "
3 | \n", "4 | \n", "14.17 | \n", "
4 | \n", "5 | \n", "14.71 | \n", "
5 | \n", "6 | \n", "15.54 | \n", "
6 | \n", "7 | \n", "11.78 | \n", "
7 | \n", "8 | \n", "10.75 | \n", "
8 | \n", "9 | \n", "22.00 | \n", "
\n", " | Region | \n", "Cost | \n", "
---|---|---|
0 | \n", "Africa | \n", "744616.68 | \n", "
1 | \n", "Americas | \n", "752808.41 | \n", "
2 | \n", "Asia | \n", "724886.88 | \n", "
3 | \n", "Eur/ME | \n", "778307.72 | \n", "
\n", " | Year | \n", "Cost | \n", "
---|---|---|
0 | \n", "2001 | \n", "766136.24 | \n", "
1 | \n", "2002 | \n", "775338.76 | \n", "
2 | \n", "2003 | \n", "751868.87 | \n", "
3 | \n", "2004 | \n", "760491.31 | \n", "
4 | \n", "2005 | \n", "714075.49 | \n", "
5 | \n", "2006 | \n", "715143.45 | \n", "
6 | \n", "2007 | \n", "711551.25 | \n", "
7 | \n", "2008 | \n", "729581.87 | \n", "
8 | \n", "2009 | \n", "782631.19 | \n", "
9 | \n", "2010 | \n", "801956.27 | \n", "
10 | \n", "2011 | \n", "759503.60 | \n", "
11 | \n", "2012 | \n", "705645.49 | \n", "
12 | \n", "2013 | \n", "701452.11 | \n", "
13 | \n", "2014 | \n", "733437.70 | \n", "
14 | \n", "2015 | \n", "875305.61 | \n", "
15 | \n", "2016 | \n", "729610.30 | \n", "
16 | \n", "2017 | \n", "770409.96 | \n", "
17 | \n", "2018 | \n", "764912.75 | \n", "
18 | \n", "2019 | \n", "699717.54 | \n", "
\n", " | Year | \n", "Cost | \n", "
---|---|---|
0 | \n", "2001 | \n", "753027.31 | \n", "
1 | \n", "2002 | \n", "759695.25 | \n", "
2 | \n", "2003 | \n", "730311.18 | \n", "
3 | \n", "2004 | \n", "734516.43 | \n", "
4 | \n", "2005 | \n", "694079.68 | \n", "
5 | \n", "2006 | \n", "704339.55 | \n", "
6 | \n", "2007 | \n", "697654.34 | \n", "
7 | \n", "2008 | \n", "724117.90 | \n", "
8 | \n", "2009 | \n", "800630.01 | \n", "
9 | \n", "2010 | \n", "841943.56 | \n", "
10 | \n", "2011 | \n", "768046.24 | \n", "
11 | \n", "2012 | \n", "743514.16 | \n", "
12 | \n", "2013 | \n", "646923.40 | \n", "
13 | \n", "2014 | \n", "752774.03 | \n", "
14 | \n", "2015 | \n", "901210.34 | \n", "
15 | \n", "2016 | \n", "682162.81 | \n", "
16 | \n", "2017 | \n", "802036.48 | \n", "
17 | \n", "2018 | \n", "741020.30 | \n", "
18 | \n", "2019 | \n", "666180.41 | \n", "
\n", " | Project Number | \n", "Parameter | \n", "Category | \n", "Sub cat | \n", "Impact | \n", "TRL | \n", "Description | \n", "Region Numeric | \n", "Region | \n", "Project | \n", "Year | \n", "Month | \n", "Cost | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3842 | \n", "3842 | \n", "Resource | \n", "People | \n", "Late start | \n", "26 | \n", "3 | \n", "Change Management Lead took unexpected medical... | \n", "1 | \n", "Asia | \n", "IT/Solution | \n", "2003 | \n", "November | \n", "2562560 | \n", "
4940 | \n", "4940 | \n", "Scope | \n", "Change | \n", "Gap | \n", "26 | \n", "8 | \n", "Chip failed and had to be refabricated with ch... | \n", "2 | \n", "Eur/ME | \n", "IT/Solution | \n", "2018 | \n", "January | \n", "2548442 | \n", "
3705 | \n", "3705 | \n", "Resource | \n", "Outsourcing | \n", "Delayed start | \n", "26 | \n", "2 | \n", "Project had to wait until all data collection ... | \n", "2 | \n", "Eur/ME | \n", "Prod. Dev. | \n", "2001 | \n", "October | \n", "2543034 | \n", "
4991 | \n", "4991 | \n", "Resource | \n", "People | \n", "Loss | \n", "26 | \n", "2 | \n", "To expand business, unrealistic commitments we... | \n", "3 | \n", "Africa | \n", "Prod. Dev. | \n", "2004 | \n", "May | \n", "2504268 | \n", "
4788 | \n", "4788 | \n", "Resource | \n", "People | \n", "Loss | \n", "25 | \n", "2 | \n", "Contract lab failed to inform us that they had... | \n", "3 | \n", "Africa | \n", "Prod. Dev. | \n", "2002 | \n", "December | \n", "2469325 | \n", "
4552 | \n", "4552 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "26 | \n", "7 | \n", "Server technology chage was necessitated to su... | \n", "2 | \n", "Eur/ME | \n", "Prod. Dev. | \n", "2015 | \n", "December | \n", "2425748 | \n", "
3394 | \n", "3394 | \n", "Schedule | \n", "Dependency | \n", "Infrastructure | \n", "26 | \n", "6 | \n", "Need to upgrade detected only at project end | \n", "2 | \n", "Eur/ME | \n", "Prod. Dev. | \n", "2003 | \n", "March | \n", "2357602 | \n", "
4843 | \n", "4843 | \n", "Resource | \n", "Outsourcing | \n", "Late start | \n", "25 | \n", "4 | \n", "Internal supplier problem; needed components d... | \n", "3 | \n", "Africa | \n", "Prod. Dev. | \n", "2013 | \n", "June | \n", "2326750 | \n", "
4797 | \n", "4797 | \n", "Scope | \n", "Change | \n", "Creep | \n", "24 | \n", "7 | \n", "Late test results came back negative | \n", "3 | \n", "Africa | \n", "IT/Solution | \n", "2011 | \n", "January | \n", "2309472 | \n", "
3523 | \n", "3523 | \n", "Scope | \n", "Change | \n", "Gap | \n", "24 | \n", "8 | \n", "Several employees had to take a leave of absen... | \n", "1 | \n", "Asia | \n", "Prod. Dev. | \n", "2011 | \n", "August | \n", "2301120 | \n", "
4641 | \n", "4641 | \n", "Resource | \n", "People | \n", "Temp loss | \n", "24 | \n", "5 | \n", "Delay in hiring more engineers due to cost cut... | \n", "3 | \n", "Africa | \n", "IT/Solution | \n", "2010 | \n", "June | \n", "2286048 | \n", "
4869 | \n", "4869 | \n", "Resource | \n", "People | \n", "Temp loss | \n", "25 | \n", "5 | \n", "Some of the cross functional teams were not in... | \n", "3 | \n", "Africa | \n", "IT/Solution | \n", "2010 | \n", "October | \n", "2242050 | \n", "
4756 | \n", "4756 | \n", "Scope | \n", "Change | \n", "Gap | \n", "25 | \n", "2 | \n", "Insufficient length of anchor bolts protruding... | \n", "2 | \n", "Eur/ME | \n", "IT/Solution | \n", "2018 | \n", "August | \n", "2237275 | \n", "
4568 | \n", "4568 | \n", "Resource | \n", "People | \n", "Queuing | \n", "25 | \n", "5 | \n", "Insufficient initial project scope was defined... | \n", "2 | \n", "Eur/ME | \n", "IT/Solution | \n", "2005 | \n", "April | \n", "2218325 | \n", "
4675 | \n", "4675 | \n", "Schedule | \n", "Delay | \n", "Information | \n", "25 | \n", "4 | \n", "Key parts would be delivered late | \n", "2 | \n", "Eur/ME | \n", "IT/Solution | \n", "2018 | \n", "September | \n", "2206475 | \n", "
3617 | \n", "3617 | \n", "Scope | \n", "Change | \n", "Creep | \n", "25 | \n", "1 | \n", "New database wouldn’t work with the proposed p... | \n", "2 | \n", "Eur/ME | \n", "IT/Solution | \n", "2015 | \n", "May | \n", "2204675 | \n", "
3897 | \n", "3897 | \n", "Scope | \n", "Change | \n", "Creep | \n", "26 | \n", "9 | \n", "Multiple projects depend on lone expert scientist | \n", "1 | \n", "Asia | \n", "Prod. Dev. | \n", "2006 | \n", "August | \n", "2194530 | \n", "
4864 | \n", "4864 | \n", "Resource | \n", "People | \n", "Queuing | \n", "23 | \n", "1 | \n", "Lack of understanding by the manager of the sy... | \n", "2 | \n", "Eur/ME | \n", "Prod. Dev. | \n", "2007 | \n", "April | \n", "2157676 | \n", "
4083 | \n", "4083 | \n", "Schedule | \n", "Estimates | \n", "Learning | \n", "22 | \n", "5 | \n", "Project delayed due to recent/last minute chan... | \n", "1 | \n", "Asia | \n", "Prod. Dev. | \n", "2014 | \n", "March | \n", "2150148 | \n", "
4883 | \n", "4883 | \n", "Schedule | \n", "Delay | \n", "Parts | \n", "24 | \n", "4 | \n", "Apartments were sold before construction begin... | \n", "2 | \n", "Eur/ME | \n", "IT/Solution | \n", "2007 | \n", "December | \n", "2124000 | \n", "
4160 | \n", "4160 | \n", "Schedule | \n", "Delay | \n", "Parts | \n", "24 | \n", "7 | \n", "Cable required had been left off the implement... | \n", "2 | \n", "Eur/ME | \n", "IT/Solution | \n", "2006 | \n", "April | \n", "2106312 | \n", "
4000 | \n", "4000 | \n", "Resource | \n", "People | \n", "Loss | \n", "26 | \n", "9 | \n", "Client requested \"15 minute\" change accepted a... | \n", "1 | \n", "Asia | \n", "Prod. Dev. | \n", "2003 | \n", "November | \n", "2098902 | \n", "
3518 | \n", "3518 | \n", "Schedule | \n", "Delay | \n", "Decision | \n", "24 | \n", "2 | \n", "Poor Fit/Gap analysis | \n", "1 | \n", "Asia | \n", "Prod. Dev. | \n", "2006 | \n", "November | \n", "2094336 | \n", "
4437 | \n", "4437 | \n", "Resource | \n", "Money | \n", "Limitation | \n", "26 | \n", "5 | \n", "None of the developers had experience with the... | \n", "2 | \n", "Eur/ME | \n", "Prod. Dev. | \n", "2009 | \n", "July | \n", "2093078 | \n", "
3726 | \n", "3726 | \n", "Resource | \n", "People | \n", "Loss | \n", "24 | \n", "9 | \n", "Project start delayed; staffing and buy-in lat... | \n", "1 | \n", "Asia | \n", "IT/Solution | \n", "2011 | \n", "June | \n", "2090328 | \n", "
3831 | \n", "3831 | \n", "Schedule | \n", "Delay | \n", "Hardware | \n", "22 | \n", "4 | \n", "After more than 2/3 of the original budget had... | \n", "2 | \n", "Eur/ME | \n", "Prod. Dev. | \n", "2003 | \n", "March | \n", "2085204 | \n", "
4835 | \n", "4835 | \n", "Resource | \n", "Outsourcing | \n", "Late or poor output | \n", "24 | \n", "7 | \n", "Parallel tasks require resources beyond what i... | \n", "2 | \n", "Eur/ME | \n", "IT/Solution | \n", "2001 | \n", "July | \n", "2082432 | \n", "
4682 | \n", "4682 | \n", "Schedule | \n", "Delay | \n", "Parts | \n", "26 | \n", "3 | \n", "Supplier was unable to make a sample correctly | \n", "2 | \n", "Eur/ME | \n", "IT/Solution | \n", "2004 | \n", "January | \n", "2081560 | \n", "
3345 | \n", "3345 | \n", "Resource | \n", "People | \n", "Temp loss | \n", "24 | \n", "8 | \n", "Scope expanded during the course of the project | \n", "1 | \n", "Asia | \n", "IT/Solution | \n", "2017 | \n", "December | \n", "2055624 | \n", "
4318 | \n", "4318 | \n", "Resource | \n", "People | \n", "Temp loss | \n", "22 | \n", "2 | \n", "Move out of old location required, but new spa... | \n", "2 | \n", "Eur/ME | \n", "IT/Solution | \n", "2017 | \n", "November | \n", "2052248 | \n", "
3557 | \n", "3557 | \n", "Resource | \n", "People | \n", "Queuing | \n", "24 | \n", "3 | \n", "Inadequate procedures for acceptance, quality,... | \n", "1 | \n", "Asia | \n", "Prod. Dev. | \n", "2015 | \n", "May | \n", "2052144 | \n", "
3857 | \n", "3857 | \n", "Resource | \n", "People | \n", "Loss | \n", "25 | \n", "7 | \n", "Team was staffed by 3 successive new hires in ... | \n", "2 | \n", "Eur/ME | \n", "IT/Solution | \n", "2010 | \n", "March | \n", "2050425 | \n", "
3556 | \n", "3556 | \n", "Resource | \n", "People | \n", "Queuing | \n", "25 | \n", "1 | \n", "A pool of unqualified, poorly performing, marg... | \n", "1 | \n", "Asia | \n", "Prod. Dev. | \n", "2013 | \n", "September | \n", "2041850 | \n", "
3898 | \n", "3898 | \n", "Resource | \n", "Outsourcing | \n", "Late or poor output | \n", "21 | \n", "5 | \n", "Errors found in data and critrical reports | \n", "1 | \n", "Asia | \n", "IT/Solution | \n", "2011 | \n", "March | \n", "2040171 | \n", "
3878 | \n", "3878 | \n", "Resource | \n", "Outsourcing | \n", "Late or poor output | \n", "22 | \n", "8 | \n", "Late stakeholders redefine requiremnts | \n", "2 | \n", "Eur/ME | \n", "IT/Solution | \n", "2017 | \n", "April | \n", "2035968 | \n", "
3235 | \n", "3235 | \n", "Scope | \n", "Defect | \n", "Hardware | \n", "21 | \n", "9 | \n", "Conversion from legacy system to SAP has multi... | \n", "2 | \n", "Eur/ME | \n", "IT/Solution | \n", "2017 | \n", "April | \n", "2033829 | \n", "
3577 | \n", "3577 | \n", "Schedule | \n", "Delay | \n", "Information | \n", "22 | \n", "3 | \n", "Project team was not aware that the new releas... | \n", "2 | \n", "Eur/ME | \n", "IT/Solution | \n", "2016 | \n", "January | \n", "2023054 | \n", "
4816 | \n", "4816 | \n", "Scope | \n", "Change | \n", "Creep | \n", "20 | \n", "3 | \n", "Inadequate staffing | \n", "2 | \n", "Eur/ME | \n", "Prod. Dev. | \n", "2018 | \n", "March | \n", "1997540 | \n", "
4517 | \n", "4517 | \n", "Scope | \n", "Change | \n", "Creep | \n", "20 | \n", "9 | \n", "Needed wiring not available on time | \n", "2 | \n", "Eur/ME | \n", "Prod. Dev. | \n", "2002 | \n", "February | \n", "1992660 | \n", "
4449 | \n", "4449 | \n", "Resource | \n", "People | \n", "Queuing | \n", "22 | \n", "3 | \n", "Work at customer site had to be done by union ... | \n", "2 | \n", "Eur/ME | \n", "Prod. Dev. | \n", "2002 | \n", "June | \n", "1991176 | \n", "
4637 | \n", "4637 | \n", "Resource | \n", "People | \n", "Queuing | \n", "21 | \n", "9 | \n", "Contract lab failed to inform us that they had... | \n", "2 | \n", "Eur/ME | \n", "IT/Solution | \n", "2015 | \n", "April | \n", "1977528 | \n", "
4815 | \n", "4815 | \n", "Scope | \n", "Change | \n", "Creep | \n", "20 | \n", "5 | \n", "Client slashed the original budget | \n", "3 | \n", "Africa | \n", "Prod. Dev. | \n", "2018 | \n", "February | \n", "1974940 | \n", "
3800 | \n", "3800 | \n", "Schedule | \n", "Delay | \n", "Parts | \n", "24 | \n", "4 | \n", "Did not have the correct people validate requi... | \n", "1 | \n", "Asia | \n", "IT/Solution | \n", "2004 | \n", "February | \n", "1971720 | \n", "
3191 | \n", "3191 | \n", "Resource | \n", "People | \n", "Temp loss | \n", "21 | \n", "9 | \n", "Redesign required late in printer project to m... | \n", "2 | \n", "Eur/ME | \n", "Prod. Dev. | \n", "2003 | \n", "October | \n", "1971123 | \n", "
4477 | \n", "4477 | \n", "Resource | \n", "Outsourcing | \n", "Late or poor output | \n", "22 | \n", "7 | \n", "All students did not complete training as sche... | \n", "2 | \n", "Eur/ME | \n", "IT/Solution | \n", "2019 | \n", "October | \n", "1968626 | \n", "
4669 | \n", "4669 | \n", "Schedule | \n", "Delay | \n", "Hardware | \n", "23 | \n", "9 | \n", "Decisions are being delayed without apparent r... | \n", "3 | \n", "Africa | \n", "Prod. Dev. | \n", "2013 | \n", "June | \n", "1964062 | \n", "
4326 | \n", "4326 | \n", "Resource | \n", "People | \n", "Queuing | \n", "25 | \n", "6 | \n", "Approvals held up at project completion to wai... | \n", "2 | \n", "Eur/ME | \n", "IT/Solution | \n", "2003 | \n", "June | \n", "1960725 | \n", "
3574 | \n", "3574 | \n", "Schedule | \n", "Delay | \n", "Hardware | \n", "26 | \n", "7 | \n", "In creating a new system, there was too little... | \n", "1 | \n", "Asia | \n", "Prod. Dev. | \n", "2002 | \n", "August | \n", "1952574 | \n", "
4405 | \n", "4405 | \n", "Scope | \n", "Change | \n", "Creep | \n", "24 | \n", "5 | \n", "Delay in patient recruitment for clinical trials | \n", "2 | \n", "Eur/ME | \n", "IT/Solution | \n", "2008 | \n", "January | \n", "1948032 | \n", "
3673 | \n", "3673 | \n", "Scope | \n", "Defect | \n", "Hardware | \n", "22 | \n", "4 | \n", "No understanding of the scope and not enough s... | \n", "1 | \n", "Asia | \n", "Prod. Dev. | \n", "2001 | \n", "March | \n", "1934790 | \n", "
\n", " | Year | \n", "Cost | \n", "
---|---|---|
0 | \n", "2001 | \n", "779125.99 | \n", "
1 | \n", "2002 | \n", "795394.55 | \n", "
2 | \n", "2003 | \n", "774372.07 | \n", "
3 | \n", "2004 | \n", "784885.11 | \n", "
4 | \n", "2005 | \n", "733375.79 | \n", "
5 | \n", "2006 | \n", "727068.51 | \n", "
6 | \n", "2007 | \n", "744882.14 | \n", "
7 | \n", "2008 | \n", "734674.51 | \n", "
8 | \n", "2009 | \n", "757989.94 | \n", "
9 | \n", "2010 | \n", "730288.23 | \n", "
10 | \n", "2011 | \n", "749011.00 | \n", "
11 | \n", "2012 | \n", "669423.28 | \n", "
12 | \n", "2013 | \n", "756446.87 | \n", "
13 | \n", "2014 | \n", "713904.06 | \n", "
14 | \n", "2015 | \n", "806226.34 | \n", "
15 | \n", "2016 | \n", "789172.05 | \n", "
16 | \n", "2017 | \n", "742397.90 | \n", "
17 | \n", "2018 | \n", "785768.02 | \n", "
18 | \n", "2019 | \n", "792031.09 | \n", "
\n", " | Region | \n", "Impact | \n", "
---|---|---|
0 | \n", "Africa | \n", "13.53 | \n", "
1 | \n", "Americas | \n", "13.51 | \n", "
2 | \n", "Asia | \n", "13.29 | \n", "
3 | \n", "Eur/ME | \n", "13.41 | \n", "
\n", " | TRL | \n", "Impact | \n", "
---|---|---|
0 | \n", "1 | \n", "13.70 | \n", "
1 | \n", "2 | \n", "13.13 | \n", "
2 | \n", "3 | \n", "13.45 | \n", "
3 | \n", "4 | \n", "13.37 | \n", "
4 | \n", "5 | \n", "13.76 | \n", "
5 | \n", "6 | \n", "13.83 | \n", "
6 | \n", "7 | \n", "13.43 | \n", "
7 | \n", "8 | \n", "12.82 | \n", "
8 | \n", "9 | \n", "12.29 | \n", "