You have been able to get a hold of the list of users affected and need to notify a credit card blocking service.

Example derived from: https://gist.github.com/jorin-vogel/2e43ffa981a97bc17259



In [2]:

    
ls *.json









    



 Volume in drive C is Windows
 Volume Serial Number is 6AD0-5968

 Directory of C:\Users\nafagg\Documents\GitHub\notebooks\Introductions

30/04/2015  07:26 PM         2,382,898 social.json
               1 File(s)      2,382,898 bytes
               0 Dir(s)  411,150,622,720 bytes free



In [3]:

    
import pandas as pd



In [4]:

    
dataset = pd.read_json("social.json")



In [5]:

    
dataset.columns









    Out[5]:





Index(['city', 'creditcard', 'email', 'mac', 'name', 'timestamp'], dtype='object')



In [6]:

    
dataset[['name', 'creditcard']].head()









    Out[6]:






  
    
      
      name
      creditcard
    
  
  
    
      0
                  Keeley Bosco
       1228-1221-1221-1431
    
    
      1
                   Rubye Jerde
       1228-1221-1221-1431
    
    
      2
       Miss Darian Breitenberg
                      None
    
    
      3
              Celine Ankunding
       1228-1221-1221-1431
    
    
      4
              Dr. Araceli Lang
       1211-1221-1234-2201



In [ ]:

	name	creditcard
0	Keeley Bosco	1228-1221-1221-1431
1	Rubye Jerde	1228-1221-1221-1431
2	Miss Darian Breitenberg	None
3	Celine Ankunding	1228-1221-1221-1431
4	Dr. Araceli Lang	1211-1221-1234-2201

A social network has been hacked!