python - 计算熊猫中的数组

Question

我正在尝试获取一个新列，其中的列数对于每个索引行都是正数

这是数据框的样子：

+----+---------+---------+---------+---------+---------+
|    |   week1 |   week2 |   week3 |   week4 |   week5 |
+====+=========+=========+=========+=========+=========+
|  0 |      70 |      60 |      50 |     -40 |     -30 |
+----+---------+---------+---------+---------+---------+
|  1 |      50 |      10 |     -20 |     -40 |     -60 |
+----+---------+---------+---------+---------+---------+
|  2 |     -80 |     -90 |    -100 |    -110 |    -120 |
+----+---------+---------+---------+---------+---------+
|  3 |     110 |      80 |      70 |      60 |      50 |
+----+---------+---------+---------+---------+---------+
|  4 |      10 |     -50 |     -70 |     -80 |     -90 |
+----+---------+---------+---------+---------+---------+

这就是我正在寻找的结果，一个新列，如果数字为正，则计算周数

+----+---------+---------+---------+---------+---------+------------------+
|    |   week1 |   week2 |   week3 |   week4 |   week5 |   POSITIVE WEEKS |
+====+=========+=========+=========+=========+=========+==================+
|  0 |      70 |      60 |      50 |     -40 |     -30 |                3 |
+----+---------+---------+---------+---------+---------+------------------+
|  1 |      50 |      10 |     -20 |     -40 |     -60 |                2 |
+----+---------+---------+---------+---------+---------+------------------+
|  2 |     -80 |     -90 |    -100 |    -110 |    -120 |                0 |
+----+---------+---------+---------+---------+---------+------------------+
|  3 |     110 |      80 |      70 |      60 |      50 |                5 |
+----+---------+---------+---------+---------+---------+------------------+
|  4 |      10 |     -50 |     -70 |     -80 |     -90 |                1 |
+----+---------+---------+---------+---------+---------+------------------+

标签： pythonpandas

Answer 1

试试这个：

df['Positive Weeks'] = df.gt(0).sum(axis=1)