Replace values in data frame with valued of another dataframe

Question

I have the following data set

fruits	quality
apple	good
mangoes	Bad

 

I want the data frame to look like this:

fruits	quality
1	2
1	2
2	1

Where in fruits, 1 stand for apple and 2 for mangoes

and in quality, 1 stand for good and 2 for bad.

How do I write a python code for this?

Answer 1

Hi @Puneeth, you use something like this:

f = pd.DataFrame({'Fruits':['1.apple','2.Mangoes', np.nan],
                   'quality':['1.Good','2.Bad']})
print (df)
    
d={x:df[x].str.extract(r'(\d+)\.(.+)').dropna().set_index(0)[1].to_dict() for x in df.columns}
print (d)
{'Fruits': {'1': 'Apples', '2': 'Mangoes'}, 
 'Ethnicity': {'1': 'Good', '2': 'Bad'}}

df1 = pd.DataFrame({'Fruits':[1,1,2],
                   'Quality':[2,2,1]})