如果現有數據幀列包含字典的鍵,則嘗試將字典值插入數據幀中的單獨列。我已經嘗試了下面的代碼,但對于值對返回[]
:
import pandas as pd
import numpy as np
df = pd.DataFrame({'key' : ["vs, vscode", "jupyter, jupyterlab", "python, vs", "python", "it was spyder before dawn"]})
my_dict = {'vscode' : 'is gross',
'jupyter' : 'is not so awesome, but hes ok, ig',
'vs' : 'is awesome',
'jupyterlab' : 'is rad',
'python' : "booya"}
def cascade_col(row_value):
cvc_row = []
for word in row_value:
if word in my_dict:
cvc_row.append(my_dict[word])
return cvc_row
df['dict value'] = df['key'].apply(cascade_col)
print(df)
我的預期產出如下:
df = pd.DataFrame({'key' : ["vs, vscode", "jupyter, jupyterlab", "python, vs", "python", "it was spyder before dawn"],
'Corresponding Value(s)' : ['is awesome, is gross', 'is not so awesome, but hes ok, ig, is rad', 'booya, is awesome', 'booya', np.nan]})
df
謝謝你回答我的問題。
我曾嘗試過解決這個問題的方法,但卻被卡住了。我已經定義了我的問題,我嘗試過的代碼,但正在尋求進一步的幫助。非常感謝。
您可以在字典中使用正則表達式提取和映射:
Output: