I'm trying to merge two dataframe together bases on mal_id on both of the dataframe, but nothing came out when I merge them together.
dataframe 1:
|user_id|mal_id|rating|
|-------|------|------|
|12|15000|5.5|
|10|152|6|
dataframe 2:
|mal_id|genres|title|
|-------|------|------|
|12|['Comedy', 'Drama']|Cowboy Depop|
|10|'Drama'|Naruto|
this is my attempt:
animes_df = animes_df.loc[animes_df['mal_id'].isin(list(map(str, np.unique(users_fav_movies['mal_id']))))].reset_index(drop=True)
and this is the output
|mal_id|genres|title|
|------|------|-----|
any suggestion?
