from watson_developer_cloud import NaturalLanguageClassifierV1
import pandas as pd
import psycopg2
import json

conn_string = 'host={} port={}  dbname={}  user={}  password={}'.format('119.203.10.242', 5432, 'mydb', 'locq', 'Mypass***')
conn_cbedce9523454e8e9fd3fb55d4c1a52e = psycopg2.connect(conn_string)

data_df_1 = pd.read_sql('SELECT description from public."search_product"', con=conn_cbedce9523454e8e9fd3fb55d4c1a52e)


natural_language_classifier = NaturalLanguageClassifierV1(
    iam_apikey='F76ugy8hv1s3sr87buhb7564vb7************'
)


classes = natural_language_classifier.classify('7818d2s519-nlc-1311', data_df_1.to_json())

print(json.loads(classes, indent=2))

---------------------------------------------------------------------------
TypeError                                 Traceback (most recent call last)
<ipython-input-7-b6b7d122a500> in <module>()
      2
      3 classes = natural_language_classifier.classify('7818d2s519-nlc-1311', data_df_1.to_json())
----> 4 print(json.loads(classes, indent=2))

/opt/conda/envs/DSX-Python35/lib/python3.5/json/__init__.py in loads(s, encoding, cls, object_hook, parse_float, parse_int, parse_constant, object_pairs_hook, **kw)
    310     if not isinstance(s, str):
    311         raise TypeError('the JSON object must be str, not {!r}'.format(
--> 312                             s.__class__.__name__))
    313     if s.startswith(u'ufeff'):
    314         raise JSONDecodeError("Unexpected UTF-8 BOM (decode using utf-8-sig)",


TypeError: the JSON object must be str, not 'DetailedResponse'