How to convert dot separated string into yaml format using python script

Question

I am having a file having some properties myprop.properties

a.b.c.d : '0'
a.b.c.e : 'hello'
a.b.c.f : 'hello1'
a.b.g.h : '123'
a.b.g.i : '4567'
http_port : false
install_java : true

I want to dump this file into yaml format, so the expected output should be:

a:
 b:
  c:
  - d: '0'
    e: hello
    f: hello1
  g:
  - h: '123'
    i: '4567'
http_port : false
install_java : true

Does this answer your question? Convert dot notation keys to tree-structured YAML in Ruby — Rahul Bharadwaj
– Rahul Bharadwaj, Commented Jan 6, 2020 at 13:40
that might help you, and also check out this for a more refined version. — FObersteiner
– FObersteiner, Commented Jan 6, 2020 at 14:24
How do you know that there has to be a sequence between the key c and the key d and not between the key b and c? It would be kind of obvious if your input was a.b.c.0.d, a.b.c.0.e, etc. but it isn't. — Anthon
– Anthon, Commented Jan 6, 2020 at 16:35

FObersteiner · Accepted Answer · 2020-01-07 19:28:21Z

5

using this nice recursive function, you could convert your dotmap string to a dict and then do a yaml.dump:

def add_branch(tree, vector, value):
    key = vector[0]
    if len(vector) == 1:
        tree[key] = value  
    else: 
        tree[key] = add_branch(tree[key] if key in tree else {}, vector[1:], value)
    return tree

dotmap_string = """a.b.c.d : '0'
a.b.c.e : 'hello'
a.b.c.f : 'hello1'
a.b.g.h : '123'
a.b.g.i : '4567'
http_port : false
install_java : true"""

# create a dict from the dotmap string:
d = {}
for substring in dotmap_string.split('\n'):
    kv = substring.split(' : ')
    d = add_branch(d, kv[0].split('.'), kv[1])

# now convert the dict to YAML:
import yaml    
print(yaml.dump(d))  
# a:
#   b:
#     c:
#       d: '''0'''
#       e: '''hello'''
#       f: '''hello1'''
#     g:
#       h: '''123'''
#       i: '''4567'''
# http_port: 'false'
# install_java: 'true'

answered Jan 7, 2020 at 19:28

FObersteiner

26.1k9 gold badges60 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

FObersteiner Over a year ago

@MM I've seen your edit suggestion: it seems like a substantial change to me, so maybe you want to add this as a separate answer? I don't want to take credit for your work here, so I rejected the edit suggestion.

Collectives™ on Stack Overflow

How to convert dot separated string into yaml format using python script

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related