将python字符串转换为bankstatemen的json

Question

这是我的意见

string = '07/08/2018 07/08/2018 IMPS DR-1763308000000116-PYTM0123456-917 592674 5,000.00 39,325.93'

我需要像这样的输出

{'date1':'07/08/2018','date2':'07/08/2018','remark':'IMPS DR-1763308000000116-PYTM0123456-917 592674','credit':'5,000.00','balance' : '39,325.93' }

我试过了

result = { 'date1': list1[0], 'date2': list1[1], 'balance': list1[-1]}
print(result)

输出

{'date1': '07/08/2018', 'date2': '07/08/2018', 'balance': '39,325.93'}

Answer 1

这里有一个简单的解决方案-

 string = '07/08/2018 07/08/2018 IMPS DR-1763308000000116-PYTM0123456-917 592674 5,000.00 39,325.93'

 l = string.split()

 result = {'date1': l[0],
           'date2': l[1],
           'remark': ' '.join((l[2],l[3])),
           'credit': l[4],
           'balance': l[5]}

输出

 {'date1': '07/08/2018', 'date2': '07/08/2018', 'remark': 'IMPS DR-1763308000000116-PYTM0123456-917', 'credit': '592674', 'balance':'5,000.00'}

Answer 2

您可以使用split来拆分字符串，并像Scott提到的那样使用它们，但前提是您可以将它以这种格式表示为字符串

str = '{'date1':'07/08/2018','date2':'07/08/2018','remark':'IMPS DR-1763308000000116-PYTM0123456-917 592674','credit':'5,000.00','balance' : '39,325.93' }'

#then you can just import json and do 

json = json.loads(str)

Answer 3

试试这个：

words = string.split(" ")
values = words[:2] + [" ".join(words[2:-2])] +  words[-2:]
keys = ["date1", "date2", "remark", "credit", "balance"]
result = {}
for i in range(5):
    result[keys[i]] = values[i]

print(result)

输出：

{'date1': '07/08/2018',
 'date2': '07/08/2018',
 'remark': 'IMPS DR-1763308000000116-PYTM0123456-917 592674',
 'credit': '5,000.00',
 'balance': '39,325.93'}