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:\pythonProject\COD1.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:\pythonProject\venv\Scripts\python.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