Untitled

 avatar
unknown
plain_text
2 years ago
2.0 kB
4
Indexable
dfClvAttrDet['hcad_entity_type'] = entity
        dfClvAttrDet['hcad_updated_by'] = 'odsBulkMigration'
        dfClvAttrDet['hcad_updated_on'] = datetime.utcnow().strftime('%Y-%m-%d %H:%M:%I') + ".0000+0000"
        dfClvAttrDet['hosc_customer_segment_desc'].replace(np_nan, "", inplace=True)
        dfClvAttrDet['hosc_customer_type'].replace(np_nan, "", inplace=True)
        dfClvAttrDet['hosc_customer_category_desc'].replace(np_nan, "", inplace=True)
        # for col in dfClvAttrDet.columns:
        #    if col=='hosc_created_on' \
        #        and (dfClvAttrDet[col].dtype == 'datetime64[ns]' \
        #            or dfClvAttrDet[col].dtype == 'object'):
        #        dfClvAttrDet["hosc_dob"] = dfClvAttrDet["hosc_dob"].dt.strftime("%Y-%m-%d")
        #dfClvAttrDet["hosc_created_on"] = dfClvAttrDet["hosc_created_on"].astype(str)
        #dfClvAttrDet['hosc_created_on'].replace(np_nan, "", inplace=True)

        dfClvAttrDet["hosc_dob"] = dfClvAttrDet["hosc_dob"].astype(str)
        dfClvAttrDet['hosc_dob'].replace(np_nan, "", inplace=True)

        dfClvAttrDet['hcad_attr_dtls'] = '{"' + dfClvAttrDet["hosc_customer_id"] + '": {' \
                                         + '"opId": "' + dfClvAttrDet["hosc_op_id"] \
                                         + '", "buId": "' + dfClvAttrDet["hosc_bu_id"] \
                                         + '", "customerSegment": "' + dfClvAttrDet["hosc_customer_segment_desc"] \
                                         + '", "customerType": "' + dfClvAttrDet["hosc_customer_type"] \
                                         + '", "marketSegment": "' + dfClvAttrDet["hosc_customer_category_desc"] \
                                         + '", "dob": "' + dfClvAttrDet["hosc_dob"] \
                                         + '", "activeSince": "' + dfClvAttrDet["hosc_created_on"] \
                                         + '"}}'





Error - the JSON object must be str, bytes or bytearray, not float
Editor is loading...