如果我没理解错你的问题，你需要使用apply()。

dic = pd.DataFrame(columns = ['col_name','origin_value','trans_value'])

# Iterate through the values in the of 'workclass' 
for value in df.workclass.value_counts().index:
    # Add a new row to the new dataframe with the column name, original value, and transformed value
    dic = dic.append({'col_name': 'workclass', 'origin_value': value, 'trans_value': value}, ignore_index=True)