回答編集履歴
2
ソース修正
answer
CHANGED
|
@@ -33,7 +33,6 @@
|
|
|
33
33
|
|
|
34
34
|
#master_dfのname列とdfのname_key列で結合し、name_key列を削除
|
|
35
35
|
output_df = pd.merge(master_df, df, left_on='name', right_on='name_key', how='inner').drop("name_key", axis=1)
|
|
36
|
-
|
|
37
36
|
print(output_df)
|
|
38
37
|
'''
|
|
39
38
|
name_x number_of_types name_y size
|
1
ソース修正
answer
CHANGED
|
@@ -18,9 +18,9 @@
|
|
|
18
18
|
columns=['name', 'number_of_types'])
|
|
19
19
|
|
|
20
20
|
#master_dfのname列を繰り返し処理
|
|
21
|
-
for column_name, item in master_df
|
|
21
|
+
for column_name, item in master_df.name.iteritems():
|
|
22
22
|
#dfのnameにmaster_dfのnameが含まれる場合、master_dfのnameをdfのname_key列として追加
|
|
23
|
-
df.loc[df
|
|
23
|
+
df.loc[df.name.str.contains(item), 'name_key'] = item
|
|
24
24
|
print(df)
|
|
25
25
|
'''
|
|
26
26
|
name size name_key
|