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