从列到合计所有值，并创建一个新的行名为' total‘

Question

这是csv的原始表：

+---------------+---------------------+--------------+-----------------+
| Access SSID   | Radio Frequencies   |   User Count | Total Traffic   |
|---------------+---------------------+--------------+-----------------|
| SIS-OPEN      | 2.4G                |          378 | 144.28 GB       |
| nan           | 5G                  |          361 | 142.59 GB       |
| SIS-STAFF     | 2.4G                |            1 | 32.63 MB        |
| nan           | 5G                  |           10 | 2.20 GB         |
| SIS-STUDENT   | 2.4G                |           88 | 31.64 GB        |
| nan           | 5G                  |          136 | 37.96 GB        |
+---------------+---------------------+--------------+-----------------+

我的结果，我尝试使用这个：

df.loc['Total'] = df.sum(axis = 0)

+---------------+---------------------+--------------+---------------------------------------------------+
| Access SSID   | Radio Frequencies   |   User Count | Total Traffic                                     |
|---------------+---------------------+--------------+---------------------------------------------------|
| SIS-OPEN      | 2.4G                |          378 | 144.28 GB                                         |
| nan           | 5G                  |          361 | 142.59 GB                                         |
| SIS-STAFF     | 2.4G                |            1 | 32.63 MB                                          |
| nan           | 5G                  |           10 | 2.20 GB                                           |
| SIS-STUDENT   | 2.4G                |           88 | 31.64 GB                                          |
| nan           | 5G                  |          136 | 37.96 GB                                          |
| Total         | 2.4G5G2.4G5G2.4G5G  |          974 | 144.28 GB142.59 GB32.63 MB2.20 GB31.64 GB37.96 GB |
+---------------+---------------------+--------------+---------------------------------------------------+

我的预期结果应该是：

+---------------+---------------------+--------------+-----------------+
| Access SSID   | Radio Frequencies   |   User Count | Total Traffic   |
|---------------+---------------------+--------------+-----------------|
| SIS-OPEN      | 2.4G                |          378 | 144.28 GB       |
| nan           | 5G                  |          361 | 142.59 GB       |
| SIS-STAFF     | 2.4G                |            1 | 32.63 MB        |
| nan           | 5G                  |           10 | 2.20 GB         |
| SIS-STUDENT   | 2.4G                |           88 | 31.64 GB        |
| nan           | 5G                  |          136 | 37.96 GB        |
+---------------+---------------------+--------------+-----------------+
| TOTAL         |                     |          974 |                 |
+---------------+---------------------+--------------+-----------------+

Answer 1

仅对数字列使用DataFrame.select_dtypes：

df.loc['Total'] = df.select_dtypes('number').sum(axis = 0)

如果还需要将缺少的值替换为空字符串，则添加DataFrame.reindex

df.loc['Total'] = (df.select_dtypes('number')
                     .sum(axis = 0)
                     .reindex(df.columns, axis=1, fill_value=''))
print (df)
            Radio Frequencies  User Count Total Traffic
Access SSID                                            
SIS-OPEN                 2.4G         378     144.28 GB
NaN                        5G         361     142.59 GB
SIS-STAFF                2.4G           1      32.63 MB
NaN                        5G          10       2.20 GB
SIS-STUDENT              2.4G          88      31.64 GB
NaN                        5G         136      37.96 GB
Total                                 974