Converts Adobe Bridge CSV into NiftyKit's metadata JSON

convert.py

import csv
import json
import re

data = []
result = []

def extract_attrs(kwds_list):
    kwds = kwds_list.split(';')
    attrs = []
    for kwd in kwds:
        # split kwd by '_', '-', ' '
        lst = re.split('[_ -]', kwd)
        attrs.append({
            'trait_type': lst[0],
            'value': ' '.join(lst[1:]),
        })
    return attrs

def main():
    with open('original.csv', 'r') as csvfile:
        reader = csv.DictReader(csvfile)
        for row in reader:
            data.append(row)

    for d in data:
        name = d['FileName'].split('.')[0]
        result.append({
            'name': name,
            'description': name,
            'image': 'ipfs://your-cid/' + d['FileName'],
            'attributes': extract_attrs(d['Keywords']),
            'animation_url': '',
            'background_color': '',
            'youtube_url': '',
            'external_url': ''
        })

    with open('metadata.json', 'w') as f:
        json.dump(result, f, indent=2)

if __name__ == '__main__':
    main()