CSV To JSON

README.md

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)

empty.py

#Empty