如何在python中合并 pandas 来在R中重现foverlaps的相同输出? [英] How to reproduce the same output of foverlaps in R with merge of pandas in python?
问题描述
我正在使用翻盖功能.但是我需要使用python复制相同的输出.我进行了搜索,发现合并在熊猫库上起作用.但是即使使用此功能,我也无法重现相同的输出.
I'm doing a merge in R of my tables using the foverlaps function. But I need to reproduce the same output using python. I did a search and I found the merge function on pandas library. But even using this function, I can't reproduce the same output.
首先将R中的输出:
这是第一个表(间隔):
This is the first table (intervals):
V1 V2 intid
1: 1 5 1
2: 4 9 2
3: 6 12 3
4: 11 17 4
5: 18 20 5
这是第二个表(分解):
This is the second table (decomp):
V1 V2 subid
1: 1 4 A
2: 4 5 B
3: 5 6 C
4: 6 9 D
5: 9 11 E
6: 11 12 F
7: 12 17 G
8: 17 18 H
9: 18 20 I
R中进行合并的代码:
The code in R that makes the merge:
relations <- foverlaps(decomp, intervals, type='within', nomatch=0)
输出(关系):
V1 V2 intid i.V1 i.V2 subid
1: 1 5 1 1 4 A
2: 1 5 1 4 5 B
3: 4 9 2 4 5 B
4: 4 9 2 5 6 C
5: 4 9 2 6 9 D
6: 6 12 3 6 9 D
7: 6 12 3 9 11 E
8: 6 12 3 11 12 F
9: 11 17 4 11 12 F
10: 11 17 4 12 17 G
11: 18 20 5 18 20 I
现在我在python中拥有的输出:
这是第一个表(df_of_pairs):
This is the first table (df_of_pairs):
V1 V2 intid
0 1 5 1
1 4 9 2
2 6 12 3
3 11 17 4
4 18 20 5
这是第二个表(df_of_adjacent):
This is the second table (df_of_adjacent):
V1 V2 subid
0 1 4 A
1 4 5 B
2 5 6 C
3 6 9 D
4 9 11 E
5 11 12 F
6 12 17 G
7 17 18 H
8 18 20 I
现在是问题,当我使用熊猫合并时,我没有在python中重现相同的输出.我尝试了几种方法,但都没有成功,这是我使用它的方法之一:
Now is the problem, I did not reproduce the same output in python when I used the pandas merge. I tried it in several ways and I did not succeed with any, here's one of the ways I've used it:
df = df_of_pairs.merge(df_of_adjacent, left_on=['V1'], right_on=['V2'] )
输出(df):
V1_x V2_x intid V1_y V2_y subid
0 4 9 2 1 4 A
1 6 12 3 5 6 C
2 11 17 4 9 11 E
3 18 20 5 17 18 H
这个问题与 R非常相似foverlaps等效于Python ,但在这种情况下,它具有不同的列.
This question is very similar to R foverlaps equivalent in Python, but in that case it has different columns.
推荐答案
我无法轻松获得所需的确切输出,但这是使用IntervalIndex
的部分解决方案.
I can't easily get your exact desired output, but here's a partial solution using IntervalIndex
.
s1 = pd.IntervalIndex.from_arrays(df1['V1'], df1['V2']) # default: closed='right'
s2 = pd.IntervalIndex.from_arrays(df2['V1'], df2['V2'])
df_of_adjacent.set_index(s2, inplace=True)
df_of_adjacent.loc[s1]
V1 V2 subid
(1, 4] 1 4 A
(4, 5] 4 5 B
(4, 5] 4 5 B
(5, 6] 5 6 C
(6, 9] 6 9 D
(6, 9] 6 9 D
(9, 11] 9 11 E
(11, 12] 11 12 F
(11, 12] 11 12 F
(12, 17] 12 17 G
(18, 20] 18 20 I
这篇关于如何在python中合并 pandas 来在R中重现foverlaps的相同输出?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!