Python读取文件并求平均值

文件“test.txt”以CSV格式保存了一条数据信息，数据在文件中的内容如下：
北京,101.5,120.7,121.4,125.0,99.5
请编写Python程序实现读取文件内容，对该条数据（除第一项为名称外）求平均值，并显示出来

import pandas as pd 
import numpy as np

data = pd.DataFrame(data = np.array([101.5,120.7,121.4,125.0,99.5]), columns = ['北京'])
data.to_csv('test.csv', index = False)
data = pd.read_csv('test.csv')
print(data)
print(data['北京'].mean())

with open(filename) as f:
    con = f.readline().replace("\n", '')
    x = list(map(float,con.split(',')[1:]))
    print(round(sum(x) / len(x), 2))