Question

我是来自奥古拉普利斯的<>大范围>包裹的新用户。我正试图操纵装自Bigquery的数据。

我正试图执行某些法典,但我正面临一个无法解决的问题。

I am trying to use the apply function on a Dataframe with the parameter axis=1 , but it doesn t seem to work. I always have an error message.

你们能否帮助我这样做?

感谢。

法典例

# example
def condition(row):
    print(row )
    if 1 <= row["month"] <= 6:
        return f"{row[ year ]:02}S1{row[ CODPY ]}{row[ CODDE ]}"
    else:
        return f"{row[ year ]:02}S2{row[ CODPY ]}{row[ CODDE ]}"

valodetail_df[ IDT ] = valodetail_df.apply(condition,axis=1)

跟踪

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/home/ubuntu/miniconda3/envs/qback/lib/python3.11/site-packages/bigframes/core/log_adapter.py", line 44, in wrapper
    return method(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/miniconda3/envs/qback/lib/python3.11/site-packages/bigframes/dataframe.py", line 3118, in apply
    results = {name: func(col, *args, **kwargs) for name, col in self.items()}
              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/miniconda3/envs/qback/lib/python3.11/site-packages/bigframes/dataframe.py", line 3118, in <dictcomp>
    results = {name: func(col, *args, **kwargs) for name, col in self.items()}
                     ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "<stdin>", line 3, in condition
  File "missing.pyx", line 419, in pandas._libs.missing.NAType.__bool__
TypeError: boolean value of NA is ambiguous
>>> valodetail_df[ IDTDCI ] = valodetail_df.apply(condition,axis=1)
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/home/ubuntu/miniconda3/envs/qback/lib/python3.11/site-packages/bigframes/core/log_adapter.py", line 44, in wrapper
    return method(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/miniconda3/envs/qback/lib/python3.11/site-packages/bigframes/dataframe.py", line 3118, in apply
    results = {name: func(col, *args, **kwargs) for name, col in self.items()}
              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/miniconda3/envs/qback/lib/python3.11/site-packages/bigframes/dataframe.py", line 3118, in <dictcomp>
    results = {name: func(col, *args, **kwargs) for name, col in self.items()}
                     ^^^^^^^^^^^^^^^^^^^^^^^^^^
TypeError: condition() got an unexpected keyword argument  axis

Answer 1

这一特殊要求:https://github.com/googleapis/python-bigquery-dataframes/issues/592 同样。

然而,如果你特别使用的话,可以通过其他手段实现。

这里是你与以下机构合作的那种数据:

import bigframes.pandas as bpd

df = bpd.DataFrame({
        "month": [1,3,6,7,12],
        "year":  ["8", "9", "10", "11", "12"],
        "CODPY": ["PY", "PY", "PY", "PY", "PY"],
        "CODDE": ["DE", "DE", "DE", "DE", "DE"],
     })
df

    month   year    CODPY   CODDE
0       1      8       PY      DE
1       3      9       PY      DE
2       6     10       PY      DE
3       7     11       PY      DE
4      12     12       PY      DE

我们可以利用其他数据框架和系列预报软件来建立理想的一栏:

condition = (df["month"] >= 1) & (df["month"] <= 6)

s1 = df["year"].str.pad(fillchar= 0 , width=2) + "S1" + df["CODPY"] + df["CODDE"]

s2 = df["year"].str.pad(fillchar= 0 , width=2) + "S2" + df["CODPY"] + df["CODDE"]

df[ IDT ] = s1.where(condition, s2)
df

   month    year    CODPY   CODDE        IDT
0      1       8       PY      DE   08S1PYDE
1      3       9       PY      DE   09S1PYDE
2      6      10       PY      DE   10S1PYDE
3      7      11       PY      DE   11S2PYDE
4     12      12       PY      DE   12S2PYDE

希望这一帮助。

友情链接