cancel
Showing results for 
Search instead for 
Did you mean: 

Identifying Patterns

Highlighted
NiCd Battery
How do I find out if a dataset with telephone numbers have different area codes but have the same phone number?
For example, "+1 415 123 12 12" vs "+90 415 123 12 12". 
Labels (1)
0 Kudos
2 Replies
DC Motor

Hello Eren,

The solution to your problem is as follows:

Step 1: Start the project with the Phone number datasetImage: https://us.v-cdn.net/6030933/uploads/editor/a6/c99e9ir2brot.png

 Now there are two ways to go about this:

In order to check if a Phone number has more than own country code associated with this.

Step 2:  Use the shape function on Paxata to perform a deduplicate and a group by operation.

Step 2.1: Perform a deduplicate on Country code, Phone number to get rid of any repeated occurrence of a Country code, phone number pair.Image: https://us.v-cdn.net/6030933/uploads/editor/1n/n07s674um5ft.png

Step 2.2: Do a group by on Phone number and do a count on country code.

Image: https://us.v-cdn.net/6030933/uploads/editor/2k/fve9vwfclqqw.png

Step 3: Use an if statement via the compute feature we can check if a duplicate exists on this column.

Image: https://us.v-cdn.net/6030933/uploads/editor/k5/9wysbbvog9n8.png

I hope this answers your question!

Thanks,

Akshay

 


0 Kudos
Highlighted
NiCd Battery
Thank you so much Akshay!
0 Kudos