AP_BSSID.csv
變成以下json格式
{
"94:b4:0f:63:4a:e2" : {
"Block" : "A",
"Floor" : "3",
"AP name" : "AP254",
"Location" : "A0323-The Jockey Club Tech Lab",
"SSID" : "CSL",
"Band" : "2.4G"
},
...
}
import csv
import json
json_AP_BSSID = {}
with open('AP_BSSID.csv', newline='') as csvfile:
#讀取 CSV 檔內容,將每一列轉成一個dictionary
rows = csv.DictReader(csvfile)
for row in rows:
# 拎BSSID出黎,再remove
bssid = row.pop('BSSID')
json_AP_BSSID[bssid] = dict(row)
with open('AP_BSSID.json', 'w') as fp:
json.dump(json_AP_BSSID, fp)