Python 菜鸡请教

[wsds]

有这么一堆数据：

#test.log
a, 1.324171
b, 0.000126
c, 1.970941
a, 1.469649
b, 0.000124
c, 0.512929
a, 1.290920
b, 0.000118
c, 0.259524
a, 0.495958
b, 0.000123
c, 0.910949
a, 1.268038
b, 0.000118
c, 1.016419
a, 1.856081
b, 0.000120
c, 1.400075
a, 1.314131
b, 0.000140

想要用 python 把左边的 key 一样的合并，但 value 要取它所有的和，还有平均值

搞了半天，发现搞不定，也是尴尬,以下还是个半成品，搞不下去了，报错，求大神指点一些简单方法

def two(file):

	arr = []
	with open(file, "r", encoding="utf-8") as f:
		for i in f.readlines():
			a = i.replace("\n", '').strip()
			if a.split(",")[0] not in arr:
				arr.append(a.split(",")[0])
	ser = -1
	while True:
		ser += 1
		try:
			if a.split(",")[ser] == arr[ser]:
				print(a.split(",")[ser])
		except IndexError:
			print("end!")
			break


two("test.log")

[linxzh1989]

pandas groupby sum?

[aborigine]

了解一下 pandas ？导入生成个 dataframe 就行了

[wsds]

@aborigine 要用纯 python 处理，该怎么弄？

[wsds]

@aborigine 我的意思是，不要用这种一步到位的库

[deepreader]

Dictionary 会用么？

[wsds]

@deepreader 抱歉，字典我知道，但以我的水平真心实现不了

[mentalkiller]

@wsds #6 dict 是 python 内置的数据结构啊，不需要你自己实现

[wsds]

@mentalkiller 我的意思不是实现字典的功能，我的意思是用字典，我实现不了我的需求

[hahastudio]

https://gist.github.com/hahastudio/d096995dc535abcad6046d79e238add4

[lixm]

就这需求还要上 pandas ？

https://gist.github.com/comynli/233412cd89bf671d7f9d754a3137be4f

[ybping]

dict 了解一下

[scriptB0y]

In [18]: data = """
...: a, 1.324171
...: b, 0.000126
...: c, 1.970941
...: a, 1.469649
...: b, 0.000124
...: c, 0.512929
...: a, 1.290920
...: b, 0.000118
...: c, 0.259524
...: a, 0.495958
...: b, 0.000123
...: c, 0.910949
...: a, 1.268038
...: b, 0.000118
...: c, 1.016419
...: a, 1.856081
...: b, 0.000120
...: c, 1.400075
...: a, 1.314131
...: b, 0.000140
...: """

In [19]: result = {}
...: for line in data.splitlines():
...: if not line: continue
...: key, value = line.split(",")
...: result.setdefault(key, []).append(float(value))
...:

In [20]: for key, values in result.items():
...: print(f"{key}: avg: {sum(values) / len(values)}, sum: {sum(values)}")
...:
a: avg: 1.2884211428571428, sum: 9.018948
b: avg: 0.00012414285714285714, sum: 0.000869
c: avg: 1.0118061666666667, sum: 6.070837

https://gist.github.com/laixintao/f4a186cea6c28fcf3dc696100458c410

[wsds]

@hahastudio
@lixm
@scriptB0y
非常感谢各位！学习了

[wplct]

def two(file):
data = {}
with open(file, "r") as f:
while True:
s = f.readline()
if s is None or not s:
break
print(s.split(', '))
k, v = s.split(', ')
v = float(v)
if k not in data:
data[k] = {
'num': 1,
'sum': v,
'avg': v
}
else:
data[k]['num'] += 1
data[k]['sum'] += v
data[k]['avg'] = data[k]['sum'] / data[k]['num']
print(data)
two('test.txt')

[wsds]

@wplct 感谢

[araraloren]

一行脚本拯救你

perl -nE 'state %z; my @z = split(", "); $z{@z[0]} += @z[1]; END { say for %z; } ' < test.log
a
9.018948
b
0.000869
c
6.070837

perl6 -ne 'state %z; given .split(", ") { %z{.[0]} += .[1].Rat; }; END { say %z; }' < test.log
{a => 9.018948, b => 0.000869, c => 6.070837}

[bufpay]

其实一个 for 循环就可以了

[E1n]

@araraloren perl 好用，用 awk 能实现吗。。

[araraloren]

@E1n awk 肯定能实现，不过我只懂基本的 awk 脚本

[imagechans]

def stand(file):
datas = [str(line).replace("\n","").strip().split(',')[1] for line in open(file)]
s = sum([float(d) for d in datas])
m = s / len(datas)
print(s,m)


stand("test.log")