回答編集履歴
1
Update
test
CHANGED
@@ -4,20 +4,22 @@
|
|
4
4
|
import numpy as np
|
5
5
|
|
6
6
|
df = pd.DataFrame({'連番': range(10), 'G': np.random.randint(0, 100, (10, ))})
|
7
|
-
df_1 = pd.DataFrame({'連番': range(5, 15), 'G': np.random.randint(0, 100, (10, ))})
|
8
|
-
|
9
|
-
dfx = pd.merge(df, df
|
7
|
+
dfx = pd.merge(df, df, how='cross').query('連番_x + 1 == 連番_y')\
|
10
8
|
.set_axis(['df.連番', 'df.G', 'df_1.連番', 'df_1.G'], axis=1)
|
11
9
|
|
12
10
|
print(dfx)
|
13
11
|
```
|
14
12
|
|
13
|
+
|
15
14
|
| df.連番 | df.G | df_1.連番 | df_1.G |
|
16
15
|
|----------:|-------:|------------:|---------:|
|
16
|
+
| 0 | 46 | 1 | 14 |
|
17
|
+
| 1 | 14 | 2 | 18 |
|
18
|
+
| 2 | 18 | 3 | 29 |
|
19
|
+
| 3 | 29 | 4 | 92 |
|
17
|
-
| 4 |
|
20
|
+
| 4 | 92 | 5 | 73 |
|
18
|
-
| 5 |
|
21
|
+
| 5 | 73 | 6 | 3 |
|
19
|
-
| 6 |
|
22
|
+
| 6 | 3 | 7 | 57 |
|
20
|
-
| 7 |
|
23
|
+
| 7 | 57 | 8 | 33 |
|
21
|
-
| 8 |
|
24
|
+
| 8 | 33 | 9 | 15 |
|
22
|
-
| 9 | 19 | 10 | 39 |
|
23
25
|
|