回答編集履歴
1
Update
answer
CHANGED
|
@@ -3,15 +3,18 @@
|
|
|
3
3
|
import pandas as pd
|
|
4
4
|
import numpy as np
|
|
5
5
|
|
|
6
|
-
|
|
6
|
+
df_A = pd.DataFrame({
|
|
7
7
|
'Col_1': [1, 2, 3, 4],
|
|
8
|
-
'Col_2': [
|
|
8
|
+
'Col_2': ['a, b, c', 'a, d', np.nan, 'e'],
|
|
9
9
|
})
|
|
10
10
|
|
|
11
|
-
dfx = df.explode('Col_2').dropna().reset_index(drop=True)
|
|
12
11
|
|
|
13
|
-
|
|
12
|
+
df_B = df_A.copy()
|
|
13
|
+
df_B['Col_2'] = df_B['Col_2'].str.split(',')
|
|
14
|
+
df_B = df_B.explode('Col_2').dropna().reset_index(drop=True)
|
|
14
15
|
|
|
16
|
+
print(df_B)
|
|
17
|
+
|
|
15
18
|
#
|
|
16
19
|
Col_1 Col_2
|
|
17
20
|
0 1 a
|