How to split a string in an array

Question

I need to split a string at a '.' and everything after is irrelevant I just need the first element at index[0].

I have tried using the .split('.')[0] in a for loop however, the output never changes.

The text.txt file looks like this [{"description":"large", "istrue":"yes","name":"george.doe.jane", "clear":"true", "money": 5000}] It has more than one object but they are all built the same.

output_file = open ('text.txt', 'r')
json_array = json.load(output_file)
json_list = []
for item in json_array:
    name = "name"
    money = "money"
    json_items = {name:None, money:None}
    json_items[name.split('.')[0]] = item[name.split('.')[0]]
    json_items[money] = item[money]
    json_list.append(json_items)

The output currently looks like {'name': 'george.doe.jane', 'money':5000} I would like it to look like {'name': 'george','doe','jane', 'money':5000}

The text.txt file looks like this [{'description':'large', 'istrue':'yes','name':'jane.doe', 'clear':'true', 'money': 5000}] It has more than one object but they are all built the same. — ubersuperuser
– ubersuperuser, Commented Jul 11, 2019 at 15:51
I'm sorry, new to python. Is an embedded dictionary the proper syntax? — ubersuperuser
– ubersuperuser, Commented Jul 11, 2019 at 16:07

Devesh Kumar Singh · Accepted Answer · 2019-07-11 16:30:40Z

1

You can use with context manager to open your file, and split the name on . to create the list of names

import json

#Open the file
with open ('text.txt', 'r') as output_file:

    #Load the json array
    json_array = json.load(output_file)

    #Iterate through the list and append the resultant dictionary to the list
    json_list = [{'name': item['name'].split('.'), 'money': item['money']} for item in json_array]

    print(json_list)

The output will be

[{'name': ['george', 'doe', 'jane'], 'money': 5000}]

answered Jul 11, 2019 at 16:30

Devesh Kumar Singh

20.5k5 gold badges25 silver badges43 bronze badges

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

Comments

ofthegoats · Accepted Answer · 2019-07-11 16:34:20Z

0

I think you're just using .split() wrong: fair enough. Here's an example of its usage:

s = 'h.e.l.l.o'
a = s.split('.')
# ['h', 'e', 'l', 'l', 'o']

So your for loop maybe should look a bit more like:

for i in json_array:
    json_list.append({'name': i['name'].split('.'), 'money': i['money']})

output should be

json_list = [{'name': ['george', 'doe', 'jane'], 'money': 5000}]

answered Jul 11, 2019 at 16:34

ofthegoats

2954 silver badges10 bronze badges

Collectives™ on Stack Overflow

How to split a string in an array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related