代码之家  ›  专栏  ›  技术社区  ›  Manasi Shah

如果行在数据帧中不是数字,则跳过对行的操作

  •  0
  • Manasi Shah  · 技术社区  · 9 年前

    我有一个数据帧:

    import pandas as pd
    df = pd.DataFrame({'start' : [5, 10, '$%%', 20], 'stop' : [10, 20, 30, 40]})
    df['length_of_region'] = pd.Series([0 for i in range(0, len(df['start']))])
    

    df['Notes'] = pd.Series(["" for i in range(0, len(df['region_name']))])
    
    for i in range(0, len(df['start'])):
        if pd.isnull(df['start'][i]) == True:
            df['Notes'][i] += 'Error: Missing value for chromosome start at region %s, required value;' % (df['region_name'][i])
            df['critical_error'][i] = True
            num_error = num_error+1
        else:
            try:
                #print (df['start'][i]).isnumeric()
                start = int(df['start'][i])
                #print start
                #print df['start'][i]
                if start == 0:
                    raise ValueError
            except:
                df['Notes'][i] += 'Error: Chromosome start should be a non zero number at region %s; ' % (df['region_name'][i])
                #print df['start'][i]
                df['critical_error'][i] = True
                num_error = num_error+1
    for i in range(0, len(df['start'][i])):
        if df['critical_error'][i] == True:
            continue
        df['length_of_region'][i] = (df['stop'][i] - df['start'][i]) + 1.0
    

    然而 pandas 转换 df['start'] str 变量,即使我使用 int

    df['length_of_region'][i] = (df['stop'][i] - df['start'][i]) + 1.0
    

    TypeError:numpy的操作数类型不受支持。“int64”和“str”

    我错过了什么?谢谢你的时间!

    2 回复  |  直到 9 年前
        1
  •  1
  •   vielkind    9 年前

    def calculate_region_length(x):
        start_val = x[0]
        stop_val = x[1]
        try:
            start_val = float(start_val)
            return (stop_val - start_val) + 1.0
        except ValueError:
            return None
    

    自定义函数接受列表作为输入。该函数将测试起始值,以查看是否可以将其转换为浮点值。如果不能,那么 None 将被退回。这样,如果“1”存储为字符串,则该值仍然可以转换为浮点值,并且不会被跳过,而示例中的“$%%”不能且将返回 .

    接下来,为每行调用自定义函数:

    df['length_of_region'] = df[['start', 'stop']].apply(lambda x: calculate_region_legnth(x), axis=1)
    

    (stop - start) + 1.0 start 不是不可转换字符串,并且 没有一个 哪里 开始

    然后,您可以更新 Notes 基于行的字段,其中 返回以标识缺少起始值的区域:

    df.loc[df['length_of_region'].isnull(), 'Notes'] = df['region_name']
    
        2
  •  0
  •   Manasi Shah    9 年前

    df['start'][i] 到 start try-except 具体如下:

    for i in range(0, len(df['start'])):
        if pd.isnull(df['start'][i]) == True:
            df['Notes'][i] += 'Error: Missing value for chromosome start at region %s, required value;' % (df['region_name'][i])
            df['critical_error'][i] = True
            num_error = num_error+1
        else:
            try:
                start = int(df['start'][i])
                df['start'][i] = start
                if start == 0:
                    raise ValueError
            except:
                df['Notes'][i] += 'Error: Chromosome start should be a non zero number at region %s; ' % (df['region_name'][i])
                #print df['start'][i]
                df['critical_error'][i] = True
                num_error = num_error+1
    for i in range(0, len(df['start'][i])):
        if df['critical_error'][i] == True:
            continue
        df['length_of_region'][i] = (df['stop'][i] - df['start'][i]) + 1.0
    

    重新分配起始变量,将其转换为 int 格式化并帮助计算 length_of_region