Skip to main content
 首页 » 编程设计

Python pandas 方法链接 : assign column from strsplit

2025年05月04日11lovecherry

当我想从另一列的拆分创建一个新列时,分配方法出现问题。如果我选择 split 方法的值,我将收到错误 ValueError: Length of values does not match length of index。如果我只是应用拆分,而不选择(索引)任何值,我会得到一个包含列表的新列。

如果我不索引拆分方法的输出,这里是输出

( 
    pd.DataFrame({ 
        "Gene": ["G1", "G1", "G2", "G2"], 
        "Sample": ["H1_T1", "H2_T1", "H1_T1", "H2_T1"] 
    }) 
    .assign(Timepoint = lambda x: x.Sample.str.split("_")[1]) 
) 
    Gene    Sample  Timepoint 
0   G1  H1_T1   [H1, T1] 
1   G1  H2_T1   [H2, T1] 
2   G2  H1_T1   [H1, T1] 
3   G2  H2_T1   [H2, T1] 

这是一个示例,我想从 Sample 列中选择 T1 或 T2 值并给出错误:

( 
    pd.DataFrame({ 
        "Gene": ["G1", "G1", "G2", "G2"], 
        "Sample": ["H1_T1", "H2_T1", "H1_T1", "H2_T1"] 
    }) 
    .assign(Timepoint = lambda x: x.Sample.str.split("_")[1]) 
) 

我得到的错误是:

/home/user/anaconda3/lib/python3.4/site-packages/pandas/core/series.py in _sanitize_index(data, index, copy) 
   2739  
   2740     if len(data) != len(index): 
-> 2741         raise ValueError('Length of values does not match length of ' 
   2742                          'index') 
   2743  
 
ValueError: Length of values does not match length of index 

请您参考如下方法:

IIUC 那么您需要额外调用 str 来选择元素:

In [234]: 
pd.DataFrame({ 
        "Gene": ["G1", "G1", "G2", "G2"], 
        "Sample": ["H1_T1", "H2_T1", "H1_T1", "H2_T1"] 
    }).assign(Timepoint = lambda x: x.Sample.str.split("_").str[1]) 
 
Out[234]: 
  Gene Sample Timepoint 
0   G1  H1_T1        T1 
1   G1  H2_T1        T1 
2   G2  H1_T1        T1 
3   G2  H2_T1        T1 

如果我们稍微修改你的 df 并查看输出

In [237]: 
df = pd.DataFrame({ 
        "Gene": ["G1", "G1", "G2", "G2"], 
        "Sample": ["H1_T1", "H2_T2", "H1_T3", "H2_T4"] 
    }) 
 
df['Sample'].str.split("_") 
 
Out[237]: 
0    [H1, T1] 
1    [H2, T2] 
2    [H1, T3] 
3    [H2, T4] 
dtype: object 

所以您尝试的是以下内容:

In [238]: 
df['Sample'].str.split("_")[1] 
 
Out[238]: 
['H2', 'T2'] 

你可以看到这里所做的是选择第二行,你想要的是选择每一行的第二个元素:

In [239]: 
df['Sample'].str.split("_").str[1] 
 
Out[239]: 
0    T1 
1    T2 
2    T3 
3    T4 
dtype: object