Untitled
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...