擅长:python、mysql、java
<p>代码:</p>
<pre><code>raw_data = """001 Ram Sharma ram@gmail.com
002 Jai Kishor 9997125640
003 Ram Sharma ram@gmail.com
004 Krishna Gupta ksh@yahoo.com
005 Ram Sharma ram@gmail.com
006 Jai Kishor 1276594888
007 Ram Sharma ram-new@gmail.com"""
def normalize(data):
dataset = [(data.split()[0],' '.join(data.split()[1:3]),' '.join(data.split()[3:])) for data in raw_data.split('\n')]
tempdict = {}
for field in dataset:
if field[1] in tempdict:
if field[2] in tempdict[field[1]]:
continue
tempdict[field[1]] += (", " + field[2])
else:
tempdict[field[1]] = ' '.join(field)
return tempdict
if __name__ == '__main__':
new_data = normalize(data=raw_data)
for value in new_data.values():
print(value)
</code></pre>
<p>输出</p>
<pre><code>001 Ram Sharma ram@gmail.com, ram-new@gmail.com
002 Jai Kishor 9997125640, 1276594888
004 Krishna Gupta ksh@yahoo.com
</code></pre>