我正在尝试获取一个新列,其中的列数对于每个索引行都是正数
这是数据框的样子:
+----+---------+---------+---------+---------+---------+
| | 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 |
+----+---------+---------+---------+---------+---------+------------------+
尝试这个:
df['Positive Weeks'] = df.gt(0).sum(axis=1)
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句