How to update a string with specific format using a dictionary with python

Question

I have a large dictionary with time format values. the example of the dictionary is "mydict". each list([[]]) shows times of a week. Each times of a day divided with ','. For example saturday times are 06:00 - 09:30 AM - 10:30 AM - 14:00 - 17:00 - 21:00. and Sunday times are 07:00 - 09:30 AM - 11:30 AM - 14:00 - 16:00 - 21:00 in the dictionary. The dictionary involves times of 7 days and thousands key/values.

I also have a string with a specific format for 7 days. I simplified the string to 2 days. I want to replace "dayname", "endTime" and "startTime" values of the string with the nested list of the dictionary then write it in dictionary format. My ideal result is shown below.

How can i solve the issues?

mydict= {'x': [['06:00 - 09:30 AM - 10:30 AM - 14:00 - 17:00 - 21:00, 07:00 - 09:30 AM - 11:30 AM - 14:00 - 16:00 - 21:00']]}

Expected Output:

{'x': [{
    "DayName": "saturday",
    "timeList": [
        {
            
            "endTime": "06:00", 
            "startTime": "09:30"
        },
        {
            
            "endTime": "10:30", 
            "startTime": "14:00"
        },
        {
            
            "endTime": "17:00", 
            "startTime": "21:00"
        }
    ]
},

{
    "DayName": "sunday",
    "timeList": [
        {
           
            "endTime": "07:00",
            "startTime": "09:30"
        },
        {
           
            "endTime": "11:30",
            "startTime": "14:00"
        },
        {
           
            "endTime": "16:00",
            "startTime": "21:00"
        }
    ]
}]}

the dictionary you posted is incomplete post the valid input — deadshot
– deadshot, Commented Aug 6, 2020 at 8:45
mydict is not a valid python dictionary did you posted the correct dictionary — deadshot
– deadshot, Commented Aug 6, 2020 at 8:48
mydict= {'x': [['06:00 - 09:30 AM - 10:30 AM - 14:00 - 17:00 - 21:00', '07:00 - 09:30 AM - 11:30 AM - 14:00 - 16:00 - 21:00']]} is this correct? comma inside the quotes? — deadshot
– deadshot, Commented Aug 6, 2020 at 9:02

deadshot · Accepted Answer · 2020-08-06 09:24:01Z

1

Try this:

mydict = {'x': [['06:00 - 09:30 - 10:30 - 14:00 - 17:00 - 21:00', '07:00 - 09:30 - 11:30 - 14:00 - 16:00 - 21:00']]}
k = ('endTime', 'startTime')
weeks = ['saturday', 'sunday']

dd = [[dict(zip(k, y)) for y in (z for z in zip(x.split(' - ')[::2], x.split(' - ')[1::2]))] for x in mydict['x'][0]]
res = {'x': [{'DayName': x, 'timeList': y} for x, y in zip(weeks, dd)]}

print(res)

Output:

{'x': [{'DayName': 'saturday',
        'timeList': [{'endTime': '06:00', 'startTime': '09:30'},
                     {'endTime': '10:30', 'startTime': '14:00'},
                     {'endTime': '17:00', 'startTime': '21:00'}]},
       {'DayName': 'sunday',
        'timeList': [{'endTime': '07:00', 'startTime': '09:30'},
                     {'endTime': '11:30', 'startTime': '14:00'},
                     {'endTime': '16:00', 'startTime': '21:00'}]}]}

answered Aug 6, 2020 at 9:24

deadshot

9,0774 gold badges24 silver badges40 bronze badges

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

5 Comments

BBG Over a year ago

Thanks for your answer. I have another question. some lists have different times. In question example i have 3 times per days but some days have 2 or 4 times for each day.

deadshot Over a year ago

It will work for any number. as long as each endTime has startTime

BBG Over a year ago

Why the result is wrong for this dictionary with your code? mydict = {'x': [['15:00 - 19:00, 00:00 - 23:59, 11:00 - 19:00, 09:00 - 20:00, 11:00 - 19:00, 10:00 - 14:00, 00:00 - 23:59']]}

deadshot Over a year ago

you have posted input like this in question mydict = {'x': [['06:00 - 09:30 - 10:30 - 14:00 - 17:00 - 21:00', '07:00 - 09:30 - 11:30 - 14:00 - 16:00 - 21:00']]} how it will work for that input? please maintain the consistency with the input? if you give input in wrong format how it will work?

BBG Over a year ago

Is that a solution for 4 or 8 times for each day?

Detlef · Accepted Answer · 2020-08-06 09:30:43Z

This is a simple approach that I don't know if it meets your requirements.

import json

x_data = json.loads(idealresult['x'])
days = []
for item in x_data:
    days.append('-'.join([f"{tm['startTime']} - {tm['endTime']}" for tm in item['timeList']]))

idealresult['x'] = json.dumps(days)

I got lost in the direction.

mydict= {'x': [['06:00 - 09:30 AM - 10:30 AM - 14:00 - 17:00 - 21:00, 07:00 - 09:30 AM - 11:30 AM - 14:00 - 16:00 - 21:00']]}
days = ['saturday', 'sunday']
x_data = mydict['x'][0][0]
results = []
for i,item in enumerate(x_data.split(', ')):
    tmp = item.split(' - ')
    results.append(
        {
            'DayName': days[i % 2], 
            'timeList': [f'{tmp[i]} - {tmp[i+1]}' for i in range(0, len(tmp), 2)]
        }
    )

idealresult = dict(x=json.dumps(results))

Collectives™ on Stack Overflow

How to update a string with specific format using a dictionary with python

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related