In [8]:

    

import pandas as pd
import numpy as np


    

In [9]:

    

data = pd.read_json('all.json', orient='records')


    

In [10]:

    

data.head()


    

    
Out[10]:






  

    

      

      
address
      
category
      
email
      
name
      
phone
      
web
    
  
  

    

      
0
      
1 Margaret Street, SMITHTON TAS 7330
      
Long Day Care
      
director@chccc.com.au
      
Circular Head Child Care Centre
      
(03) 6452 2626
      
NaN
    
    

      
1
      
34 Wragg St, SOMERSET TAS 7322
      
Family Day Care
      
admin@coastalfdc.org
      
Coastal Family Day Care Scheme Inc
      
(03) 6435 3322
      
http://www.coastalfdc.org
    
    

      
2
      
422 Mengah Road, FOREST TAS 7330
      
After School Care
      
director@chccc.com.au
      
Forest After School Care
      
0429 936 239
      
NaN
    
    

      
3
      
19 Smith St, SMITHTON TAS 7330
      
Long Day Care
      
gigglesearlylearning@gmail.com
      
Giggles Early Learning
      
(03) 6452 1150
      
NaN
    
    

      
4
      
19 Smith St, SMITHTON TAS 7330
      
After School Care
      
gigglesearlylearning@gmail.com
      
Giggles Early Learning OSHC
      
0439 545 760
      
NaN
    
  

In [17]:

    

# total number of CC with an email address
len(data) - len(data[data.email.isnull()])


    

    
Out[17]:





219017