#1.1st method: pd.read_json('url',encoding='utf-8')
import pandas as pd
df = pd.read_json("https://od.moi.gov.tw/od/data/api/EA28418E-8956-4790-BAF4-C2D3988266CC?$format=json",encoding="utf-8")
print(df.head(5))

#2.2nd method:urllib.request
import urllib.request as request
web = request.urlopen("https://od.moi.gov.tw/od/data/api/EA28418E-8956-4790-BAF4-C2D3988266CC?$format=json")
txt = web.read()
df2 = pd.read_json(txt)
print(df2.head(5))

#3.print out the unit name
print('unit name = ', df['unit'].head(5))
print('unit name = ', df['unit'][0:6])

#4.find the record of 金門，print out the address and tel
#search command = df[].str.contains('keyword')
#c1 = conditon 1
c1 = df['unit'].str.contains('金門')
print(df[c1])
print(df[['unit','address','telephon']][c1])