擅长:python、mysql、java
<pre><code> import pandas as pd
# Reading file, 'r' -> read
file = open('data.txt', 'r')
lines = file.readlines()
# Fict where info will be stored
main_dict = {}
for line in lines:
# Getting the list of values in the line
# values -> [key1, key2, group, v1, v2, v3, v4]
# indexs -> 0 1 2 3 4 5 6
values = line.split('|')
#creating combo_key
combo_key = str(values[0])+"_"+str(values[1])
#tests if key already exists
#if not, creats a new dict into it
if combo_key not in main_dict.keys():
main_dict[combo_key] = {} #adding new dict to dict key
main_dict[combo_key][str(values[2])] = [values[3], values[4]]
data = []
for key in main_dict.keys():
data.append([key, str(main_dict[key])])
df = pd.DataFrame(data, columns = ['ComboKey1', "new_v1"])
print(df)
</code></pre>
<p>那就把这条命令分类吧(:</p>