Is there any way to use python to output this string of data in the format I want?

Question

{Code...} I want to output the above string of data in the format of {Code...}. Is there any other way? I've been thinking about it for a long time and can't think of an effective way to do it.

伊谢尔伦 · Answer

# python2
# coding: utf8
a = [('2016-09', 20874.73, '李四'), ('2016-10', 64296.45, '李四'), ('2016-11', 58657.1, '李四'), ('2016-12', 51253.14, '李四'), ('2017-01', 57791.88, '李四'), ('2017-01', 46007.0, '张三'), ('2017-02', 67193.55, '李四'), ('2017-02', 38352.0, '张三'), ('2017-03', 83359.53, '李四'), ('2017-03', 49661.0, '张三'), ('2017-04', 39907.0, '张三')]
s = []
for i in a:
    for dict_tmp in s:
        if dict_tmp.get('name', '') == i[2]:
            dict_tmp['data'].append([i[0], i[1]])
            break
    else:
        s.append(
            {
                'name': i[2],
                'data':  [[i[0], i[1]]]
            }
        )
print s

为情所困 · Answer

from collections import defaultdict

d = defaultdict(list)

l_data = [('2016-09', 20874.73, '李四'), ('2016-10', 64296.45, '李四'), ('2016-11', 58657.1, '李四'), ('2016-12', 51253.14, '李四'), ('2017-01', 57791.88, '李四'), ('2017-01', 46007.0, '张三'), ('2017-02', 67193.55, '李四'), ('2017-02', 38352.0, '张三'), ('2017-03', 83359.53, '李四'), ('2017-03', 49661.0, '张三'), ('2017-04', 39907.0, '张三')]

for x in l_data:
    d[x[2]].append([x[0], x[1]])

result = [{'name': k, 'data': v} for k, v in d.iteritems()]

女神的闺蜜爱上我 · Answer

In this case, the pandas module should be used to make it more sustainable:

data_input = [('2016-09', 20874.73, '李四'), ('2016-10', 64296.45, '李四'), ('2016-11', 58657.1, '李四'), ('2016-12', 51253.14, '李四'), ('2017-01', 57791.88, '李四'), ('2017-01', 46007.0, '张三'), ('2017-02', 67193.55, '李四'), ('2017-02', 38352.0, '张三'), ('2017-03', 83359.53, '李四'), ('2017-03', 49661.0, '张三'), ('2017-04', 39907.0, '张三')]

import pandas as pd
df = pd.DataFrame(data_input)
df.columns = ['month','value','name']
d = df.set_index(['name'])
print ( set(d.index) )                           # {'张三', '李四'}
print ( list(d.loc['张三'].values.tolist()) )  # data變成list
print ( [{'data':list(d.loc[x].values.tolist()) , 'name': x} for x in set(d.index) ] )

The last line is the result you want. Basically, the index result of the third to last row is used as the basis for list derivation to produce the dictionary you want, which contains name and data, and data contains the data listed in the list

[{'data': [['2016-09', 20874.73],
   ['2016-10', 64296.45],
   ['2016-11', 58657.1],
   ['2016-12', 51253.14],
   ['2017-01', 57791.88],
   ['2017-02', 67193.55],
   ['2017-03', 83359.53]],
  'name': '李四'},
 {'data': [['2017-01', 46007.0],
   ['2017-02', 38352.0],
   ['2017-03', 49661.0],
   ['2017-04', 39907.0]],
  'name': '张三'}]

If you need more data processing, I really recommend learning the pandas module.