主页 / user-10722752

Karthik S's questions

Martin Hope
Karthik S
Asked: 2024-11-15 22:26:58 +0800 CST
  • 6

我需要为 pandas 数据框的许多列中的每个值分配分数，具体取决于每个值之间的百分位数分数范围。

我创建了一个函数：

import pandas as pd
import numpy as np

def get_percentiles(x, percentile_array):
    percentile_array = np.sort(np.array(percentile_array))
    if x < x.quantile(percentile_array[0]) < 0:
        return 1
    elif (x >= x.quantile(percentile_array[0]) & (x < x.quantile(percentile_array[1]):
        return 2
    elif (x >= x.quantile(percentile_array[1]) & (x < x.quantile(percentile_array[2]):
        return 3
    elif (x >= x.quantile(percentile_array[2]) & (x < x.quantile(percentile_array[3]):
        return 4
    else:
        return 5

样本数据：

df = pd.DataFrame({'col1' : [1,10,5,9,15,4],
                   'col2' : [4,10,15,19,3,2],
                   'col3' : [10,5,6,9,1,24]})

当我尝试使用 apply 运行该函数时：

percentile_array = [0.05, 0.25, 0.5, 0.75]

df.apply(lambda x : get_percentiles(x, percentile_array), result_type = 'expand')

我收到以下错误：

Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()

预期输出是包含 3 列的新数据框，其分数介于 1 到 5 之间，具体取决于每列中每个值属于哪个百分位范围

python
Martin Hope
Karthik S
Asked: 2024-06-25 13:37:30 +0800 CST
  • 5

尝试导入PythonScriptStep和RunDetails使用时：

from azureml.pipeline.steps import PythonScriptStep
from azureml.widgets import RunDetails

获取ModuleNotFoundError: No module named 'azureml.pipeline' ModuleNotFoundError：没有名为“azureml.widgets”的模块错误

我尝试使用以下方法手动安装 azureml 管道：

!pip install azureml-pipeline

出现各种不兼容错误：

ERROR: ray 2.0.0 has requirement click<=8.0.4,>=7.0, but you'll have click 8.1.3 which is incompatible.
ERROR: ray 2.0.0 has requirement grpcio<=1.43.0,>=1.28.1; python_version < "3.10", but you'll have grpcio 1.54.2 which is incompatible.
ERROR: pyopenssl 23.0.0 has requirement cryptography<40,>=38.0.0, but you'll have cryptography 42.0.8 which is incompatible.
ERROR: jupyterlab-server 2.23.0 has requirement jinja2>=3.0.3, but you'll have jinja2 2.11.2 which is incompatible.
ERROR: datasets 2.3.2 has requirement dill<0.3.6, but you'll have dill 0.3.6 which is incompatible.
ERROR: dask-sql 2023.6.0 has requirement pandas>=1.4.0, but you'll have pandas 1.1.5 which is incompatible.
ERROR: azureml-widgets 1.56.0 has requirement azureml-core~=1.56.0, but you'll have azureml-core 1.51.0.post1 which is incompatible.
ERROR: azureml-widgets 1.56.0 has requirement azureml-telemetry~=1.56.0, but you'll have azureml-telemetry 1.51.0 which is incompatible.
ERROR: azureml-inference-server-http 0.8.4 has requirement flask<2.3.0, but you'll have flask 2.3.2 which is incompatible.
ERROR: azure-cli 2.49.0 has requirement azure-keyvault-keys==4.8.0b2, but you'll have azure-keyvault-keys 4.8.0 which is incompatible.
ERROR: azure-cli 2.49.0 has requirement azure-mgmt-keyvault==10.2.0, but you'll have azure-mgmt-keyvault 10.2.1 which is incompatible.
ERROR: azure-cli 2.49.0 has requirement azure-mgmt-resource==22.0.0, but you'll have azure-mgmt-resource 21.1.0b1 which is incompatible.
ERROR: azure-cli-core 2.49.0 has requirement msal[broker]==1.20.0, but you'll have msal 1.22.0 which is incompatible.
ERROR: autokeras 1.0.16 has requirement tensorflow<=2.5.0,>=2.3.0, but you'll have tensorflow 2.11.0 which is…
Show all (20.4 kB)

有人可以帮我解决这些错误吗？

Martin Hope
Karthik S
Asked: 2023-08-17 17:54:51 +0800 CST
  • 5

我有一个包含 12 列的数据框。在这些列中，我有许多浮动列，我需要验证这些值是否大致相等或足够接近。

样本数据：

df = pd.DataFrame({'id' : ['abc', 'pqr', 'xyz', 'cbz'],
                  'col1' : [0.0234, 0.001852, 4.123, 0.0012],
                  'col2' : [0.0235, 0.001851, 0.0123, 0.0013],
                  'col3' : [0.0233, 0.001849, 0.124, 0.0011]})
df

    id  col1      col2      col3
0   abc 0.0234    0.0235    0.0233
1   pqr 0.001852  0.001851  0.001849
2   xyz 4.123     0.0123    0.124

我可以使用np.isclose并设置一个适用于我的情况的阈值，即 0.062。但是有人可以告诉我如何比较 col1 约等于 col2 约等于 col3 吗？如果甚至有 1 列不满足条件，则结果应False与 的情况相同id xyz。

python