import pandas as pd
!pip install cloudant
from cloudant.client import Cloudant

from cloudant.client import Cloudant
client = Cloudant.iam(
    "..........................", #username
    "..........................", #apikey 
    connect=True
)

impo=[]

Connect = client['<name of the db in cloudant>']

for document in Connect:
    impo.append(document)

abl = pd.DataFrame(impo)
abl.tail()

# =============================================================================
# DB data writing (recording the new record in Cloudant)
# =============================================================================

def db_data_writing(credential:dict, db_name:str, files:dict):
    """
    DB data writing
    This function reach the online database and write the input files as a new document
    Parameters
    ----------
    credential: dict
                credential to access the online Cloudant database instance
    db_name: str
                name of the database on which write data
    files: dict
                json containing data to write on db
    Returns
    -------
    bool
        exit status
    """
    # Feed credential and establish a connection
    client = Cloudant.iam(credential["username"],credential["apikey"],connect=True)
    # Select the database instance on which write results
    db = client[db_name]
    # write and save document
    db.create_document(files).save()
    # shutdown the connection
    client.disconnect()