Demo for PyData Montreal 2021, part 1¶

Based on Market_Intelligence_Part1.ipynb.

In [1]:

# Import Python libraries
from typing import *
import os

if "IBM_API_KEY" not in os.environ:
    raise ValueError("IBM_API_KEY environment variable not set. Please create "
                     "a free instance of IBM Watson Natural Language Understanding "
                     "(see https://www.ibm.com/cloud/watson-natural-language-understanding) "
                     "and set the IBM_API_KEY environment variable to your instance's "
                     "API key value.")
api_key = os.environ.get("IBM_API_KEY")
service_url = os.environ.get("IBM_SERVICE_URL")  

# Github notebook gists will be this wide: ------------------>
# Screenshots of this notebook should be this wide: ----------------------------->

In [2]:

# Show the document
doc_url = "https://newsroom.ibm.com/2020-02-19-IBM-Power-Systems-Certified-for-SAP-HANA-R-Enterprise-Cloud-as-a-provider-for-large-SAP-HANA-systems"
doc_url

Out[2]:

'https://newsroom.ibm.com/2020-02-19-IBM-Power-Systems-Certified-for-SAP-HANA-R-Enterprise-Cloud-as-a-provider-for-large-SAP-HANA-systems'

In [3]:

import ibm_watson
import ibm_watson.natural_language_understanding_v1 as nlu
import ibm_cloud_sdk_core

natural_language_understanding = ibm_watson.NaturalLanguageUnderstandingV1(
    version="2021-01-01",
    authenticator=ibm_cloud_sdk_core.authenticators.IAMAuthenticator(api_key)
)
natural_language_understanding.set_service_url(service_url)
nlu_results = natural_language_understanding.analyze(
    url=doc_url,
    return_analyzed_text=True,
    features=nlu.Features(
        entities=nlu.EntitiesOptions(mentions=True),
        semantic_roles=nlu.SemanticRolesOptions())).get_result()
nlu_results

Out[3]:

{'usage': {'text_units': 1, 'text_characters': 3810, 'features': 2},
 'semantic_roles': [{'subject': {'text': 'IBM'},
   'sentence': 'ARMONK, N.Y., Feb. 19, 2020 /PRNewswire/ --\xa0IBM (NYSE: IBM) today announced that IBM Power Systems has been certified for the SAP HANA® Enterprise Cloud as a critical infrastructure platform provider for large SAP HANA systems, aiming to simplify the IT infrastructure for the managed, private cloud environment.',
   'object': {'text': 'that IBM Power Systems has been certified for the SAP HANA® Enterprise Cloud as a critical infrastructure platform provider for large SAP HANA systems, aiming to simplify the IT infrastructure for the managed, private cloud environment'},
   'action': {'verb': {'text': 'announce', 'tense': 'past'},
    'text': 'announced',
    'normalized': 'announce'}},
  {'subject': {'text': 'IBM Power Systems'},
   'sentence': 'ARMONK, N.Y., Feb. 19, 2020 /PRNewswire/ --\xa0IBM (NYSE: IBM) today announced that IBM Power Systems has been certified for the SAP HANA® Enterprise Cloud as a critical infrastructure platform provider for large SAP HANA systems, aiming to simplify the IT infrastructure for the managed, private cloud environment.',
   'object': {'text': 'certified for the SAP HANA® Enterprise Cloud as a critical infrastructure platform provider for large SAP HANA systems'},
   'action': {'verb': {'text': 'be', 'tense': 'past'},
    'text': 'been',
    'normalized': 'be'}},
  {'subject': {'text': 'to simplify the IT infrastructure'},
   'sentence': 'ARMONK, N.Y., Feb. 19, 2020 /PRNewswire/ --\xa0IBM (NYSE: IBM) today announced that IBM Power Systems has been certified for the SAP HANA® Enterprise Cloud as a critical infrastructure platform provider for large SAP HANA systems, aiming to simplify the IT infrastructure for the managed, private cloud environment.',
   'object': {'text': 'for the managed, private cloud environment'},
   'action': {'verb': {'text': 'aim', 'tense': 'present'},
    'text': 'aiming',
    'normalized': 'aim'}},
  {'subject': {'text': 'the IT infrastructure'},
   'sentence': 'ARMONK, N.Y., Feb. 19, 2020 /PRNewswire/ --\xa0IBM (NYSE: IBM) today announced that IBM Power Systems has been certified for the SAP HANA® Enterprise Cloud as a critical infrastructure platform provider for large SAP HANA systems, aiming to simplify the IT infrastructure for the managed, private cloud environment.',
   'object': {'text': 'for the managed, private cloud environment'},
   'action': {'verb': {'text': 'simplify', 'tense': 'future'},
    'text': 'aiming to simplify',
    'normalized': 'aim to simplify'}},
  {'subject': {'text': 'IBM POWER9-based IBM Power Systems E980 servers'},
   'sentence': " The service will run on IBM POWER9-based IBM Power Systems E980 servers, which have the industry's largest virtualized server scalability of 24TB for the SAP HANA databasei.",
   'object': {'text': "the industry's largest virtualized server scalability of 24TB for the SAP HANA databasei"},
   'action': {'verb': {'text': 'have', 'tense': 'present'},
    'text': 'have',
    'normalized': 'have'}},
  {'subject': {'text': 'the IT infrastructure'},
   'sentence': " Providing the IT infrastructure for a managed, private cloud environment, the SAP HANA Enterprise Cloud is a scalable and secured service that is designed to accelerate a user's evolution\xa0on the path to cloud readiness.",
   'object': {'text': 'for a managed'},
   'action': {'verb': {'text': 'Providing', 'tense': 'present'},
    'text': 'Providing',
    'normalized': 'Providing'}},
  {'subject': {'text': 'the SAP HANA Enterprise Cloud'},
   'sentence': " Providing the IT infrastructure for a managed, private cloud environment, the SAP HANA Enterprise Cloud is a scalable and secured service that is designed to accelerate a user's evolution\xa0on the path to cloud readiness.",
   'object': {'text': 'a scalable'},
   'action': {'verb': {'text': 'be', 'tense': 'present'},
    'text': 'is',
    'normalized': 'be'}},
  {'subject': {'text': 'a scalable and secured service'},
   'sentence': " Providing the IT infrastructure for a managed, private cloud environment, the SAP HANA Enterprise Cloud is a scalable and secured service that is designed to accelerate a user's evolution\xa0on the path to cloud readiness.",
   'object': {'text': "a user's evolution"},
   'action': {'verb': {'text': 'accelerate', 'tense': 'future'},
    'text': 'is designed to accelerate',
    'normalized': 'be design to accelerate'}},
  {'subject': {'text': 'It'},
   'sentence': ' It\xa0provides capabilities that span the software and hardware stack, a comprehensive\xa0menu of functional and technical services, and the level of control clients should expect on\xa0premises, all in one privately managed environment.',
   'object': {'text': 'capabilities that span the software and hardware stack, a comprehensive\xa0menu of functional and technical services, and the level of control clients should expect on\xa0premises'},
   'action': {'verb': {'text': 'provide', 'tense': 'present'},
    'text': 'provides',
    'normalized': 'provide'}},
  {'subject': {'text': 'capabilities'},
   'sentence': ' It\xa0provides capabilities that span the software and hardware stack, a comprehensive\xa0menu of functional and technical services, and the level of control clients should expect on\xa0premises, all in one privately managed environment.',
   'object': {'text': 'the software and hardware stack'},
   'action': {'verb': {'text': 'span', 'tense': 'present'},
    'text': 'span',
    'normalized': 'span'}},
  {'subject': {'text': 'SAP HANA Enterprise Cloud on IBM Power Systems'},
   'sentence': ' "SAP HANA Enterprise Cloud on IBM Power Systems will help clients unlock the full value of SAP HANA in the cloud, with the possibility of enhancing the scalability and availability of mission critical SAP applications while moving workloads to SAP HANA and lowering TCO," said Christoph Herman, SVP and Head of SAP HANA Enterprise Cloud Delivery.',
   'object': {'text': 'clients unlock the full value of SAP HANA in the cloud'},
   'action': {'verb': {'text': 'help', 'tense': 'future'},
    'text': 'will help',
    'normalized': 'will help'}},
  {'subject': {'text': 'Christoph Herman, SVP and Head of SAP HANA Enterprise Cloud Delivery'},
   'sentence': ' "SAP HANA Enterprise Cloud on IBM Power Systems will help clients unlock the full value of SAP HANA in the cloud, with the possibility of enhancing the scalability and availability of mission critical SAP applications while moving workloads to SAP HANA and lowering TCO," said Christoph Herman, SVP and Head of SAP HANA Enterprise Cloud Delivery.',
   'object': {'text': 'SAP HANA Enterprise Cloud on IBM Power Systems will help clients unlock the full value of SAP HANA in the cloud, with the possibility of enhancing the scalability and availability of mission critical SAP applications while moving workloads to SAP HANA and lowering TCO'},
   'action': {'verb': {'text': 'say', 'tense': 'past'},
    'text': 'said',
    'normalized': 'say'}},
  {'subject': {'text': 'closer alignment'},
   'sentence': ' "Combining SAP HANA Enterprise Cloud capabilities with IBM Power Systems can help establish a faster path to cloud readiness for our clients while addressing risk and providing closer alignment to the intelligent enterprise."',
   'object': {'text': 'to the intelligent enterprise'},
   'action': {'verb': {'text': 'provide', 'tense': 'present'},
    'text': 'providing',
    'normalized': 'provide'}},
  {'subject': {'text': 'SAP HANA Enterprise Cloud users'},
   'sentence': ' SAP HANA Enterprise Cloud users can take advantage of the firmware-based virtualization in the IBM POWER platform that offers the largest SAP HANA scalability in scale-up systemsii.',
   'object': {'text': 'advantage'},
   'action': {'verb': {'text': 'take', 'tense': 'future'},
    'text': 'can take',
    'normalized': 'can take'}},
  {'subject': {'text': 'the IBM POWER platform'},
   'sentence': ' SAP HANA Enterprise Cloud users can take advantage of the firmware-based virtualization in the IBM POWER platform that offers the largest SAP HANA scalability in scale-up systemsii.',
   'object': {'text': 'the largest SAP HANA scalability'},
   'action': {'verb': {'text': 'offer', 'tense': 'present'},
    'text': 'offers',
    'normalized': 'offer'}},
  {'subject': {'text': 'This'},
   'sentence': ' This helps enable SAP HANA Enterprise Cloud users to accommodate capacity changes – this is designed for clients to benefit from faster performance of their SAP HANA-based business intelligence applications by running them in a single node while maximizing the availability of SAP applications with the highly resilient infrastructure.',
   'object': {'text': 'enable SAP HANA Enterprise Cloud users'},
   'action': {'verb': {'text': 'help', 'tense': 'present'},
    'text': 'helps',
    'normalized': 'help'}},
  {'subject': {'text': 'This'},
   'sentence': ' This helps enable SAP HANA Enterprise Cloud users to accommodate capacity changes – this is designed for clients to benefit from faster performance of their SAP HANA-based business intelligence applications by running them in a single node while maximizing the availability of SAP applications with the highly resilient infrastructure.',
   'object': {'text': 'SAP HANA Enterprise Cloud users'},
   'action': {'verb': {'text': 'enable', 'tense': 'present'},
    'text': 'helps enable',
    'normalized': 'help enable'}},
  {'subject': {'text': 'SAP HANA Enterprise Cloud users'},
   'sentence': ' This helps enable SAP HANA Enterprise Cloud users to accommodate capacity changes – this is designed for clients to benefit from faster performance of their SAP HANA-based business intelligence applications by running them in a single node while maximizing the availability of SAP applications with the highly resilient infrastructure.',
   'object': {'text': 'capacity changes – this'},
   'action': {'verb': {'text': 'accommodate', 'tense': 'future'},
    'text': 'to accommodate',
    'normalized': 'to accommodate'}},
  {'subject': {'text': 'from faster performance of their SAP HANA-based business intelligence applications by running them in a single node while maximizing the availability of SAP applications with the highly resilient infrastructure'},
   'sentence': ' This helps enable SAP HANA Enterprise Cloud users to accommodate capacity changes – this is designed for clients to benefit from faster performance of their SAP HANA-based business intelligence applications by running them in a single node while maximizing the availability of SAP applications with the highly resilient infrastructure.',
   'object': {'text': 'clients'},
   'action': {'verb': {'text': 'benefit', 'tense': 'future'},
    'text': 'to benefit',
    'normalized': 'to benefit'}},
  {'subject': {'text': 'them'},
   'sentence': ' This helps enable SAP HANA Enterprise Cloud users to accommodate capacity changes – this is designed for clients to benefit from faster performance of their SAP HANA-based business intelligence applications by running them in a single node while maximizing the availability of SAP applications with the highly resilient infrastructure.',
   'action': {'verb': {'text': 'run', 'tense': 'present'},
    'text': 'running',
    'normalized': 'run'}},
  {'subject': {'text': 'IBM'},
   'sentence': ' "In June, IBM announced the availability of POWER9 in the IBM Cloud, taking the first step toward our goal of bringing IBM Cognitive Systems technology to our clients, no matter where they are," said Stephen Leonard, General Manager, IBM Cognitive Systems, "With the addition of IBM Power Systems in SAP HANA Enterprise Cloud, we\'re giving our clients more choices and greater flexibility to run their workloads where they want to across the hybrid cloud and accelerate digital transformation."',
   'object': {'text': 'the availability of POWER9 in the IBM Cloud, taking the first step toward our goal of bringing IBM Cognitive Systems technology to our clients, no matter where they are'},
   'action': {'verb': {'text': 'announce', 'tense': 'past'},
    'text': 'announced',
    'normalized': 'announce'}},
  {'subject': {'text': 'IBM'},
   'sentence': ' "In June, IBM announced the availability of POWER9 in the IBM Cloud, taking the first step toward our goal of bringing IBM Cognitive Systems technology to our clients, no matter where they are," said Stephen Leonard, General Manager, IBM Cognitive Systems, "With the addition of IBM Power Systems in SAP HANA Enterprise Cloud, we\'re giving our clients more choices and greater flexibility to run their workloads where they want to across the hybrid cloud and accelerate digital transformation."',
   'object': {'text': 'the first step toward our goal of bringing IBM Cognitive Systems technology to our clients, no matter where they are'},
   'action': {'verb': {'text': 'take', 'tense': 'present'},
    'text': 'taking',
    'normalized': 'take'}},
  {'subject': {'text': 'IBM Cognitive Systems technology'},
   'sentence': ' "In June, IBM announced the availability of POWER9 in the IBM Cloud, taking the first step toward our goal of bringing IBM Cognitive Systems technology to our clients, no matter where they are," said Stephen Leonard, General Manager, IBM Cognitive Systems, "With the addition of IBM Power Systems in SAP HANA Enterprise Cloud, we\'re giving our clients more choices and greater flexibility to run their workloads where they want to across the hybrid cloud and accelerate digital transformation."',
   'object': {'text': 'to our clients'},
   'action': {'verb': {'text': 'bring', 'tense': 'future'},
    'text': 'bringing',
    'normalized': 'bring'}},
  {'subject': {'text': 'Stephen Leonard, General Manager, IBM Cognitive Systems, "With the addition of IBM Power Systems in SAP HANA Enterprise Cloud, we\'re giving our clients more choices and greater flexibility to run their workloads where they want to across the hybrid cloud and accelerate digital transformation'},
   'sentence': ' "In June, IBM announced the availability of POWER9 in the IBM Cloud, taking the first step toward our goal of bringing IBM Cognitive Systems technology to our clients, no matter where they are," said Stephen Leonard, General Manager, IBM Cognitive Systems, "With the addition of IBM Power Systems in SAP HANA Enterprise Cloud, we\'re giving our clients more choices and greater flexibility to run their workloads where they want to across the hybrid cloud and accelerate digital transformation."',
   'object': {'text': 'In June, IBM announced the availability of POWER9 in the IBM Cloud, taking the first step toward our goal of bringing IBM Cognitive Systems technology to our clients, no matter where they are'},
   'action': {'verb': {'text': 'say', 'tense': 'past'},
    'text': 'said',
    'normalized': 'say'}},
  {'subject': {'text': 'we'},
   'sentence': ' "In June, IBM announced the availability of POWER9 in the IBM Cloud, taking the first step toward our goal of bringing IBM Cognitive Systems technology to our clients, no matter where they are," said Stephen Leonard, General Manager, IBM Cognitive Systems, "With the addition of IBM Power Systems in SAP HANA Enterprise Cloud, we\'re giving our clients more choices and greater flexibility to run their workloads where they want to across the hybrid cloud and accelerate digital transformation."',
   'object': {'text': 'giving our clients more choices and greater flexibility to run their workloads where they want to across the hybrid cloud and accelerate digital transformation'},
   'action': {'verb': {'text': 'be', 'tense': 'present'},
    'text': 'are',
    'normalized': 'be'}},
  {'subject': {'text': 'we'},
   'sentence': ' "In June, IBM announced the availability of POWER9 in the IBM Cloud, taking the first step toward our goal of bringing IBM Cognitive Systems technology to our clients, no matter where they are," said Stephen Leonard, General Manager, IBM Cognitive Systems, "With the addition of IBM Power Systems in SAP HANA Enterprise Cloud, we\'re giving our clients more choices and greater flexibility to run their workloads where they want to across the hybrid cloud and accelerate digital transformation."',
   'object': {'text': 'more choices and greater flexibility to run their workloads where they want to across the hybrid cloud and accelerate digital transformation'},
   'action': {'verb': {'text': 'give', 'tense': 'present'},
    'text': 'giving',
    'normalized': 'give'}},
  {'subject': {'text': 'we'},
   'sentence': ' "In June, IBM announced the availability of POWER9 in the IBM Cloud, taking the first step toward our goal of bringing IBM Cognitive Systems technology to our clients, no matter where they are," said Stephen Leonard, General Manager, IBM Cognitive Systems, "With the addition of IBM Power Systems in SAP HANA Enterprise Cloud, we\'re giving our clients more choices and greater flexibility to run their workloads where they want to across the hybrid cloud and accelerate digital transformation."',
   'object': {'text': 'their workloads'},
   'action': {'verb': {'text': 'run', 'tense': 'future'},
    'text': 'to run',
    'normalized': 'to run'}},
  {'subject': {'text': 'they'},
   'sentence': ' "In June, IBM announced the availability of POWER9 in the IBM Cloud, taking the first step toward our goal of bringing IBM Cognitive Systems technology to our clients, no matter where they are," said Stephen Leonard, General Manager, IBM Cognitive Systems, "With the addition of IBM Power Systems in SAP HANA Enterprise Cloud, we\'re giving our clients more choices and greater flexibility to run their workloads where they want to across the hybrid cloud and accelerate digital transformation."',
   'object': {'text': 'digital transformation'},
   'action': {'verb': {'text': 'accelerate', 'tense': 'present'},
    'text': 'accelerate',
    'normalized': 'accelerate'}},
  {'subject': {'text': 'IBM Power Systems'},
   'sentence': ' IBM Power Systems has been delivering scalability and availability for SAP HANA applications since it was certified for SAP HANA in 2015, and the ongoing collaboration between IBM Power Systems and SAP provides virtualization on-demand via hypervisor-defined features in Power Systems.',
   'object': {'text': 'scalability and availability'},
   'action': {'verb': {'text': 'deliver', 'tense': 'past'},
    'text': 'has been delivering',
    'normalized': 'have be deliver'}},
  {'subject': {'text': 'it'},
   'sentence': ' IBM Power Systems has been delivering scalability and availability for SAP HANA applications since it was certified for SAP HANA in 2015, and the ongoing collaboration between IBM Power Systems and SAP provides virtualization on-demand via hypervisor-defined features in Power Systems.',
   'object': {'text': 'certified for SAP HANA'},
   'action': {'verb': {'text': 'be', 'tense': 'past'},
    'text': 'was',
    'normalized': 'be'}},
  {'subject': {'text': 'it'},
   'sentence': ' IBM Power Systems has been delivering scalability and availability for SAP HANA applications since it was certified for SAP HANA in 2015, and the ongoing collaboration between IBM Power Systems and SAP provides virtualization on-demand via hypervisor-defined features in Power Systems.',
   'object': {'text': 'for SAP HANA'},
   'action': {'verb': {'text': 'certify', 'tense': 'past'},
    'text': 'was certified',
    'normalized': 'be certify'}},
  {'subject': {'text': 'the ongoing collaboration between IBM Power Systems and SAP'},
   'sentence': ' IBM Power Systems has been delivering scalability and availability for SAP HANA applications since it was certified for SAP HANA in 2015, and the ongoing collaboration between IBM Power Systems and SAP provides virtualization on-demand via hypervisor-defined features in Power Systems.',
   'object': {'text': 'virtualization on-demand'},
   'action': {'verb': {'text': 'provide', 'tense': 'present'},
    'text': 'provides',
    'normalized': 'provide'}},
  {'subject': {'text': 'This'},
   'sentence': ' This enables clients to take advantage of multiple SAP HANA Enterprise Cloud service levels and transform their IT operations by shifting the focus from infrastructure maintenance to innovating with SAP HANA in the cloud.',
   'object': {'text': 'clients'},
   'action': {'verb': {'text': 'enable', 'tense': 'present'},
    'text': 'enables',
    'normalized': 'enable'}},
  {'subject': {'text': 'clients'},
   'sentence': ' This enables clients to take advantage of multiple SAP HANA Enterprise Cloud service levels and transform their IT operations by shifting the focus from infrastructure maintenance to innovating with SAP HANA in the cloud.',
   'object': {'text': 'advantage'},
   'action': {'verb': {'text': 'take', 'tense': 'future'},
    'text': 'to take',
    'normalized': 'to take'}},
  {'subject': {'text': 'the focus'},
   'sentence': ' This enables clients to take advantage of multiple SAP HANA Enterprise Cloud service levels and transform their IT operations by shifting the focus from infrastructure maintenance to innovating with SAP HANA in the cloud.',
   'object': {'text': 'from infrastructure maintenance to innovating with SAP HANA in the cloud'},
   'action': {'verb': {'text': 'shift', 'tense': 'present'},
    'text': 'shifting',
    'normalized': 'shift'}},
  {'subject': {'text': 'with SAP HANA'},
   'sentence': ' This enables clients to take advantage of multiple SAP HANA Enterprise Cloud service levels and transform their IT operations by shifting the focus from infrastructure maintenance to innovating with SAP HANA in the cloud.',
   'action': {'verb': {'text': 'innovate', 'tense': 'future'},
    'text': 'innovating',
    'normalized': 'innovate'}},
  {'subject': {'text': 'SAP HANA Enterprise Cloud on IBM Power Systems'},
   'sentence': " SAP HANA Enterprise Cloud on IBM Power Systems is another testament to IBM and SAP's long-standing, client-centric relationship.",
   'object': {'text': "another testament to IBM and SAP's long-standing, client-centric relationship"},
   'action': {'verb': {'text': 'be', 'tense': 'present'},
    'text': 'is',
    'normalized': 'be'}},
  {'subject': {'text': 'IBM Services and SAP'},
   'sentence': ' Since forming the Digital Transformation partnership\xa0more than three years ago, IBM Services and SAP have worked together to provide services and capabilities that help accelerate how customers around the world modernize their systems and processes on their path to becoming an intelligent enterprise.',
   'object': {'text': 'the Digital Transformation partnership\xa0more than three years ago'},
   'action': {'verb': {'text': 'form', 'tense': 'present'},
    'text': 'forming',
    'normalized': 'form'}},
  {'subject': {'text': 'IBM Services and SAP'},
   'sentence': ' Since forming the Digital Transformation partnership\xa0more than three years ago, IBM Services and SAP have worked together to provide services and capabilities that help accelerate how customers around the world modernize their systems and processes on their path to becoming an intelligent enterprise.',
   'action': {'verb': {'text': 'have', 'tense': 'present'},
    'text': 'have worked',
    'normalized': 'have work'}},
  {'subject': {'text': 'IBM Services and SAP'},
   'sentence': ' Since forming the Digital Transformation partnership\xa0more than three years ago, IBM Services and SAP have worked together to provide services and capabilities that help accelerate how customers around the world modernize their systems and processes on their path to becoming an intelligent enterprise.',
   'object': {'text': 'to provide services and capabilities that help accelerate how customers around the world modernize their systems and processes on their path to becoming an intelligent enterprise'},
   'action': {'verb': {'text': 'work', 'tense': 'past'},
    'text': 'have worked',
    'normalized': 'have work'}},
  {'subject': {'text': 'IBM Services and SAP'},
   'sentence': ' Since forming the Digital Transformation partnership\xa0more than three years ago, IBM Services and SAP have worked together to provide services and capabilities that help accelerate how customers around the world modernize their systems and processes on their path to becoming an intelligent enterprise.',
   'object': {'text': 'services and capabilities'},
   'action': {'verb': {'text': 'provide', 'tense': 'future'},
    'text': 'to provide',
    'normalized': 'to provide'}},
  {'subject': {'text': 'capabilities'},
   'sentence': ' Since forming the Digital Transformation partnership\xa0more than three years ago, IBM Services and SAP have worked together to provide services and capabilities that help accelerate how customers around the world modernize their systems and processes on their path to becoming an intelligent enterprise.',
   'object': {'text': 'accelerate how customers around the world modernize their systems and processes'},
   'action': {'verb': {'text': 'help', 'tense': 'present'},
    'text': 'help',
    'normalized': 'help'}},
  {'subject': {'text': 'POWER9 a maximum of 24TB'},
   'sentence': ' i\xa0As per the SAP Note 2188482, on POWER9 a maximum of 24TB can be\xa0used by single HANA 2.0 (scale-up) must not be exceeded',
   'object': {'text': 'used by single HANA 2.0 (scale-up'},
   'action': {'verb': {'text': 'be', 'tense': 'future'},
    'text': 'be',
    'normalized': 'be'}},
  {'subject': {'text': 'by single HANA 2.0 (scale-up)'},
   'sentence': ' i\xa0As per the SAP Note 2188482, on POWER9 a maximum of 24TB can be\xa0used by single HANA 2.0 (scale-up) must not be exceeded',
   'object': {'text': 'POWER9 a maximum of 24TB'},
   'action': {'verb': {'text': 'use', 'tense': 'future'},
    'text': 'can be\xa0used',
    'normalized': 'can be\xa0use'}}],
 'retrieved_url': 'https://newsroom.ibm.com/2020-02-19-IBM-Power-Systems-Certified-for-SAP-HANA-R-Enterprise-Cloud-as-a-provider-for-large-SAP-HANA-systems',
 'language': 'en',
 'entities': [{'type': 'Organization',
   'text': 'SAP',
   'relevance': 0.807653,
   'mentions': [{'text': 'SAP',
     'location': [126, 129],
     'confidence': 0.706408},
    {'text': 'SAP', 'location': [210, 213], 'confidence': 0.625238},
    {'text': 'SAP', 'location': [565, 568], 'confidence': 0.70457},
    {'text': 'SAP', 'location': [937, 940], 'confidence': 0.738066},
    {'text': 'SAP', 'location': [1137, 1140], 'confidence': 0.644183},
    {'text': 'SAP', 'location': [1294, 1297], 'confidence': 0.224388},
    {'text': 'SAP', 'location': [1509, 1512], 'confidence': 0.746624},
    {'text': 'SAP', 'location': [1709, 1712], 'confidence': 0.616656},
    {'text': 'SAP', 'location': [1968, 1971], 'confidence': 0.876088},
    {'text': 'SAP', 'location': [2720, 2723], 'confidence': 0.807853},
    {'text': 'SAP', 'location': [2859, 2862], 'confidence': 0.674871},
    {'text': 'SAP', 'location': [3030, 3033], 'confidence': 0.738465},
    {'text': 'SAP', 'location': [3109, 3112], 'confidence': 0.935623},
    {'text': 'SAP', 'location': [3256, 3259], 'confidence': 0.609506}],
   'disambiguation': {'name': 'Computers_and_Structures',
    'dbpedia_resource': 'http://dbpedia.org/resource/Computers_and_Structures'},
   'count': 14,
   'confidence': 1},
  {'type': 'Organization',
   'text': 'IBM',
   'relevance': 0.739592,
   'mentions': [{'text': 'IBM', 'location': [44, 47], 'confidence': 0.923359},
    {'text': 'IBM', 'location': [55, 58], 'confidence': 0.955547},
    {'text': 'IBM', 'location': [337, 340], 'confidence': 0.923548},
    {'text': 'IBM', 'location': [354, 357], 'confidence': 0.826499},
    {'text': 'IBM', 'location': [1338, 1341], 'confidence': 0.920989},
    {'text': 'IBM', 'location': [1604, 1607], 'confidence': 0.896893},
    {'text': 'IBM', 'location': [2037, 2040], 'confidence': 0.947928},
    {'text': 'IBM', 'location': [2085, 2088], 'confidence': 0.875871},
    {'text': 'IBM', 'location': [2146, 2149], 'confidence': 0.895943},
    {'text': 'IBM', 'location': [2306, 2309], 'confidence': 0.832583},
    {'text': 'IBM', 'location': [2522, 2525], 'confidence': 0.963734},
    {'text': 'IBM', 'location': [3101, 3104], 'confidence': 0.948039},
    {'text': 'IBM', 'location': [3488, 3491], 'confidence': 0.91803},
    {'text': 'IBM', 'location': [3588, 3591], 'confidence': 0.920051},
    {'text': 'IBM', 'location': [3806, 3809], 'confidence': 0.798765}],
   'disambiguation': {'subtype': ['SoftwareLicense',
     'Company',
     'OperatingSystemDeveloper',
     'ProcessorManufacturer',
     'SoftwareDeveloper',
     'CompanyFounder',
     'ProgrammingLanguageDesigner',
     'ProgrammingLanguageDeveloper'],
    'name': 'IBM',
    'dbpedia_resource': 'http://dbpedia.org/resource/IBM'},
   'count': 15,
   'confidence': 1},
  {'type': 'Organization',
   'text': 'SAP HANA',
   'relevance': 0.531033,
   'mentions': [{'text': 'SAP HANA',
     'location': [1180, 1188],
     'confidence': 0.413465},
    {'text': 'SAP HANA', 'location': [1848, 1856], 'confidence': 0.46181},
    {'text': 'SAP HANA', 'location': [2593, 2601], 'confidence': 0.356218},
    {'text': 'SAP HANA', 'location': [2642, 2650], 'confidence': 0.460657}],
   'count': 4,
   'confidence': 0.890394},
  {'type': 'Organization',
   'text': 'IBM Power Systems',
   'relevance': 0.441607,
   'mentions': [{'text': 'IBM Power Systems',
     'location': [81, 98],
     'confidence': 0.633804},
    {'text': 'IBM Power Systems',
     'location': [966, 983],
     'confidence': 0.560009},
    {'text': 'IBM Power Systems',
     'location': [2698, 2715],
     'confidence': 0.575683},
    {'text': 'IBM Power Systems',
     'location': [3059, 3076],
     'confidence': 0.565056}],
   'count': 4,
   'confidence': 0.970264},
  {'type': 'Location',
   'text': 'ARMONK, N.Y.',
   'relevance': 0.308323,
   'mentions': [{'text': 'ARMONK, N.Y.',
     'location': [0, 12],
     'confidence': 0.83211}],
   'count': 1,
   'confidence': 0.83211},
  {'type': 'Person',
   'text': 'Christoph Herman',
   'relevance': 0.217154,
   'mentions': [{'text': 'Christoph Herman',
     'location': [1213, 1229],
     'confidence': 0.94435}],
   'count': 1,
   'confidence': 0.94435},
  {'type': 'Organization',
   'text': 'Head of SAP',
   'relevance': 0.215329,
   'mentions': [{'text': 'Head of SAP',
     'location': [1239, 1250],
     'confidence': 0.560687}],
   'count': 1,
   'confidence': 0.560687},
  {'type': 'Organization',
   'text': 'NYSE',
   'relevance': 0.142168,
   'mentions': [{'text': 'NYSE',
     'location': [49, 53],
     'confidence': 0.739278}],
   'disambiguation': {'subtype': ['Location',
     'Company',
     'Facility',
     'HistoricPlace',
     'Building'],
    'name': 'New_York_Stock_Exchange',
    'dbpedia_resource': 'http://dbpedia.org/resource/New_York_Stock_Exchange'},
   'count': 1,
   'confidence': 0.739278},
  {'type': 'Person',
   'text': 'Stephen Leonard',
   'relevance': 0.136166,
   'mentions': [{'text': 'Stephen Leonard',
     'location': [2227, 2242],
     'confidence': 0.989177}],
   'disambiguation': {'name': 'Steve_Leonard',
    'dbpedia_resource': 'http://dbpedia.org/resource/Steve_Leonard'},
   'count': 1,
   'confidence': 0.989177},
  {'type': 'Organization',
   'text': 'IBM Cognitive Systems',
   'relevance': 0.133117,
   'mentions': [{'text': 'IBM Cognitive Systems',
     'location': [2261, 2282],
     'confidence': 0.578752}],
   'count': 1,
   'confidence': 0.578752},
  {'type': 'Organization',
   'text': 'SVP',
   'relevance': 0.120376,
   'mentions': [{'text': 'SVP',
     'location': [1231, 1234],
     'confidence': 0.465067}],
   'count': 1,
   'confidence': 0.465067},
  {'type': 'JobTitle',
   'text': 'General Manager',
   'relevance': 0.05826,
   'mentions': [{'text': 'General Manager',
     'location': [2244, 2259],
     'confidence': 0.915838}],
   'count': 1,
   'confidence': 0.915838},
  {'type': 'Organization',
   'text': 'IBM Services',
   'relevance': 0.050347,
   'mentions': [{'text': 'IBM Services',
     'location': [3239, 3251],
     'confidence': 0.655422}],
   'count': 1,
   'confidence': 0.655422},
  {'type': 'Organization',
   'text': 'Power Systems',
   'relevance': 0.046073,
   'mentions': [{'text': 'Power Systems',
     'location': [2793, 2806],
     'confidence': 0.485185}],
   'count': 1,
   'confidence': 0.485185},
  {'type': 'Organization',
   'text': 'Digital Transformation',
   'relevance': 0.038946,
   'mentions': [{'text': 'Digital Transformation',
     'location': [3177, 3199],
     'confidence': 0.659625}],
   'count': 1,
   'confidence': 0.659625},
  {'type': 'Person',
   'text': 'Sam Ponedal',
   'relevance': 0.020711,
   'mentions': [{'text': 'Sam Ponedal',
     'location': [3574, 3585],
     'confidence': 0.894298}],
   'count': 1,
   'confidence': 0.894298},
  {'type': 'EmailAddress',
   'text': 'sponeda@us.ibm.com',
   'relevance': 0.017259,
   'mentions': [{'text': 'sponeda@us.ibm.com',
     'location': [3609, 3627],
     'confidence': 0.8}],
   'count': 1,
   'confidence': 0.8}],
 'analyzed_text': 'ARMONK, N.Y., Feb. 19, 2020 /PRNewswire/ --\xa0IBM (NYSE: IBM) today announced that IBM Power Systems has been certified for the SAP HANA® Enterprise Cloud as a critical infrastructure platform provider for large SAP HANA systems, aiming to simplify the IT infrastructure for the managed, private cloud environment. The service will run on IBM POWER9-based IBM Power Systems E980 servers, which have the industry\'s largest virtualized server scalability of 24TB for the SAP HANA databasei.\nProviding the IT infrastructure for a managed, private cloud environment, the SAP HANA Enterprise Cloud is a scalable and secured service that is designed to accelerate a user\'s evolution\xa0on the path to cloud readiness. It\xa0provides capabilities that span the software and hardware stack, a comprehensive\xa0menu of functional and technical services, and the level of control clients should expect on\xa0premises, all in one privately managed environment.\n"SAP HANA Enterprise Cloud on IBM Power Systems will help clients unlock the full value of SAP HANA in the cloud, with the possibility of enhancing the scalability and availability of mission critical SAP applications while moving workloads to SAP HANA and lowering TCO," said Christoph Herman, SVP and Head of SAP HANA Enterprise Cloud Delivery. "Combining SAP HANA Enterprise Cloud capabilities with IBM Power Systems can help establish a faster path to cloud readiness for our clients while addressing risk and providing closer alignment to the intelligent enterprise."\nSAP HANA Enterprise Cloud users can take advantage of the firmware-based virtualization in the IBM POWER platform that offers the largest SAP HANA scalability in scale-up systemsii. This helps enable SAP HANA Enterprise Cloud users to accommodate capacity changes – this is designed for clients to benefit from faster performance of their SAP HANA-based business intelligence applications by running them in a single node while maximizing the availability of SAP applications with the highly resilient infrastructure.\n"In June, IBM announced the availability of POWER9 in the IBM Cloud, taking the first step toward our goal of bringing IBM Cognitive Systems technology to our clients, no matter where they are," said Stephen Leonard, General Manager, IBM Cognitive Systems, "With the addition of IBM Power Systems in SAP HANA Enterprise Cloud, we\'re giving our clients more choices and greater flexibility to run their workloads where they want to across the hybrid cloud and accelerate digital transformation."\nIBM Power Systems has been delivering scalability and availability for SAP HANA applications since it was certified for SAP HANA in 2015, and the ongoing collaboration between IBM Power Systems and SAP provides virtualization on-demand via hypervisor-defined features in Power Systems. This enables clients to take advantage of multiple SAP HANA Enterprise Cloud service levels and transform their IT operations by shifting the focus from infrastructure maintenance to innovating with SAP HANA in the cloud.\nSAP HANA Enterprise Cloud on IBM Power Systems is another testament to IBM and SAP\'s long-standing, client-centric relationship. Since forming the Digital Transformation partnership\xa0more than three years ago, IBM Services and SAP have worked together to provide services and capabilities that help accelerate how customers around the world modernize their systems and processes on their path to becoming an intelligent enterprise.\nFor more information about IBM Power Systems, visit https://www.ibm.com/it-infrastructure/power.\nMedia Contact:\n Sam Ponedal \n IBM Media Relations\n sponeda@us.ibm.com\ni\xa0As per the SAP Note 2188482, on POWER9 a maximum of 24TB can be\xa0used by single HANA 2.0 (scale-up) must not be exceeded\n ii\xa0See footnote 1 for more detailed explanation\nSOURCE IBM\n'}

In [17]:

import pandas as pd
import text_extensions_for_pandas as tp

# Convert the output of Watson Natural Language Understanding to DataFrames.
dataframes = tp.io.watson.nlu.parse_response(nlu_results)
dataframes.keys()

Out[17]:

dict_keys(['syntax', 'entities', 'entity_mentions', 'keywords', 'relations', 'semantic_roles'])

In [18]:

entity_mentions = dataframes["entity_mentions"]
entity_mentions

Out[18]:

	type	text	span	confidence
0	Organization	SAP	[126, 129): 'SAP'	0.706408
1	Organization	SAP	[210, 213): 'SAP'	0.625238
2	Organization	SAP	[565, 568): 'SAP'	0.704570
3	Organization	SAP	[937, 940): 'SAP'	0.738066
4	Organization	SAP	[1137, 1140): 'SAP'	0.644183
5	Organization	SAP	[1294, 1297): 'SAP'	0.224388
6	Organization	SAP	[1509, 1512): 'SAP'	0.746624
7	Organization	SAP	[1709, 1712): 'SAP'	0.616656
8	Organization	SAP	[1968, 1971): 'SAP'	0.876088
9	Organization	SAP	[2720, 2723): 'SAP'	0.807853
10	Organization	SAP	[2859, 2862): 'SAP'	0.674871
11	Organization	SAP	[3030, 3033): 'SAP'	0.738465
12	Organization	SAP	[3109, 3112): 'SAP'	0.935623
13	Organization	SAP	[3256, 3259): 'SAP'	0.609506
14	Organization	IBM	[44, 47): 'IBM'	0.923359
15	Organization	IBM	[55, 58): 'IBM'	0.955547
16	Organization	IBM	[337, 340): 'IBM'	0.923548
17	Organization	IBM	[354, 357): 'IBM'	0.826499
18	Organization	IBM	[1338, 1341): 'IBM'	0.920989
19	Organization	IBM	[1604, 1607): 'IBM'	0.896893
20	Organization	IBM	[2037, 2040): 'IBM'	0.947928
21	Organization	IBM	[2085, 2088): 'IBM'	0.875871
22	Organization	IBM	[2146, 2149): 'IBM'	0.895943
23	Organization	IBM	[2306, 2309): 'IBM'	0.832583
24	Organization	IBM	[2522, 2525): 'IBM'	0.963734
25	Organization	IBM	[3101, 3104): 'IBM'	0.948039
26	Organization	IBM	[3488, 3491): 'IBM'	0.918030
27	Organization	IBM	[3588, 3591): 'IBM'	0.920051
28	Organization	IBM	[3806, 3809): 'IBM'	0.798765
29	Organization	SAP HANA	[1180, 1188): 'SAP HANA'	0.413465
30	Organization	SAP HANA	[1848, 1856): 'SAP HANA'	0.461810
31	Organization	SAP HANA	[2593, 2601): 'SAP HANA'	0.356218
32	Organization	SAP HANA	[2642, 2650): 'SAP HANA'	0.460657
33	Organization	IBM Power Systems	[81, 98): 'IBM Power Systems'	0.633804
34	Organization	IBM Power Systems	[966, 983): 'IBM Power Systems'	0.560009
35	Organization	IBM Power Systems	[2698, 2715): 'IBM Power Systems'	0.575683
36	Organization	IBM Power Systems	[3059, 3076): 'IBM Power Systems'	0.565056
37	Location	ARMONK, N.Y.	[0, 12): 'ARMONK, N.Y.'	0.832110
38	Person	Christoph Herman	[1213, 1229): 'Christoph Herman'	0.944350
39	Organization	Head of SAP	[1239, 1250): 'Head of SAP'	0.560687
40	Organization	NYSE	[49, 53): 'NYSE'	0.739278
41	Person	Stephen Leonard	[2227, 2242): 'Stephen Leonard'	0.989177
42	Organization	IBM Cognitive Systems	[2261, 2282): 'IBM Cognitive Systems'	0.578752
43	Organization	SVP	[1231, 1234): 'SVP'	0.465067
44	JobTitle	General Manager	[2244, 2259): 'General Manager'	0.915838
45	Organization	IBM Services	[3239, 3251): 'IBM Services'	0.655422
46	Organization	Power Systems	[2793, 2806): 'Power Systems'	0.485185
47	Organization	Digital Transformation	[3177, 3199): 'Digital Transformation'	0.659625
48	Person	Sam Ponedal	[3574, 3585): 'Sam Ponedal'	0.894298
49	EmailAddress	sponeda@us.ibm.com	[3609, 3627): 'sponeda@us.ibm.com'	0.800000

In [19]:

# Extract mentions of person names
person_mentions = entity_mentions[entity_mentions["type"] == "Person"]
person_mentions

Out[19]:

	type	text	span	confidence
38	Person	Christoph Herman	[1213, 1229): 'Christoph Herman'	0.944350
41	Person	Stephen Leonard	[2227, 2242): 'Stephen Leonard'	0.989177
48	Person	Sam Ponedal	[3574, 3585): 'Sam Ponedal'	0.894298

In [20]:

# Show person mentions in context
person_mentions["span"].array

Out[20]:

	begin	end	covered_text
0	1213	1229	Christoph Herman
1	2227	2242	Stephen Leonard
2	3574	3585	Sam Ponedal

ARMONK, N.Y., Feb. 19, 2020 /PRNewswire/ -- IBM (NYSE: IBM) today announced that IBM Power Systems has been certified for the SAP HANA® Enterprise Cloud as a critical infrastructure platform provider for large SAP HANA systems, aiming to simplify the IT infrastructure for the managed, private cloud environment. The service will run on IBM POWER9-based IBM Power Systems E980 servers, which have the industry's largest virtualized server scalability of 24TB for the SAP HANA databasei.
Providing the IT infrastructure for a managed, private cloud environment, the SAP HANA Enterprise Cloud is a scalable and secured service that is designed to accelerate a user's evolution on the path to cloud readiness. It provides capabilities that span the software and hardware stack, a comprehensive menu of functional and technical services, and the level of control clients should expect on premises, all in one privately managed environment.
"SAP HANA Enterprise Cloud on IBM Power Systems will help clients unlock the full value of SAP HANA in the cloud, with the possibility of enhancing the scalability and availability of mission critical SAP applications while moving workloads to SAP HANA and lowering TCO," said Christoph Herman, SVP and Head of SAP HANA Enterprise Cloud Delivery. "Combining SAP HANA Enterprise Cloud capabilities with IBM Power Systems can help establish a faster path to cloud readiness for our clients while addressing risk and providing closer alignment to the intelligent enterprise."
SAP HANA Enterprise Cloud users can take advantage of the firmware-based virtualization in the IBM POWER platform that offers the largest SAP HANA scalability in scale-up systemsii. This helps enable SAP HANA Enterprise Cloud users to accommodate capacity changes – this is designed for clients to benefit from faster performance of their SAP HANA-based business intelligence applications by running them in a single node while maximizing the availability of SAP applications with the highly resilient infrastructure.
"In June, IBM announced the availability of POWER9 in the IBM Cloud, taking the first step toward our goal of bringing IBM Cognitive Systems technology to our clients, no matter where they are," said Stephen Leonard, General Manager, IBM Cognitive Systems, "With the addition of IBM Power Systems in SAP HANA Enterprise Cloud, we're giving our clients more choices and greater flexibility to run their workloads where they want to across the hybrid cloud and accelerate digital transformation."
IBM Power Systems has been delivering scalability and availability for SAP HANA applications since it was certified for SAP HANA in 2015, and the ongoing collaboration between IBM Power Systems and SAP provides virtualization on-demand via hypervisor-defined features in Power Systems. This enables clients to take advantage of multiple SAP HANA Enterprise Cloud service levels and transform their IT operations by shifting the focus from infrastructure maintenance to innovating with SAP HANA in the cloud.
SAP HANA Enterprise Cloud on IBM Power Systems is another testament to IBM and SAP's long-standing, client-centric relationship. Since forming the Digital Transformation partnership more than three years ago, IBM Services and SAP have worked together to provide services and capabilities that help accelerate how customers around the world modernize their systems and processes on their path to becoming an intelligent enterprise.
For more information about IBM Power Systems, visit https://www.ibm.com/it-infrastructure/power.
Media Contact:
Sam Ponedal
IBM Media Relations
sponeda@us.ibm.com
i As per the SAP Note 2188482, on POWER9 a maximum of 24TB can be used by single HANA 2.0 (scale-up) must not be exceeded
ii See footnote 1 for more detailed explanation
SOURCE IBM

In [21]:

# Go back to the Watson output and retrieve the results from the semantic_roles
# model. This mode finds subject-verb-object triples.
semantic_roles = dataframes["semantic_roles"]
semantic_roles

Out[21]:

	subject.text	sentence	object.text	action.verb.text	action.verb.tense	action.text	action.normalized
0	IBM	ARMONK, N.Y., Feb. 19, 2020 /PRNewswire/ -- IB...	that IBM Power Systems has been certified for ...	announce	past	announced	announce
1	IBM Power Systems	ARMONK, N.Y., Feb. 19, 2020 /PRNewswire/ -- IB...	certified for the SAP HANA® Enterprise Cloud a...	be	past	been	be
2	to simplify the IT infrastructure	ARMONK, N.Y., Feb. 19, 2020 /PRNewswire/ -- IB...	for the managed, private cloud environment	aim	present	aiming	aim
3	the IT infrastructure	ARMONK, N.Y., Feb. 19, 2020 /PRNewswire/ -- IB...	for the managed, private cloud environment	simplify	future	aiming to simplify	aim to simplify
4	IBM POWER9-based IBM Power Systems E980 servers	The service will run on IBM POWER9-based IBM ...	the industry's largest virtualized server scal...	have	present	have	have
5	the IT infrastructure	Providing the IT infrastructure for a managed...	for a managed	Providing	present	Providing	Providing
6	the SAP HANA Enterprise Cloud	Providing the IT infrastructure for a managed...	a scalable	be	present	is	be
7	a scalable and secured service	Providing the IT infrastructure for a managed...	a user's evolution	accelerate	future	is designed to accelerate	be design to accelerate
8	It	It provides capabilities that span the softwa...	capabilities that span the software and hardwa...	provide	present	provides	provide
9	capabilities	It provides capabilities that span the softwa...	the software and hardware stack	span	present	span	span
10	SAP HANA Enterprise Cloud on IBM Power Systems	"SAP HANA Enterprise Cloud on IBM Power Syste...	clients unlock the full value of SAP HANA in t...	help	future	will help	will help
11	Christoph Herman, SVP and Head of SAP HANA Ent...	"SAP HANA Enterprise Cloud on IBM Power Syste...	SAP HANA Enterprise Cloud on IBM Power Systems...	say	past	said	say
12	closer alignment	"Combining SAP HANA Enterprise Cloud capabili...	to the intelligent enterprise	provide	present	providing	provide
13	SAP HANA Enterprise Cloud users	SAP HANA Enterprise Cloud users can take adva...	advantage	take	future	can take	can take
14	the IBM POWER platform	SAP HANA Enterprise Cloud users can take adva...	the largest SAP HANA scalability	offer	present	offers	offer
15	This	This helps enable SAP HANA Enterprise Cloud u...	enable SAP HANA Enterprise Cloud users	help	present	helps	help
16	This	This helps enable SAP HANA Enterprise Cloud u...	SAP HANA Enterprise Cloud users	enable	present	helps enable	help enable
17	SAP HANA Enterprise Cloud users	This helps enable SAP HANA Enterprise Cloud u...	capacity changes – this	accommodate	future	to accommodate	to accommodate
18	from faster performance of their SAP HANA-base...	This helps enable SAP HANA Enterprise Cloud u...	clients	benefit	future	to benefit	to benefit
19	them	This helps enable SAP HANA Enterprise Cloud u...	None	run	present	running	run
20	IBM	"In June, IBM announced the availability of P...	the availability of POWER9 in the IBM Cloud, t...	announce	past	announced	announce
21	IBM	"In June, IBM announced the availability of P...	the first step toward our goal of bringing IBM...	take	present	taking	take
22	IBM Cognitive Systems technology	"In June, IBM announced the availability of P...	to our clients	bring	future	bringing	bring
23	Stephen Leonard, General Manager, IBM Cognitiv...	"In June, IBM announced the availability of P...	In June, IBM announced the availability of POW...	say	past	said	say
24	we	"In June, IBM announced the availability of P...	giving our clients more choices and greater fl...	be	present	are	be
25	we	"In June, IBM announced the availability of P...	more choices and greater flexibility to run th...	give	present	giving	give
26	we	"In June, IBM announced the availability of P...	their workloads	run	future	to run	to run
27	they	"In June, IBM announced the availability of P...	digital transformation	accelerate	present	accelerate	accelerate
28	IBM Power Systems	IBM Power Systems has been delivering scalabi...	scalability and availability	deliver	past	has been delivering	have be deliver
29	it	IBM Power Systems has been delivering scalabi...	certified for SAP HANA	be	past	was	be
30	it	IBM Power Systems has been delivering scalabi...	for SAP HANA	certify	past	was certified	be certify
31	the ongoing collaboration between IBM Power Sy...	IBM Power Systems has been delivering scalabi...	virtualization on-demand	provide	present	provides	provide
32	This	This enables clients to take advantage of mul...	clients	enable	present	enables	enable
33	clients	This enables clients to take advantage of mul...	advantage	take	future	to take	to take
34	the focus	This enables clients to take advantage of mul...	from infrastructure maintenance to innovating ...	shift	present	shifting	shift
35	with SAP HANA	This enables clients to take advantage of mul...	None	innovate	future	innovating	innovate
36	SAP HANA Enterprise Cloud on IBM Power Systems	SAP HANA Enterprise Cloud on IBM Power System...	another testament to IBM and SAP's long-standi...	be	present	is	be
37	IBM Services and SAP	Since forming the Digital Transformation part...	the Digital Transformation partnership more th...	form	present	forming	form
38	IBM Services and SAP	Since forming the Digital Transformation part...	None	have	present	have worked	have work
39	IBM Services and SAP	Since forming the Digital Transformation part...	to provide services and capabilities that help...	work	past	have worked	have work
40	IBM Services and SAP	Since forming the Digital Transformation part...	services and capabilities	provide	future	to provide	to provide
41	capabilities	Since forming the Digital Transformation part...	accelerate how customers around the world mode...	help	present	help	help
42	POWER9 a maximum of 24TB	i As per the SAP Note 2188482, on POWER9 a ma...	used by single HANA 2.0 (scale-up	be	future	be	be
43	by single HANA 2.0 (scale-up)	i As per the SAP Note 2188482, on POWER9 a ma...	POWER9 a maximum of 24TB	use	future	can be used	can be use

In [22]:

# Extract instances of subjects that made statements
quotes = semantic_roles[semantic_roles["action.normalized"] == "say"]
quotes

Out[22]:

	subject.text	sentence	object.text	action.verb.text	action.verb.tense	action.text	action.normalized
11	Christoph Herman, SVP and Head of SAP HANA Ent...	"SAP HANA Enterprise Cloud on IBM Power Syste...	SAP HANA Enterprise Cloud on IBM Power Systems...	say	past	said	say
23	Stephen Leonard, General Manager, IBM Cognitiv...	"In June, IBM announced the availability of P...	In June, IBM announced the availability of POW...	say	past	said	say

In [23]:

# Filter down to just the columns we're interested in
subjects = quotes[["subject.text"]].reset_index(drop=True)
subjects

Out[23]:

	subject.text
0	Christoph Herman, SVP and Head of SAP HANA Ent...
1	Stephen Leonard, General Manager, IBM Cognitiv...

In [24]:

# subjects["subject.text"] contains strings. We need spans. Create spans.
    
# Original document had HTML tags. Get the detagged document text.
doc_text = entity_mentions["span"].array.document_text

# Use String.index() to find where the strings in "subject.text" begin
subjects["begin"] = pd.Series(
    [doc_text.index(s) for s in subjects["subject.text"]], dtype=int)
subjects

Out[24]:

	subject.text	begin
0	Christoph Herman, SVP and Head of SAP HANA Ent...	1213
1	Stephen Leonard, General Manager, IBM Cognitiv...	2227

In [25]:

# Compute end offsets
subjects["end"] = subjects["begin"] + subjects["subject.text"].str.len()
subjects

Out[25]:

	subject.text	begin	end
0	Christoph Herman, SVP and Head of SAP HANA Ent...	1213	1281
1	Stephen Leonard, General Manager, IBM Cognitiv...	2227	2519

In [26]:

# Wrap the <begin, end, text> triples in a SpanArray column
subjects["span"] = tp.SpanArray(doc_text, subjects["begin"], subjects["end"])
subjects

Out[26]:

	subject.text	begin	end	span
0	Christoph Herman, SVP and Head of SAP HANA Ent...	1213	1281	[1213, 1281): 'Christoph Herman, SVP and Head ...
1	Stephen Leonard, General Manager, IBM Cognitiv...	2227	2519	[2227, 2519): 'Stephen Leonard, General Manage...

In [27]:

# Align subjects with person names
executives = tp.spanner.contain_join(subjects["span"], 
                                     person_mentions["span"],
                                     "subject", "person")
executives

Out[27]:

	subject	person
0	[1213, 1281): 'Christoph Herman, SVP and Head ...	[1213, 1229): 'Christoph Herman'
1	[2227, 2519): 'Stephen Leonard, General Manage...	[2227, 2242): 'Stephen Leonard'

In [28]:

final_result = executives.drop(columns="subject")
final_result["url"] = doc_url
final_result

Out[28]:

	person	url
0	[1213, 1229): 'Christoph Herman'	https://newsroom.ibm.com/2020-02-19-IBM-Power-...
1	[2227, 2242): 'Stephen Leonard'	https://newsroom.ibm.com/2020-02-19-IBM-Power-...

In [ ]: