Untitled
unknown
plain_text
2 years ago
2.0 kB
10
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 floatEditor is loading...