python基于pandas求取行列的和与均值

import pandas as pd
# DateFrame中，index为行索引，columns为列索引
##解决列名输出不对称问题
pd.set_option('display.unicode.ambiguous_as_wide',True)
pd.set_option('display.unicode.east_asian_width', True)
s1 = 'H:pythonProjectCOD1.csv'
s2 = pd.read_csv(s1, index_col=0)
# 指定第一列为行索引
print(s2)
# 输出原始数据
###Series结构索引
print('******---'*10)
#计算行的和
s2['行的和'] = s2.sum(axis=1)
print(s2)
# 输出原始数据-行的和
print('******---'*10)
#计算列的和
s2.loc['列的和'] = s2.sum(axis=0)
print(s2)
# 输出原始数据-列的和
print('******---'*10)
##求取均值
s2['行的均值'] = s2.mean(axis=1)#axis=1表示求行的均值
print(s2)
# 输出原始数据-行的均值
print('******---'*10)
s2.loc['列的均值'] = s2.sum(axis=0)
print(s2)
# 输出原始数据-列的均值
print('******---'*10)

结果为

H:pythonProjectvenvScriptspython.exe H:/pythonProject/main.py
COD
b1
b2
b3
b4
b5
s1
6.246465
0.033064
0.044745
0.063753
0.046467
0.061651
s2
7.300000
0.032765
0.040027
0.060715
0.047964
0.062193
s3
7.151515
0.034787
0.044034
0.068569
0.047349
0.062583
s4
5.858586
0.038918
0.054270
0.070237
0.049240
0.063075
s5
7.458586
0.037524
0.047527
0.065471
0.046837
0.060580
s6
7.458586
0.044111
0.055397
0.075133
0.052282
0.067838
s7
7.022222
0.043152
0.056629
0.072561
0.052936
0.070106
s8
7.846465
0.044698
0.061596
0.073882
0.053898
0.073508
s9
10.561616
0.042522
0.060696
0.069076
0.051668
0.080740
s10
2.828283
0.048858
0.057816
0.077516
0.056419
0.081748
s11
8.492929
0.041209
0.058360
0.070019
0.053007
0.095129
s12
12.581818
0.046677
0.067138
0.071816
0.052377
0.082932
s11
8.492929
0.041209
0.058360
0.070019
0.053007
0.095129
******---******---******---******---******---******---******---******---******---******---
COD
b1
b2
b3
b4
b5
行的和
s1
6.246465
0.033064
0.044745
0.063753
0.046467
0.061651
6.496145
s2
7.300000
0.032765
0.040027
0.060715
0.047964
0.062193
7.543664
s3
7.151515
0.034787
0.044034
0.068569
0.047349
0.062583
7.408838
s4
5.858586
0.038918
0.054270
0.070237
0.049240
0.063075
6.134327
s5
7.458586
0.037524
0.047527
0.065471
0.046837
0.060580
7.716525
s6
7.458586
0.044111
0.055397
0.075133
0.052282
0.067838
7.753346
s7
7.022222
0.043152
0.056629
0.072561
0.052936
0.070106
7.317606
s8
7.846465
0.044698
0.061596
0.073882
0.053898
0.073508
8.154045
s9
10.561616
0.042522
0.060696
0.069076
0.051668
0.080740
10.866318
s10
2.828283
0.048858
0.057816
0.077516
0.056419
0.081748
3.150641
s11
8.492929
0.041209
0.058360
0.070019
0.053007
0.095129
8.810654
s12
12.581818
0.046677
0.067138
0.071816
0.052377
0.082932
12.902758
s11
8.492929
0.041209
0.058360
0.070019
0.053007
0.095129
8.810654
******---******---******---******---******---******---******---******---******---******---
COD
b1
b2
b3
b4
b5
行的和
s1
6.246465
0.033064
0.044745
0.063753
0.046467
0.061651
6.496145
s2
7.300000
0.032765
0.040027
0.060715
0.047964
0.062193
7.543664
s3
7.151515
0.034787
0.044034
0.068569
0.047349
0.062583
7.408838
s4
5.858586
0.038918
0.054270
0.070237
0.049240
0.063075
6.134327
s5
7.458586
0.037524
0.047527
0.065471
0.046837
0.060580
7.716525
s6
7.458586
0.044111
0.055397
0.075133
0.052282
0.067838
7.753346
s7
7.022222
0.043152
0.056629
0.072561
0.052936
0.070106
7.317606
s8
7.846465
0.044698
0.061596
0.073882
0.053898
0.073508
8.154045
s9
10.561616
0.042522
0.060696
0.069076
0.051668
0.080740
10.866318
s10
2.828283
0.048858
0.057816
0.077516
0.056419
0.081748
3.150641
s11
8.492929
0.041209
0.058360
0.070019
0.053007
0.095129
8.810654
s12
12.581818
0.046677
0.067138
0.071816
0.052377
0.082932
12.902758
s11
8.492929
0.041209
0.058360
0.070019
0.053007
0.095129
8.810654
列的和
99.300000
0.529494
0.706596
0.908767
0.663452
0.957212
103.065521
******---******---******---******---******---******---******---******---******---******---
COD
b1
b2
...
b5
行的和
行的均值
s1
6.246465
0.033064
0.044745
...
0.061651
6.496145
1.856041
s2
7.300000
0.032765
0.040027
...
0.062193
7.543664
2.155332
s3
7.151515
0.034787
0.044034
...
0.062583
7.408838
2.116811
s4
5.858586
0.038918
0.054270
...
0.063075
6.134327
1.752665
s5
7.458586
0.037524
0.047527
...
0.060580
7.716525
2.204722
s6
7.458586
0.044111
0.055397
...
0.067838
7.753346
2.215242
s7
7.022222
0.043152
0.056629
...
0.070106
7.317606
2.090745
s8
7.846465
0.044698
0.061596
...
0.073508
8.154045
2.329727
s9
10.561616
0.042522
0.060696
...
0.080740
10.866318
3.104662
s10
2.828283
0.048858
0.057816
...
0.081748
3.150641
0.900183
s11
8.492929
0.041209
0.058360
...
0.095129
8.810654
2.517330
s12
12.581818
0.046677
0.067138
...
0.082932
12.902758
3.686502
s11
8.492929
0.041209
0.058360
...
0.095129
8.810654
2.517330
列的和
99.300000
0.529494
0.706596
...
0.957212
103.065521
29.447292
[14 rows x 8 columns]
******---******---******---******---******---******---******---******---******---******---
COD
b1
b2
...
b5
行的和
行的均值
s1
6.246465
0.033064
0.044745
...
0.061651
6.496145
1.856041
s2
7.300000
0.032765
0.040027
...
0.062193
7.543664
2.155332
s3
7.151515
0.034787
0.044034
...
0.062583
7.408838
2.116811
s4
5.858586
0.038918
0.054270
...
0.063075
6.134327
1.752665
s5
7.458586
0.037524
0.047527
...
0.060580
7.716525
2.204722
s6
7.458586
0.044111
0.055397
...
0.067838
7.753346
2.215242
s7
7.022222
0.043152
0.056629
...
0.070106
7.317606
2.090745
s8
7.846465
0.044698
0.061596
...
0.073508
8.154045
2.329727
s9
10.561616
0.042522
0.060696
...
0.080740
10.866318
3.104662
s10
2.828283
0.048858
0.057816
...
0.081748
3.150641
0.900183
s11
8.492929
0.041209
0.058360
...
0.095129
8.810654
2.517330
s12
12.581818
0.046677
0.067138
...
0.082932
12.902758
3.686502
s11
8.492929
0.041209
0.058360
...
0.095129
8.810654
2.517330
列的和
99.300000
0.529494
0.706596
...
0.957212
103.065521
29.447292
列的均值
198.600000
1.058988
1.413193
...
1.914423
206.131042
58.894583
[15 rows x 8 columns]
******---******---******---******---******---******---******---******---******---******---
进程已结束，退出代码为 0

最后

以上就是勤恳纸飞机为你收集整理的python基于pandas求取行列的和与均值的全部内容，希望文章能够帮你解决python基于pandas求取行列的和与均值所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。