# !/root/venv/bin/python -m pip install --upgrade pip
# !pip install urllib3
# Load Library
import json
import pandas as pd
# JSON file
f = open ('/work/Dataset/data.json', "r")
# Reading from file
data = json.loads(f.read())
# Iterating through the json
# list
data['data']['dosen']
# Closing file
f.close
# convert json to dataframe
df = pd.DataFrame(data['data']['dosen'])
df.head()
df.isnull().any()
df.isnull().sum()
# Helper Dictionary
dictionary = {
'name' : ['Ike','Togu','Tiurma','Monalisa','Goklas'],
'nidn' : ['','','','','','']
}
for value in dictionary['name']:
print(value)
print(dictionary.items())
print(dictionary['name'][0])
Ike
Togu
Tiurma
Monalisa
Goklas
dict_items([('name', ['Ike', 'Togu', 'Tiurma', 'Monalisa', 'Goklas']), ('nidn', ['', '', '', '', '', ''])])
Ike
# Declare function
def checkEmail1(pegawaiId):
print(df['pegawaiId'] == pegawaiId)
def checkEmail2(name='',nidn=''):
if(len(name) + len(nidn) >= 3):
print(pd.DataFrame(df.loc[(df['nama'].str.contains(name)) & (df['nidn'].str.contains(nidn)),['nama','email'] ]))
def checkEmailWithDict(data):
for i in range(len(data['name'])):
if(len(data['name'][i]) + len(data['nidn'][i]) >= 3):
print(pd.DataFrame(df.loc[(df['nama'].str.contains(data['name'][i])) & (df['nidn'].str.contains(data['nidn'][i])),['nama','email'] ]))
# Filter
df_email = df[['nama','email']]
df_email.head()
namaobject
emailobject
0
Tennov Simanjuntak, S.T, M.Sc
tennov@del.ac.id
1
Yaya Setiadi, S.Si., MT
yaya@del.ac.id, yaya.s@lycos.com
2
Candra Taufik
ctaufik@lycos.com, candra@del.ac.id
3
Musthofa Lutfi
mlutfi@del.ac.id, musthofal@yahoo.com
4
Kurnia Djaja
kurnia@del.ac.id, kurenia_djaja@msn.com
# Export
# df_email.to_csv("/work/Dataset/dosenMail.csv")
nama \
141 Goklas Henry Agus Panjaitan, S.Tr.Kom
email
141 goklas.panjaitan@del.ac.id;goklasif10029@gmail...
dictionary = {
'name' : ['Ike','Togu','Tiurma','Monalisa','Goklas'],
'nidn' : ['','','','','','']
}
checkEmailWithDict(dictionary)
nama email
96 Ike Fitriyaningsih, S.Si., M.Si -
nama email
102 Togu Novriansyah Turnip, S.S.T., M.IM -
nama email
114 Tiurma Lumban Gaol, SP., M.P tiur@del.ac.id, tiurlg@yahoo.com
nama email
120 Monalisa Pasaribu, SS., M.Ed (TESOL) -
nama \
141 Goklas Henry Agus Panjaitan, S.Tr.Kom
email
141 goklas.panjaitan@del.ac.id;goklasif10029@gmail...