usingSystem;usingGoogle.Api.Gax.ResourceNames;usingGoogle.Cloud.Dlp.V2;publicclassDeidentifyUsingTableBucketing{publicstaticTableDeidentifyData(stringprojectId,TabletableToInspect=null){// Instantiate dlp client.vardlp=DlpServiceClient.Create();// Construct the table if null.if(tableToInspect==null){varrow1=newValue[]{newValue{StringValue="101"},newValue{StringValue="Charles Dickens"},newValue{StringValue="95"}};varrow2=newValue[]{newValue{StringValue="22"},newValue{StringValue="Jane Austin"},newValue{StringValue="21"}};varrow3=newValue[]{newValue{StringValue="55"},newValue{StringValue="Mark Twain"},newValue{StringValue="75"}};tableToInspect=newTable{Headers={newFieldId{Name="AGE"},newFieldId{Name="PATIENT"},newFieldId{Name="HAPPINESS SCORE"}},Rows={newTable.Types.Row{Values={row1}},newTable.Types.Row{Values={row2}},newTable.Types.Row{Values={row3}}}};}// Construct the table content item.varcontentItem=newContentItem{Table=tableToInspect};// Specify how the content should be de-identified.varfixedSizeBucketingConfig=newFixedSizeBucketingConfig{BucketSize=10,LowerBound=newValue{IntegerValue=0},UpperBound=newValue{IntegerValue=100},};// Specify the fields to be encrypted.varfields=newFieldId[]{newFieldId{Name="HAPPINESS SCORE"}};// Associate the encryption with the specified field.varfieldTransformation=newFieldTransformation{PrimitiveTransformation=newPrimitiveTransformation{FixedSizeBucketingConfig=fixedSizeBucketingConfig},Fields={fields}};// Construct the deidentify config.vardeidentifyConfig=newDeidentifyConfig{RecordTransformations=newRecordTransformations{FieldTransformations={fieldTransformation}}};// Construct the request.varrequest=newDeidentifyContentRequest{ParentAsLocationName=newLocationName(projectId,"global"),DeidentifyConfig=deidentifyConfig,Item=contentItem,};// Call the API.varresponse=dlp.DeidentifyContent(request);// Inspect the response.Console.WriteLine(response.Item.Table);returnresponse.Item.Table;}}

import("context""fmt""io"dlp"cloud.google.com/go/dlp/apiv2""cloud.google.com/go/dlp/apiv2/dlppb")// deIdentifyTableBucketing de-identifies data using table bucketingfuncdeIdentifyTableBucketing(wio.Writer,projectIDstring)error{// projectId := "your-project-id"// table := "your-table-value"row1:=&dlppb.Table_Row{Values:[]*dlppb.Value{{Type:&dlppb.Value_StringValue{StringValue:"22"}},{Type:&dlppb.Value_StringValue{StringValue:"Jane Austen"}},{Type:&dlppb.Value_StringValue{StringValue:"21"}},},}row2:=&dlppb.Table_Row{Values:[]*dlppb.Value{{Type:&dlppb.Value_StringValue{StringValue:"55"}},{Type:&dlppb.Value_StringValue{StringValue:"Mark Twain"}},{Type:&dlppb.Value_StringValue{StringValue:"75"}},},}row3:=&dlppb.Table_Row{Values:[]*dlppb.Value{{Type:&dlppb.Value_StringValue{StringValue:"101"}},{Type:&dlppb.Value_StringValue{StringValue:"Charles Dickens"}},{Type:&dlppb.Value_StringValue{StringValue:"95"}},},}table:=&dlppb.Table{Headers:[]*dlppb.FieldId{{Name:"AGE"},{Name:"PATIENT"},{Name:"HAPPINESS SCORE"},},Rows:[]*dlppb.Table_Row{{Values:row1.Values},{Values:row2.Values},{Values:row3.Values},},}ctx:=context.Background()// Initialize a client once and reuse it to send multiple requests. Clients// are safe to use across goroutines. When the client is no longer needed,// call the Close method to cleanup its resources.client,err:=dlp.NewClient(ctx)iferr!=nil{returnerr}// Closing the client safely cleans up background resources.deferclient.Close()// Specify what content you want the service to de-identify.contentItem:=&dlppb.ContentItem{DataItem:&dlppb.ContentItem_Table{Table:table,},}// Specify how the content should be de-identified.fixedSizeBucketingConfig:=&dlppb.FixedSizeBucketingConfig{BucketSize:10,LowerBound:&dlppb.Value{Type:&dlppb.Value_IntegerValue{IntegerValue:0,},},UpperBound:&dlppb.Value{Type:&dlppb.Value_IntegerValue{IntegerValue:100,},},}primitiveTransformation:=&dlppb.PrimitiveTransformation_FixedSizeBucketingConfig{FixedSizeBucketingConfig:fixedSizeBucketingConfig,}// Specify field to be encrypted.fieldId:=&dlppb.FieldId{Name:"HAPPINESS SCORE",}// Associate the encryption with the specified field.fieldTransformation:=&dlppb.FieldTransformation{Transformation:&dlppb.FieldTransformation_PrimitiveTransformation{PrimitiveTransformation:&dlppb.PrimitiveTransformation{Transformation:primitiveTransformation,},},Fields:[]*dlppb.FieldId{fieldId,},}recordTransformations:=&dlppb.RecordTransformations{FieldTransformations:[]*dlppb.FieldTransformation{fieldTransformation,},}// Construct the de-identification request to be sent by the client.req:=&dlppb.DeidentifyContentRequest{Parent:fmt.Sprintf("projects/%s/locations/global",projectID),DeidentifyConfig:&dlppb.DeidentifyConfig{Transformation:&dlppb.DeidentifyConfig_RecordTransformations{RecordTransformations:recordTransformations,},},Item:contentItem,}// Send the request.resp,err:=client.DeidentifyContent(ctx,req)iferr!=nil{returnerr}// Print the results.fmt.Fprintf(w,"Table after de-identification : %v",resp.GetItem().GetTable())returnnil}

importcom.google.cloud.dlp.v2.DlpServiceClient;importcom.google.privacy.dlp.v2.ContentItem;importcom.google.privacy.dlp.v2.DeidentifyConfig;importcom.google.privacy.dlp.v2.DeidentifyContentRequest;importcom.google.privacy.dlp.v2.DeidentifyContentResponse;importcom.google.privacy.dlp.v2.FieldId;importcom.google.privacy.dlp.v2.FieldTransformation;importcom.google.privacy.dlp.v2.FixedSizeBucketingConfig;importcom.google.privacy.dlp.v2.LocationName;importcom.google.privacy.dlp.v2.PrimitiveTransformation;importcom.google.privacy.dlp.v2.RecordTransformations;importcom.google.privacy.dlp.v2.Table;importcom.google.privacy.dlp.v2.Table.Row;importcom.google.privacy.dlp.v2.Value;importjava.io.IOException;publicclassDeIdentifyTableBucketing{publicstaticvoidmain(String[]args)throwsIOException{// TODO(developer): Replace these variables before running the sample.StringprojectId="your-project-id";TabletableToDeIdentify=Table.newBuilder().addHeaders(FieldId.newBuilder().setName("AGE").build()).addHeaders(FieldId.newBuilder().setName("PATIENT").build()).addHeaders(FieldId.newBuilder().setName("HAPPINESS SCORE").build()).addRows(Row.newBuilder().addValues(Value.newBuilder().setStringValue("101").build()).addValues(Value.newBuilder().setStringValue("Charles Dickens").build()).addValues(Value.newBuilder().setStringValue("95").build()).build()).addRows(Row.newBuilder().addValues(Value.newBuilder().setStringValue("22").build()).addValues(Value.newBuilder().setStringValue("Jane Austen").build()).addValues(Value.newBuilder().setStringValue("21").build()).build()).addRows(Row.newBuilder().addValues(Value.newBuilder().setStringValue("55").build()).addValues(Value.newBuilder().setStringValue("Mark Twain").build()).addValues(Value.newBuilder().setStringValue("75").build()).build()).build();deIdentifyTableBucketing(projectId,tableToDeIdentify);}publicstaticTabledeIdentifyTableBucketing(StringprojectId,TabletableToDeIdentify)throwsIOException{// Initialize client that will be used to send requests. This client only needs to be created// once, and can be reused for multiple requests. After completing all of your requests, call// the "close" method on the client to safely clean up any remaining background resources.try(DlpServiceClientdlp=DlpServiceClient.create()){// Specify what content you want the service to de-identify.ContentItemcontentItem=ContentItem.newBuilder().setTable(tableToDeIdentify).build();// Specify how the content should be de-identified.FixedSizeBucketingConfigfixedSizeBucketingConfig=FixedSizeBucketingConfig.newBuilder().setBucketSize(10).setLowerBound(Value.newBuilder().setIntegerValue(0).build()).setUpperBound(Value.newBuilder().setIntegerValue(100).build()).build();PrimitiveTransformationprimitiveTransformation=PrimitiveTransformation.newBuilder().setFixedSizeBucketingConfig(fixedSizeBucketingConfig).build();// Specify field to be encrypted.FieldIdfieldId=FieldId.newBuilder().setName("HAPPINESS SCORE").build();// Associate the encryption with the specified field.FieldTransformationfieldTransformation=FieldTransformation.newBuilder().setPrimitiveTransformation(primitiveTransformation).addFields(fieldId).build();RecordTransformationstransformations=RecordTransformations.newBuilder().addFieldTransformations(fieldTransformation).build();DeidentifyConfigdeidentifyConfig=DeidentifyConfig.newBuilder().setRecordTransformations(transformations).build();// Combine configurations into a request for the service.DeidentifyContentRequestrequest=DeidentifyContentRequest.newBuilder().setParent(LocationName.of(projectId,"global").toString()).setItem(contentItem).setDeidentifyConfig(deidentifyConfig).build();// Send the request and receive response from the service.DeidentifyContentResponseresponse=dlp.deidentifyContent(request);// Print the results.System.out.println("Table after de-identification: "+response.getItem().getTable());returnresponse.getItem().getTable();}}}

// Imports the Google Cloud Data Loss Prevention libraryconstDLP=require('@google-cloud/dlp');// Initialize google DLP Clientconstdlp=newDLP.DlpServiceClient();// The project ID to run the API call under// const projectId = 'my-project';// Construct the tabular dataconsttablularData={headers:[{name:'AGE'},{name:'PATIENT'},{name:'HAPPINESS SCORE'}],rows:[{values:[{integerValue:101},{stringValue:'Charles Dickens'},{integerValue:95},],},{values:[{integerValue:22},{stringValue:'Jane Austen'},{integerValue:21},],},{values:[{integerValue:55},{stringValue:'Mark Twain'},{integerValue:75},],},],};asyncfunctiondeIdentifyTableBucketing(){// Specify field to be de-identified.consttargetColumn={name:'HAPPINESS SCORE'};// Specify how the content should be de-identified.constbucketingConfig={bucketSize:10,lowerBound:{integerValue:0,},upperBound:{integerValue:100,},};constprimitiveTransformation={fixedSizeBucketingConfig:bucketingConfig,};// Combine configurations into a request for the service.constrequest={parent:`projects/${projectId}/locations/global`,item:{table:tablularData,},deidentifyConfig:{recordTransformations:{fieldTransformations:[{fields:[targetColumn],primitiveTransformation,},],},},};// Send the request and receive response from the serviceconst[response]=awaitdlp.deidentifyContent(request);// Print the results.console.log(`Table after de-identification:${JSON.stringify(response.item.table)}`);}deIdentifyTableBucketing();

use Google\Cloud\Dlp\V2\Client\DlpServiceClient;use Google\Cloud\Dlp\V2\ContentItem;use Google\Cloud\Dlp\V2\DeidentifyConfig;use Google\Cloud\Dlp\V2\DeidentifyContentRequest;use Google\Cloud\Dlp\V2\FieldId;use Google\Cloud\Dlp\V2\FieldTransformation;use Google\Cloud\Dlp\V2\FixedSizeBucketingConfig;use Google\Cloud\Dlp\V2\PrimitiveTransformation;use Google\Cloud\Dlp\V2\RecordTransformations;use Google\Cloud\Dlp\V2\Table;use Google\Cloud\Dlp\V2\Table\Row;use Google\Cloud\Dlp\V2\Value;/** * De-identify data using table bucketing * Transform a column without inspection. To transform a column in which the content is * already known, you can skip inspection and specify a transformation directly. * * @param string $callingProjectId      The Google Cloud project id to use as a parent resource. * @param string $inputCsvFile          The input file(csv) path  to deidentify * @param string $outputCsvFile         The oupt file path to save deidentify content * */function deidentify_table_bucketing(    // TODO(developer): Replace sample parameters before running the code.    string $callingProjectId,    string $inputCsvFile = './test/data/table2.csv',    string $outputCsvFile = './test/data/deidentify_table_bucketing_output.csv'): void {    // Instantiate a client.    $dlp = new DlpServiceClient();    // Read a CSV file    $csvLines = file($inputCsvFile, FILE_IGNORE_NEW_LINES);    $csvHeaders = explode(',', $csvLines[0]);    $csvRows = array_slice($csvLines, 1);    // Convert CSV file into protobuf objects    $tableHeaders = array_map(function ($csvHeader) {        return (new FieldId)            ->setName($csvHeader);    }, $csvHeaders);    $tableRows = array_map(function ($csvRow) {        $rowValues = array_map(function ($csvValue) {            return (new Value())                ->setStringValue($csvValue);        }, explode(',', $csvRow));        return (new Row())            ->setValues($rowValues);    }, $csvRows);    // Construct the table object    $tableToDeIdentify = (new Table())        ->setHeaders($tableHeaders)        ->setRows($tableRows);    // Specify what content you want the service to de-identify.    $contentItem = (new ContentItem())        ->setTable($tableToDeIdentify);    // Specify how the content should be de-identified.    $fixedSizeBucketingConfig = (new FixedSizeBucketingConfig())        ->setBucketSize(10)        ->setLowerBound((new Value())            ->setIntegerValue(10))        ->setUpperBound((new Value())            ->setIntegerValue(100));    $primitiveTransformation = (new PrimitiveTransformation())        ->setFixedSizeBucketingConfig($fixedSizeBucketingConfig);    // Specify the field to to apply bucketing transform on    $fieldId = (new FieldId())        ->setName('HAPPINESS_SCORE');    // Associate the encryption with the specified field.    $fieldTransformation = (new FieldTransformation())        ->setPrimitiveTransformation($primitiveTransformation)        ->setFields([$fieldId]);    $recordTransformations = (new RecordTransformations())        ->setFieldTransformations([$fieldTransformation]);    // Create the deidentification configuration object    $deidentifyConfig = (new DeidentifyConfig())        ->setRecordTransformations($recordTransformations);    $parent = "projects/$callingProjectId/locations/global";    // Run request    $deidentifyContentRequest = (new DeidentifyContentRequest())        ->setParent($parent)        ->setDeidentifyConfig($deidentifyConfig)        ->setItem($contentItem);    $response = $dlp->deidentifyContent($deidentifyContentRequest);    // Print results    $csvRef = fopen($outputCsvFile, 'w');    fputcsv($csvRef, $csvHeaders);    foreach ($response->getItem()->getTable()->getRows() as $tableRow) {        $values = array_map(function ($tableValue) {            return $tableValue->getStringValue();        }, iterator_to_array($tableRow->getValues()));        fputcsv($csvRef, $values);    };    printf($outputCsvFile);}

fromtypingimportDict,List,Unionimportgoogle.cloud.dlpfromgoogle.cloud.dlp_v2importtypesdefdeidentify_table_bucketing(project:str,table_data:Dict[str,Union[List[str],List[List[str]]]],deid_content_list:List[str],bucket_size:int,bucketing_lower_bound:int,bucketing_upper_bound:int,)->types.dlp.Table:"""Uses the Data Loss Prevention API to de-identify sensitive data in a    table by replacing them with fixed size bucket ranges.    Args:        project: The Google Cloud project id to use as a parent resource.        table_data: Dictionary representing table data.        deid_content_list: A list of fields in table to de-identify.        bucket_size: Size of each bucket for fixed sized bucketing            (except for minimum and maximum buckets). So if ``bucketing_lower_bound`` = 10,            ``bucketing_upper_bound`` = 89, and ``bucket_size`` = 10, then the            following buckets would be used: -10, 10-20, 20-30, 30-40,            40-50, 50-60, 60-70, 70-80, 80-89, 89+.       bucketing_lower_bound: Lower bound value of buckets.       bucketing_upper_bound:  Upper bound value of buckets.    Returns:       De-identified table is returned;       the response from the API is also printed to the terminal.    Example:    >> $ python deidentify_table_bucketing.py \        '{"header": ["email", "phone number", "age"],        "rows": [["robertfrost@example.com", "4232342345", "35"],        ["johndoe@example.com", "4253458383", "68"]]}' \        ["age"] 10 0 100        >>  '{"header": ["email", "phone number", "age"],            "rows": [["robertfrost@example.com", "4232342345", "30:40"],            ["johndoe@example.com", "4253458383", "60:70"]]}'    """# Instantiate a client.dlp=google.cloud.dlp_v2.DlpServiceClient()# Convert the project id into a full resource id.parent=f"projects/{project}/locations/global"# Construct the `table`. For more details on the table schema, please see# https://cloud.google.com/dlp/docs/reference/rest/v2/ContentItem#Tableheaders=[{"name":val}forvalintable_data["header"]]rows=[]forrowintable_data["rows"]:rows.append({"values":[{"string_value":cell_val}forcell_valinrow]})table={"headers":headers,"rows":rows}# Construct the `item`.item={"table":table}# Construct fixed sized bucketing configurationfixed_size_bucketing_config={"bucket_size":bucket_size,"lower_bound":{"integer_value":bucketing_lower_bound},"upper_bound":{"integer_value":bucketing_upper_bound},}# Specify fields to be de-identifieddeid_content_list=[{"name":_i}for_iindeid_content_list]# Construct Deidentify Configdeidentify_config={"record_transformations":{"field_transformations":[{"fields":deid_content_list,"primitive_transformation":{"fixed_size_bucketing_config":fixed_size_bucketing_config},}]}}# Call the API.response=dlp.deidentify_content(request={"parent":parent,"deidentify_config":deidentify_config,"item":item})# Print the results.print(f"Table after de-identification:{response.item.table}")# Return the response.returnresponse.item.table

usingSystem;usingGoogle.Api.Gax.ResourceNames;usingGoogle.Cloud.Dlp.V2;publicclassDeidentifyTableUsingMaskingAndLogic{publicstaticTableDeidentifyTable(stringprojectId,TabletableToInspect=null){// Instantiate the client.vardlp=DlpServiceClient.Create();// Construct the table if null.if(tableToInspect==null){varrow1=newValue[]{newValue{StringValue="101"},newValue{StringValue="Charles Dickens"},newValue{StringValue="95"},newValue{StringValue="Charles Dickens name was a curse invented by Shakespeare."}};varrow2=newValue[]{newValue{StringValue="22"},newValue{StringValue="Jane Austin"},newValue{StringValue="21"},newValue{StringValue="There are 14 kisses in Jane Austen's novels."}};varrow3=newValue[]{newValue{StringValue="55"},newValue{StringValue="Mark Twain"},newValue{StringValue="75"},newValue{StringValue="Mark Twain loved cats."}};tableToInspect=newTable{Headers={newFieldId{Name="AGE"},newFieldId{Name="PATIENT"},newFieldId{Name="HAPPINESS SCORE"},newFieldId{Name="FACTOID"}},Rows={newTable.Types.Row{Values={row1}},newTable.Types.Row{Values={row2}},newTable.Types.Row{Values={row3}}}};}// Construct the table content item.varcontentItem=newContentItem{Table=tableToInspect};//Specify how the content should be de-identified.varprimitiveTransformation=newPrimitiveTransformation{CharacterMaskConfig=newCharacterMaskConfig{MaskingCharacter="*"}};// Specify the fields to be de-identified.varfields=newFieldId[]{newFieldId{Name="HAPPINESS SCORE"}};// Specify when the above fields should be de-identified using condition.varcondition=newRecordCondition.Types.Conditions{Conditions_={newRecordCondition.Types.Condition{Field=newFieldId{Name="AGE"},Operator=RelationalOperator.GreaterThan,Value=newValue{IntegerValue=89}}}};// Apply the condition to recordsvarrecordCondition=newRecordCondition{Expressions=newRecordCondition.Types.Expressions{Conditions=condition}};// Associate the de-identification and conditions with the specified fields.vardeidentifiedConfig=newDeidentifyConfig{RecordTransformations=newRecordTransformations{FieldTransformations={newFieldTransformation{PrimitiveTransformation=primitiveTransformation,Fields={fields},Condition=recordCondition}}}};// Construct the request.varrequest=newDeidentifyContentRequest{ParentAsLocationName=newLocationName(projectId,"global"),DeidentifyConfig=deidentifiedConfig,Item=contentItem};// Call the API.varresponse=dlp.DeidentifyContent(request);// Inspect the response.Console.WriteLine(response.Item.Table);returnresponse.Item.Table;}}

import("context""fmt""io"dlp"cloud.google.com/go/dlp/apiv2""cloud.google.com/go/dlp/apiv2/dlppb")// deidentifyTableMaskingCondition de-identifies the table data using masking// and conditional logicfuncdeidentifyTableMaskingCondition(wio.Writer,projectIDstring)error{// projectId := "your-project-id"row1:=&dlppb.Table_Row{Values:[]*dlppb.Value{{Type:&dlppb.Value_StringValue{StringValue:"22"}},{Type:&dlppb.Value_StringValue{StringValue:"Jane Austen"}},{Type:&dlppb.Value_StringValue{StringValue:"21"}},},}row2:=&dlppb.Table_Row{Values:[]*dlppb.Value{{Type:&dlppb.Value_StringValue{StringValue:"55"}},{Type:&dlppb.Value_StringValue{StringValue:"Mark Twain"}},{Type:&dlppb.Value_StringValue{StringValue:"75"}},},}row3:=&dlppb.Table_Row{Values:[]*dlppb.Value{{Type:&dlppb.Value_StringValue{StringValue:"101"}},{Type:&dlppb.Value_StringValue{StringValue:"Charles Dickens"}},{Type:&dlppb.Value_StringValue{StringValue:"95"}},},}table:=&dlppb.Table{Headers:[]*dlppb.FieldId{{Name:"AGE"},{Name:"PATIENT"},{Name:"HAPPINESS SCORE"},},Rows:[]*dlppb.Table_Row{{Values:row1.Values},{Values:row2.Values},{Values:row3.Values},},}ctx:=context.Background()// Initialize a client once and reuse it to send multiple requests. Clients// are safe to use across goroutines. When the client is no longer needed,// call the Close method to cleanup its resources.client,err:=dlp.NewClient(ctx)iferr!=nil{returnerr}// Closing the client safely cleans up background resources.deferclient.Close()// Specify what content you want the service to de-identify.contentItem:=&dlppb.ContentItem{DataItem:&dlppb.ContentItem_Table{Table:table,},}// Specify how the content should be de-identified.charMaskConfig:=&dlppb.CharacterMaskConfig{MaskingCharacter:"*",}primitiveTransformation:=&dlppb.PrimitiveTransformation_CharacterMaskConfig{CharacterMaskConfig:charMaskConfig,}// Specify field to be de-identified.fieldId:=&dlppb.FieldId{Name:"HAPPINESS SCORE",}// Apply the condition to the records present in table.recordCondition:=&dlppb.RecordCondition_Condition{Field:fieldId,Operator:dlppb.RelationalOperator_GREATER_THAN,Value:&dlppb.Value{Type:&dlppb.Value_IntegerValue{IntegerValue:89,},},}expression:=&dlppb.RecordCondition_Expressions{Type:&dlppb.RecordCondition_Expressions_Conditions{Conditions:&dlppb.RecordCondition_Conditions{Conditions:[]*dlppb.RecordCondition_Condition{recordCondition,},},},}// Specify when the above field should be de-identified.condition:=&dlppb.RecordCondition{// Apply the condition to recordsExpressions:expression,}// Associate the de-identification and conditions with the specified field.fieldTransformation:=&dlppb.FieldTransformation{Fields:[]*dlppb.FieldId{fieldId,},Transformation:&dlppb.FieldTransformation_PrimitiveTransformation{PrimitiveTransformation:&dlppb.PrimitiveTransformation{Transformation:primitiveTransformation,},},Condition:condition,}recordTransformations:=&dlppb.RecordTransformations{FieldTransformations:[]*dlppb.FieldTransformation{fieldTransformation,},}// Combine configurations into a request for the service.req:=&dlppb.DeidentifyContentRequest{Parent:fmt.Sprintf("projects/%s/locations/global",projectID),DeidentifyConfig:&dlppb.DeidentifyConfig{Transformation:&dlppb.DeidentifyConfig_RecordTransformations{RecordTransformations:recordTransformations,},},Item:contentItem,}// Send the request.resp,err:=client.DeidentifyContent(ctx,req)iferr!=nil{returnerr}// Print the results.fmt.Fprintf(w,"Table after de-identification : %v",resp.GetItem().GetTable())returnnil}

importcom.google.cloud.dlp.v2.DlpServiceClient;importcom.google.privacy.dlp.v2.CharacterMaskConfig;importcom.google.privacy.dlp.v2.ContentItem;importcom.google.privacy.dlp.v2.DeidentifyConfig;importcom.google.privacy.dlp.v2.DeidentifyContentRequest;importcom.google.privacy.dlp.v2.DeidentifyContentResponse;importcom.google.privacy.dlp.v2.FieldId;importcom.google.privacy.dlp.v2.FieldTransformation;importcom.google.privacy.dlp.v2.LocationName;importcom.google.privacy.dlp.v2.PrimitiveTransformation;importcom.google.privacy.dlp.v2.RecordCondition;importcom.google.privacy.dlp.v2.RecordCondition.Condition;importcom.google.privacy.dlp.v2.RecordCondition.Conditions;importcom.google.privacy.dlp.v2.RecordCondition.Expressions;importcom.google.privacy.dlp.v2.RecordTransformations;importcom.google.privacy.dlp.v2.RelationalOperator;importcom.google.privacy.dlp.v2.Table;importcom.google.privacy.dlp.v2.Table.Row;importcom.google.privacy.dlp.v2.Value;importjava.io.IOException;publicclassDeIdentifyTableConditionMasking{publicstaticvoidmain(String[]args)throwsIOException{// TODO(developer): Replace these variables before running the sample.StringprojectId="your-project-id";TabletableToDeIdentify=Table.newBuilder().addHeaders(FieldId.newBuilder().setName("AGE").build()).addHeaders(FieldId.newBuilder().setName("PATIENT").build()).addHeaders(FieldId.newBuilder().setName("HAPPINESS SCORE").build()).addRows(Row.newBuilder().addValues(Value.newBuilder().setStringValue("101").build()).addValues(Value.newBuilder().setStringValue("Charles Dickens").build()).addValues(Value.newBuilder().setStringValue("95").build()).build()).addRows(Row.newBuilder().addValues(Value.newBuilder().setStringValue("22").build()).addValues(Value.newBuilder().setStringValue("Jane Austen").build()).addValues(Value.newBuilder().setStringValue("21").build()).build()).addRows(Row.newBuilder().addValues(Value.newBuilder().setStringValue("55").build()).addValues(Value.newBuilder().setStringValue("Mark Twain").build()).addValues(Value.newBuilder().setStringValue("75").build()).build()).build();deIdentifyTableConditionMasking(projectId,tableToDeIdentify);}publicstaticTabledeIdentifyTableConditionMasking(StringprojectId,TabletableToDeIdentify)throwsIOException{// Initialize client that will be used to send requests. This client only needs to be created// once, and can be reused for multiple requests. After completing all of your requests, call// the "close" method on the client to safely clean up any remaining background resources.try(DlpServiceClientdlp=DlpServiceClient.create()){// Specify what content you want the service to de-identify.ContentItemcontentItem=ContentItem.newBuilder().setTable(tableToDeIdentify).build();// Specify how the content should be de-identified.CharacterMaskConfigcharacterMaskConfig=CharacterMaskConfig.newBuilder().setMaskingCharacter("*").build();PrimitiveTransformationprimitiveTransformation=PrimitiveTransformation.newBuilder().setCharacterMaskConfig(characterMaskConfig).build();// Specify field to be de-identified.FieldIdfieldId=FieldId.newBuilder().setName("HAPPINESS SCORE").build();// Specify when the above field should be de-identified.Conditioncondition=Condition.newBuilder().setField(FieldId.newBuilder().setName("AGE").build()).setOperator(RelationalOperator.GREATER_THAN).setValue(Value.newBuilder().setIntegerValue(89).build()).build();// Apply the condition to recordsRecordConditionrecordCondition=RecordCondition.newBuilder().setExpressions(Expressions.newBuilder().setConditions(Conditions.newBuilder().addConditions(condition).build()).build()).build();// Associate the de-identification and conditions with the specified field.FieldTransformationfieldTransformation=FieldTransformation.newBuilder().setPrimitiveTransformation(primitiveTransformation).addFields(fieldId).setCondition(recordCondition).build();RecordTransformationstransformations=RecordTransformations.newBuilder().addFieldTransformations(fieldTransformation).build();DeidentifyConfigdeidentifyConfig=DeidentifyConfig.newBuilder().setRecordTransformations(transformations).build();// Combine configurations into a request for the service.DeidentifyContentRequestrequest=DeidentifyContentRequest.newBuilder().setParent(LocationName.of(projectId,"global").toString()).setItem(contentItem).setDeidentifyConfig(deidentifyConfig).build();// Send the request and receive response from the service.DeidentifyContentResponseresponse=dlp.deidentifyContent(request);// Print the results.System.out.println("Table after de-identification: "+response.getItem().getTable());returnresponse.getItem().getTable();}}}

// Imports the Google Cloud Data Loss Prevention libraryconstDLP=require('@google-cloud/dlp');// Initialize google DLP Clientconstdlp=newDLP.DlpServiceClient();// The project ID to run the API call under// const projectId = 'my-project';// Construct the tabular dataconsttablularData={headers:[{name:'AGE'},{name:'PATIENT'},{name:'HAPPINESS SCORE'}],rows:[{values:[{integerValue:101},{stringValue:'Charles Dickens'},{integerValue:95},],},{values:[{integerValue:22},{stringValue:'Jane Austen'},{integerValue:21},],},{values:[{integerValue:55},{stringValue:'Mark Twain'},{integerValue:75},],},],};asyncfunctiondeIdentifyTableConditionalCharMasking(){// Column that needs to be transformedconstfieldIds=[{name:'HAPPINESS SCORE'}];// Construct PrimitiveTransformation configurationconstprimitiveTransformation={characterMaskConfig:{maskingCharacter:'*',},};// Construct conditionconstcondition={expressions:{conditions:{conditions:[{field:{name:'AGE'},operator:'GREATER_THAN',value:{integerValue:89},},],},},};// Construct RecordTransformations configurationsconstrecordTransformations={fieldTransformations:[{primitiveTransformation,fields:fieldIds,condition,},],};// Combine configurations into a request for the service.constrequest={parent:`projects/${projectId}/locations/global`,item:{table:tablularData,},deidentifyConfig:{recordTransformations,},};// Send the request and receive response from the serviceconst[response]=awaitdlp.deidentifyContent(request);// Print the resultsconsole.log(`Table after de-identification:${JSON.stringify(response.item.table)}`);}deIdentifyTableConditionalCharMasking();

use Google\Cloud\Dlp\V2\CharacterMaskConfig;use Google\Cloud\Dlp\V2\Client\DlpServiceClient;use Google\Cloud\Dlp\V2\ContentItem;use Google\Cloud\Dlp\V2\DeidentifyConfig;use Google\Cloud\Dlp\V2\DeidentifyContentRequest;use Google\Cloud\Dlp\V2\FieldId;use Google\Cloud\Dlp\V2\FieldTransformation;use Google\Cloud\Dlp\V2\PrimitiveTransformation;use Google\Cloud\Dlp\V2\RecordCondition;use Google\Cloud\Dlp\V2\RecordCondition\Condition;use Google\Cloud\Dlp\V2\RecordCondition\Conditions;use Google\Cloud\Dlp\V2\RecordCondition\Expressions;use Google\Cloud\Dlp\V2\RecordTransformations;use Google\Cloud\Dlp\V2\RelationalOperator;use Google\Cloud\Dlp\V2\Table;use Google\Cloud\Dlp\V2\Table\Row;use Google\Cloud\Dlp\V2\Value;/** * De-identify table data using masking and conditional logic. * Transform a column based on the value of another column. * * @param string $callingProjectId      The Google Cloud project id to use as a parent resource. * @param string $inputCsvFile          The input file(csv) path  to deidentify * @param string $outputCsvFile         The oupt file path to save deidentify content */function deidentify_table_condition_masking(    // TODO(developer): Replace sample parameters before running the code.    string $callingProjectId,    string $inputCsvFile = './test/data/table2.csv',    string $outputCsvFile = './test/data/deidentify_table_condition_masking_output.csv'): void {    // Instantiate a client.    $dlp = new DlpServiceClient();    $parent = "projects/$callingProjectId/locations/global";    // Read a CSV file    $csvLines = file($inputCsvFile, FILE_IGNORE_NEW_LINES);    $csvHeaders = explode(',', $csvLines[0]);    $csvRows = array_slice($csvLines, 1);    // Convert CSV file into protobuf objects    $tableHeaders = array_map(function ($csvHeader) {        return (new FieldId)            ->setName($csvHeader);    }, $csvHeaders);    $tableRows = array_map(function ($csvRow) {        $rowValues = array_map(function ($csvValue) {            return (new Value())                ->setStringValue($csvValue);        }, explode(',', $csvRow));        return (new Row())            ->setValues($rowValues);    }, $csvRows);    // Construct the table object    $tableToDeIdentify = (new Table())        ->setHeaders($tableHeaders)        ->setRows($tableRows);    // Specify what content you want the service to de-identify.    $content = (new ContentItem())        ->setTable($tableToDeIdentify);    // Specify how the content should be de-identified.    $characterMaskConfig = (new CharacterMaskConfig())        ->setMaskingCharacter('*');    $primitiveTransformation = (new PrimitiveTransformation())        ->setCharacterMaskConfig($characterMaskConfig);    // Specify field to be de-identified.    $fieldId = (new FieldId())        ->setName('HAPPINESS_SCORE');    // Specify when the above fields should be de-identified.    $condition = (new Condition())        ->setField((new FieldId())            ->setName('AGE'))        ->setOperator(RelationalOperator::GREATER_THAN)        ->setValue((new Value())            ->setIntegerValue(89));    // Apply the condition to records    $recordCondition = (new RecordCondition())        ->setExpressions((new Expressions())                ->setConditions((new Conditions())                        ->setConditions([$condition])                )        );    // Associate the de-identification and conditions with the specified fields.    $fieldTransformation = (new FieldTransformation())        ->setPrimitiveTransformation($primitiveTransformation)        ->setFields([$fieldId])        ->setCondition($recordCondition);    $recordtransformations = (new RecordTransformations())        ->setFieldTransformations([$fieldTransformation]);    $deidentifyConfig = (new DeidentifyConfig())        ->setRecordTransformations($recordtransformations);    // Run request    $deidentifyContentRequest = (new DeidentifyContentRequest())        ->setParent($parent)        ->setDeidentifyConfig($deidentifyConfig)        ->setItem($content);    $response = $dlp->deidentifyContent($deidentifyContentRequest);    // Print results    $csvRef = fopen($outputCsvFile, 'w');    fputcsv($csvRef, $csvHeaders);    foreach ($response->getItem()->getTable()->getRows() as $tableRow) {        $values = array_map(function ($tableValue) {            return $tableValue->getStringValue();        }, iterator_to_array($tableRow->getValues()));        fputcsv($csvRef, $values);    };    printf('After de-identify the table data (Output File Location): %s', $outputCsvFile);}

fromtypingimportDict,List,Unionimportgoogle.cloud.dlpfromgoogle.cloud.dlp_v2importtypesdefdeidentify_table_condition_masking(project:str,table_data:Dict[str,Union[List[str],List[List[str]]]],deid_content_list:List[str],condition_field:str=None,condition_operator:str=None,condition_value:int=None,masking_character:str=None,)->types.dlp.Table:""" Uses the Data Loss Prevention API to de-identify sensitive data in a      table by masking them based on a condition.    Args:        project: The Google Cloud project id to use as a parent resource.        table_data: Json string representing table data.        deid_content_list: A list of fields in table to de-identify.        condition_field: A table Field within the record this condition is evaluated against.        condition_operator: Operator used to compare the field or infoType to the value. One of:            RELATIONAL_OPERATOR_UNSPECIFIED, EQUAL_TO, NOT_EQUAL_TO, GREATER_THAN, LESS_THAN, GREATER_THAN_OR_EQUALS,            LESS_THAN_OR_EQUALS, EXISTS.        condition_value: Value to compare against. [Mandatory, except for ``EXISTS`` tests.].        masking_character: The character to mask matching sensitive data with.    Returns:        De-identified table is returned;        the response from the API is also printed to the terminal.    Example:    >> $ python deidentify_table_condition_masking.py \    '{"header": ["email", "phone number", "age", "happiness_score"],    "rows": [["robertfrost@example.com", "4232342345", "35", "21"],    ["johndoe@example.com", "4253458383", "64", "34"]]}' \    ["happiness_score"] "age" "GREATER_THAN" 50    >> '{"header": ["email", "phone number", "age", "happiness_score"],        "rows": [["robertfrost@example.com", "4232342345", "35", "21"],        ["johndoe@example.com", "4253458383", "64", "**"]]}'    """# Instantiate a client.dlp=google.cloud.dlp_v2.DlpServiceClient()# Construct the `table`. For more details on the table schema, please see# https://cloud.google.com/dlp/docs/reference/rest/v2/ContentItem#Tableheaders=[{"name":val}forvalintable_data["header"]]rows=[]forrowintable_data["rows"]:rows.append({"values":[{"string_value":cell_val}forcell_valinrow]})table={"headers":headers,"rows":rows}# Construct the `item`item={"table":table}# Specify fields to be de-identifieddeid_content_list=[{"name":_i}for_iindeid_content_list]# Construct condition listcondition=[{"field":{"name":condition_field},"operator":condition_operator,"value":{"integer_value":condition_value},}]# Construct deidentify configuration dictionarydeidentify_config={"record_transformations":{"field_transformations":[{"primitive_transformation":{"character_mask_config":{"masking_character":masking_character}},"fields":deid_content_list,"condition":{"expressions":{"conditions":{"conditions":condition}}},}]}}# Convert the project id into a full resource id.parent=f"projects/{project}/locations/global"# Call the API.response=dlp.deidentify_content(request={"parent":parent,"deidentify_config":deidentify_config,"item":item})# Print the resultprint(f"Table after de-identification:{response.item.table}")# Return the responsereturnresponse.item.table

usingSystem;usingSystem.Collections.Generic;usingGoogle.Api.Gax.ResourceNames;usingGoogle.Cloud.Dlp.V2;publicclassDeidentifyTableWithInfoTypes{publicstaticTableDeidentifyTable(stringprojectId,TabletableToInspect=null,IEnumerable<InfoType>infoTypes=null){// Instantiate a client.vardlp=DlpServiceClient.Create();// Construct the table if null.if(tableToInspect==null){varrow1=newValue[]{newValue{StringValue="101"},newValue{StringValue="Charles Dickens"},newValue{StringValue="95"},newValue{StringValue="Charles Dickens name was a curse invented by Shakespeare."}};varrow2=newValue[]{newValue{StringValue="22"},newValue{StringValue="Jane Austin"},newValue{StringValue="21"},newValue{StringValue="There are 14 kisses in Jane Austen's novels."}};varrow3=newValue[]{newValue{StringValue="55"},newValue{StringValue="Mark Twain"},newValue{StringValue="75"},newValue{StringValue="Mark Twain loved cats."}};tableToInspect=newTable{Headers={newFieldId{Name="AGE"},newFieldId{Name="PATIENT"},newFieldId{Name="HAPPINESS SCORE"},newFieldId{Name="FACTOID"}},Rows={newTable.Types.Row{Values={row1}},newTable.Types.Row{Values={row2}},newTable.Types.Row{Values={row3}}}};}// Construct the table content item.varcontentItem=newContentItem{Table=tableToInspect};// Construct Replace With InfoTypes config to replace the match.varreplaceInfoTypesConfig=newReplaceWithInfoTypeConfig();// Construct Fields to be de-identified.varfieldIds=newFieldId[]{newFieldId{Name="PATIENT"},newFieldId{Name="FACTOID"}};// Construct InfoType Transformation.varinfoTypeTransformations=newInfoTypeTransformations{Transformations={newInfoTypeTransformations.Types.InfoTypeTransformation{PrimitiveTransformation=newPrimitiveTransformation{ReplaceWithInfoTypeConfig=replaceInfoTypesConfig},InfoTypes={infoTypes??newInfoType[]{newInfoType{Name="PERSON_NAME"}}}}}};// Construct the de-identify config using replace config.vardeidentifyConfig=newDeidentifyConfig{RecordTransformations=newRecordTransformations{FieldTransformations={newFieldTransformation{InfoTypeTransformations=infoTypeTransformations,Fields={fieldIds}}}}};// Construct the request.varrequest=newDeidentifyContentRequest{ParentAsLocationName=newLocationName(projectId,"global"),DeidentifyConfig=deidentifyConfig,Item=contentItem};// Call the API.varresponse=dlp.DeidentifyContent(request);// Inspect the response.Console.WriteLine(response.Item.Table);returnresponse.Item.Table;}}

import("context""fmt""io"dlp"cloud.google.com/go/dlp/apiv2""cloud.google.com/go/dlp/apiv2/dlppb")// deidentifyTableInfotypes de-identifies table data with info typesfuncdeidentifyTableInfotypes(wio.Writer,projectIDstring)error{// projectId := "your-project-id"row1:=&dlppb.Table_Row{Values:[]*dlppb.Value{{Type:&dlppb.Value_StringValue{StringValue:"22"}},{Type:&dlppb.Value_StringValue{StringValue:"Jane Austen"}},{Type:&dlppb.Value_StringValue{StringValue:"21"}},{Type:&dlppb.Value_StringValue{StringValue:"There are 14 kisses in Jane Austen's novels."}},},}row2:=&dlppb.Table_Row{Values:[]*dlppb.Value{{Type:&dlppb.Value_StringValue{StringValue:"55"}},{Type:&dlppb.Value_StringValue{StringValue:"Mark Twain"}},{Type:&dlppb.Value_StringValue{StringValue:"75"}},{Type:&dlppb.Value_StringValue{StringValue:"Mark Twain loved cats."}},},}row3:=&dlppb.Table_Row{Values:[]*dlppb.Value{{Type:&dlppb.Value_StringValue{StringValue:"101"}},{Type:&dlppb.Value_StringValue{StringValue:"Charles Dickens"}},{Type:&dlppb.Value_StringValue{StringValue:"95"}},{Type:&dlppb.Value_StringValue{StringValue:"Charles Dickens name was a curse invented by Shakespeare."}},},}table:=&dlppb.Table{Headers:[]*dlppb.FieldId{{Name:"AGE"},{Name:"PATIENT"},{Name:"HAPPINESS SCORE"},{Name:"FACTOID"},},Rows:[]*dlppb.Table_Row{{Values:row1.Values},{Values:row2.Values},{Values:row3.Values},},}ctx:=context.Background()// Initialize a client once and reuse it to send multiple requests. Clients// are safe to use across goroutines. When the client is no longer needed,// call the Close method to cleanup its resources.client,err:=dlp.NewRESTClient(ctx)iferr!=nil{returnerr}// Closing the client safely cleans up background resources.deferclient.Close()// Specify what content you want the service to de-identify.contentItem:=&dlppb.ContentItem{DataItem:&dlppb.ContentItem_Table{Table:table,},}// Specify how the content should be de-identified.// Select type of info to be replaced.infoTypes:=[]*dlppb.InfoType{{Name:"PERSON_NAME"},}// Specify that findings should be replaced with corresponding info type name.replaceWithInfoTypeConfig:=&dlppb.ReplaceWithInfoTypeConfig{}primitiveTransformation:=&dlppb.PrimitiveTransformation{Transformation:&dlppb.PrimitiveTransformation_ReplaceWithInfoTypeConfig{ReplaceWithInfoTypeConfig:replaceWithInfoTypeConfig,},}// Associate info type with the replacement strategyinfoTypeTransformations:=&dlppb.InfoTypeTransformations{Transformations:[]*dlppb.InfoTypeTransformations_InfoTypeTransformation{{InfoTypes:infoTypes,PrimitiveTransformation:primitiveTransformation,},},}// Specify fields to be de-identified.fields:=[]*dlppb.FieldId{{Name:"PATIENT"},{Name:"FACTOID"},}// Associate the de-identification and conditions with the specified field.fieldTransformation:=&dlppb.FieldTransformation{Fields:fields,Transformation:&dlppb.FieldTransformation_InfoTypeTransformations{InfoTypeTransformations:infoTypeTransformations,},}recordTransformations:=&dlppb.RecordTransformations{FieldTransformations:[]*dlppb.FieldTransformation{fieldTransformation,},}// Construct the de-identification request to be sent by the client.req:=&dlppb.DeidentifyContentRequest{Parent:fmt.Sprintf("projects/%s/locations/global",projectID),DeidentifyConfig:&dlppb.DeidentifyConfig{Transformation:&dlppb.DeidentifyConfig_RecordTransformations{RecordTransformations:recordTransformations,},},Item:contentItem,}// Send the request.resp,err:=client.DeidentifyContent(ctx,req)iferr!=nil{returnerr}// Print the results.fmt.Fprintf(w,"Table after de-identification : %v",resp.GetItem().GetTable())returnnil}