我有一个带有列的输入数据框:
Template Template Name
This is String
This is String line
This is Int
This is Int Name
This is String Name
String Name is none
Int is empty
预期输出数据框:
Template Template Name
This is String String
This is String line String
This is Int Int
This is Int Name Int
This is String Name String
String Name is none String
Int is empty Int
我已经尝试了以下代码
all_data['Template Name'] = all_data['Template'].str.contains('String')
if all_data['Template'].str.contains('String').any() == True:
all_data['Template Name'] = 'String'
但它只会在所有单元格中显示“字符串”,请帮助我。
我认为您需要extract
:
df['Template Name'] = df.Template.str.extract('(String|Int)', expand=False)
print (df)
Template Template Name
0 This is String String
1 This is String line String
2 This is Int Int
3 This is Int Name Int
4 This is String Name String
5 String Name is none String
6 Int is empty Int
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句